Advanced Excel Mastery Course
Master 60+ Functions, Automation & AI Tools
-
Working with Functions (Formulas)▼
- Conditional Expressions (IF, Nested IF)
- Logical: AND, OR, NOT Functions
- VLOOKUP, HLOOKUP & XLOOKUP
- MATCH, INDEX & Dynamic Lookup
- Consolidating Multiple Sheets
-
Data Management & Templates▼
- Data Validation (Dropdown Lists & Custom)
- Designing & Standardizing Templates
- Multi-level Sorting & Advanced Filtering
- Cleaning & Formatting Raw Data
-
Reports & Pivot Tables▼
- Subtotals & Grouping Data
- Pivot Tables (Creation & Styling)
- Pivot Charts & Visual Reports
- Slicers, Timelines & External Data
-
Power Functions (60+)▼
- COUNTIFS, SUMIFS, AVERAGEIFS
- Financial: PMT, PPMT, IPMT, NPV
- Database: DSUM, DCOUNT, DAVERAGE
- Advanced Date, Time & Text Functions
-
What-If Analysis & Formatting▼
- Goal Seek & Data Tables
- Scenario Manager for Business Planning
- Advanced Conditional Formatting
- Relative, Absolute & Mixed References
-
Charts, Security & Macros▼
- Advanced Dynamic Charts & Dashboards
- Protecting Worksheets & Specific Cells
- Introduction to Macros (Automation)
-
Bonus: Excel with AI Tools▼
- Leveraging AI for Complex Formulas
- Smart Data Analysis & Automation Tools
