MORE ABOUT THE ONLINE PRODUCTIVITY WORKSHOPS
Aimed at self-taught Excel users of any level!
Each online session is approximately one hour long
Excel short-cuts and speed features
SESSION 1:
Aimed at self-taught Excel users of any level, you will learn better and/or faster ways to:
- Recap of Excel basics and names of the Excel window’s components
- Pointers and cursors – the mouse wheel is smarter than you think
- Navigate quickly around your workbook
- Quickly select cells, including non-adjacent groups of cells
- The Ctrl and Shift keys pack a punch!
- Select long columns of data with one action
- The Fill Handle punches even harder!
- Copy multiple formulas in a list with one mouse action
- Basic formulas recap – and quicker ways to create them
- Fast formatting
- Shortcut keystrokes
- Bonus tips (if time allows)
Excel short-cuts and speed features
SESSION 2:
Please note that attending Session 1 is strongly recommended.
Aimed at self-taught Excel users of any level, you will learn better and/or faster ways to:
- Copying and moving
- Open multiple windows in the same workbook
- Split the screen (look at 2 parts of the same worksheet simultaneously)
- Work on multiple sheets simultaneously
- Reference cells on another worksheet
- Paste Special does way more than you think!
- Relative and Absolute cell references
- Create a drop-down list
- Named cells and ranges
- Add up multiple rows/columns simultaneously with one key combination
- Shortcut keystrokes
- Bonus tips (if time allows)
RUFF – Really Useful Functions & Features
SESSION 1:
Build on the basics, enhance your capabilities.
- Advanced cell and range naming
- Create intelligent drop-down lists
- Tables (with a capital T!)
- VLOOKUP and XLOOKUP
- Remove duplicates
- Automatic subtotals
- IF & IFS, SUMIF & SUMIFS
- Shortcut keystrokes
- Bonus features (if time allows)
RUFF – Really Useful Functions & Features
SESSION 2:
Please note that attending Session 1 is strongly recommended.
Build on the basics, enhance your capabilities.
- COUNTIF & COUNTIFS
- The f(x) button
- Sort
- Filter
- Advanced formatting hacks
- Conditional formatting
- Paste special (advanced)
- Formatting hacks (eg. telephone numbers that don’t lose their 0)
- Flash fill
- Shortcut keystrokes
- Bonus features (if time allows)
Pivot Tables and Data Analysis
Aimed at self-taught Excel users at the intermediate level:
- Structure your data so it’s easy to analyse instantly
- Create pivot tables
- Set it up once and let it work for you forever
- Create a dashboard
- Display data graphically
- “Slice” your data to drill down for deails on individual clients/projects/products
AI in Excel
Is it hype or is it amazing?
- Built-in AI features
- External options
- How to prompt the AI engines
- When to use it and when it will waste your time
WHAT YOU NEED TO KNOW
WHERE:
Online
COST:
Short-cuts & Speed Features
RUFF – Really Useful Functions & Features
R300 per person, per session
R250 per person for BNI members only
Pricing excludes VAT
Corporate packages of 10 or more on request (discounts apply)
COST:
Pivot Tables and Data Analysis
R400 per person, per session
R350 per person for BNI members only
Pricing excludes VAT
Corporate packages of 10 or more on request (discounts apply)
COST:
AI in Excel
Attendance at the Pivot Tables and Data Analysis is recommended before attending this workshop.
R400 per person, per session
R350 per person for BNI members only
Pricing excludes VAT
Corporate packages of 10 or more on request (discounts apply)
WHAT YOU WILL NEED:
Log in & ensure you have Office 2016 or higher software installed
After making your booking, an invoice will be sent to you via mail.
Please note that your booking will only be confirmed once payment has been received.
THE WORKSHOP SCHEDULE!
- SHORT-CUTS & SPEED FEATURES
SESSION 1 - Wed 17 December 2025
10:30 – 11:30
- SHORT-CUTS & SPEED FEATURES
SESSION 2 - Thur 17 December 2025
10:30 – 11:30
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – SESSION 1 - Wed 17 December 2025
10:30 – 11:30
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – SESSION 2 - Wed 17 December 2025
10:30 – 11:30
- PIVOT TABLES
AND DATA ANALYSIS - Wed 26 November 2025
10:30 – 11:30
- AI
IN EXCEL - Thur 27 November 2025
10:30 – 11:30
2026 WORKSHOP SCHEDULE!
- SHORT-CUTS & SPEED FEATURES
SESSION 1 - Tue January 13 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 11 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 10 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 8 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 12 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 10 June 2026
10:30 – 11:30 and 15:00 – 16:00
- SHORT-CUTS & SPEED FEATURES
SESSION 2 - Wed January 14 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 12 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 11 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 9 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 13 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 11 June 2026
10:30 – 11:30 and 15:00 – 16:00
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – SESSION 1 - Tue 20 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 18 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 17 Mar 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 15 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 19 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 17 June 2026
10:30 – 11:30 and 15:00 – 16:00
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – SESSION 2 - Wed 21 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 19 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 18 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 16 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 20 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 18 June 2026
10:30 – 11:30 and 15:00 – 16:00
- PIVOT TABLES
ANDDATA ANALYSIS - Tue 27 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 25 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 24 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 22 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 26 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 24 June 2026
10:30 – 11:30 and 15:00 – 16:00
- AI
in Excel - Wed 28 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 26 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 25 Mar 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 23 Apr 2026
10:30 – 11:30 - Wed 27 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 25 June 2026
10:30 – 11:30 and 15:00 – 16:00
MAKE YOUR BOOKING NOW!
AVAILABLE ON REQUEST
Microsoft Word Styles Workshop
- This high-value workshop is for anyone who has ever struggled with documents containing multi-level numbered paragraphs.
- Save hours every week!
- Put away the Format Painter forever!
- Learn how to take even the most horrendously formatted documents and format them beautifully in less time than you thought possible.
- Ensure the spacing between paragraphs is consistent and create a template to base all future documents on so all your company’s documents will always look the same, no matter who creates or edits them.
- Ideal for lawyers, engineers, and report writers.
ONLINE EXCEL PRODUCTIVITY WORKSHOPS
Short-cuts & speed features – Sessions 1 and 2
RUFF – Really Useful Functions and Features – Sessions 1 and 2
Pivot Tables and Data Analysis
AI in Excel
MORE ABOUT THE ONLINE EXCEL PRODUCTIVITY WORKSHOP
Aimed at self-taught Excel users of any level!
Excel short-cuts and speed features
SESSION 1:
Aimed at self-taught Excel users of any level, you will learn better and/or faster ways to:
- Recap of Excel basics and names of the Excel window’s components
- Pointers and cursors – the mouse wheel is smarter than you think
- Navigate quickly around your workbook
- Quickly select cells, including non-adjacent groups of cells
- The Ctrl and Shift keys pack a punch!
- Select long columns of data with one action
- The Fill Handle punches even harder!
- Copy multiple formulas in a list with one mouse action
- Basic formulas recap – and quicker ways to create them
- Fast formatting
- Shortcut keystrokes
- Bonus tips (if time allows)
Excel short-cuts and speed features
SESSION 2:
Please note that attending Session 1 is strongly recommended.
Aimed at self-taught Excel users of any level, you will learn better and/or faster ways to:
- Copying and moving
- Open multiple windows in the same workbook
- Split the screen (look at 2 parts of the same worksheet simultaneousl
- Work on multiple sheets simultaneously
- Reference cells on another worksheet
- Paste Special does way more than you think!
- Relative and Absolute cell references
- Create a drop-down list
- Named cells and ranges
- Add up multiple rows/columns simultaneously with one key combination
- Shortcut keystrokes
- Bonus tips (if time allows)
RUFF – Really Useful Functions & Features
SESSION 1:
Build on the basics, enhance your capabilities.
- Advanced cell and range naming
- Create intelligent drop-down lists
- Tables (with a capital T!)
- VLOOKUP and XLOOKUP
- Remove duplicates
- Automatic subtotals
- IF & IFS, SUMIF & SUMIFS
- Shortcut keystrokes
- Bonus features (if time allows)
RUFF – Really Useful Functions & Features
SESSION 2:
Please note that attending Session 1 is strongly recommended.
Build on the basics, enhance your capabilities.
- COUNTIF & COUNTIFS
- The f(x) button
- Sort
- Filter
- Advanced formatting hacks
- Conditional formatting
- Paste special (advanced)
- Formatting hacks (eg. telephone numbers that don’t lose their 0)
- Flash fill
- Shortcut keystrokes
- Bonus features (if time allows)
Pivot Tables and Data Analysis
Aimed at self-taught Excel users at the intermediate level:
- Structure your data so it’s easy to analyse instantly
- Create pivot tables
- Set it up once and let it work for you forever
- Create a dashboard
- Display data graphically
- “Slice” your data to drill down for deails on individual clients/projects/products
AI in Excel
Is it hype or is it amazing?
- Built-in AI features
- External options
- How to prompt the AI engines
- When to use it and when it will waste your time
WHAT YOU NEED TO KNOW
WHERE:
Online
COST:
Short-cuts & Speed Features
RUFF – Really Useful Functions & Features
R300 per person, per session
R250 per person for BNI members only
Pricing excludes VAT
Corporate packages of 10 or more on request (discounts apply)
COST:
Pivot Tables and Data Analysis
R400 per person, per session
R350 per person for BNI members only
Pricing excludes VAT
Corporate packages of 10 or more on request (discounts apply)
COST:
AI in Excel
Attendance at the Pivot Tables and Data Analysis is recommended before attending this workshop.
R400 per person, per session
R350 per person for BNI members only
Pricing excludes VAT
Corporate packages of 10 or more on request (discounts apply)
WHAT YOU WILL NEED:
Log in & ensure you have Office 2016 or higher software installed
After making your booking, an invoice will be sent to you via mail.
Please note that your booking will only be confirmed once payment has been received.
THE WORKSHOP SCHEDULE!
- SHORT-CUTS & SPEED FEATURES
SESSION 1 - Wed 17 December 2025 10:30 – 11:30
- SHORT-CUTS & SPEED FEATURES
SESSION 2 - Thur 17 December 2025 10:30 – 11:30
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – Session 1 - no more courses until the New Year
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – Session 1 - no more courses until the New Year
- PIVOT TABLES AND DATA ANALYSIS
- Wed 26 November 2025 10:30 – 11:30
- AI
IN EXCEL - Thur 27 November 2025
10:30 – 11:30
2026 WORKSHOP SCHEDULE!
- SHORT-CUTS & SPEED FEATURES
SESSION 1 - Tue January 13 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 11 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 10 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 8 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 12 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 10 June 2026
10:30 – 11:30 and 15:00 – 16:00
- SHORT-CUTS & SPEED FEATURES
SESSION 2 - Wed January 14 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 12 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 11 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 9 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 13 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 11 June 2026
10:30 – 11:30 and 15:00 – 16:00
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – Session 1 - Tue 20 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 18 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 17 Mar 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 15 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 19 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 17 June 2026
10:30 – 11:30 and 15:00 – 16:00
- REALLY USEFUL FUNCTIONS AND FEATURES
RUFF – Session 1 - Wed 21 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 19 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 18 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 16 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 20 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 18 June 2026
10:30 – 11:30 and 15:00 – 16:00
- PIVOT TABLES AND DATA ANALYSIS
- Tue 27 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 25 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 24 March 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 22 Apr 2026
10:30 – 11:30 and 15:00 – 16:00 - Tue 26 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 24 June 2026
10:30 – 11:30 and 15:00 – 16:00
- AI IN EXCEL
- Wed 28 January 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 26 February 2026
10:30 – 11:30 and 15:00 – 16:00 - Wed 25 Mar 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 23 Apr 2026
10:30 – 11:30 - Wed 27 May 2026
10:30 – 11:30 and 15:00 – 16:00 - Thur 25 June 2026
10:30 – 11:30 and 15:00 – 16:00
