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
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+...