Using Excel’s COUNT() function
Excel’s COUNT() function counts the number of cells in a given range that contain values. The values could be numbers,…
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…
File compression
File size can be reduced by compressing (“squashing”) files using a file compression utility. The amount of “space saved” depends…
The Microsoft Word interface
You will find learning Word (and other software) far easier if you can quickly learn the names of all the…
The Microsoft Excel interface
You will find learning Excel (and other software) far easier if you can quickly learn the names of all the…
Excel’s Auto Fill Feature
The results from left-click-dragging the Fill Handle are dependent on the contents of the selected cell or range. Follow the…
“Hello World!” batch file
This tutorial is your introduction to writing a batch file. We discussed using the Windows CLI in the Windows Command…
Record a Macro in Excel
Macros are handy tools for automating your work. Recording Macros and inspecting the code is also an easy and enjoyable…