Data Management & Analysis with Pivot Table - Excel 2010
Overview / Course Outline
This 1 day hands-on course will provide you with the capability to be able to summarize the massive data they have into useful summary tables. With these tables, you can help your superior to analyse the data better.
-
Create an Excel Table
-
Modify an Excel Table
-
What is a Pivot Table
-
Parts of aPivot Table
-
When is a Pivot Table Used
-
Creating a Basic Pivot Table Report
-
Rearranging a Pivot Table Report
-
Changing Summary Calculations
-
Adding and Removing Subtotals
-
Sorting and Filtering in a Pivot Table
-
Create Report Filter Pages
-
Custom Pivot Table
-
Using Slicers in Pivot Table
-
Working with Pivot Chart
-
Using External Databases to create a Pivot Table
-
End of Session Project Work
Pre-requisite
You must be a user of MS Excel 2010 and know the basic stuff such as creating worksheets, printing, changing of column width etc.
Duration
1 Day, 9.00am to 5.30pm