Shopping Cart

Are you trying to get Square Pegs into Round Holes with Excel?

If you’ve seen The Social Dilemma, you’ll realise how easy it is for computer programmers and data scientists to manipulate programmes to suits their needs and protect their time and mental wellbeing. Whether coding in Python or reporting in Excel, saving time with automation tools is vital to methods of working in today’s fast paced, demanding working world.

However, you don’t need to be a computer programmer or technology boffin and develop a model to automate your Excel tasks. We’re here to help you save hours, if not days of time, by empowering you to automate mundane, repetitive Excel tasks using advanced tools embedded within MS Excel.

Manipulating data can often feel like that classic analogy of getting a square peg into a round hole. This, however, is a daily reality for millions of people around the world working with Excel.

Most resort to manually whittling away at their square peg to get it to fit into the round hole, but this can be incredibly time-consuming, prone to errors and downright frustrating; especially if you’re doing it on a regular basis.

Many of you, our clients, have spent time sharpening your axes by working through our Beginner, Intermediate and Advanced Excel courses. As a result, your ‘chopping time’ has been significantly reduced as you become far more effective and efficient with data manipulation; however, you still end up having to wield the axe and do the tedious work of gathering, sorting and manipulating data to suit your reporting needs.

What if you could simply push a button and send all your square pegs through some sort of device that spits out round pegs that are a perfect fit every time? Well, you can!

Unbeknown to most, Excel has some incredibly powerful automation tools that can help you achieve this pipe dream, all puns intended.

Our Excel Automation course takes you through automation processes step by step so you can feel confident combining advanced tools of Power Query, Power Pivot and Macros (VBA) to accelerate your workflow.

In this course, our MS Excel experts guide you as you discover the following and so much more:

  • Macros, how you can use them and a arrange a tips and tricks on recording a Macro
  • VBA, how to manipulate VBA snippets and everything you need to know about VBA coding basics
  • Power Query, connecting data sources and manipulating data tables
  • Integration of advanced Excel tools with PowerPoint and Word

By understanding how to use Excel automation tools correctly, you can smile as you complete your weekly or monthly reports and reward yourself with an extra-long coffee break, and get to the work that really needs your time and energy.

To learn how to combine Excel’s advanced tools of Power Query, Power Pivot and Macros (VBA), watch the introduction video to our Excel Automation course and enroll today. Who knows? You may even give those data scientists and Google engineers from The Social Dilemma a run for their code, and have colleagues lining up at your door hoping to learn a thing or two from you, the office’s Excel Automation Master.

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
  • 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

This draw is closed. Keep checking back, for the next draw.