Online Excel Productivity Workshops
Improve your efficiency. Work smarter. Save valuable time.
Phil has been using Microsoft Excel since 1996. Trained as a civil engineer, Phil likes things that work well, work quickly, and work accurately. He believes in making people Lazy-Productive, i.e. enabling Excel users to do more with less effort and in less time and with improved accuracy – do it once, do it right, make it easy to do it quickly next time.
These workshops are aimed specifically at teaching productivity short-cuts, tools and functions that you will actually use (unlike courses that ramble tediously through the menus icon by icon and include functions that you will never use and instantly forget). They are structured to give maximum benefit in minimum time. If you want to boost your productivity in Excel, then a couple of hours invested in these workshops will repay itself over and over again.
Become Lazy-Productive in no time at all.
What Can You Expect From The Excel Online Productivity Workshops?
These workshops help you to Be Lazy-Productive and more efficient in Microsoft Excel, with practical skills that boost productivity at any level.
Excel Short-cuts & Speed Features Session 1
Aimed at Excel users of any level, you will learn better and faster ways to do many things.
- Recap of Excel basics and names of the Excel window’s components
- Menus 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
- Selecting columns or rows with one action
- The Fill Handle punches even harder
- Copy multiple formulas in 1 x mouse action
- Basic formulas – and quicker ways to create them
- Fast formatting
- Shortcut keystrokes
- Bonus tips (if time allows)
Excel Short-cuts & Speed Features Session 2
Please note that attending Session 1 is strongly recommended.
Aimed at Excel users of any level, you will learn better and faster ways to do many things.
- 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)
Really Useful Functions & Features (RUFF) Session 1
- Advanced cell and range naming techniques
- Create intelligent and dynamic drop-down lists
- Working with Excel Tables (with a capital T!)
- Using VLOOKUP and XLOOKUP for powerful data retrieval
- Advanced formatting techniques and productivity hacks
- Flash Fill – a powerful tool for fast data manipulation
- Removing duplicate data efficiently
- Logical and conditional functions: IF, IFS, SUMIF, SUMIFS, COUNTIF, and COUNTIFS
- Bonus features (if time allows)
Really Useful Functions & Features (RUFF) Session 2
- Creating automatic subtotals for quick data summaries
- Using the f(x) function button to insert formulas efficiently
- Working with shapes in Excel
- Applying special effects for improved visual presentation
- Sorting data effectively
- Filtering data to focus on what matters
- Using conditional formatting to highlight important information
- Using Paste Special for advanced data manipulation
- Bonus features (if time allows)
Introduction to Pivot Tables &
Dashboards
- Structure your data so it’s easy to analyse instantly
- How to create Pivot Tables
- Analyse the same data in multiple different ways – instantly
- Set it up once and let it work for you forever!
- Create a dashboard
- Display data graphically
- “Slice” your data to drill down for details on individual clients/projects/products
- Reduce your admin time from hours (or days, see below) per month to minutes
AI in Excel:
AI Tools & Automation features
- What’s built-in
- Copilot
- Prompting
- When to use it
- When not to use it
What Does It Cost?
These workshops help you work faster and more efficient in Microsoft Excel, with practical skills that boost productivity at any level.
Short-cuts & Speed Features Sessions 1 & 2
- R400 per person, per session
- R300 per person for BNI members only
- Pricing excludes VAT
- Corporate packages of 10 or more on request (discounts apply)
Really Useful Functions & Features Sessions 1 & 2
- R600 per person, per session
- R500 per person for BNI members only
- Pricing excludes VAT
- Corporate packages of 10 or more on request (discounts apply)
Introduction to
Pivot Tables &
Dashboards
- R800 per person, per session
- R700 per person for BNI members only
- Pricing excludes VAT
- Corporate packages of 10 or more on request (discounts apply)
AI in Excel:
AI Tools & Automation features
- R800 per person, per session
- R700 per person for BNI members only
- Pricing excludes VAT
- Corporate packages of 10 or more on request (discounts apply)
Important Information You Need To Know
Office 2016 or higher is required, on PC or Mac. 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.
What our clients say about Phil
Phil from Moral Computer Support created the most amazing system for my business. He spent time listening to where the struggles with our income streams were and reviewed all the processes and data we received each month. It used to take 3 or 4 hours to process the monthly data and data analysis was always months behind. Phil’s magical system now processes the data in minutes, and we can plan for and prevent any issues that are arising in the business. Phil is always available for updates and has tweaked the system over the years to make it even more efficient. Phil is a Whizz.
Joe WebsterThe Hereford Group
We’ve used Moral Computer Support on and off for years now. Everything that we’ve ever asked Phil to design and implement has saved us hours of time and effort and certainly made us far more productive. Most of the data extraction tools that Phil has built for us are simple, easy to use and produce valuable business insights. Moral Computer Support is also not going to break the bank.
David DallingMotheo Water
Phil Maund is a phenomenal Excel genius and the best IT support person. He has a ton of patience with technologically challenged people. He really gives you the moral support you need to become confident. Phil gets any industries backgrounds mechanics. Have a coffee with him and explain to him what your needs are, and he will be ten steps ahead of what you thought you needed.
Hettie WainwrightStudio 46, Bloubergstrand
Not only has Phil assisted me with setting up a slick automated invoicing system in Excel which allowed me to move away from subscribed accounting software but he has also offered invaluable IT support when one I had no where else to turn. Phil is patient and absolutely thrives on sharing his knowledge on the power of Excel and how it can change your productivity in an instant.
Merle RivaM Create
Phil will be walking us through setting up a powerful spreadsheet that will allow us, as a building contractor, to know exactly what our spend is on any running project with a few simple clicks. This is going to be a game changer for our business especially for cashflow control.
Nigel DawsDaws Projects
2026 WORKSHOP SCHEDULE
Please note: Bookings close on the previous Friday before each workshop date.
Pivot Tables & Data Analysis and AI in Excel sessions may run up to 90 minutes.
Short-cuts & Speed Features
Session 1
- Tue 7 Jul 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 5 Aug 2026
10:00 - 11:00 and 15:00 - 16:00 - Tue 8 Sep 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 7 Oct 2026
10:00 - 11:00 and 15:00 - 16:00 - Tue 10 Nov 2026
10:00 - 11:00 and 15:00 - 16:00
Short-cuts & Speed Features
Session 2
- Wed 8 Jul 2026
10:00 - 11:00 and 15:00 - 16:00 - Thu 6 Aug 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 9 Sep 2026
10:00 - 11:00 and 15:00 - 16:00 - Thu 8 Oct 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 11 Nov 2026
10:00 - 11:00 and 15:00 - 16:00
Really Useful Functions
& Features
RUFF - Session 1
- Tue 14 Jul 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 12 Aug 2026
10:00 - 11:00 and 15:00 - 16:00 - Tue 15 Sep 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 14 Oct 2026
10:00 - 11:00 and 15:00 - 16:00 - Tue 17 Nov 2026
10:00 - 11:00 and 15:00 - 16:00
Really Useful Functions
& Features
RUFF - Session 2
- Wed 15 Jul 2026
10:00 - 11:00 and 15:00 - 16:00 - Thu 13 Aug 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 16 Sep 2026
10:00 - 11:00 and 15:00 - 16:00 - Thu 15 Oct 2026
10:00 - 11:00 and 15:00 - 16:00 - Wed 18 Nov 2026
10:00 - 11:00 and 15:00 - 16:00
Pivot Tables
& Dashboards
- Tue 21 Jul 2026
10:00 - 11:00 and 15:00 - 16:30 - Wed 19 Aug 2026
10:00 - 11:00 and 15:00 - 16:30 - Tue 22 Sep 2026
10:00 - 11:00 and 15:00 - 16:30 - Wed 21 Oct 2026
10:00 - 11:00 and 15:00 - 16:30 - Tue 24 Nov 2026
10:00 - 11:00 and 15:00 - 16:30
AI
In
Excel
- Wed 22 Jul 2026
10:00 - 11:00 and 15:00 - 16:30 - Thu 20 Aug 2026
10:00 - 11:00 and 15:00 - 16:30 - Wed 23 Sep 2026
10:00 - 11:00 and 15:00 - 16:30 - Thu 22 Oct 2026
10:00 - 11:00 and 15:00 - 16:30 - Wed 25 Nov 2026
10:00 - 11:00 and 15:00 - 16:30