Excel 2016 from Scratch

Timeline

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconIn this exercise in the Excel 2016 from Scratch series, Peter Kalmstrom shows how to insert a timeline, for easy filtering of a pivot table. The timeline lets you select a period of dates in a pivot table to display data more visually.

This is what Peter shows in the demo below:

  • How to format a range of cells as a table.

  • How to summarize the data in a pivot table.

  • How to create a pivot table view.

  • How to insert and use a timeline.

Excel timeline

Peter uses Excel 2016 for his demo, but Excel 2013 also has the timeline feature.




Learn more



---------------------------------------------------------------------------------------







Always the latest news in the kalmstrom.com blog



Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

back icon next icon