Need to brush up on your Excel skills, or perhaps you know the functions but can’t quite remember how to use them? This webinar is designed just for you!

Join us for an engaging and practical learning session where we will walk you through essential everyday Excel functions, using real-life examples to make the concepts clear and easy to apply.

1. Essential Mathematical & Statistical Functions

• Freeze panes
• Find and replace
• Filter- Different filter uses
• AVERAGE() – Calculating mean
• MIN() & MAX() – Finding smallest & largest values
• COUNT() & COUNTA() – Counting numbers & non-empty cells
• ROUND(), ROUNDUP(), ROUNDDOWN() – Controlling decimal places

2. Text Functions for Data Cleaning

• LEFT(), RIGHT(), MID() – Extracting text
• LEN() – Counting characters
• CONCAT() & TEXTJOIN() – Combining text
• IF Function and uses.
• TRIM() & CLEAN() – Removing spaces and unwanted characters

3. Date & Time Functions

• TODAY() & NOW() – Working with current dates and times
• DATEDIF() – Calculating age or differences in dates
• YEAR(), MONTH(), DAY() – Extracting date components
• TEXT() – Formatting dates into custom formats

4. Advanced Excel Functions

• TEXT() – Formatting numbers and dates
• INDIRECT() – Referencing cell ranges dynamically
• OFFSET() – Creating dynamic ranges
• CHOOSE() – Selecting values from a list
• Pivot Tables
• Mail Merge

All Included:

• Recording of the session
• Q&A with the presenter
• Downloadable course material
• Certificate of training
• Assessment (optional)
• SAIT Accredited (2 verifiable CPD hours)