This Event has Passed
Wednesday, January 09, 2019 - 10:00 AM
to Thursday, January 10, 2019 - 11:00 AM
10:00 AM - 11:00 AM See all dates and Times
https://www.traininng.com/webinar/mastering-excel-pivot-tables-200473live?upcomingevents-Jan-Seo-2019
Overview PivotTable capabilities are enormous; among its many tools and features. You will learn the following in this webinar, The quickest and best ways to create PivotTables and Pivot Charts, including these capabilities: The following subjects will be covered in detail:
How to compare two or more fields in a variety of layout styles
How to sort and filter results
How to perform ad-hoc grouping of information
Areas Covered in the Session
Pre-requisites for source data - preparing data so that it can be analyzed by PivotTables
Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option
Manipulating the appearance of a PivotTable via dragging and command techniques
Using Slicers to accentuate fields currently being shown (and which ones are not)
Using the new (in Excel 2013) Timeline feature
Creating ad hoc and date-based groupings within a PivotTable
Quickly create and manipulate a Pivot Chart to accompany a PivotTable
Who Will Benefit
Excel users who are familiar with PivotTable concepts, but need Expanded Techniques to Analyze lists of Data
Anyone Needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this Course
How to compare two or more fields in a variety of layout styles
How to sort and filter results
How to perform ad-hoc grouping of information
Areas Covered in the Session
Pre-requisites for source data - preparing data so that it can be analyzed by PivotTables
Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option
Manipulating the appearance of a PivotTable via dragging and command techniques
Using Slicers to accentuate fields currently being shown (and which ones are not)
Using the new (in Excel 2013) Timeline feature
Creating ad hoc and date-based groupings within a PivotTable
Quickly create and manipulate a Pivot Chart to accompany a PivotTable
Who Will Benefit
Excel users who are familiar with PivotTable concepts, but need Expanded Techniques to Analyze lists of Data
Anyone Needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this Course
