Shopping Cart
Excel Range Selection

Quickest way to select and check an Excel Range

Many of the cool features in Excel auto-detect data ranges to function, such as Filters, Flash-Fill and Pivots, to name but a few. Considering this, it’s really important that we store our data in such a way that an Excel Range can be detected without any issues. Simply put, our Data should be stored in […]

Quickest Way To Move A Column

Quickest way to move a column

Most times using a keyboard shortcut is quicker than using a mouse. Sometimes though, it’s a nifty combination of the two that does the trick! Let’s look at the quickest way to a move a column in Excel. The standard way of moving a column within a range of data is to right-click on the […]

A breakdown of 6 careers that require Excel skills

Businesses are obsessed with data – and for good reason. We turn data into meaningful insights to understand how we can successfully implement new strategies for growth, reduce risk, increase productivity, and manage costs. Essentially, we try to use data to predict and plan for the future, and with data being collected around the clock, […]

The history of Excel and why it’s still relevant

Microsoft Excel has become a household term – everyone knows about it or has used it before. Most of us use Excel in our day to day lives as professionals, students or even to keep track of our admin like budgets and spending. But how did it all start? How did Excel become one of […]

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, […]

Excel Troubles And Geneticists

Why Geneticists Renamed Genes Due to Excel Troubles

Excel is a useful tool to effectively organise, analyse and share data. What happens, though, when the default methods used in Excel to organise information do not align with the way we typically work with data? A recent article titled ‘Why Geneticists Really, Really Hate Microsoft Excel’ shows how frustrating Excel can be to use, […]

A Keyboard Shortcut To Inserting Columns

A Keyboard Shortcut combo to magically insert columns

Inserting an additional column is something we often need to do and the whole right-click insert thing is quite cumbersome. The trick to doing this without your mouse is to employ a Keyboard Shortcut combo… Ctrl + Spacebar to select the column of your current Active cell and Ctrl + “+”                to insert a […]

Navigating Lots of Excel Worksheets

Navigating lots of Excel worksheets? hover-over of your Worksheet Scroll arrows to reveal two more very useful tips! Ctrl + Left Click on the right arrow shoots to the last Sheet. (Ctrl + Left click on the left arrow will shoot back to the First one)Right Clicking on either arrow gives you a Pop-up Contents […]

No. of Days between two Dates

In Excel, subtracting an Earlier Date from a Later Date will calculate the number of Days in between – which can be very useful. However, we may need to calculate the number of Working Days between two Dates. If that is the case then NETWORKDAYS() is your goto function.  (Makes more sense if you read […]

Fixing Incorrect Dates

We often receive data where the Date Format is incorrect and subsequently does not load as a genuine date. (Remember, a Date is numeric, so should align to the right) Which brings us to the topic of fixing incorrect dates. Trying to force it to be Date using the Short Date Format does not work […]

Preventing an SA ID Number from displaying in Scientific Notation

It’s always a good idea to store ID Numbers as Text, especially as some can start with a leading zero. In this article we focus on displaying I.D numbers correctly in Excel. The problem though, is that if you convert cells with large numbers to Text it displays it in Scientific Notation. E.g. 8605065397083 display […]

Validating an SA ID Number

It’s pretty well known that the first 6 digits of your South African ID Number is your Date of Birth. Un-beknown to many though, the SA ID Number has a few other Personal Details hidden within its 13 digits! In this article we look at validating an SA ID number on and Excel spreadsheet. This […]

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