MS Excel Complete Course – Programmer's Picnic

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. 1. Introduction to Excel Interface POST: excel-introduction-interface
2. 2. Cells, Rows, Columns & Worksheets POST: excel-cells-rows-columns-worksheets
3. 3. Basic Data Entry & Editing POST: excel-data-entry-editing
4. 4. Saving, Opening & Managing Workbooks POST: excel-workbooks-saving-opening
5. 5. Formatting Basics (Font, Color, Alignment) POST: excel-formatting-basics
6. 6. Number Formatting (Currency, Date, Percentage) POST: excel-number-formatting
7. 7. Basic Formulas (SUM, AVERAGE, MAX, MIN) POST: excel-basic-formulas
8. 8. AutoFill, Flash Fill & Quick Analysis POST: excel-autofill-flashfill-quick-analysis
9. 9. Basic Sorting & Filtering POST: excel-sorting-filtering-basics
10. 10. Freeze Panes & View Options POST: excel-freeze-panes-view-options

Level 2 – Intermediate Skills

Build confidence

11. 11. Working with Multiple Sheets POST: excel-multiple-sheets
12. 12. Cell Referencing (Relative, Absolute, Mixed) POST: excel-cell-referencing
13. 13. Conditional Formatting Basics POST: excel-conditional-formatting-basics
14. 14. Text Functions (LEFT, RIGHT, MID, CONCAT, TEXTJOIN) POST: excel-text-functions
15. 15. Date & Time Functions (TODAY, NOW, DATEDIF, EOMONTH) POST: excel-date-time-functions
16. 16. Logical Functions (IF, AND, OR, NOT) POST: excel-logical-functions
17. 17. Lookup Functions (VLOOKUP, HLOOKUP) POST: excel-lookup-functions
18. 18. XLOOKUP – The Modern Lookup POST: excel-xlookup
19. 19. Tables & Structured References POST: excel-tables-structured-references
20. 20. Basic Data Validation (Dropdown lists, Limits) POST: excel-data-validation-basics

Level 3 – Advanced Excel

Power features

21. 21. PivotTables – Complete Guide POST: excel-pivottables-guide
22. 22. Pivot Charts & Dashboards Intro POST: excel-pivot-charts-dashboards-intro
23. 23. Advanced Conditional Formatting POST: excel-conditional-formatting-advanced
24. 24. Advanced Data Validation POST: excel-data-validation-advanced
25. 25. Advanced Lookup (INDEX+MATCH) POST: excel-index-match-lookup
26. 26. Dynamic Arrays (UNIQUE, FILTER, SORT) POST: excel-dynamic-arrays
27. 27. What-If Analysis (Goal Seek, Scenario Manager) POST: excel-what-if-analysis
28. 28. Power Query Basics POST: excel-power-query-basics
29. 29. Power Pivot Basics POST: excel-power-pivot-basics
30. 30. Macros Introduction (No Coding) POST: excel-macros-introduction

Level 4 – Automation with VBA

For power users

31. 31. Introduction to VBA Editor POST: excel-vba-editor-introduction
32. 32. Recording vs Writing Macros POST: excel-macros-recording-vs-writing
33. 33. Variables, Loops & Conditions POST: excel-vba-variables-loops-conditions
34. 34. Working with Ranges in VBA POST: excel-vba-ranges
35. 35. UserForms Basics POST: excel-vba-userforms-basics
36. 36. Automating Reports with VBA POST: excel-vba-automating-reports
37. 37. Connecting Excel with APIs using VBA POST: excel-vba-apis
38. 38. Creating Custom Excel Functions (UDFs) POST: excel-vba-udfs
39. 39. Error Handling in VBA POST: excel-vba-error-handling
40. 40. Building a Mini Excel Add-in POST: excel-vba-mini-addin

Level 5 – Real-World Projects

Apply & practice

41. 41. Monthly Budget Tracker POST: excel-project-monthly-budget-tracker
42. 42. Sales Dashboard with PivotTables POST: excel-project-sales-dashboard
43. 43. Inventory Management Sheet POST: excel-project-inventory-management
44. 44. Attendance Tracker (Auto Marking) POST: excel-project-attendance-tracker
45. 45. Invoice Generator (With PDF Export) POST: excel-project-invoice-generator
46. 46. Data Cleaning Automation (Power Query) POST: excel-project-data-cleaning-power-query
47. 47. Student Marks & Grade Sheet POST: excel-project-student-grade-sheet
48. 48. HR Leave Management Tool POST: excel-project-hr-leave-management
49. 49. Mini CRM on Excel POST: excel-project-mini-crm
50. 50. Excel-Based Data Entry Form POST: excel-project-data-entry-form

Part of the Programmer's Picnic learning series by Champak Roy.