Accreditation
ESS Certificate
Microsoft Excel Intermediate Certificate
Course duration
10 hours
Certificate valid for
Never expires
This Microsoft Excel Intermediate course is recommended for those with a basic understanding of the functions and formula within Excel and delves further into the more complex concepts that were covered within our Excel for Beginners course.
Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions.
Microsoft Excel Intermediate Course Overview
The Microsoft Excel Intermediate course will give you a more in-depth look into some of the fundamentals of Excel, this includes;
- Learning more about intermediate Excel functions including ABS, AVERAGEIF, AVERAGEIFS, and AVERAGEA
- Data validation with date, list, time, and numbers
- Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
- How to remove duplicates in Excel
- Creating random numbers
- Changing text case
- How to use Templates
- Insert Charts
- Adding custom backgrounds
- How to use Tables
- How to auto fill data
- Adding special characters
- Changing border colour and theme
This Excel Intermediate course is broken down into 34 modules. Following completion of these 34 modules, there is a multiple choice test.
On completion of this course, you will receive a Microsoft Excel Advanced certification.
Further Progression
Following the completion of this course, you can move onto the following courses: