About This CourseBeginner
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:
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!
Advanced Microsoft Excel Master Class Practice PackAdd to Cart
Section 1 - Vlookup
Inputs For Vlookup
Recap Of Vlookup First Example
Naming A Range
Name Manager – Ctrl F3
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
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
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
Multiple Row Labels And Stylizing PivotTables
Filtering PivotTables Part 2
Grouping PivotTable Data
In-depth Sales Tracking
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