Excel Advanced Formula Hacking | Dragos Stefanescu | Skillshare
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





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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

Report class