| Sr.No | Topic | Subtopics |
|---|---|---|
| 1 | File Menu | General Overview |
| 2 | Clipboard, Styles & Cells | Clipboard Options, Cell Styles, Cell Formatting |
| 3 | Data Validation |
Basic: Data Validation Options, Custom Rules Advanced: Drop-Down Lists, Dependent Lists, Custom Formulas, Error Messages |
| 4 | Sort & Filter | Basic Sorting, Custom Sorting, Filter Options |
| 5 | Find & Replace | Find Tool, Replace Tool |
| 6 | Insert Options | Picture, Clip Art, Shapes, SmartArt, Links, Text Box |
| 7 | Themes & Page Layout | Themes, Page Setup, Format Menu, Header & Footer, WordArt |
| 8 | Functions & Formulas |
Basic: AutoSum, Logical Functions, Text Functions, Date/Time Functions Advanced: Nested IFs, IFS, SWITCH, INDEX & MATCH, INDIRECT, ADDRESS |
| 9 | Lookup & Reference Functions | VLOOKUP, HLOOKUP, XLOOKUP, XMATCH, OFFSET, CHOOSE |
| 10 | Conditional Formatting | Formula-Based Formatting, Color Scales, Icon Sets, Data Bars |
| 11 | Formula Auditing | Trace Precedents, Trace Dependents, Error Checking, Formula Auditing Tools |
| 12 | Data Tools | Flash Fill, Remove Duplicates, Text to Columns |
| 13 | Comments & Notes | Add/Edit/Delete Comments, Notes Usage, Track Changes (Collaboration) |
| 14 | Outline & Workbook Views | Grouping, Ungrouping, Show/Hide, Zoom, Workbook Views |
| 15 | Window & Workbook Management | New Window, Arrange, Freeze Panes, Track Changes, Workbook Protection |
| 16 | Pivot Tables & Pivot Charts | Creating Pivot Tables, Grouping, Filtering, Calculated Fields, Pivot Charts |
| 17 | Dynamic Named Ranges | OFFSET/INDEX-Based Ranges, Naming Conventions |
| 18 | Array Formulas & Spill Ranges | Traditional Array Formulas, SEQUENCE, FILTER, SORT, UNIQUE |
| 19 | Advanced Charting | Combo Charts, Dynamic Charts |
| 20 | Dashboard Techniques | Interactive Dashboards, Use of Slicers |
| 21 | Data Cleaning Techniques | TRIM, CLEAN, TEXT Functions, Remove Duplicates, Flash Fill, Split Columns |
| 22 | What-If Analysis | Goal Seek, Scenario Manager, Data Tables |
| 23 | Working with Large Data Sets | Advanced Sorting, Advanced Filters, Managing Workbooks |
| 24 | Collaboration & Protection | Sheet and Workbook Protection, Shared Workbook Options, Comments, Track Changes |
| 25 | Mathematical Formulas | ROUND, CEILING, FLOOR (Math & Trig Functions) |