Day

Date

Objective

Delivery

Basic Excel

Day 1

Tuesday

1/13/2026

Onboarding – Course outline

Introduction to Excel Interface

·        Navigating the Excel ribbon, tabs, and menus.

·        Understanding worksheets, rows, columns, and cells.

·        Saving, opening, and creating workbooks.

Online (Live session)

Day 2

Thursday

1/15/2026

Data entry and Basic Formatting

·        Overview of types of data

·        Entering, editing, and deleting data.

·        Formatting cells

·        Adjusting row heights and column widths.

Online (Live session)

Day 3

Tuesday

1/20/2026

Basic Formulas and Functions

·        Introduction to formulas

·        Common functions

·        Relative vs. absolute cell references.

Online (Live session)

Day 4

Thursday

1/22/2026

Working with Rows, Columns, and Sheets

·        Inserting, deleting, and moving rows/columns.

·        Renaming, adding, and deleting sheets.

·        Using freeze panes and split view.

Online (Live session)

Day 5

Tuesday

1/27/2026

Basic Sorting and Filtering

·        Sorting data (ascending/descending).

·        Applying filters to view specific data.

·        Clearing sorting and filters.

Online (Live session)

Day 6

Thursday

1/29/2026

Introduction to Charts

·        Creating basic charts: Bar, Line, and Pie charts.

·        Customizing chart elements (titles, axes, legends).

·        Printing and exporting charts.

Online (Live session)

Day 7

Tuesday

2/3/2026

Basic Data Validation

·        Setting rules for data entry

·        Using dropdown lists.

·        Removing data validation.

Online (Live session)

Day 8

Thursday

2/5/2026

Printing and Sharing Workbooks

·        Setting print areas and adjusting page layout.

·        Using print preview and scaling options.

·        Sharing workbooks via email or cloud storage.

Online (Live session)

Intermediate excel

Day 9

Tuesday

2/10/2026

Advanced Formatting

·        Conditional formatting basics.

·        Using cell styles and themes.

·        Custom number formatting.

Online (Live session)

Day 10

Thursday

2/12/2026

Intermediate Formulas and Functions

·        Logical functions:

·        Text functions

·        Lookup functions

Online (Live session)

Day 11

Tuesday

2/17/2026

Working with Tables

·        Creating and formatting Excel tables.

·        Using structured references in formulas.

·        Sorting and filtering data in tables.

Online (Live session)

Day 12

Thursday

2/19/2026

Data Visualization with Charts

·        Creating combo charts.

·        Adding sparklines to data.

·        Enhancing charts with trendlines and formatting.

Online (Live session)

Day 13

Tuesday

2/24/2026

Pivot Tables Basics

·        Creating and customizing pivot tables.

·        Adding calculated fields and values.

·        Grouping data within pivot tables.

Online (Live session)

Day 14

Thursday

2/26/2026

Data Validation and Protection

·        Advanced data validation rules.

·        Protecting sheets and locking cells.

·        Understanding workbook security options.

Online (Live session)

Day 15

Tuesday

3/3/2026

Using Templates and Macros

·        Creating and saving templates.

·        Recording and running simple macros.

·        Assigning macros to buttons.

Online (Live session)

Day 16

Thursday

3/5/2026

Introduction to Collaboration

·        Sharing workbooks for collaboration.

·        Using comments and notes.

·        Tracking changes in shared workbooks.

Online (Live session)

Advanced Excel

Day 17

Tuesday

3/10/2026

Advanced Functions and Nested Formulas

·        Lookup and reference functions:

·        Array functions:

·        Nested IF and combined functions.

Online (Live session)

Day 18

Thursday

3/12/2026

Power Query Basics

·        Importing data from external sources.

·        Cleaning and transforming data in Power Query.

·        Merging and appending queries.

Online (Live session)

Day 19

Tuesday

3/17/2026

Advanced Pivot Tables and Pivot Charts

·        Using slicers and timelines with pivot tables.

·        Creating pivot charts and dynamic reports.

·        Working with OLAP tools.

Online (Live session)

Day 20

Thursday

3/19/2026

Data Analysis Tools

·        Using the Analysis ToolPak.

·        Running what-if scenarios and sensitivity analysis.

·        Data tables, goal seek, and solver.

Online (Live session)

Day 21

Tuesday

3/24/2026

Advanced Charting Techniques

·        Dynamic charts with named ranges.

·        Waterfall and thermometer charts.

·        Creating custom chart types.

Online (Live session)

Day 22

Thursday

3/26/2026

Macros and VBA Introduction

·        Editing macros in the VBA editor.

·        Writing simple VBA scripts.

·        Automating tasks with VBA.

Online (Live session)

Day 23

Tuesday

3/31/2026

Power BI and Power Pivot

·        Connecting Excel to Power BI.

·        Using Power Pivot for data modeling.

·        Creating relationships between tables.

Online (Live session)

Day 24

Thursday

4/2/2026

Automation and Dashboard Creation

·        Building dynamic dashboards.

·        Using form controls and slicers.

·        Automating dashboard updates with VBA.

Online (Live session)

Capstone Project: Sales Performance and Forecasting Dashboard