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

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
26 ratings
  1. Great class!

    5

    This class was able to teach and walk through some more advance excel skills, that will undoubtedly make working with spreadsheets better and faster!

  2. Great content.

    5

    Really helped me gaining new excel skills.

Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel