Pivot Table is classified as an advanced Excel function. But to us, it is one of the fundamental function that must be acquired by anyone who is a frequent user of Excel. In this example, we will demonstrate the functions that you could tap on to increase your productivity in analyzing huge amount of information and preparing a report from it with a few mouse clicks.
4.1 Create a Pivot Table Using Data from an Excel Spreadsheet
4.2-4.3 Format & Sort Pivot Table
4.4-4.6 More Pivot Table Options
Quick Access to the other Hidden Secrets in Data Analysis with Excel cases.