"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com
  • Understand and Create Pivot Tables

Warning: Invalid argument supplied for foreach() in /homepages/7/d408082301/htdocs/sites/jcstraining.com/training/wp-content/themes/jcstheme/single-courses.php on line 58

Understand And Create Pivot Tables

Course Overview

Understand and Create Pivot Tables. In this 1 day training course we look at all of the aspects of creating and manipulating Pivot tables. They are useful if you are looking to extract more meaningful information from your data. A PivotTable is an interactive table that quickly summarizes large amounts of numeric data so you can then analyse in it detail

 

Course Title  Understand and Create Pivot Tables

Course Summary
         Course Duration 1 Day
 

 

In this 1 day training course we look at all of the aspects of creating and manipulating Pivot tables. They are useful if you are looking to extract more meaningful information from your data.                    A PivotTable is an interactive table that quickly summarizes large amounts of numeric data so you can then analyse in it detail

Prerequisites:

Candidates should have knowledge of Excel to an advanced level and have ideally attended level1, level2 & level 3 training or have the equivalent working knowledge.


Introduction


Create a one dimensional pivot table report from a table

Create a grouped pivot table report

Understand pivot table rows and columns

Use an external data source

 

Apply a simple filter and sort to a pivot table

Use report filter fields

Filter a pivot table visually using slicers

Use slicers to create a date-driven interface

Use report filter fields to automatically create multiple pages

                                                                                                                                                    

 

 

                                                                                                                                                    
Format a pivot table using PivotTable styles

Create a custom PivotTable style

Understand pivot table report layouts

Add/remove subtotals and apply formatting to pivot table fields

Display multiple summations within a single pivot table

           
Add a calculated field to a pivot table   

Add a calculated item to a pivot table

           
Group by Text  

Group by Date

Group by numeric value ranges 


Sow row data by percentage of total rather than value

           
Create a pivot chart from a pivot table

Embed multiple pivot tables onto a worksheet

Use slicers to filter multiple pivot tables