How to use Index Match

In this tutorial what I am looking at is the alternative to Vlookup() – Index/Match which is – astonishingly enough – a combination of two functions: Index and Match. I give an explanation of Match in this tutorial as well.  You can download the...

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...