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…
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…
Conquering Excel’s VLOOKUP
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can…