Excel Mastery Workshop Cohort 5

Day

Date

Objective

Delivery

Basic Excel

Day 1

Monday

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

Wednesday

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

Monday

10/08/2026

Basic Formulas and Functions

• Introduction to formulas

• Common functions

• Relative vs. absolute cell references.

Online (Live session)

Day 4

Wednesday

12/08/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

Monday

17/08/2026

Basic Sorting and Filtering

• Sorting data (ascending/descending).

• Applying filters to view specific data.

• Clearing sorting and filters.

Online (Live session)

Day 6

Wednesday

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

Monday

24/08/2026

Basic Data Validation

• Setting rules for data entry

• Using dropdown lists.

• Removing data validation.

Online (Live session)

Day 8

Wednesday

26/08/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

Monday

31/08/2026

Advanced Formatting

• Conditional formatting basics.

• Using cell styles and themes.

• Custom number formatting.

Online (Live session)

Day 10

Wednesday

02/09/2026

Intermediate Formulas and Functions

• Logical functions:

• Text functions

• Lookup functions

Online (Live session)

Day 11

Monday

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

Wednesday

09/09/2026

Data Visualization with Charts

• Creating combo charts.

• Adding sparklines to data.

• Enhancing charts with trendlines and formatting.

Online (Live session)

Day 13

Monday

14/09/2026

Pivot Tables Basics

• Creating and customizing pivot tables.

• Adding calculated fields and values.

• Grouping data within pivot tables.

Online (Live session)

Day 14

Wednesday

16/09/2026

Data Validation and Protection

• Advanced data validation rules.

• Protecting sheets and locking cells.

• Understanding workbook security options.

Online (Live session)

Day 15

Monday

21/09/2026

Using Templates and Macros

• Creating and saving templates.

• Recording and running simple macros.

• Assigning macros to buttons.

Online (Live session)

Day 16

Wednesday

23/09/2026

Introduction to Collaboration

• Sharing workbooks for collaboration.

• Using comments and notes.

• Tracking changes in shared workbooks.

Online (Live session)

Advanced excel

Day 17

Monday

28/09/2026

Advanced Functions and Nested Formulas

• Lookup and reference functions:

• Array functions:

• Nested IF and combined functions.

Online (Live session)

Day 18

Wednesday

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

Monday

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

Wednesday

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

Monday

12/10/2026

Advanced Charting Techniques

• Dynamic charts with named ranges.

• Waterfall and thermometer charts.

• Creating custom chart types.

Online (Live session)

Day 22

Wednesday

14/10/2026

Macros and VBA Introduction

• Editing macros in the VBA editor.

• Writing simple VBA scripts.

• Automating tasks with VBA.

Online (Live session)

Day 23

Monday

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

Wednesday

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