The problem with Excel is not Excel: the problem is the problem
I find that many of my students battle with Excel questions that require problem-solving skills: the problem is not their…
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…
The Microsoft Excel interface
You will find learning Excel (and other software) far easier if you can quickly learn the names of all the…
Navigating the Excel environment
This tutorial deals specifically with navigating the Excel interface. I cannot stress enough how much more productive you will be…
Advanced criteria in Excel logic functions
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form…
Clearing ALL checkboxes in an Excel workbook
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test…
Transpose-pasting data in Microsoft Excel
How do you decide how your data should be arranged in terms of rows and columns? And what to do…
Copy-paste and moving Excel worksheets
The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered…
“Shrink to Fit” Excel cell formatting
This was a genuinely esoteric question in the NSC P1 Prelim 2020. I was completely unaware of this setting: I…
Adding up Check Boxes in Excel
So, you have created a form in Excel with nifty Check Box Controls. Looks real purrrty! But how do you…