Excel mastery Workshop Cohort 4

Day

Date

Objective

Delivery

Basic Excel

Day 1 – (Wednesday)

June 3, 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 – (Friday)

June 5, 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)

June 08, 2026

Basic Formulas and Functions

• Introduction to formulas

• Common functions

• Relative vs. absolute cell references.

Online (Live session)

Day 4 – (Wednesday)

June 10, 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)

June 15, 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)

June 17, 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)

June 22, 2026

Basic Data Validation

• Setting rules for data entry

• Using dropdown lists.

• Removing data validation.

Online (Live session)

Day 8 – (Wednesday)

June 24, 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)

June 29, 2026

Advanced Formatting

• Conditional formatting basics.

• Using cell styles and themes.

• Custom number formatting.

Online (Live session)

Day 10 – (Wednesday)

July 1, 2026

Intermediate Formulas and Functions

• Logical functions:

• Text functions

• Lookup functions

Online (Live session)

Day 11 – (Monday)

July 6, 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)

July 8, 2026

Data Visualization with Charts

• Creating combo charts.

• Adding sparklines to data.

• Enhancing charts with trendlines and formatting.

Online (Live session)

Day 13 – (Monday)

July 13, 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)

July 15, 2026

Data Validation and Protection

• Advanced data validation rules.

• Protecting sheets and locking cells.

• Understanding workbook security options.

Online (Live session)

Day 15 – (Monday)

July 20, 2026

Using Templates and Macros

• Creating and saving templates.

• Recording and running simple macros.

• Assigning macros to buttons.

Online (Live session)

Day 16 – (Wednesday)

July 22, 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)

July 27, 2026

Advanced Functions and Nested Formulas

• Lookup and reference functions:

• Array functions:

• Nested IF and combined functions.

Online (Live session)

Day 18 – (Wednesday)

July 29, 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 – (Monday)

August 3, 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)

August 5, 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)

August 10, 2026

Advanced Charting Techniques

• Dynamic charts with named ranges.

• Waterfall and thermometer charts.

• Creating custom chart types.

Online (Live session)

Day 22 – (Wednesday)

August 12, 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)

August 17, 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)

August 19, 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