Advanced Microsoft Excel

It’s time to level-up your Excel skills!  This course is the next step from our Microsoft Excel Bootcamp.  You will learn all the advanced functions you need to become a real Excel ninja!


Course Objectives

Excel Ninja is a level that can open career doors, make you more productive, and generally make your life easier.  This course is guaranteed to put you ahead of your co-workers and friends.  In this Advanced Excel Course, we’ll spend time taking your keyboard shortcuts to the next level to make you super productive (get rid of that mouse!). After that, you’ll learn advanced functions that are needed for real analysis in excel…. things like: INDEX/MATCH, MAX, MIN, and some other real powerful tools for analysis.

To wrap up we will get into advanced PivotTable functionality and get you started with Macros. As with all our courses, we focus on REAL WORLD skills that can help you in your job today.  When you finish this course, you will have the tools needed for any analysis! 

Some key things you’ll learn:

  • Advanced Keyboard shortcuts​ for real productivity
  • How to work with Named Ranges
  • Advanced reference formulas
  • Next level PivotTable skills
  • How to get started with Macros
  • And much more!

We also recommend taking our Excel VBA Macros Bootcamp which is a fantastic complement to this course. Or if you need a quick refresher on some of the basics, checkout our Microsoft Excel Bootcamp

Additional Info

Format: 3-6 minute videos, quizzes, and a final exam

Estimated time to complete: 4-5 hours

Category: Financial Tools and Software

Prerequisites: You should have a good working knowledge of Excel (e.g. how to do VLOOKUP, SUMIFS, COUNTIFS, PivotTables)  If you need a quick refresher on some of the basics, checkout our Microsoft Excel Bootcamp.

Enroll in Advanced Microsoft Excel now

Course Content

Expand All