PrabasTech

How to use #Timeline in Excel to Pivot Table

Excel Timeline to filter Pivot Table

Download

Excel for Practice

If you watch and understand the entire video tutorial along with the practice file, it is a great time saver in such scenarios. 

The Timeline option is available from Excel 2013 version. So, if you use any versions older than from Excel 2013, this fantastic option may not be available in your Excel application. 

Timeline is one of the good tool to filter-down your Excel Pivot Table. So, if you have any Pivot Table in your Excel book, make sure to explore the usage of Timeline as soon as you watch this video.

There is an important step before creating a Timeline, which is converting your raw data into an Excel table (ctrl + t) then to Pivot Table. So, convert your raw data into Excel table by hitting ctrl + t to switch your normal data into a structured Excel Table, then convert the table to Pivot Table to explore the Timeline options.

  1. Now, go to Insert tab
  2. And navigate to Filter group
  3. Then select the Timeline commend
  4. You are good to go and explore all the discussed option in our linked video.
  5. Last but not the least, you can also change the color of your Timeline like Slicers as you need

I hope you understood and practiced the entire concept. Thanks for your time for reading this article.

Want to receive weekly insights  tips & tricks

then register here

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?