● Excel Interface & Navigation
● Workbook & Worksheet Management
● Data Types & Formatting
● Shortcuts & Productivity Tips

● Sorting & Filtering (Advanced Filter)
● Remove Duplicates
● Text to Columns
● Flash Fill
● Data Validation (Drop-downs, Rules)
● Conditional Formatting (Advanced Rules)

● Logical Functions
● IF, IFS, AND, OR, NOT
● Lookup & Reference
● VLOOKUP, HLOOKUP
● INDEX & MATCH
● XLOOKUP
● Text Functions
●LEFT, RIGHT, MID, LEN
● TRIM, CLEAN, CONCAT, TEXT
Date & Time
● TODAY, NOW, DATEDIF, EOMONTH
Statistical & Math
● SUMIFS, COUNTIFS, AVERAGEIFS
● ROUND, CEILING, FLOOR

● Creating Pivot Tables
● Grouping & Calculated Fields
● Slicers & Timelines
● Pivot Charts
● Interactive Dashboards

● Line, Bar, Column, Pie Charts
● Dynamic Charts
● Best Practices for Business Reports
● Formatting Data

● Dashboard Design Principles
● Dynamic Dashboards using Pivot & Formulas
● Interactive Controls (Slicers, Drop-downs)
● Executive-level Reporting

● Importing Data (Excel, CSV, Text, Web)
● Data Cleaning & Transformation
● Merge & Append Queries
● Refresh Automation
● Data Modeling Basics

● Creating Relationships
● Data Model Concepts
● Measures vs Calculated Columns
● Time Intelligence (Basics)

● Goal Seek
● Scenario Manager
● Data Tables
● Forecast Sheets
● Analysis

● Macro Recording
● Automating Tasks
● Buttons & Forms
● Error Handling (Basics)

● Advanced Shortcuts
● Template Creation
● Protecting Sheets & Workbooks
● Collaboration & Version Control

● Business Presentation of Data
● Resume & Excel Portfolio Creation
● Interview Questions & Case Studies
● Corporate Excel Best Practices