Advanced Microsoft Excel Master Class

5/5 (25 ratings)

See all reviews1,030 students enrolled

This course is designed for those interested in understanding Microsoft Excel on a deeper level.

About This Courseadvanced

The Advanced Microsoft Excel Master Class course is designed for professionals that want to learn the advanced ins and outs of Excel to help boost your productivity and skills for work or personal use.

Andrew explains in depth the advanced topics of Microsoft Excel including VLOOKUP, PivotTables and Macros. This is meant to be an advanced version of the Microsoft Excel Masterclass.

I’m sure if you are looking at this course, you already have some experience with excel but don’t really know how to use excel to its full power.

There are so many different buttons and features in excel that it can become really overwhelming, confusing and frustrating.

I can relate.

I’ve been using excel since high school but it wasn’t until I started getting properly trained that I really understood the different options, tools and functionalities excel really had.

It was a shift in my career.

It has made my job much easier and I now have a highly developed skill desired by employers.

If you don’t understand how to really use excel, you’ll slowly get left behind. I encourage you to take the next step in separating yourself from your peers by learning how to really use excel.

Advanced Sections Covered:

Vlookup
PivotTable
Macros

Our Promise to You
By the end of this course, you will have the knowledge to use Excel more effectively.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and develop the skill of Microsoft Excel!

Course Handbook

Advanced Microsoft Excel Master Class Practice Pack

Add to Cart

Course Curriculum

Course Sections

Section 1 - Vlookup

Vlookup Introduction

Inputs For Vlookup

Recap Of Vlookup First Example

Naming A Range

Name Manager – Ctrl F3

IfError Intro

IfError Simple Use

Using Iferror With Vlookup For Clarity

Example Of Time Consuming Operation

How Vlookup Eliminates Time Consuming Operations

Approximate Match – How It Works

Vlookup And Absolute Cell References

Using Vlookup Within Cost Calculations

Adding Drop Downs & Data Validation

Example Drop Down

Using Vlookup With Drop Downs

Using Vlookup & Drop Downs Without Editing Formula

Special Paste Options & Transposing Tables

Hlookup

Vlookup Reports On Other Sheets

Quickly Copying Vlookup For Reports

Using Vlookup Within Vlookup, Search Using A Search

Additional Values Useful For Reports

LOOKUP Function Intro

Filtering To Sort Data Easily

Checking Lookups For Assurance

Thoughts On Reports & Performance Tracking

Expandable Ranges

COLUMNS Function

Using COLUMNS With Vlookup

COLUMNS & ROWS For Vlookup/Hlookup

Conditional Formatting Intro

Conditional Formatting Example

Conditional Formatting Example 2

Conditional Formatting Example 3

Conditional Formatting Data Bars

Conditional Formatting Color Scales

Conditional Formatting Icon Sets

Using The MATCH Function

Vlookup With MATCH Function

Concatenate And Using “&” To Join

Vlookup With Multiple Inputs

Section 2 - PivotTable

Intro To PivotTables

Creating An “Excel Table” And A PivotTable

PivotTables User Interface

Row Labels & Values

Filtering Row Labels & Cell Types

Different Types of Values

Column Labels

Multiple Row Labels And Stylizing PivotTables

Filtering PivotTables

Filtering PivotTables Part 2

Grouping PivotTable Data

In-depth Sales Tracking

PivotCharts Exercise

Filtering PivotCharts

Line Graphs With PivotCharts

Grouping Numbers Into Ranges

Grouping Price Ranges

Slicer Intro & Pie Graph PivotCharts

Inserting A Slicer

Formatting A Slicer

Section 3 - Macros

Intro To Macros

Developer Tab & VBA Editor

Golden Rules For Macros

Macro Relative References

Using Arrow Keys For Macros

Make Macros Short & Simple

Recording A Macro

Seeing What Macros Record

Adding A Command Button

VBA Coding Inside Command Button

Using Command Buttons

Hard Coding Cells In VBA

Reviews

25 student reviews

Mina says:
Great step by step guide by instructor
Very thorough and I appreciated how the instructed broke everything down into steps so I could go back to where I needed to and replay what he said to grasp the whole concept.
Carlo Zebedee Gualvez says:
Great Course
The course helped me to maximize the full potential of Microsoft Excel and Spreadsheet. I've learned to organize a simple raw data through the help of different techniques taught in this course. A must have for all professionals who are directly involved in data curation.
Chi Lee says:
Now everything makes sense!!
I have been using Macro and VLookUp at work, but sometimes will run into errors and that really take away my time on focusing the work because I have to first figure out how to fix them. I think most of the time I just got lucky, but after this course, everything makes sense now. Now I know "exactly" where I need to go in to look for the error and fix them in a few seconds. What a great course it really helps me to improve skills and save me a great deal of time to better Excel at work and at a personal level. Thank you!