Excel Mastery Workshop Cohort 5

Day

Date

Objective

Delivery

Basic Excel

Day 1

Tuesday

01/09/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

03/09/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

08/09/2026

Basic Formulas and Functions

• Introduction to formulas

• Common functions

• Relative vs. absolute cell references.

Online (Live session)

Day 4

Thursday

10/09/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

15/09/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

17/09/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

22/09/2026

Basic Data Validation

• Setting rules for data entry

• Using dropdown lists.

• Removing data validation.

Online (Live session)

Day 8

Thursday

24/09/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

29/09/2026

Advanced Formatting

• Conditional formatting basics.

• Using cell styles and themes.

• Custom number formatting.

Online (Live session)

Day 10

Thursday

01/10/2026

Intermediate Formulas and Functions

• Logical functions:

• Text functions

• Lookup functions

Online (Live session)

Day 11

Tuesday

06/10/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

08/10/2026

Data Visualization with Charts

• Creating combo charts.

• Adding sparklines to data.

• Enhancing charts with trendlines and formatting.

Online (Live session)

Day 13

Tuesday

13/10/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

15/10/2026

Data Validation and Protection

• Advanced data validation rules.

• Protecting sheets and locking cells.

• Understanding workbook security options.

Online (Live session)

Day 15

Tuesday

20/10/2026

Using Templates and Macros

• Creating and saving templates.

• Recording and running simple macros.

• Assigning macros to buttons.

Online (Live session)

Day 16

Thursday

22/10/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

27/10/2026

Advanced Functions and Nested Formulas

• Lookup and reference functions:

• Array functions:

• Nested IF and combined functions.

Online (Live session)

Day 18

Thursday

29/10/2026

VPower Query Basics

• Importing data from external sources.

• Cleaning and transforming data in Power Query.

• Merging and appending queries.

Online (Live session)

Day 19

Tuesday

03/11/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

05/11/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

10/11/2026

Advanced Charting Techniques

• Dynamic charts with named ranges.

• Waterfall and thermometer charts.

• Creating custom chart types.

Online (Live session)

Day 22

Thursday

12/11/2026

Macros and VBA Introduction

• Editing macros in the VBA editor.

• Writing simple VBA scripts.

• Automating tasks with VBA.

Online (Live session)

Day 23

Tuesady

17/11/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

19/11/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