| Sr. No | Topics | Sub Topics |
| 1 | Data Sorting | A To Z Sorting |
| Z To A Sorting | ||
| Custom Sort | ||
| Font Colour Wise Data Sorting | ||
| Cell Colour Wise Data Sorting | ||
| 2 | Filter | Normal Filter |
| Text Colour Filter | ||
| Cell Colour Filter | ||
| 3 | Conditional Formating | Highlight Duplicate Value |
| Highlight Top 10 Value | ||
| Highlight Bottom 10 Value | ||
| Highlight Greater Than Less Than Value | ||
| 4 | Math & Trig Function | SUM Function |
| SUMIF Function | ||
| COUNT FUNCTION | ||
| COUNTA FUNCTION | ||
| COUNTIF FUNCTION | ||
| DCOUNT FUNCTION | ||
| DCOUNTA FUNCTION | ||
| SUBTOTAL FUNCTION | ||
| AGGREGATE FUNCTION | ||
| 5 | Statical Function | AVERAGE FUNCTION |
| MIN FUNCTION | ||
| MAX FUNCTION | ||
| 6 | Logical Function | IF FUNCTION |
| OR FUNCTION | ||
| AND FUNCTION | ||
| 7 | Text Function | TEXT |
| PROPER FUNCTION | ||
| UPPER FUNCTION | ||
| LOWER FUNCTION | ||
| REPT | ||
| REPLACE | ||
| 8 | Date & Time Function | DATE |
| DAY | ||
| MONTH | ||
| YEAR | ||
| TIME | ||
| HOUR | ||
| MINUTE | ||
| SECOND | ||
| 9 | Lookup Function | LOOKUP |
| VLOOKUP | ||
| HLOOKUP | ||
| XLOOKUP | ||
| 10 | Pivot Table | PIVOT TABLE |
| PIVOT CHART | ||
| 11 | Chart & Graph | COLUMN CHART |
| BAR CHART | ||
| LINE CHART | ||
| PIE CHART |
