| Excel 325 All About Pivot Tables and Pivot Charts 1/2 day This course is challenging Prerequisites: Excel Level 1 and Level 2 or equivalents for both click here to return |
Hands On: Create a Pivot Table Report the hard way with “finish” Hands On: Create a Pivot Table Report the easier way Hands On: Create a Pivot Table with multiple Page items Hands On: Create a Pivot Table with multiple Row and/or Column items Hands On: Drill down in a Pivot Table Enhance Pivot Tables with Groupings
Hands On: Quickly group hundreds of dates by month Hands On: Quickly group hundreds of dates by week Hands On: Create Grouped Row or Column items Hands On: Create Grouped Page items (you thought this was impossible?) The Pivot Table Toolbar
Hands On: Use the Toolbar to change the contents of a pivot table Hands On: Use the Toolbar to change the displayed format of a pivot table Hands On: Use the Toolbar to refresh data A Quick Review of Excel Charts
A quick look at custom chart types Hands On: Create a Chart and place it in the same page as the table Hands On: Create a Chart and place it on a separate page Hands On: Put an Excel Chart into a Word document
Understand the relationship between Pivot Charts and Pivot Tables Hands On: Create a Pivot Chart Report using Chart layout (the hard way) Hands On: Create a Pivot Chart Report the easier way Hands On: Quickly add a Pivot Chart to an existing Pivot Table Hands On: Change the contents of an existing Pivot Chart Hands On: Change the type of an existing Pivot Chart |