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

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

    • Using Indirect + Address For Accurate Data

    • The Ultimate Guide To 2 Way Lookups

    • A Guide To The SumProduct Formula

    • 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

10 of 10 students recommendSee All

The teacher is very great and i learn new things using Excel. I love to learn more things in future from this particular teacher.
A good excel knowledge will always excel you in business.. Yes thats true by watching these classes. I had a great value of the items provided & had a good understanding how to perform great in excel
Easy to follow formula! This information will help me deal with errors properly. Thanks for this class! :-)





Dragos Stefanescu

TeacHack Founder - Teaching 1000s Online

About Me

I'm an Internet Entrepreneur with a background in both the Management Consulting & Telecommunications industries. The skills that I have acquired during those stints and in previous years in general have unleashed my passion to teach.

I have a wide array of skills that I share with you via my courses

(1) Social Media

One of my true passions, I have invested a lot of time building a presence online. Highlights include:

Creating a connection base of 100+...

See full profile