Case 5

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.

Case 1

Case 2

Case 3a

Case 3b

Case 4

Case 5

Case 6

Case 7