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 [...]
February 2012
I had an email from Bobcat today asking how to lookup data that is spread across multiple columns. Table 1 has data with the name in just one column: And Table 2 has the name across 3 columns (D, E and F): We want to find the Employee number from Table [...]
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 [...]
What if my side eBay bike business sold an extra 10%, what if I increased my price by $15 per bike, what if my costs increased by $5000 per year? What-if analysis is commonly done in Excel by saving different versions of the same workbook, or having a different sheet for each scenario which then [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
