Download Excel Start File:
Download File:
Learn how to use a PivotTable & Filter Slicer To Show Historical Adj Stock Price by Year & Month:
1. (00:10) Problem Setup
2. (01:08) Create PivotTable
3. (02:07) Group Daily Date Field into Months and Years in Row Area
4. (03:08) Drag Year Field to Filter Area to allow Filtering of Entire Report
5. (03:32) Create an Average, Maximum and Minimum Calculation for the Adj Stock Price. Learn how to change the calculation for a Field (Column) and change the Number Formatting to Currency.
6. (05:50) Change columns widths to same size
7. (06:04) Change Report Layout to Tabular Layout
8. (06:14) Set PivotTable Options to not change column widths when PivotTable is updates using the “AutoFit column widths on update” check box
9. (06:37) Add a Slicer to easy change filter to desired year.
10. (07:51) Format PivotTable Title
