P7 Excel Online Classes
Excel Basic to Advance – Practical & Job Oriented Training
📅 Daily & Weekend
⏳ Duration: 10 Hours
💰 Course Fees: ₹300
🎥 Live Classes
✅ Affordable course for Students & Professionals.
⏳ Batches: Daily – 1 Hour, Weekend – 2 Hours.
📚 Practice materials via WhatsApp & Email.
📆 Starts: 1st & 15th of every month.
👥 Max 20 students per batch.
⏳ Batches: Daily – 1 Hour, Weekend – 2 Hours.
📚 Practice materials via WhatsApp & Email.
📆 Starts: 1st & 15th of every month.
👥 Max 20 students per batch.
✨ Topics✨
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 🎉