Advanced COUNTIF() function
This caught me out the other day: I was looking to do something that I at first pegged as a…
productivity through technology
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 provides two functions to produce random numbers. The functions can easily be used in conjunction with other functions to…
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…
The ISBLANK() function is high on the list of handy little functions that you will almost certainly never use —…
Looking to create barcodes easily? Look no further than this fantastic free font and Microsoft Excel. I completed this exercise…
This simple function is a great introduction to Excel’s logic functions. We all use this kind of logic every single…
We covered converting Roman numerals to numbers in the post Using Excel’s ARABIC function. Here we look at the opposite…
If nothing else, Excel’s DEC2BIN function is handy for playing with binary notation when you are studying your ICT theory.…