Tag Archives: Autofilter

Analysing Tables with Slicers

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 “refresher”, here’s a link to November’s tip when we discussed Tables […]

Tables in Excel

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 possibilities. They also make […]