Filter Excel table and PivotTable data

- [Voiceover] The art of creating a dashboard…includes determining which data to include…and what to exclude.…Excel lets you focus the data shown in a worksheet…by creating different types of filters.…In this movie, I will show you how to create different…types of filters, including the very useful top ten filter.…My sample file is the filter workbook,…and you can find it in the chapter one folder of the…exercise files collection.…This workbook contains a worksheet with an Excel table…and you can see that I have five columns,…year, quarter, month, room type, and revenue…for my hotel operations, and also 48 rows of data.…

Let's say that I want to limit the data that appears…by selecting a specific room type.…For example, rather than having Cambridge…and Piccadilly data, I only want to see Piccadilly.…To create that filter, I would go to the Room Type…column header, and you can see the filter arrow here…at the right.…So if I click the filter arrow,…I will get the filter interface.…I can sort from A to Z or Z to A.…