Excel functions you need to know for IGCSE & AS
The post lists all the Microsoft Excel functions that you will learn in your 3-year IGCSE journey followed by your…
productivity through technology
The post lists all the Microsoft Excel functions that you will learn in your 3-year IGCSE journey followed by your…
In the very unlikely event that you have a column of Roman numerals that needs to be converted to "normal"…
You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that…
This function takes two or more arguments, and all the arguments must return TRUE for the function to return TRUE…
The Freeze Panes command makes it easier to work in spreadsheets when scrolling both vertically and horizontally by allowing the…
This is something that is tested almost every year in Grade 12 exam papers: the Subtotal command in the Outline…
Conditional Formatting commonly means applying a format to a cell based on the value in that same cell. This post…
Using one Excel function as an argument for a second Excel function is an important skill to master. This process…
This tutorial explains the COUNTIF function in Excel, which counts cells meeting specific criteria within a range, featuring syntax explanation…
Below is some data from a questionnaire where the respondent was asked: “What is your favourite ice cream flavour?”. The…