MS Excel Intermediate Course
Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 2 course will take what the team member learnt in the Level 1 course and expand on it, teaching them more advanced concepts than those that were presented in the earlier course.
What’s Covered in the Course?
The Level 2 Excel course is designed for individuals who use Excel in their workplace and want to enhance their skills. It is beneficial for those who work with a lot of data, such as in investments, banking or consulting. It is important for new employees to have at least intermediate (Level 2) Excel skills. Before starting the Level 2 course, it is recommended that individuals have a good understanding of the Level 1 Excel functions. Even if experienced with Excel, it is advisable to review the Level 1 material before beginning the Level 2 material.
The course covers functions such as AVERAGEA, AVERAGEIF, AVERAGEIFS, and ABS. Team members will also learn data validation techniques, including date, list, and time validation, as well as specific functions like CHAR, CODE, MEDIAN, MODE, and ROUND, and how to use them to meet the organization's needs. Additionally, team members will learn how to modify text in Excel, such as converting text to uppercase or lowercase, and add background colors and custom images. The course also covers how to use AutoFill and insert special characters.
By completing the Level 2 Excel course, employees will have knowledge of most Excel functions and be able to use the software at an intermediate level. This skill set is sufficient for using Excel in most business environments.
What are the Benefits of the Course?
- Excel data analysis tools have applications throughout the organisation;
- As with the Level 1 course, the Level 2 course comprises short modules, accessible on any device that can connect to the internet;
- Lifetime access to the course materials allows learners to revise any of the material at any time in the future;
- Online learning support is provided for your employees.