Excel functions you need to know for CAT
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE curriculum). The…
Excel’s Subtotal feature
This is something that is tested almost every year in Grade 12 exam papers: the Subtotal command in the Outline…
Excel Conditional Formatting
OK, so the following scenario catches me every time: Conditional Formatting of cells based on values in a separate range…
Advanced criteria in Excel logic functions
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is…
Using an Excel function as part of another function
Using one Excel function as an argument for a second Excel function is an important skill to master. This process…
Using Excel’s COUNTIF function
Below is a simple, self-explanatory example of using the COUNTIF function to evaluate a range of data. The COUNTIF function…
Excel Stacked Column Chart
Below is some data from a questionnaire where the respondent was asked: “What is your favourite ice-cream flavour?”. This data…
Excel Sunburst chart
Excel’s Sunburst Chart is such a visually effective way to demonstrate data that is organised in categories with sub-categories. The…
Selecting function criteria in Excel
When using Excel logic functions such as COUNTIF and SUMIF which involve ranges being evaluated based on criteria, you cannot…
Cleaning data in Excel
In the example below I have used three Microsoft Excel functions to identify and then correct a common mistake that…
Excel’s Text to Columns command
There are a few super-handy timesaving tricks in Microsoft Excel for when your data is not quite the way you…