Module 1: Advanced Functions and Formulas

• Nested IF, AND, OR functions
• Advanced Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH
• Logical & Error Handling Functions: IFERROR, ISERROR, IFNA
• Date & Time Functions: TEXT, TODAY, EOMONTH, NETWORKDAYS
• Text Functions: LEN, MID, FIND, LEFT, RIGHT, SUBSTITUTE
• Dynamic Arrays & Spill Functions: UNIQUE, FILTER, SORT, SEQUENCE

Module 2: Data Validation and Conditional Formatting

• Creating custom validation rules
• Dynamic dropdown lists using Data Validation
• Applying advanced conditional formatting with formulas
• Highlighting duplicate & unique values

Module 3: Data Analysis and PivotTables

• Creating & customizing PivotTables
• Grouping and filtering data dynamically
• Calculated Fields & Calculated Items in PivotTables
• Using Slicers and Timelines for data analysis
• Introduction to Power Pivot and Data Model

Module 4: Data Cleaning and Transformation

• Removing duplicates & splitting text using Text to Columns
• Using Flash Fill for quick data transformations
• Advanced Find & Replace techniques
• Cleaning data with Power Query (Get & Transform)

Module 5: Advanced Charting and Visualization

• Creating dynamic charts with OFFSET and Named Ranges
• Customizing Combo Charts (e.g., Line + Bar)
• Creating interactive dashboards with Slicers & PivotCharts
• Waterfall, Histogram, Box & Whisker Charts
• Creating Sparklines for trend visualization

Module 6: Automation with Macros and VBA (Optional)

• Introduction to Macros & VBA
• Recording & Running Macros
• Writing Basic VBA Scripts
• Automating repetitive tasks using VBA

Module 7: Power Query & Power Pivot (Data Modeling)

• Importing data from multiple sources
• Merging & appending datasets
• Creating relationships between tables
• Introduction to DAX (Data Analysis Expressions)

Module 8: Financial & Statistical Analysis

• Using NPV, IRR, PMT, PV, FV for financial modeling
• Regression Analysis & Forecasting in Excel
• Statistical Functions: STDEV, VAR, CORREL, TREND
• Creating Monte Carlo Simulations

Module 9: What-If Analysis & Scenario Planning

• Goal Seek & Solver for optimization
• Data Tables (One-Variable & Two-Variable)
• Scenario Manager for financial projections