Excel tutorial - stylus

This function is useful in terms of understanding data verification using double data entry (covered in the Cambridge International IT…

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…

It is possible to export an Excel spreadsheet to PDF format. This is a very simple process and has several…

The introduction of the XLOOKUP() renders the VLOOKUP() & HLOOKUP() functions redundant. Don’t celebrate yet: the XLOOKUP() function is most…

The WEEKDAY() function returns a number for the day of the week corresponding to the date provided. The day is…

This caught me out the other day: I was looking to do something that I at first pegged as a…

Excel’s PI function is one of four functions that do not require arguments. This is an awesome cross-curricular, experiential exercise,…

Excel has hundreds of functions. I have been presenting Excel courses for many years and use Excel every day at…

Another totally random-seeming function is being used to great effect in this tutorial! In this tutorial: Required knowledge: 1. Syntax…

Tag: Excel tutorial