by Colin Foster | Nov 19, 2018 | Microsoft Excel, Tips and Tricks
What are Tables Tables are Excel’s way of allowing you to manage and analyse a group of related data in a structured way. You can turn a range of cells into an Excel table at the click of a couple of buttons & this then provides a wide range of analysis...
by Colin Foster | Oct 8, 2018 | Microsoft Excel, Tips and Tricks
Changing case to help printing I’ve recently been doing some consultancy work which has involved copying some data from another software program into Excel. Unfortunately, the text was all in upper case & not only is this difficult to read, it physically...
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 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,...
