Pivot Table can be further enhanced with the use of MSQuery. When combined together, your Pivot Table becomes completely automated if the data source is a database like MS Access or a SQL server. You can also make use of it to tap into the Excel data maintained your colleagues.
5.1-5.2 Connect to the Source Database
5.3.-5.5 Format Pivot Table Created From Database
5.6.-5.7 Analyzing Monthly Sales Trend
5.8-5.10 Using Pivot Chart
Quick Access to the other Hidden Secrets in Data Analysis with Excel cases.