1. Excel interface optimization
2. Data types & structured tables
3. Named ranges (modern usage)

1. Logical functions (IF, IFS, SWITCH)
2. Text functions (LEFT, RIGHT, MID, TEXT, TRIM)
3. Dynamic array functions: FILTER, SORT, UNIQUE, SEQUENCE
4. Error handling (IFERROR, ISERROR)

1. XLOOKUP
2. INDEX + MATCH
3. Lookup Essentials

• Module_3 MCQs

1. Removing duplicates
2. Data validation (advanced rules)
3. Text-to-columns, flash fill
4. Power Query basics
5. Slicers

1. Handling Large Datasets & Reducing File Size

1. Importing from multiple sources
2. Data transformation steps
3. Merging & appending datasets
4. Automating refresh workflows

• Module_6 MCQs

1. Advanced Pivot Tables
2. Pivot charts
3. Calculated fields

1. Creating interactive dashboards
2. Dynamic Charts
3. KPI tracking
4. advanced Conditional formatting

1. Data model creation
2. Relationships between Data Model
3. DAX basics (CALCULATE, SUMX)
4. Business intelligence concepts

1. Macro basics (recording & editing)

• Module_10 MCQs

1. Industry Fraud Transaction Case Study
2. Sales Process Issue Analysis
3. Excel for Supply Chain Operations
4. Financial Reporting Issue Analysis