Microsoft Excel Intermediate Certificate

Accreditation

ESS Certificate

Course duration

10 hours

Certificate valid for

Never expires

Book this course today. Call 0115 8970 529 or click here to send us a message

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: