This course is designed for those interested in understanding Microsoft Excel on a deeper level.
Read more.Instructor
My name is Andy Norris and I've been an engineer for 5 years. I graduated from SDSU with a bachelor's degree in mechanical engineering, and I am EIT certified in California. I currently work as a salary design engineer for a multinational diversified engineering and manufacturing corporation. I have a passion for teaching and I hope my courses help you succeed in your professional life, as well as your personal life.
Only want this course? Buy this course for $199 $29 and keep lifetime access.
Click here
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.
10 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 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 Review
5.0
32 RatingsRelated Courses
MS EXCEL ADVANCED
The course is well worthwhile taking. I was able to learn some new routines and enjoyed the method of presentation. I am glad that I enrolled in this course of Advanced Excel.
Interesting and easy to follow
I found Andrew very clear in his explanation. The information and the exercises were easy to follow and increasingly complicated, helping to learn step by step.
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!