by Colin Foster | Mar 15, 2021 | Microsoft Excel, Tips and Tricks
When we have a list of data, sometimes it can be quite difficult to extract information from it quickly and efficiently. However, provided that we’ve the right sort of information in the various columns of our list, then we can make a start by using Excel’s...
by Colin Foster | Jan 22, 2019 | Microsoft Excel, Tips and Tricks
A brief reminder In this Tip, we first remind ourselves some of the basic analysis tools for tables before moving on to discuss Slicers. Tables, you’ll hopefully recall, are Excel’s way of holding data in a clear & structured manner; If you need a...
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...
