Microsoft Excel Basics
What you'll learn
- Excel Interface, Formatting, and File creation
- Formulas and Functions
- Visual Presentations (Charts and Graphs)
- Pivot Tables
- No requirements
This is a great course for someone who is just starting in Excel. It will boost learner's confidence and ability in excel skills. The course will focus on:
- How to open, name, and save an excel file.
- Excel Interface: sheet layout and organization.
- Borders and Sheet Format.
- Merging Cells: how to merge multiple cells
- Sort & Filter: how to sort texts from A to Z or Z to A; and how to sort numbers from largest to smallest or smallest to largest.
- Find & Select: how to search a sheet to find a specific text or number
- Replace: how to find a target and replace it with another input.
- Sum, Average, and Count: calculate the sum, average, and count for a set of numbers
- Minimum and Maximum: find the minimum and maximum within a set of numbers
- IF Statements: how to use the IF Statements function to make conditional arguments.
- Dropdown Lists: how to create a dropdown list
- VLOOKUP: how to use the VLOOKUP to extract some data from a data range/table.
- Bar Chart: how to create a bar chart
- Pie Chart: how to create a pie chart
- Chart Formatting: how to format a chart
- Pivot Tables: how to use Pivot Tables to summarize and analyse large data.
- Pivot Tables Formatting: how to format a Pivot Table.
Who this course is for:
- Learners who need an introduction to excel
Adnan currently work as a finance and accounting lecturer at Anglia Ruskin University London, UK.
Qualifications and Professional Certificates:
Chartered Global Management Accountant, CGMA, CIMA UK
Associate Chartered Management Accountant, ACMA, CIMA UK
International Expert In SME Finance, Frankfurt Business School
MBA in Finance and Banking
PGCE Mathematical Economics
22 years of industry experience
+1,000 hours teaching at UK universities
+300 workshops and training sessions developed and delivered
+750 SME consulted in finance and accounting
+100 courses designed, developed, and implemented