Level 1: Start Here — Set Your Goals

Objective: Set Your Goals

• Why learn Excel?
• Define your learning goals.
• Set a learning plan.
• Practice with sample data.
• Explore real-world use cases.
• Be consistent and build habits.

Key Activities:

• Set Goals
• Create a Study Plan
• Practice Regularly
• Track Your Progress

Level 2: Getting Started — Learn the Essentials

Objective: Learn the Essentials

• Understand Excel interface (Ribbon, Tabs).
• Workbooks, Worksheets & Cells.
• Enter and edit data.
• Use shortcuts to work faster.
• Save, open and manage files.
• Basic navigation and selection.
• Undo & redo, find & replace.

Key Topics:

• Excel Interface
• Workbooks & Worksheets
• Cell Navigation
• Shortcuts
• Save & Open
• Find & Replace
• Undo / Redo
• Basic Settings

Learning Outcomes:

• Get familiar with Excel.
• Navigate with ease.
• Use basic tools.
• Build confidence.

Level 3: Basic Level — Build a Strong Foundation

Objective: Build a Strong Foundation

• Cell basics (data entry, editing, formatting).
• Formulas and cell references.
• Basic functions (SUM, AVERAGE, COUNT, etc.).
• Insert rows, columns and sheets.
• Number formats & custom formats.
• Basic charts (Column, Line, Pie).
• Page setup & printing.

Key Topics:

• SUM
• AVERAGE
• COUNT
• Cell Formatting
• Insert Rows/Columns
• Basic Charts
• Number Formats
• Page Setup & Print

Learning Outcomes:

• Understand the basics.
• Use essential functions.
• Create simple charts.
• Format data neatly.

Level 4: Intermediate Level — Work Smarter with Data

Objective: Work Smarter with Data

• Logical functions (IF, IFS, SWITCH).
• Text functions (TEXT, LEFT, RIGHT, MID, etc.).
• Date & time functions.
• Data cleaning & formatting.
• Sort, Filter & Advanced Filter.
• Conditional Formatting.
• Data from multiple sheets (3D formulas).

Key Topics:

• IF / IFS
• Text Functions
• Date & Time
• Sort & Filter
• Conditional Formatting
• Data Cleaning
• 3D Formulas
• Working with Multiple Sheets

Learning Outcomes:

• Clean and transform data.
• Use powerful formulas.
• Analyze and summarize data.
• Work with multiple sheets and large datasets.

Level 5: Advanced Level — Analyze, Automate & Visualize

Objective: Analyze, Automate & Visualize

• Lookup functions (XLOOKUP, INDEX-MATCH).
• Advanced functions (LET, LAMBDA, etc.).
• Data analysis with Pivot Tables & Charts.
• Data validation & conditional logic.
• What-If Analysis & Forecasting.
• Introduction to Power Query & Power Pivot.
• Create interactive dashboards.

Key Topics:

• XLOOKUP
• INDEX-MATCH
• Pivot Tables
• Advanced Charts
• Data Validation
• What-If Analysis
• Slicers & Timelines
• Interactive Dashboard

Learning Outcomes:

• Work with large data.
• Create dynamic reports.
• Build dashboards.
• Make data-driven decisions.

Level 6: Pro Level — Become an Excel Expert

Objective: Become an Excel Expert

• Advanced formulas & problem solving.
• Power Query (Get & Transform).
• Power Pivot & Data Model.
• DAX basics for analysis.
• Automate with VBA Macros.
• Build interactive dashboards.
• Work on real-world projects.

Key Topics:

• Power Query
• Power Pivot
• DAX
• VBA
• Advanced Dashboards
• Automation
• Data Model
• Real-World Projects

Learning Outcomes:

• Solve complex problems.
• Automate your work.
• Build powerful reports.
• Get job-ready for advanced roles.

Career Benefits of Learning Excel

• Better Job Opportunities
• Higher Productivity
• Solve Real Business Problems
• Grow Your Career