Instant access

Interactive Course
4 Hours

  • Certified Course
  • Lifetime access & no monthly fees
  • Complete on multiple devices
  • Courses receive accredited certificate

Advanced Excel Course

Advanced Excel – Online Course

Course Description

This Microsoft Excel Advanced training course will give you a deeper understanding of the many complex and in-depth features of Excel.

With over 400 formula functions you need to know how to find the ones you need, This course will prepare you to locate and use the many advanced functions in Excel and will provide an in-depth look at the most commonly used.

This is an interactive course that will not only show you but also allow you to participate in the lesson by clicking and typing the appropriate commands which will drastically improve your memory of the course.

Course Overview

Module 1 - Understanding Commands

Lesson 1: Problem Solving and Understanding Commands
Problem Solving, TRUE, FALSE, IF, AND, OR and NOT

Module 2 - Finding and Highlighting Formulas

Lesson 1: How to Find and Highlight Formulas
How to find and highlight formulas, Hierarchy of actions in formulas, ROUND, ROUNDUP, ROUNDDOWN and Using CONVERT

Module 3 - Date and Time

Lesson 1: Understanding and Using Date and Time
Understanding Date and Time formatting, Using formula with your Date and Time, Using DATEDIF and END-OF functions

Module 4 - Macros

Lesson 1: Understanding and Using Macros
Understand Macros, How to create Macros, Creating triggers, Multiple actions and Fixing errors.

Module 5 - Using Formulas

Lesson 1: Using Formulas for Information
How to get information and fix errors using formulas

Module 6 - PivotTables

Lesson 1: Understanding and Using PivotTables
Understanding and creating PivotTables, Using formulas in PivotTables, Making interactive PivotTables

Module 7 - Cleaning your Spreadsheets

Lesson 1: Cleaning your Spreadsheets
Steps to making charts cleaner, Adding projections and trends, Adding pictures and charts, Creating break-even charts

What Will I Learn?
You will learn the advanced features that will improve your excel skills including the following:
– Finding and Highlighting Formulas
– Date and Time Functions
– Macros
– Using formulas to find and edit data
– PivotTables
– Cleaning your spreadsheets
– Problem Solving and Commands

– Microsoft Excel 2013 (most functions taught in this lesson are compatible with other Excel versions)
– A basic understanding of Excel

Single payment of $199


Shawn McCreight

Shawn is a Professionally Certified Instructional Designer and eLearning Developer with 25+ years experience. Committed to continuing education, current and emerging technologies and best practices. Shawn specialises in customizing solutions involving a collaborative approach to ensure the concepts introduced in the program can come to life within an organization and are supported for sustainability.


– Professionally Certified Instructional Designer
– eLearning Developer with 25+ years experience.

Read More


Very Helpful

5 5 1
Easy to follow and the explanations cover not only the process but also their most common uses.

Advanced Excel

5 5 1
This course was perfect! Feel so much more confident with excel yaye

Great Course

5 5 1
Excellent course Thank you

Bit Disappointing

3 5 1
Good content but very brief and superficial, especially when explaining what some of the formula do and how to apply them.

Very Helpfull Course

5 5 1
Very Helpfull Course Thank You!

good course

4 5 1
course provided good information, the clickable course was good but slow at times

Fantastic Course

5 5 1
I loved this course. Thank you Shawn/CourseFirst

Good for a better understanding of Excel

5 5 1
I knew the basics of the excel program but I decided to get a better understanding and this course was perfect

Nice Course

4 5 1
This course really helped to expand my knowledge with Excel

Lots of Content

5 5 1
Lots of Content. Great Course. Interactive course makes it very easy to remember

In depth course!

5 5 1
I always knew I could get much more out of Excel but did not know how. This course was perfect and easy to follow
Review Title
Review Content
Advanced Excel Course Overall rating: ★★★★★ 4.6 based on 11 reviews
5 1