[go: up one dir, main page]
Scribd
Upload
48 views3 pages

Excel Course Roadmap

The Excel Course Roadmap outlines a structured learning path across three levels: Basic, Intermediate, and Advanced Excel, each with specific goals and topics. Level 1 focuses on the Excel interface, basic formulas, and data handling; Level 2 emphasizes data analysis with logical functions and pivot tables; and Level 3 covers advanced automation, reporting, and the use of macros. Each level includes practical tasks to reinforce learning, such as creating a student marksheet and an employee attendance sheet.

Uploaded by

ucyadav
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
48 views3 pages

Excel Course Roadmap

The Excel Course Roadmap outlines a structured learning path across three levels: Basic, Intermediate, and Advanced Excel, each with specific goals and topics. Level 1 focuses on the Excel interface, basic formulas, and data handling; Level 2 emphasizes data analysis with logical functions and pivot tables; and Level 3 covers advanced automation, reporting, and the use of macros. Each level includes practical tasks to reinforce learning, such as creating a student marksheet and an employee attendance sheet.

Uploaded by

ucyadav
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Excel Course Roadmap

📘 Level 1: Basic Excel (5 Days)

Goal: Get comfortable with Excel interface, formulas, and basic data
handling.

Topics:

1. Getting Started

o Interface overview: Ribbon, Sheets, Cells, Workbook

o Data types (text, numbers, dates)

2. Basic Operations

o Entering and formatting data

o Autofill and Flash Fill

o Basic formatting (font, cell color, number formats)

3. Basic Formulas & Functions

o SUM, AVERAGE, MIN, MAX, COUNT

o Basic arithmetic operations (+ - * /)

o Formula bar, relative vs absolute cell references

4. Working with Data

o Sorting and filtering

o Freeze Panes, Wrap Text, Merge Cells

o Inserting/deleting rows and columns

5. Basic Charts

o Creating Column, Line, and Pie charts

o Chart elements: titles, labels, legends

Practice Task:
Create a simple student marksheet with total, average, and pass/fail status.
📙 Level 2: Intermediate Excel (5–7 Days)

Goal: Analyze and summarize data using formulas and built-in tools.

Topics:

1. Logical & Lookup Functions

o IF, IFS, AND, OR, IFERROR

o VLOOKUP, HLOOKUP, INDEX, MATCH

2. Data Validation & Drop-Downs

o Create dynamic drop-down lists

o Input restrictions and error messages

3. Conditional Formatting

o Color scales, icon sets, custom formulas

4. Tables & Structured References

o Converting ranges to tables

o Table formulas and slicers

5. Date & Text Functions

o TODAY, NOW, DATEDIF, TEXT, LEFT, RIGHT, MID, CONCAT

6. Basic Pivot Tables

o Creating pivot tables and charts

o Grouping, filtering, and slicers

Practice Task:
Create an employee attendance sheet with conditional formatting and
monthly summary using a Pivot Table.

📕 Level 3: Advanced Excel (7–10 Days)


Goal: Master automation, analysis, and reporting.

Topics:

1. Advanced Formulas

o Nested IFs

o SUMIFS, COUNTIFS, XLOOKUP

o Dynamic named ranges

2. Advanced Pivot Tables

o Calculated fields

o Pivot charts with slicers

3. Data Analysis Tools

o What-If Analysis (Goal Seek, Data Tables)

o Scenario Manager

o Solver Add-in

4. Dynamic Dashboards

o Form controls (dropdown, checkbox)

o Interactive charts

o KPI indicators

5. Power Query (Get & Transform)

o Importing data from multiple sources

o Cleaning and transforming data

o Merging and appending queries

6. Introduction to Macros (VBA)

o Recording Macros

o Assigning macros to buttons

You might also like