AS Excel - stylus

Please do not use this feature! It is not part of the syllabus and will only result in your becoming…

Data Validation rules applied to cells in Excel help to ensure the accuracy and speed of data capture.

I am not sure I have ever seen an instance where these 2 functions are NOT used together! In this…

The RIGHT() function returns a specified number of characters from a string, starting from the right-hand side (essentially the opposite…

This is especially handy if you are looking to create a list of unique values (or records) to import into…

Headers and footers can be created for the printing of your Excel worksheets in a similar fashion to those available…

Excel’s COUNTBLANK function counts the number of cells in a given range that are blank. The cells must be completely…

In the tutorial on Excel’s Auto Fill Feature, we looked at copying a formula down in a spreadsheet. By default,…

Excel’s COUNT() function counts the number of cells in a given range that contain values. The values could be numbers,…

The post lists all the Microsoft Excel functions that you will learn in your 3-year IGCSE journey followed by your…

Tag: AS Excel