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…
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…
Using Excel’s CONVERT function
This function is really straightforward: it simply converts an amount from one unit of measurement to another. In the example…
Nested IF Statements in Excel
This little gem finds its way into Matric finals over and over again. It takes some practice to get your…
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…
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…
Phase 2 Excel analysis
Previous post: Phase 2 Excel data capture Once you have captured your questionnaire data in Microsoft Excel (or downloaded your…