Shopping Cart

A little bit of Excel can save you a whole lot of time (and money)

Excel Courses To Save You Time

One of the key components of any training program is to get people to apply what they learned in their every-day. Irrespective of how brilliant the training might be, if the transfer and application of skills are not evident once training has taken place, then there is no real value in what’s been learned.

To help facilitate this process, we encourage our clients to continue to engage with us even after the training has taken place, either with a quick email here and there to ask for advice or assistance, or more specifically with an official consult.

I remember back in the early days after one of our first Excel Advanced courses, where we revisited one of our financial services clients to help assist their staff implement the skills that they learned during training to their broad range of tasks in financial planning, asset managements, tax and legal documentation. There was one lady that I remembered in particular who was manually assigning data from a downloaded transactional CSV file to a Master Client List in Excel. She knew that the VLOOKUP function she had learned during training could help speed up the process but just wasn’t able to implement it as a solution.

Once she had briefly explained her requirements, it took us about half an hour to build an Excel Template to dynamically assign the downloaded data to the Master List. A daily task that was sometimes taking her up to 2 hours to complete every morning was now taking a couple of seconds!

I phoned her the other day out of curiosity to see if she was still using the template that we created over 4 years ago, and she proudly told me that she still uses the very same template every day.

If we conservatively say that this little template has saved her 1 hour a day for the past 4 years, with approximately 250 working days in a year, that’s a well-rounded 1000 hours saved and counting. Not bad for a 30-minute consult. This is a simple example of how a little bit of Excel can save you time (and money). This then begs the question: How many hours could you be saving?

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks