Please ensure Javascript is enabled for purposes of website accessibility
Advanced Microsoft Excel Master Class
5.0( 32 REVIEWS )
6732 STUDENTS
3h 10m

This course is designed for those interested in understanding Microsoft Excel on a deeper level.

Read more.
Students
6732
Course Skill Level
Advanced
Time Estimate
3h 10m

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

5.0
32 Ratings
  1. Anonymous

    MS EXCEL ADVANCED

    5.0

    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.

  2. Anonymous

    Interesting and easy to follow

    5.0

    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.

  3. Anonymous

    Good Class!

    5.0

    Great job. This course laid out its material succinctly, and gave plenty of options within the course work. Well done.

  4. Anonymous

    Great Course!

    5.0

    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.

  5. Anonymous

    Learned a lot

    5.0

    Learned more than I thought I would!

Are you interested in higher education?

We’re working on a service to connect learners with higher education programs, enter your name and email to join the waitlist

You’ve been added to the waitlist!

Keep an eye out for the announcement via email.

You’ll be the first to know.

3954196

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

3954197

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!