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 |
Ineradicable course
very helpful.
Great Class!
I love the fact that the class is really well put together and well explained step by step. The instructor’s voice sounds like Dane Cook’s voice and it makes me smile while listening to the class! 🙂
This advance class goes through a lot of advance and difficult topics that not everyone knows about! I think this class will make my job easier and make me look excel savvy!
Good knowledge
Instructor is knowledgeable in excel formatting
Great class!
This class was able to teach and walk through some more advance excel skills, that will undoubtedly make working with spreadsheets better and faster!
Great content.
Really helped me gaining new excel skills.