Microsoft Excel Certification

DAY 1 – Introduction to Excel & Basic Operations

Topics

• Excel interface, ribbons, worksheets
• Working with rows, columns, cells
• Formatting: borders, colors, styles
• Basic formulas: SUM, AVERAGE, COUNT, MIN, MAX
• Time-saving shortcuts

Hands-On

• Student score sheet
• Formatting & basic calculations

DAY 2 – Data Cleaning & Preparation

Topics

• Remove duplicates
• Text-to-columns
• Flash Fill
• Data validation
• Sorting & filtering
• Cleaning messy data

Hands-On

• Clean an HR dataset
• Validate entries with rules

DAY 3 – Logical & Text Formulas

Topics

• IF, AND, OR, NOT logic
• Nested IF
• Text functions: LEFT, RIGHT, MID, LEN, TRIM, CONCAT
• Use cases in HR, Finance & Operations

Hands-On

• HR salary structure logic
• Text cleanup automation

DAY 4 – Lookup & Reference Functions

Topics

• VLOOKUP, HLOOKUP
• XLOOKUP (Latest Excel function)
• MATCH
• INDEX
• INDIRECT
• OFFSET basics

Hands-On

• Create a product lookup sheet
• Build a student result fetcher

DAY 5 – Date, Time & Math Formulas

Topics

• TODAY, NOW
• DATEDIF
• NETWORKDAYS
• EOMONTH
• Rounding functions
• Mathematical functions for analysis

Hands-On

• Salary payable calculation
• Age & duration calculator

DAY 6 – Data Analysis Tools

Topics

• Conditional formatting (Advanced)
• What-If Analysis
• Goal Seek
• Scenario Manager
• Solver basics

Hands-On

• KPI coloring dashboard
• Break-even analysis

DAY 7 – PivotTables & PivotCharts

Topics

• PivotTable creation
• Grouping, summarizing, filtering
• Calculated fields
• PivotCharts
• Slicers & Timelines

Hands-On

• Sales Pivot dashboard
• Customer trend analysis

DAY 8 – Excel Dashboards (Beginner to Advanced)

Topics

• Dashboard planning
• Data modeling
• Combining PivotCharts & formulas
• Design principles
• Interactive dashboards

Hands-On

• Build a Sales Dashboard
• Use slicers to control charts

DAY 9 – Excel Automation Basics

Topics

• Introduction to Macros
• Recording and running macros
• Intro to VBA basics (optional)
• Using templates & automation ideas
• Error-proofing spreadsheets

Hands-On

• Record macro for monthly report
• Auto-generate formatting buttons

DAY 10 – Final Project & MOS Certification Prep

Topics

• Full syllabus revision
• Practice tests for MOS
• Tips to pass MOS Excel exam
• Interview questions for Excel-based roles

Final Project (Choose One)

• HR Dashboard (Attendance, Leaves)
• Finance Dashboard (Budget vs Actual)
• Sales Dashboard (Monthly KPI Report)
• Academic Dashboard (Student Performance)

Outcome:

Students complete a portfolio-ready Excel project and become MOS certification ready.

Career Paths After This Course

• MIS Executive
• Junior Data Analyst
• HR Analyst
• Finance Analyst
• Marketing Analyst
• Operations Executive