shopping cart0
Call for support:

Excel Training: How To Use Pivot Tables

Webinar: ID# 1015378
Recorded On-Demand
About This Course:
Pivot Tables are interactive tables in Excel that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis.

One advantage of Pivot Tables is that they allow you to quickly convert lists of data into useful reports and charts. Another advantage allows you to extract significance from a huge data dumps, or to rearrange, hide, or display different category fields within the Pivot Table to provide alternate views of the data.

Unfortunately, Pivot Tables are one of the most underutilized Excel features, primarily because users often fear there's a long learning curve. However, by the end of this webcast, you'll be able to transform data into a pivot table-ready format and instantly create reports by simply dragging and dropping fields with your mouse.What You'll Learn:
  • Identify how to transform unwieldly data into usable reports in just a few simple steps
  • Compile unwieldy data into the format required for pivot table analysis quickly and easily
  • Disable the GETPIVOTDATA function if it's not needed for your analysis
  • Discover how pivot tables differ from worksheet formulas and learn the importance of the Refresh command
  • Discover the Recommended Pivot Tables feature
  • Identify the requirements of ideal data sets to be analyzed within your pivot tables
  • Incorporate calculations within or alongside pivot tables
  • Learn how to expand and collapse pivot table elements, thereby avoiding information overload
  • Prevent frustration by understanding the nuances of pivot table formatting
  • Use a simple keyboard shortcut to post the same formula to multiple cells at once
  • Use the Report Filter command to create breakout tables and dig deeper into the numbers
  • Apply what you've learned to easily implement Excel's PivotTable feature
  • Define how to use the Slicers feature introduced in Excel 2010 as well as Recommended Pivot Tables in Excel 2013
Continuing Education Credits:

Click the 'Credits' tab above for information on PHR/SPHR, PDCs, and other CE credits offered by taking this course.
Excel Training: How To Use Pivot Tables
Available 12:00 till 1:30pm Eastern or via On-Demand
Share This:
HR Training Center 5755 North Point Parkway Suite 227 Alpharetta, GA 30022 770-410-1219
Stay Up To Date New Course Dates, and News
Need training or resources in other areas? Try our other Training Center sites:
Accounting Banking Insurance Financial Services Real Estate Mortgage Safety Sales