ADVANCE EXCEL

ADVANCE EXCEL

DURATION :- 28 days 

LEARN ABOUT

1️⃣ Advanced Formulas and Functions

2️⃣ Data Validation and Conditional Formatting

3️⃣Pivot Tables and Pivot Charts

4️⃣ Using Lookup Functions (VLOOKUP, HLOOKUP, INDEX & MATCH)

5️⃣ Working with Macros and VBA Basics

6️⃣ What-If Analysis and Scenario Manager

7️⃣ Data Consolidation and Linking Multiple Sheets

8️⃣ Power Query and Power Pivot

9️⃣ Advanced Charting Techniques

🔟 Protecting and Securing Workbooks