Excel lets you focus the data shown in a worksheet by creating different types of filters. In this movie, I’ll show you how to create several different types of filters.
- [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.…
Released
3/8/2017- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows
Share this video
Embed this video
Video: Filter Excel table and PivotTable data