Microsoft Office Online Training

From time to time I get asked the question “what order do formulas evaluate?” The acronym BEDMAS can help you remember. It stands for: Brackets: Any operation(s) contained in brackets will be carried out first followed by any exponents. Exponents: Then any exponents like ^ or SQRT Division or Multiplication (left to right): Excel considers [...]

Using Data Validation to restrict what gets entered in a cell or range of cells is great for standardising your workbooks. But what if you want a second data validation list to only show values that are specific to the first list, like the one below? Well, that’s exactly what Jackie emailed me about the [...]

Let’s say that a baby learning to crawl is an analogy for learning the AVERAGE function in Excel. Then learning the AVERAGEIF function is like learning to walk, and learning the AVERAGEIFS function is like learning to run. So, lace up your shoes and get ready to run We’ll be using the table below in [...]

My Toughest Excel Challenge So Far! Recently a member contacted me with a VLOOKUP question, but when I further understood the requirements it became a challenge I’d never come across before. This pushed me to my Excel limits and I have to be honest…I nearly gave up twice! By giving up I mean I was [...]