Batch Date:
01-11-2025 (1 Month)
Timing:
9 to 10 PM (Mon-Sat)
Device:
Teams (Mobile/Laptop)
Material:
PPT, PDF & Live Training.
Course Fee:
Rs. 200/-
✨ Excel Basic to Advance Classes ✨
1 Month Learning Plan
1. Introduction to Excel Interface
2. Workbook & Worksheet Basics
3. Entering and Editing Data
4. Formatting Cells & Text
5. Adjusting Rows, Columns & Sheets
6. Basic Formulas – SUM, AVERAGE
7. Understanding Cell References
8. Fill Handle & AutoFill Tricks
9. Sorting & Filtering Data
10. Conditional Formatting Basics
11. Working with Dates & Time
12. Text Functions – LEFT, RIGHT, MID, CONCAT
13. Number Functions – ROUND, INT, MOD
14. Logical Functions – IF, AND, OR
15. Lookup Functions – VLOOKUP, HLOOKUP
16. Charts – Column, Pie, Line
17. Formatting Charts & Legends
18. Using Pivot Tables – Basics
19. Pivot Charts & Formatting
20. Data Validation & Drop-down Lists
21. Freezing Panes & Split Window
22. Protecting Worksheets & Cells
23. Advanced Formulas – INDEX & MATCH
24. Macros Basics & Recording
25. Workbook Review & Comments
26. Printing & Page Setup Options
27. Shortcuts & Productivity Tips
28. Real-world Excel Project Practice
29. Revision of Key Topics
30. Certificate Day & Completion 🎉