MS Excel Complete Course
Step-by-step Excel learning path for students and professionals.
From simple cells to powerful dashboards – one small step every day.
Level 1 – Beginner Essentials
Start here
- 1. Introduction to Excel Interface
- 2. Cells, Rows, Columns & Worksheets
- 3. Basic Data Entry & Editing
- 4. Saving, Opening & Managing Workbooks
- 5. Formatting Basics (Font, Color, Alignment)
- 6. Number Formatting (Currency, Date, Percentage)
- 7. Basic Formulas (SUM, AVERAGE, MAX, MIN)
- 8. AutoFill, Flash Fill & Quick Analysis
- 9. Basic Sorting & Filtering
- 10. Freeze Panes & View Options
Level 2 – Intermediate Skills
Build confidence
- 11. Working with Multiple Sheets
- 12. Cell Referencing (Relative, Absolute, Mixed)
- 13. Conditional Formatting Basics
- 14. Text Functions (LEFT, RIGHT, MID, CONCAT, TEXTJOIN)
- 15. Date & Time Functions (TODAY, NOW, DATEDIF, EOMONTH)
- 16. Logical Functions (IF, AND, OR, NOT)
- 17. Lookup Functions (VLOOKUP, HLOOKUP)
- 18. XLOOKUP – The Modern Lookup
- 19. Tables & Structured References
- 20. Basic Data Validation (Dropdown lists, Limits)
Level 3 – Advanced Excel
Power features
- 21. PivotTables – Complete Guide
- 22. Pivot Charts & Dashboards Intro
- 23. Advanced Conditional Formatting
- 24. Advanced Data Validation
- 25. Advanced Lookup (INDEX+MATCH)
- 26. Dynamic Arrays (UNIQUE, FILTER, SORT)
- 27. What-If Analysis (Goal Seek, Scenario Manager)
- 28. Power Query Basics
- 29. Power Pivot Basics
- 30. Macros Introduction (No Coding)
Level 4 – Automation with VBA
For power users
- 31. Introduction to VBA Editor
- 32. Recording vs Writing Macros
- 33. Variables, Loops & Conditions
- 34. Working with Ranges in VBA
- 35. UserForms Basics
- 36. Automating Reports with VBA
- 37. Connecting Excel with APIs using VBA
- 38. Creating Custom Excel Functions (UDFs)
- 39. Error Handling in VBA
- 40. Building a Mini Excel Add-in
Level 5 – Real-World Projects
Apply & practice
- 41. Monthly Budget Tracker
- 42. Sales Dashboard with PivotTables
- 43. Inventory Management Sheet
- 44. Attendance Tracker (Auto Marking)
- 45. Invoice Generator (With PDF Export)
- 46. Data Cleaning Automation (Power Query)
- 47. Student Marks & Grade Sheet
- 48. HR Leave Management Tool
- 49. Mini CRM on Excel
- 50. Excel-Based Data Entry Form