About Course
Excel has 450+ functions that can do a range of awesome things. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on.
With a combination of functions, you can create some advanced Excel formulas that can do some incredibly advanced things with a press of a key.
If you want to learn how to best use the VLOOKUP function and PivotTable and master the advanced MS Excel functions and formulas, check out our comprehensive course! Enhance your Excel skills with our engaging online classes.
Course Content
All Videos Step By Step
-
01 – Getting started with Excel Interface
06:58 -
02 – Advanced Balance Formatting With Nearest digit
11:14 -
03 – Using Arrays for Dynamic Data Integrity
15:11 -
04 – Create Dynamic Data Sheet with PivotTables
16:28 -
05 – Working with Multiple Consolidation
09:30 -
6 – Calculated PivotTable field PivotTable data in a formula
10:40 -
07 – VLOOKUP For Dynamically Data Searching
11:01 -
08 – Wildcard in VLOOKUP formula
11:38 -
09 – Using MATCH and INDEX for Advance Filter
09:49 -
10 – Exercise – Salary Sheet
18:14 -
11 – Conclusion and what’s next
02:00
Exercise Files
Student Ratings & Reviews
No Review Yet
