16 – Conditional formatting in Excel

So for this I am going to walk you through one of the exercises I do with my learners when I am teaching Conditional formatting – particularly using the Highlight Cells Rules options. This is a file with the exercises in it. Here are the questions The number of...

01 – Starting Excel from the beginning

One of my key ideas for this year is to create a section in my newsletter specifically for Excel newbies – so that people who are new to Excel can use it as a way to get stuck in and start understanding the terminology. If that is you, I would suggest starting...

Faster Filtering with Filter()

Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism – create your formula in ONE cell and then copy it down or across. The new range of...