Excel: Basic to Advanced

Formulas, pivots, dashboards.

1 month (4 weeks)
20 topics
Final exam

Book a trainer

Your learning path

4 weeks from start to certificate

1
Week 1
Excel essentials
2
Week 2
Working with data
3
Week 3
Analysis & visuals
4
Week 4
Advanced & automation
Finish
Exam & certificate

Every week

How each week works

Learn

Live class with your trainer

Practice

Guided hands-on exercises

Build

Mini project for your portfolio

Review

Feedback and Q&A

Concept lab

See how the core concepts connect

Follow the path from foundations to real workplace application. Every concept feeds the next project.

Week 1

Introduction to Excel Interface

Week 1

Basic Data Entry & Formatting

Week 2

Organizing Data into Tables

Week 2

Sorting and Filtering Data

Week 3

Conditional Formatting

Week 3

Logical Functions for Decisions

Week 4

PivotTables for Data Summarization

Week 4

PivotCharts for Visual Analysis

Topics per week

20 topics · 80 lessons

Week 15

Week 25

Week 35

Week 45

Course curriculum

Week 1 · 5 topics · 20 lessons

Excel essentials

By the end of this week: Learners will competently navigate Excel, manage worksheets, and apply basic formulas for data entry and manipulation.

1.1Introduction to Excel Interface
- Ribbon, Tabs, Groups, Commands
- Workbooks, Worksheets, Cells
- Formula Bar, Name Box, Status Bar
- Quick Access Toolbar Customization
1.2Basic Data Entry & Formatting
- Text, Numbers, Dates, Times
- Fill Handle, AutoFill Options
- Number, Date, Currency Formats
- Alignment, Borders, Cell Styles
1.3Understanding Formulas & Functions
- Operators: +, -, *, /, ^
- Cell References: Relative, Absolute
- Basic Functions: SUM, AVERAGE
- MIN, MAX, COUNT Functions
1.4Worksheet & Workbook Management
- Insert, Delete, Move Sheets
- Rename, Group, Hide Sheets
- Copy, Paste, Paste Special
- Find and Replace Data
1.5Printing & Sharing Workbooks
- Page Layout, Print Area Setup
- Page Breaks, Print Titles
- Headers and Footers
- PDF Export, Share Options

Week 1
Excel essentials

Introduction to Excel Interface

Basic Data Entry & Formatting

Understanding Formulas & Functions

Worksheet & Workbook Management

Printing & Sharing Workbooks

Hands-on project

Personal Budget Tracker

Week 2 · 5 topics · 20 lessons

Working with data

By the end of this week: Learners will efficiently organize, clean, filter, and structure data using Excel's powerful data management features.

2.1Organizing Data into Tables
- Creating Excel Tables
- Table Styles and Options
- Adding, Deleting Rows/Columns
- Structured References
2.2Sorting and Filtering Data
- Single Level Sort
- Multi-Level Sort
- Basic AutoFilter
- Custom and Advanced Filters
2.3Text Manipulation Functions
- CONCATENATE & CONCAT
- LEFT, RIGHT, MID, LEN
- TRIM, CLEAN, PROPER
- FIND, SEARCH, SUBSTITUTE
2.4Data Validation & Integrity
- Data Validation Rules
- Input Messages, Error Alerts
- Dependent Drop-Down Lists
- Circle Invalid Data
2.5Removing Duplicates & Flash Fill
- Remove Duplicates Feature
- Highlighting Duplicates
- Flash Fill for Patterns
- Text to Columns Wizard

Week 2
Working with data

Organizing Data into Tables

Sorting and Filtering Data

Text Manipulation Functions

Data Validation & Integrity

Removing Duplicates & Flash Fill

Hands-on project

Customer Sales Database

Week 3 · 5 topics · 20 lessons

Analysis & visuals

By the end of this week: Learners will perform complex data analysis using lookup functions, conditional logic, and create insightful visualizations.

3.1Conditional Formatting
- Highlight Cells Rules
- Top/Bottom Rules
- Data Bars, Color Scales
- Icon Sets, New Rule Manager
3.2Logical Functions for Decisions
- IF Statement Basics
- Nested IF Statements
- AND, OR, NOT Functions
- IFERROR, IFERROR with VLOOKUP
3.3Lookup and Reference Functions
- VLOOKUP for Exact Match
- VLOOKUP for Approximate Match
- HLOOKUP Introduction
- INDEX and MATCH Combination
3.4Creating Effective Charts
- Column, Bar, Line Charts
- Pie, Doughnut Charts
- Scatter, Bubble Charts
- Chart Design, Layout, Formatting
3.5Advanced Charting & Sparklines
- Combo Charts, Dual Axis
- Trendlines, Error Bars
- Sparklines: Line, Column, Win/Loss
- Dynamic Chart Ranges

Week 3
Analysis & visuals

Conditional Formatting

Logical Functions for Decisions

Lookup and Reference Functions

Creating Effective Charts

Advanced Charting & Sparklines

Hands-on project

Employee Performance Dashboard

Week 4 · 5 topics · 20 lessons

Advanced & automation

By the end of this week: Learners will master advanced analytical tools, automate tasks with macros, and integrate Excel with other data sources.

4.1PivotTables for Data Summarization
- Creating PivotTables
- PivotTable Fields, Filters
- Value Field Settings: Sum, Count
- Grouping, Slicers, Timelines
4.2PivotCharts for Visual Analysis
- Creating PivotCharts
- Synchronizing Slicers
- PivotChart Layout and Design
- Dynamic Reporting with PivotCharts
4.3What-If Analysis Tools
- Goal Seek for Target Values
- Scenario Manager for Variables
- Data Tables: One-variable
- Data Tables: Two-variables
4.4Introduction to Macros (VBA)
- Developer Tab, Macro Security
- Recording Simple Macros
- Running and Editing Macros
- Assigning Macros to Buttons
4.5External Data & Power Query
- Importing Data from Text/CSV
- Importing Data from Web
- Introduction to Power Query
- Cleaning Data with Power Query

Week 4
Advanced & automation

PivotTables for Data Summarization

PivotCharts for Visual Analysis

What-If Analysis Tools

Introduction to Macros (VBA)

External Data & Power Query

Hands-on project

Automated Sales Report

Final exam & certificate

Finish the 4 weeks, then take the online exam. Score 70% or more to pass.

Job-ready syllabus

Learn it. Build it. Explain it. Use it.

The syllabus goes beyond watching lessons. You practice the tasks employers expect, produce evidence of your skills, and prepare to discuss your work clearly.

Workplace skills

Apply Introduction to Excel Interface, Basic Data Entry & Formatting, Understanding Formulas & Functions, Worksheet & Workbook Management in guided business scenarios.

Portfolio proof

Complete 4 practical projects, including Personal Budget Tracker.

Professional practice

Present your work, respond to feedback, document decisions, and improve the final result.

Interview readiness

Review common role questions and explain your process, tools, trade-offs, and project outcomes.

Your completion pack

Weekly projects, trainer feedback, final assessment, and a certificate you can add to your résumé and LinkedIn profile.

Why learn from us?

Six reasons students pick M - IT Solutions

One-month programs built around live teaching, real projects and support that actually shows up.

Live online classes

Learn with a real instructor in real time — not pre-recorded videos you watch alone.

Hands-on projects

Every week ends with practical work you can show employers on day one.

1-on-1 trainer time

Stuck or want to go deeper? Book private sessions with a trainer whenever you need.

A real learning area

Lessons, progress tracking and exams all live in your account, on any device.

Trusted by companies

We train individuals and whole teams — from small businesses to enterprise programs.

Verified & supported

Verified accounts, real certificates and a support team that answers when you write.

1000+ learners trainedLive, instructor-ledProject-based every week