Please ensure Javascript is enabled for purposes of website accessibility

About This Course

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

Course Curriculum

3h 10m

Section 1 - Vlookup
Vlookup Introduction 00:00:00
Inputs For Vlookup 00:00:00
Recap Of Vlookup First Example 00:00:00
Naming A Range 00:00:00
Name Manager – Ctrl F3 00:00:00
IfError Intro 00:00:00
IfError Simple Use 00:00:00
Using Iferror With Vlookup For Clarity 00:00:00
Example Of Time Consuming Operation 00:00:00
How Vlookup Eliminates Time Consuming Operations 00:00:00
Approximate Match – How It Works 00:00:00
Vlookup And Absolute Cell References 00:00:00
Using Vlookup Within Cost Calculations 00:00:00
Adding Drop Downs & Data Validation 00:00:00
Example Drop Down 00:00:00
Using Vlookup With Drop Downs 00:00:00
Using Vlookup & Drop Downs Without Editing Formula 00:00:00
Special Paste Options & Transposing Tables 00:00:00
Hlookup 00:00:00
Vlookup Reports On Other Sheets 00:00:00
Quickly Copying Vlookup For Reports 00:00:00
Using Vlookup Within Vlookup, Search Using A Search 00:00:00
Additional Values Useful For Reports 00:00:00
LOOKUP Function Intro 00:00:00
Filtering To Sort Data Easily 00:00:00
Checking Lookups For Assurance 00:00:00
Thoughts On Reports & Performance Tracking 00:00:00
Expandable Ranges 00:00:00
COLUMNS Function 00:00:00
Using COLUMNS With Vlookup 00:00:00
COLUMNS & ROWS For Vlookup/Hlookup 00:00:00
Conditional Formatting Intro 00:00:00
Conditional Formatting Example 00:00:00
Conditional Formatting Example 2 00:00:00
Conditional Formatting Example 3 00:00:00
Conditional Formatting Data Bars 00:00:00
Conditional Formatting Color Scales 00:00:00
Conditional Formatting Icon Sets 00:00:00
Using The MATCH Function 00:00:00
Vlookup With MATCH Function 00:00:00
Concatenate And Using “&” To Join 00:00:00
Vlookup With Multiple Inputs 00:00:00
Section 2 - PivotTable
Intro To PivotTables 00:00:00
Creating An “Excel Table” And A PivotTable 00:00:00
PivotTables User Interface 00:00:00
Row Labels & Values 00:00:00
Filtering Row Labels & Cell Types 00:00:00
Different Types of Values 00:00:00
Column Labels 00:00:00
Multiple Row Labels And Stylizing PivotTables 00:00:00
Filtering PivotTables 00:00:00
Filtering PivotTables Part 2 00:00:00
Grouping PivotTable Data 00:00:00
In-depth Sales Tracking 00:00:00
PivotCharts Exercise 00:00:00
Filtering PivotCharts 00:00:00
Line Graphs With PivotCharts 00:00:00
Grouping Numbers Into Ranges 00:00:00
Grouping Price Ranges 00:00:00
Slicer Intro & Pie Graph PivotCharts 00:00:00
Inserting A Slicer 00:00:00
Formatting A Slicer 00:00:00
Section 3 - Macros
Intro To Macros 00:00:00
Developer Tab & VBA Editor 00:00:00
Golden Rules For Macros 00:00:00
Macro Relative References 00:00:00
Using Arrow Keys For Macros 00:00:00
Make Macros Short & Simple 00:00:00
Recording A Macro 00:00:00
Seeing What Macros Record 00:00:00
Adding A Command Button 00:00:00
VBA Coding Inside Command Button 00:00:00
Using Command Buttons 00:00:00
Hard Coding Cells In VBA 00:00:00

Course Reviews

5

5
30 ratings
  1. Good Class!

    5

    Great job. This course laid out its material succinctly, and gave plenty of options within the course work. Well done.

  2. Anonymous

    Great Course!

    5

    Even though I already had some prior knowledge of Excel, this course definitely added some additional tools to my arsenal. PivotTables and Macros seemed intimidating in the past, but the instructor does a great job at breaking them down in a way that is easy to understand. Highly recommend this for anyone who wants to dive deeper into what Excel has to offer.

  3. Anonymous

    Learned a lot

    5

    Learned more than I thought I would!

  4. Anonymous

    Advanced Excel

    5

    Great job Andy, I enjoyed each of the modules very much.

  5. Anonymous
    Heather Allen June 9, 2020 at 20:47 PM

    5

    WOW! This advanced class opened my eyes and furthered my love and curiosity to Excel. I’ve worked with Vlookups and Pivot Tables before, but this was my first time hearing about Macros. This would have been a game changer in my last job; I can’t wait to use this in a new job!! Great teacher, easy to follow along, and short videos which makes it easy to step away if you need to.