Video duration: 439 seconds
Global video hits: 907
See how to create a dynamic range for a Pivot Table & Pivot Chart with a Report Filter. The Excel 2007 Table feature automatically creates dynamic ranges that can be used by a Pivot Table and a Pivot Chart.
Also, see how to Filter the whole report with a Report Filter (2007) or a Page Field (2003).
Using an Excel PivotTable, I created PivotCharts and saved them as .JPG files in PowerPoint. I then imported the files into Windows Movie Maker and save the project as a .wmv file
Create over 20 "Aged Date" and "Reformatted Date" type calculated fields for use in Excel PivotTables created by Excel or EZ-Pivot. There are eight variations of Accounting Type "Aged Dates" like the popular Current, 31-60, 61-90, 91-120, 120+ Aging.