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

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

      4:54
    • 3. Using Indirect + Address For Accurate Data

      3:59
    • 4. The Ultimate Guide To 2 Way Lookups

      5:08
    • 5. A Guide To The SumProduct Formula

      4:04
    • 6. Dealing With Errors In Excel

      4:55

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