Free Excel Training Modules – Limited Seats Available
Build your Excel skills with our series of free, instructor-led training modules, designed to help professionals strengthen their data-handling and productivity skills.
We are offering specialised modules, each delivered live on separate dates.
Each module is limited to few seats, and we encourage participants to register only if they are committed to attending. A confirmation email will be issued only to selected participants.
Upcoming Modules
EXCEL 4: MORE ON FUNCTIONS
Date: January 16th 2026
Time: 11.30 – 1.00pm
Topics Covered:
→ Creating and working with named ranges.
→ VLOOKUP Function
→ IF Error function revisited
→ Index and Match
→ XLOOKUP – Excel 2019 / 365 only
Basic XLOOKUP
XLOOKUP – [if_not_found] argument
Search Mode argument
→ Goal Seek and Scenario Manager
Excel 5: PIVOT TABLES & PIVOT CHARTS
Date: January 23rd 2026
Time: 11.30 – 1.00pm
Topics Covered:
→ Creating and understanding a basic Pivot Table
→ Filtering Data
→ Refreshing a Pivot Table / Refresh
automatically on opening
→ Using the Pivot Table Design Ribbon
→ Resizing columns and preserving column
widths
→ Grouping Dates / Grouping Fields
→ Using Slicers with Pivot Tables
→ Creating / Modifying Calculated Fields
→ Creating and Modifying Pivot Charts
EXCEL 1: Working With Formulas And Functions
Date: January 2026
Time: TBC
Topics Covered:
Writing and understanding basic formulas
Writing and understanding basic functions
SUM / MIN / MAX / AVERAGE / COUNT / COUNTA / COUNTBLANK
Copying formulas: Relative vs. Absolute cell addressing
Conditional formatting revisited (using formulas)
EXCEL 2 : Working With Lists / Manipulating Text
Date: Jan 2026
Time: TBC
Topics Covered:
Working with Lists
Freezing Panes / Print Titles
Sorting and filtering a list
The Filter Function (Excel 2019 / Microsoft 365 only)
Creating and working with Excel Tables
Changing formatting
Changing display options (Total Row, etc.)
Working with functions
Using slicers in tables
Creating calculated fields
Manipulating Text
Changing the case of text – UPPER / PROPER / LOWER
Text to Columns
Joining text using & and TEXTJOIN
Flash Fill
Removing duplicates
EXCEL 3: CREATING AND WORKING WITH CHARTS
Date: Jan 2026
Time: TBC
Topics Covered:
→ Creating and editing various chart types
Column / Bar / Line / Pie
→ Moving / Resizing the chart
→ Adding / Editing chart elements
Chart title / Legend / Chart Style / Data Table /
Data Labels
Switch Row / Column
Manually Formatting a chart
Change overlap and Gap width
→ Creating a combined chart
→ Displaying data on a secondary axis
→ Adding an additional range to a chart once
created
→ Creating and working with Sparklines
Why are you required to fill your data to register for the webinar? Read our Data Privacy Information
