MS Excel Mastery (Syllabus)
| Sno. | Topic |
| 1 | Introduction to Excel |
| 2 | Data Entry & Basic Formulas in Excel |
| 3 | Sorting Data in Excel |
| 4 | Filter Data in Excel |
| 5 | Advanced Filter in Excel With Macro |
| 6 | Data validation in Excel |
| 7 | Condition Formating in Excel |
| 8 | Text to Columns & Flash Fill |
| 9 | Remove Duplicates & Unique Formula |
| 10 | Paste Special in Excel |
| 11 | If Formula in Excel |
| 12 | if With AND Formula in Excel |
| 13 | if With OR Formula in Excel |
| 14 | Nested in Formula in Excel |
| 15 | Sumif and countif |
| 16 | SumIFS and CountIFS Formula |
| 17 | Match and Index Formula |
| 18 | Vlookup and Hlookup Formla |
| 19 | Text Fformulas in Excel |
| 20 | Date Formula in Excel |
| 21 | Pivot Table in Excel |
| 22 | Pivot Chart in Excel |
| 23 | Slicer in Pivot Table |
| 24 | Timeline and Pivot Table Options |
| 25 | Sort & Ffilter Formula |
| 26 | Financial Function in Excel |
| 27 | Xlookup Formula in Excel |
| 28 | Printing Tips in Excel |
| 29 | Macros and Addins in Excel |
| 30 | Use of ChatGPT in Excel |
| 31 | AI Powered Data Cleaning |
