Description
Online | Duration: 15 | Work on All major devices and browsers | Access: Lifetime
Qualification To Achieve: Level 1 Microsoft Excel Certification | Exam: Yes
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 – Level 1, Level 2 and Level 3 Excel – can assist.
This Level 1 starter 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:
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.
The course covers all the basics, such as calculations of sums, averages and totals. The team member will learn some of the basic functions, such as IF, COUNTIF, SUMIF and AVERAGEIF, as well as the use of pivot tables, creating graphs and charts and using hyperlinks.
The second half of the Level 1 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.
