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

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

      4:54
    • Using Indirect + Address For Accurate Data

      3:59
    • The Ultimate Guide To 2 Way Lookups

      5:08
    • A Guide To The SumProduct Formula

      4:04
    • 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

11 of 11 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! :-)

65

Students

--

Projects

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