Module 1: Advanced Formulae & Functions

Logical Functions: IF, Nested IF, IFS, AND, OR, NOT, IFERROR

Lookup & Reference: VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH (Standard & Advanced)

Statistical & Mathematical: COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, RANK

Text & Date Functions: CONCAT, TEXTJOIN, LEFT, RIGHT, MID, NETWORKDAYS, WORKDAY

Module 2: Data Management & Analysis

Advanced Data Sorting & Filtering: Multi-level sorting, Advanced Filter using criteria

Data Validation: Creating Dependent Drop-down lists, Custom validation rules

Flash Fill & Text to Columns: Cleaning and splitting complex data strings

Removing Duplicates: Conditional and absolute data cleaning

Module 3: Data Visualization & Reporting

Conditional Formatting: Highlighting trends, using Data Bars, Icon Sets, and Formula-based formatting

Advanced Charting: Pivot Charts, Combo Charts, Dual-Axis Charts, Trendlines, and Sparklines

Interactive Dashboards: Designing dynamic business dashboards using Slicers and Timelines

Module 4: Pivot Tables & Power Tools

Advanced Pivot Tables: Grouping data, Calculated Fields, Calculated Items, Custom layouts

Introduction to Power Query: Importing, transforming, and cleaning external data

Data Modeling: Understanding relationships between multiple tables

Module 5: Automation & Security

Macro Automation: Recording Macros, Assigning Macros to buttons/shapes

Introduction to VBA: Basic syntax, understanding modules, and automating repetitive tasks

Sheet & Workbook Protection: Locking specific cells, password protecting formulas, and tracking changes