In
this demo in the Excel 2016 from Scratch series Peter Kalmstrom
shows how to make data easier to grasp by presenting it
in a pivot table and create a view that groups the data
per week.
Peter also shows how to calculate week numbers and how to
insert a chart based on the pivot table view.