Excel Mastery Workshop Cohort 6

Day

Date

Objective

Delivery

Basic Excel

Day 1

Tuesday

06/04/2027

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

08/04/2027

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

13/04/2027

Basic Formulas and Functions

·        Introduction to formulas

·        Common functions

·        Relative vs. absolute cell references.

Online (Live session)

Day 4

Thursday

15/04/2027

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

20/04/2027

Basic Sorting and Filtering

·        Sorting data (ascending/descending).

·        Applying filters to view specific data.

·        Clearing sorting and filters.

Online (Live session)

Day 6

Thursday

22/04/2027

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

27/04/2027

Basic Data Validation

·        Setting rules for data entry

·        Using dropdown lists.

·        Removing data validation.

Online (Live session)

Day 8

Thursday

29/04/2027

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

04/05/2027

Advanced Formatting

·        Conditional formatting basics.

·        Using cell styles and themes.

·        Custom number formatting.

Online (Live session)

Day 10

Thursday

06/05/2027

Intermediate Formulas and Functions

·        Logical functions:

·        Text functions

·        Lookup functions

Online (Live session)

Day 11

Tuesday

11/05/2027

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

13/05/2027

Data Visualization with Charts

·        Creating combo charts.

·        Adding sparklines to data.

·        Enhancing charts with trendlines and formatting.

Online (Live session)

Day 13

Tuesday

18/05/2027

Pivot Tables Basics

·        Creating and customizing pivot tables.

·        Adding calculated fields and values.

·        Grouping data within pivot tables.

Online (Live session)

Day 14

Thursday

20/05/2027

Data Validation and Protection

·        Advanced data validation rules.

·        Protecting sheets and locking cells.

·        Understanding workbook security options.

Online (Live session)

Day 15

Tuesday

25/05/2027

Using Templates and Macros

·        Creating and saving templates.

·        Recording and running simple macros.

·        Assigning macros to buttons.

Online (Live session)

Day 16

Thursday

27/05/2027

Introduction to Collaboration

·        Sharing workbooks for collaboration.

·        Using comments and notes.

·        Tracking changes in shared workbooks.

Online (Live session)

Advanced Excel

Day 17

Thursday

03/06/2027

Advanced Functions and Nested Formulas

·        Lookup and reference functions:

·        Array functions:

·        Nested IF and combined functions.

Online (Live session)

Day 18

Tuesday

08/06/2027

Power Query Basics

·        Importing data from external sources.

·        Cleaning and transforming data in Power Query.

·        Merging and appending queries.

Online (Live session)

Day 19

Thursday

10/06/2027

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

Tuesday

15/06/2027

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

Thursday

17/06/2027

Advanced Charting Techniques

·        Dynamic charts with named ranges.

·        Waterfall and thermometer charts.

·        Creating custom chart types.

Online (Live session)

Day 22

Tuesday

22/06/2027

Macros and VBA Introduction

·        Editing macros in the VBA editor.

·        Writing simple VBA scripts.

·        Automating tasks with VBA.

Online (Live session)

Day 23

Thursday

24/06/2027

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

Tuesday

29/06/2027

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