Excel Magic Trick 1218


PivotTable & Slicer To Show Historical Adj Stock Price by Year & Month

DESCRIPTION

Learn how to use a PivotTable & Filter Slicer To Show Historical Adj Stock Price by Year & Month:
(00:10) Problem Setup
(01:08) Create PivotTable
(02:07) Group Daily Date Field into Months and Years in Row Area
(03:08) Drag Year Field to Filter Area to allow Filtering of Entire Report
(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.
(05:50) Change columns widths to same size
(06:04) Change Report Layout to Tabular Layout
(06:14) Set PivotTable Options to not change column widths when PivotTable is updates using the “AutoFit column widths on update” check box
(06:37) Add a Slicer to easy change filter to desired year.
(07:51) Format PivotTable Title

WORKBOOKS