How to use a Pivot Table Timeline in Excel

Описание: In this tutorial you will see the steps for adding a timeline to a pivot table in Excel, and then using it to filter the data.

You can filter your Pivot Table with Slicers and Timelines and have the applied filters visually displayed.

A timeline is just like a slicer, the difference is that the timeline only filters dates.

This video is about filtering excel data with timelines, but I have another video where I explain how to add a slicer to your Pivot Table.
(Link bellow 👇 )
   • How to use a Slicer in a Pivot Table in Excel  

Instead of adjusting filters to show dates, you can use a PivotTable Timeline, which allows you to easily filter by date/time, and zoom in on the period you want with a slider control.

With a default filter option it’s very hard to filter with months, quarters and years if you have simple dates, but with a timeline filter you don’t need to open the filter, again and again, you just do it with a single click.

At the end of this video, you will have a timeline filter in your worksheet and you will have the possibility to filter your pivot table with this.

If you find this useful, please drop a 👍 on the video and subscribe 🧐

Timestamp:
00:00 Intro
00:24 The most important column
00:35 Adding a Timeline
01:05 Use the Timeline
01:39 This is how you do it!

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions:    • 💰 Compound interest calculator template in...  
🎥 Common errors:    • 🚨 How to solve the #DIV/0! error in Excel  
🎥 How to tutorials:    • How to use UPPER in Excel  
🎥 Regular functions explained:    • BASIC EXCEL FUNCTIONS  

Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel