Download Excel File: https://ift.tt/2xnWrLb
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to use a PivotTable to create reports for Yearly Total Sales (from daily date transactions), YOY Change in Sales & % YOY Change in Sales. Learn that PivotTables are easier to create than Worksheet Formulas, but require a refresh when source data changes to get report to reflect the changed data.