by Colin Foster | Sep 14, 2018 | Microsoft Excel, Tips and Tricks
Making use of errors OK, so logic says that you don’t want to have any errors in your spreadsheet & broadly speaking, that’s correct… however, there can be occasions when an “error” can be helpful. As we saw in last month’s tip, the...
by Colin Foster | Aug 13, 2018 | Microsoft Excel, Tips and Tricks
The #N/A Error If we use the VLOOKUP Function to match between two sets of data – then occasionally, Excel will return an #N/A error where it can’t find the value in one list in the other one In this example, we have two lists of employee data where in the...
by Colin Foster | Jul 17, 2018 | Case Studies
The Client’s problem Hyde Community College (HCC) is a secondary school in Tameside with almost 1,000 pupils. In common with many commercial businesses, HCC makes extensive use of data; analysing, amongst other things, pupils’ performance data in assessments...
by Colin Foster | Jul 6, 2018 | Microsoft Excel, Tips and Tricks
Highlighting cells in accordance with a set of rules That is, in a “nutshell” what Conditional Formatting is all about – the formatting changes based on a set of rules that you specify. This could be whether a cell value is higher or lower than a target,...
by Colin Foster | Jun 1, 2018 | Microsoft Excel, Tips and Tricks
Making your spreadsheet understandable and easy to update For many of us, building a spreadsheet can be a one-off exercise to answer a specific issue or calculate a value. However, for others, spreadsheets can be designed to capture a year’s worth (or more) of...
