- Start Date - 13/10/2015
- End Date - 13/10/2015
- Start Time - 09:30
- End Time - 12:30
- Location -
- Interested -
This module is designed to bring participants through the steps involved in creating and working with MS Excel Pivot Tables and Pivot Charts.
From preparing the data right through to summarizing, filtering, sorting and calculating Pivot Table data, the module will equip the participant with all they need to know to help them get the most from this advanced spread sheet functionality.
The module will include demonstrations and practical examples along with opportunities for the participants to practice the topics as listed below.
– Topic List and Course Structure
– Working with Excel PivotTables
– Preparing data for use in a PivotTable
– Creating a PivotTable
– Configuring, updating and managing a PivotTable
– Summarizing PivotTable Data
– Adding, removing, and positioning subtotals and grand totals
– Changing the PivotTable data field summary operation
– Creating a calculated field
– Grouping PivotTable fields
– Using PivotTable data in a formul
– Sorting and Filtering PivotTable Data
– Sorting and Filtering PivotTable Data
– Sorting PivotTable data
– Creating a custom sort order
– Filtering by selection or by rule
– Filtering a PivotTable using a search filter
– Using Slicers
– Formatting PivotTables
– Applying a PivotTable style
– Creating a PivotTable style
– Changing the PivotTable layout
– Changing the data field number format
– Creating and Manipulating Pivot Charts
– Printing PivotTables and Pivot Charts
– Target Audience: Any experienced Excel user wishing to improve their knowledge of the Pivot Table tool.
Duration: 3 Hours
All courses are bookable on the Upcoming Courses page. Please contact Catriona Campbell, Staff L&D Manager, if you are interested in attending (ext. 2527, Staff_L&D@rcsi.ie)