Create Pivot Tables Quickly based on a Variety of Different Sources

  EVENT DATE

June 15, 2017

  PRESENTER(s)

Dennis Taylor

  1:00 PM ET | 12:00 PM CT | 10:00 AM PT | 60 Minutes




DESCRIPTION



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.

Training Highlights:

  • 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

Download Conference Material




RELATED WEBINARS

 


CERTIFICATION PARTNERS

 
HRCI
HRCI
HRCI
HRCI