Excel PivotTables: Crunch Data More Efficiently NOW!

Duration: 90 minutes

You can only go so far with sorting, filtering, and inserting subtotals. PivotTables add the ability to create multiple totals in columns and rows, quickly swap, add or delete fields, and sort without formulas or sequences.

Any Excel user who maintains data needs the ability to analyze with speed and ease—that’s exactly what PivotTables and PivotCharts provide.

This will be presented in Excel 2013 with references to Excel 2010 & 2016. 


WHY ATTEND

You don’t have to be a data junkie or manage thousands of rows in Excel to save time and gain deeper insights with PivotTables. Think budgets, sales projections, even Little League schedules -- PivotTables are ideal for spreadsheets big and small.

A PivotTable is Excel’s premier analytical tool for quickly creating summary information that you can easily drag-and-drop to manipulate and show multiple levels of totals in a variety of layouts.

PivotTables offer total flexibility:

  • compare multiple field summary contents
  • change row/column layouts
  • perform ad hoc grouping of information
  • drill down to see the details behind a summary
  • categorize date/time data on multiple levels
  • create visual displays with PivotCharts

LEARNING OBJECTIVES

In this webinar, you will learn how to:

  • Use the Recommended PivotTables button to create PivotTables that will best suit your data so you don’t spend time building features manually
  • Drill-down in your data to instantly see the detail records that comprise a summary
  • Sort PivotTable data by field or content without command or formulas
  • Analyze your data by year, quarter, month, or hour with one click 
  • Use Slicers as interactive filters 
  • Create and manipulate a visual display of your data with PivotCharts
  • Group data spontaneously to reveal new summary information not in the source data
  • Utilize the Timeline feature to simplify time-based filtering

This session will be presented in Excel 2013 with comparison information available for Excel 2010.

ABOUT THE SPEAKER

Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on those spreadsheet and database techniques that improve business efficiency and productivity. Dennis has over 25 years of training and consulting experience. He has taught well over 4,000 seminars and classes for over 100 companies, organizations, and government agencies.

Dennis is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. He has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to many clients over the past 25 years. In addition, Mr. Taylor has authored and presented more than 50 different training courses on Excel topics and has presented over 300 webinars to thousands of attendees.

What You Get With Each Option

Live Recording

Live Only

Participation in the live upcoming webinar

Recording

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

What You Get With Each Option close

Live Recording

Live Only

Participation in the live upcoming webinar

Recording

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

About Webinar Connections close

Each purchase is for ONE computer to access the session.
A group may participate in a room together as long as only 1 computer is logged in.
If you need more than one computer to access the webinar, please call customer service at 888-479-2777.
A charge will apply for each connection.