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 |
Good Class!
Great job. This course laid out its material succinctly, and gave plenty of options within the course work. Well done.
Great Course!
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.
Learned a lot
Learned more than I thought I would!
Advanced Excel
Great job Andy, I enjoyed each of the modules very much.
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.