Please Note: This Microsoft Excel Intermediate training uses the Microsoft 365 version of Excel. Any other versions will have some differences in the functions.
The Microsoft (MS) Excel Intermediate Certification course will take what the team member learnt in the Beginner course and expand on it, teaching them more advanced concepts than those that were presented in the earlier course.
What’s Covered in our Microsoft Excel Intermediate training ?
The material in the Intermediate course is designed for those who work with Excel in the workplace and wish to improve their skills. Whether the employee is involved in investments, banking or consulting, the content will be useful for anyone who tracks and analyses a lot of data.
Employees who are new to the workforce will need to ensure that they are equipped with at least intermediate Excel skills.
Before starting this Intermediate course, the employee should have a good grasp of the Beginner Excel functions. Those with experience in Excel may feel that they can skip the Beginner course, but it is advisable to at least review the course material before starting the Intermediate material.
The course teaches team members how to use functions, including AVERAGEA, AVERAGEIF, AVERAGEIFS and ABS. They will also learn data validation information, focusing on the type of data validation, such as date, list and time, as well as more information on specific functions, including CHAR, CODE, MEDIAN, MODE and ROUND and how to utilise these functions, in order to meet the organisation’s needs.
Other information in the Intermediate course includes how to change text in Excel, e.g., changing text to all upper case or lower case. Team members will also learn how to change the background and add a custom image, how to use AutoFill and how to insert special characters.
Upon completing or Microsoft Excel Intermediate training, employees will know about most of the functions that Excel has and how to use the software at an intermediate level, which is sufficient to be able to use Excel in most business environments.
Explore our full library of training courses.
Course Duration: 9
Total Modules: 34
Module 1: SumProduct Formula
Module 2 : Data Validation With Date
Module 3 : Data Validation with Whole Numbers
Module 4 : Data Validation with List Feature
Module 5 : ABS Function
Module 6 : CHAR Function
Module 7 : CLEAN Function
Module 8 : CODE Function
Module 9 : EXACT Function
Module 10 : AVERAGEA Function
Module 11 : AVERAGEIF
Module 12 : AVERAGEIFS Function
Module 13 : CELL Function With 10 Variations
Module 14 : LARGE Function
Module 15: MAX Function
Module 16: MEDIAN Function
Module 17: MIN Function
Module 18: MODE Function
Module 19 : N Function
Module 20 : RANDBETWEEN Function (Insert Random Numbers)
Module 21 : RANK Function
Module 22 : Remove Duplicate Values
Module 23 : ROUND Function Up/Down
Module 24 : Add Custom Background Image
Module 25: Change Text To Lower Case
Module 26: Change Text To Upper Case
Module 27: Change Text To Proper Case
Module 28: Insert Special Character
Module 29: Use Autofill : A Time Saving Trick
Module 30: Treemap Chart
Module 31: Sunburst Chart
Module 32: Use Tables
Module 33: Use Templates
Module 34: Use Themes
