Lesson 4 of 4: Filter Data Using Timelines and Slicers

One of the most powerful features in PivotTables is the ability to drill down into raw data to view fine data. PivotTable Timeline is a dynamic filter option that lets you easily filter by date/time, and zoom in on the period you want with a slider control. Pivot Table Slicers are a visual filter in the form of an interactive button.

Stick around to the very end, as I include some WONDERFUL bonuses!

Note: Downloadable Excel file is included in Lesson 1 (Creating a PivotTable)