by Colin Foster | Feb 20, 2019 | Microsoft Excel, Tips and Tricks
In the past couple of tips, we’ve looked at how to create Tables & use the tools that then become available (such as Filters and Slicers) to begin to extract information from the data that we hold. We’re now going to look at how to take this much...
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...