Topic Sub topic Daywise
Introduction to • What is Excel?
Excel • Overview of Excel interface
• Understanding Workbooks,
Worksheets, and Cells
• Types of data (text, numbers,
dates, etc.)
Basic Excel • Opening, saving, and closing
Operations workbooks
• Navigating through worksheets
• Entering and editing data in
cells Day 1(2Hrs)
• Autofill and Fill Handle
• Copy, Cut, Paste, and
Paste Special
• Undo and Redo actions
Formatting Cells • Text formatting (font, size,
color, bold, italics)
• Number formatting (currency,
percentages, date formats)
• Cell borders, colors, and shading
Working with • Inserting, deleting, and resizing
Rows, Columns, rows/columns
and Sheets • Hiding/unhiding rows and
columns
Renaming, adding, and deleting Day 2(2Hrs)
sheets
Basic • Basic arithmetic operations:
Formulas and addition, subtraction,
Functions multiplication, division
• Introduction to Excel functions:
SUM, AVERAGE, MIN, MAX
• Using the formula bar
• Relative vs Absolute references
in formulas
Basic Data • Sorting data (ascending,
Organization descending)
• Filtering data
• Using Find and Replace
Intermediate Excel
Intermediate • Logical functions: IF, AND,
Functions OR, NOT
• Text functions:
CONCATENATE, LEFT,
RIGHT, MID, LEN, UPPER,
LOWER, PROPER
• Date and Time functions:
TODAY, NOW, YEAR, Day 3(2Hrs)
MONTH, DAY, WEEKDAY,
DATEDIF
• Lookup functions:
VLOOKUP, HLOOKUP,
INDEX, MATCH
Data Validation • Creating data validation rules
• Drop-down lists
• Restricting data entries (whole
numbers, dates, etc.)
• Error messages and input
messages
Advanced • Conditional Formatting Day 4(2Hrs)
Formatting (highlight cells based on
conditions)
• Creating custom number
formats
• Data Bars, Color Scales, and
Icon Sets
• Formatting tables and ranges
Charts and Graphs • Creating basic charts: bar, line,
pie, etc.
• Formatting charts (titles, axis
labels, legends)
• Modifying chart data and types
• Adding trend lines and data
labels
• Using recommended charts
and customizing axes
Pivot Tables • introduction to PivotTables and Day 5(2Hrs)
their purpose
• Creating PivotTables from data
• Grouping data in PivotTables
• Using PivotChart to visualize
PivotTable data
• Slicers and filters for
PivotTables
Advanced Excel (Level 3)
Power Query and • Introduction to Power Query for Day 6(2Hrs)
Power Pivot data import and transformation
• Connecting to external data
sources (Excel, CSV, databases)
• Data cleansing: removing
duplicates, filling blanks, and
splitting columns
• Power Pivot for data modeling
• Creating relationships
between different data tables
• Using Power Pivot for
advanced calculations
Advanced • Creating Combo Charts (mixing
Charting different chart types)
Techniques • Secondary axis in charts
• Advanced data visualization
tools
• Customizing chart themes
and styles
Macros and VBA • introduction to macros and Day 7 (2Hrs)
(Visual Basic for automation
Applications) • Recording basic macros
• Writing simple VBA code
• Using VBA for custom
functions and operations
• Creating custom Excel add-ins
Introduction to • What is a Dashboard?
Dashboards in • Preparing Data for
Excel Dashboards
• Designing the Dashboard
Layout
• Visualization Techniques
for Dashboards
• Interactive dashboard
Additional content(if time supports)
Data Analysis and • Using Solver for optimization
Modeling • Data Analysis Tool Pak
(descriptive statistics,
regression analysis)
