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 table below is searchable and sortable, and some of the…
productivity through technology
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE curriculum). The table below is searchable and sortable, and some 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…
OK, so the following scenario catches me every time: Conditional Formatting of cells based on values in a separate range of cells! In the example below, we have rows of…
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is being analysed. A closed question required respondents to select 3 of…
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?”. This data was then analysed by age group. This arrangement of tabulated…
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…