Week 1: Excel Basics (Days 1–7)
Day 1: Getting Started with Excel
Understand the Excel interface (Ribbon, Toolbar, Sheets)
Navigating workbooks and worksheets
Basic data entry: text, numbers, and dates
Practice: Create a simple budget sheet.
Day 2: Basic Operations and Formatting
Copying, pasting, and autofill
Formatting cells: fonts, borders, colors, and alignment
Number formatting: percentages, currency, dates
Conditional formatting basics
Practice: Format a sales report for easy readability.
Day 3: Introduction to Formulas and Functions
Basic formulas: SUM, AVERAGE, MIN, MAX
Cell referencing (relative, absolute, mixed)
Using AutoSum and quick calculations
Practice: Calculate total and average expenses.
Day 4: Sorting and Filtering Data
Sorting data (A-Z, Z-A, by values)
Filtering rows based on conditions
Removing duplicates
Practice: Organize and clean a customer database.
Day 5: Basic Chart Creation
Creating bar, line, and pie charts
Adding titles, labels, and legends
Customizing chart styles
Practice: Visualize monthly sales data.
Day 6: Introduction to Tables
Converting data into Excel tables
Table formatting and structured references
Using table styles and filters
Practice: Create a product inventory table.
Day 7: Recap and Practical Assignment
Review all topics from Week 1
Assignment: Create a formatted financial report with calculations and a chart.
Week 2: Intermediate Skills (Days 8–14)
Day 8: Intermediate Formulas
Logical functions: IF, AND, OR
Text functions: CONCATENATE, LEFT, RIGHT, TRIM
Date functions: TODAY, NOW, YEAR
Practice: Create a leave tracker with conditional logic.
Day 9: Working with Pivot Tables
Creating and customizing pivot tables
Grouping and filtering data in pivot tables
Adding calculated fields
Practice: Analyze sales performance using pivot tables.
Day 10: Advanced Charts
Combo charts
Adding trendlines and secondary axes
Using sparklines for quick insights
Practice: Create a sales trend analysis chart.
Day 11: Data Validation
Creating dropdown lists
Setting input restrictions and error messages
Practice: Design a data entry form with validations.
Day 12: Basic Data Cleaning
Removing blank spaces and duplicates
Splitting text into columns (Text to Columns)
Using Find and Replace
Practice: Clean a messy dataset for analysis.
Day 13: Introduction to Lookup Functions
VLOOKUP and HLOOKUP basics
XLOOKUP for advanced lookups
Practice: Fetch product prices from a reference table.
Day 14: Recap and Practical Assignment
Review all topics from Week 2
Assignment: Create a dynamic sales dashboard using pivot tables and charts.
Week 3: Advanced Skills (Days 15–21)
Day 15: Advanced Formulas
INDEX and MATCH
Nested IF functions
Array formulas and dynamic arrays
Practice: Create a performance evaluation sheet.
Day 16: Advanced Pivot Tables
Using slicers and timelines
Advanced filtering and grouping
Practice: Build an interactive report with slicers.
Day 17: Advanced Conditional Formatting
Custom formatting rules
Data bars, color scales, and icon sets
Practice: Highlight top-performing employees in a dataset.
Day 18: Power Query Basics
Importing data from external sources
Cleaning and transforming data
Merging and appending datasets
Practice: Consolidate monthly sales files into one dataset.
Day 19: Introduction to Macros
Recording and running simple macros
Assigning macros to buttons
Practice: Automate a repetitive formatting task.
Day 20: Creating Dashboards
Combining pivot tables, charts, and slicers
Designing an interactive dashboard layout
Practice: Create a management-level dashboard.
Day 21: Recap and Practical Assignment
Review all topics from Week 3
Assignment: Build a fully functional KPI dashboard.
Week 4: Practical Applications and Job Preparation (Days 22–30)
Day 22: Job-Specific Applications
Financial analysis (profit/loss statement)
Inventory management
HR tools (attendance and payroll tracker)
Practice: Create a payroll tracker for employees.
Day 23: Advanced Data Analysis
What-If analysis: Goal Seek, Data Tables
Solver for optimization problems
Practice: Solve a resource allocation problem.
Day 24: Collaboration and Sharing
Protecting sheets and workbooks
Track changes and comments
Sharing and collaborating using OneDrive
Practice: Share and protect a project file.
Day 25: Final Practical Assignment
Real-world problem-solving project
o Example: Analyze and visualize a company's sales performance.
o Deliverables: Clean dataset, pivot table, charts, and dashboard.
Day 26: Mock Job Test Preparation
Solve common Excel-based interview tests:
o Data cleaning and analysis
o Basic to advanced formulas
o Dashboard creation
Day 27: Revision Day
Revisit complex topics like INDEX/MATCH, macros, and dashboards
Clarify doubts and reattempt previous assignments
Day 28: Job-Specific Practice
Tailor skills to the specific job role you're applying for:
o Finance: Focus on financial modeling.
o Sales: Emphasize dashboards and reports.
o HR: Learn payroll and attendance management.
Day 29: Final Assessment
Take a comprehensive Excel test:
o 50% Formulas and Functions
o 30% Data Analysis
o 20% Dashboard Creation
Day 30: Certification and Portfolio
Organize your completed projects into a portfolio
Export dashboards and analysis for interviews
Practice explaining your work for interviews.
This course ensures you're job-ready in just 30 days. Let me know if you’d like help with
specific exercises or resources for any day!
