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
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! :-)
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+...
