Excel 2016 from Scratch
An Excel tutorial by Peter Kalmstrom In 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.
Peter uses Excel 2016 for his demo, but Excel 2013 also has the timeline feature.