Excel Advanced Formula Hacking
Dragos Stefanescu, TeacHack Founder - Teaching 1000s Online
-
-
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
Class Projects See All
No projects have
been added yet
No projects have
been added yet
No projects have
been added yet
No projects have
been added yet
Students
Projects
-
- --
- Beginner
- Intermediate
- Advanced
- All Levels
- Beg/Int
- Int/Adv
Level
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.
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+...
