A Pivot Table is a visually-oriented feature which displays fields in different location, and is useful to nearly all users of the software. With a Pivot Table, you needn’t bother about formulas and command techniques. It’s an amazingly useful, efficient tool which can be used for a variety of things.
The features of a PivotTable include comparing multiple fields in different layout styles, sorting and filtering results, performing ad hoc grouping of information, drilling down to see summary details, categorizing date/time data in multiple levels, creating Pivot Charts which are in sync with the tables, adding calculated fields to perform additional analysis, choosing to hide or reveal information with a single click, and many others.
All webinar attendees will be provided handouts which will help them remember and make the most of the training they have received. These include a 15-slide PowerPoint Presentation.
- Compare two or more fields in different layout styles
- Sort and filter results
- Group information
- Use Slicers instead of filters
- Drill down to see the details behind the summary
- Categorize data and time data in multiple levels
- Add calculated fields to perform additional analyses
- Hide or reveal information with one click
- Create a Pivot Chart in sync with the PivotTable
- Deal with dynamic source data
- Learn about “refresh”
- Create a PivotTable based on data from multiple worksheets
Who will benefit:
The following people will benefit from, and should therefore attend, this webinar:
- People who are familiar with Excel’s features, but don’t know much about PivotTables
- People familiar with PivotTables, but unfamiliar with Excel 2013 or 2016
- People who wish to learn about the various applications and uses of Excel’s PivotTables