Tools Required: Microsoft Excel (Office 365 or Excel 2016+), Windows PC, a recommended laptop with internet is mandatory
Phase 1: Beginner Level (Days 1–5 | 10 Hours)
Day 1: Excel Interface & Basics (2 Hours)
- Excel layout, ribbons, workbook navigation
- Data entry, formatting, autofill, basic shortcuts
- Saving, printing, and file types
- Mini task: formatted invoice sheet
Day 2: Basic Formulas & Functions (2 Hours)
- Cell references: relative, absolute
- Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT
- AutoSum, formula auditing
- Mini task: monthly expense calculator
Day 3: Working with Tables & Sorting (2 Hours)
- Creating and formatting tables
- Sorting and filtering data
- Conditional formatting basics
- Mini task: sales tracker with filters
Day 4: Charts & Visualization (2 Hours)
- Column, bar, line, pie charts
- Chart customization: titles, legends, colors
- Sparklines and data bars
- Mini task: product performance dashboard
Day 5: Basic Data Validation & Printing (2 Hours)
- Drop-down lists, input messages
- Print setup: scaling, page breaks, headers/footers
- Mini project: attendance sheet with validation
- Recap and quiz
Phase 2: Intermediate Level (Days 6–10 | 10 Hours)
Day 6: Logical & Text Functions (2 Hours)
- IF, AND, OR, NOT
- CONCAT, TEXTJOIN, LEFT, RIGHT, MID, LEN
- Mini task: employee eligibility checker
Day 7: Lookup Functions (2 Hours)
- VLOOKUP, HLOOKUP, XLOOKUP (if available)
- INDEX + MATCH combo
- Mini task: product price finder
Day 8: Date & Time Functions (2 Hours)
- TODAY, NOW, DAY, MONTH, YEAR
- DATEDIF, NETWORKDAYS, WORKDAY
- Mini task: project timeline calculator
Day 9: Pivot Tables & Slicers (2 Hours)
- Creating pivot tables, field settings
- Grouping, summarizing, filtering
- Adding slicers and timelines
- Mini task: regional sales summary
Day 10: Intermediate Dashboard Project (2 Hours)
- Combining charts, pivot tables, slicers
- Layout design and interactivity
- Final project: sales dashboard
- Recap and quiz
Phase 3: Advanced Level (Days 11–15 | 10 Hours)
Day 11: Advanced Formulas & Named Ranges (2 Hours)
- Nested IFs, IFS, SWITCH
- Named ranges, dynamic ranges
- Mini task: performance grading system
Day 12: Data Validation & Error Handling (2 Hours)
- Advanced validation rules
- ISERROR, IFERROR, ISBLANK
- Mini task: clean data entry form
Day 13: Power Query Basics (2 Hours)
- Importing data from files and web
- Cleaning, transforming, merging tables
- Mini task: automated data cleanup
Day 14: Macros & VBA Introduction (2 Hours)
- Recording macros, assigning buttons
- Intro to VBA editor, basic syntax
- Mini task: automated report generator
Day 15: Final Capstone Project & Wrap-up (2 Hours)
- Full dashboard with formulas, charts, pivot tables, slicers
- Optional: Power Query + Macro integration
- Final quiz, certification roadmap, career tips
Reviews
There are no reviews yet.