Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (24m)
    • 1. Introduction

    • 2. Match + Index: The Formula Combo That Changed The Way I Worked In Excel

    • 3. Using Indirect + Address For Accurate Data

    • 4. The Ultimate Guide To 2 Way Lookups

    • 5. A Guide To The SumProduct Formula

    • 6. Dealing With Errors In Excel


About This Class

What if you mastered Excel formulas to the point where you could create Investment Banking quality spreadsheets that are efficient, automated and easy to maintain? What I can do is show you the fastest way to master formulas if you are willing to take action. 

What You Will Learn In This Course:

  • Formula Combinations (Match+Index and Indirect+Access) that are invaluable especially when you have to deal with Dashboards and Databasesor when you have a great deal of data that you want to make sense of.
  • 2 Criteria Lookups
  • How to use SumProduct
  • How to Deal With Errors in Excel