Description
About This 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.
What You’ll Learn
- Advanced Balance Formatting
- Create Dynamic Data Sheet with
- Working with Multiple Consolidation
- VLOOKUP For Dynamically Data Searching
- Using MATCH and INDEX for Advance Filter
- Using Arrays for Dynamic Data Integrity
- PivotTables Using
- Calculated PivotTable field & PivotTable data in a formula
- Wildcard in VLOOKUP formula
- Working with sales sheet
Requirements
- pc
- internet
Course Content
All Videos Step By Step
- Getting started with Excel Interface
- Advanced Balance Formatting With Nearest digit
- Using Arrays for Dynamic Data Integrity
- Create Dynamic Data Sheet with PivotTables
- Working with Multiple Consolidations
- Calculated PivotTable field PivotTable data in a formula
- VLOOKUP For Dynamically Data Searching
- Wildcard in VLOOKUP formula
- Using MATCH and INDEX for Advanced Filter
- Exercise – Salary Sheet
- Conclusion and what’s next
Reviews
There are no reviews yet.