In the very unlikely event that you have a column of Roman numerals that need to be converted to “normal” numbers, you can haul Excel’s ARABIC() function out of the…

This function takes multiple arguments and all the arguments must return TRUE for the function to return TRUE. You will most likely find this function combined with another function, as…

The Freeze Panes command makes it easier to work in spreadsheets when scrolling both vertically and horizontally by allowing the user to specify heading row(s) and/or heading column(s) that should…

This is something that is tested almost every year in Grade 12 exam papers: the Subtotal command in the Outline group of the Data ribbon. It is a useful way…

Conditional Formatting commonly means applying a format to a cell based on the value in that same cell. This post covers two advanced Conditional Formatting scenarios. Scenario One OK, so…

Using one Excel function as an argument for a second Excel function is an important skill to master. This process can become fairly complex, for example, a Nested-IF statement. Here…

Below is a simple, self-explanatory example of using the COUNTIF function to evaluate a range of data. The COUNTIF function counts the number of values in a range of cells…

Below is some data from a questionnaire where the respondent was asked: “What is your favourite ice-cream flavour?”. The respondents were grouped into age ranges and the flavour preference data…

Excel’s Sunburst Chart is such a visually effective way to demonstrate data that is organised in categories with sub-categories. The example below reflects sales figures for an ice-cream parlour in…

When using Excel logic functions such as COUNTIF and SUMIF which involve ranges being evaluated based on criteria, you cannot select the criteria from the range of data you are…