Microsoft Excel for Beginners Certification

Microsoft Excel for Beginners Certification

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.