This course is also available as in-house training.
Enquire now to find out more.
Please note: This Excel for Beginners course uses the Microsoft 365 version of Excel. Any other versions will have some differences in the functions.
Microsoft (MS) Excel is one of the most widely used data capture and analysis tools in the world. Whether the team member is new to the use of Excel spreadsheets or already has some knowledge of the software and is looking to improve upon their skills, this series of courses – Beginner, Intermediate and Advanced Excel – can assist.
Who is the Microsoft Excel Beginner Certification For?
This Beginner course is recommended for anyone in the business that may use Excel for uncomplicated data capture and analysis, such as tracking simple expenditure or for calculating sums or totals.
The course is ideal for anyone who:
- Has never used Excel before;
- Has only a basic understanding of the software;
- Wishes to update their skills to the latest version of the software.
It is also the ideal starting point for those who wish to go on to use Excel for more advanced applications, such as functions and formulae.
What’s covered in the course?
The course covers all the basic Excel skills, such as:
- Basic calculations: sums, averages and totals
- Data visualisation: pivot tables, graphs and charts
- Essential Excel functions: IF, COUNTIF, SUMIF, AVERAGEIF
The second half of the Microsoft Excel Beginner course covers ‘sheets’ – the Excel equivalent of a page. The team member will learn how to rename, delete, hide and unhide a sheet and how to move and copy a sheet. They will also learn how to change the colour of the tabs.
Explore our full library of training courses.
Course Duration: 9
Total Modules: 36
Module 1 : Introduction to Excel
Module 2 : Add
Module 3 : Multiply
Module 4 : Subtraction in Excel
Module 5 : Dividing
Module 6 : Sort
Module 7 : Percentage
Module 8 : Running Totals
Module 9 : Print
Module 10 : Paste Special
Module 11 : Merge
Module 12 : Filter
Module 13 : AVERAGE
Module 14 : AVERAGEIF
Module 15 : SUMIF Formula
Module 16 : IF Formula
Module 17 : VLOOKUP
Module 18 : HLOOKUP
Module 19 : COUNTIF Formula
Module 20 : COUNTBLANK
Module 21 : COUNTA Formula
Module 22 : COUNT Formula
Module 23 : CONCATENATE
Module 24 : TRANSPOSE
Module 25 : DATE Formula
Module 26 : MONTH Formula
Module 27 : Pivot Tables
Module 28 : Pie Charts
Module 29 : Doughnut Charts
Module 30 : Line Charts
Module 31 : Column Charts
Module 32 : Bar Charts
Module 33 : Number Formatting
Module 34 : Create Borders
Module 35 : Conditional Formatting
Module 36: Comments
