Date/Time
Date(s) - 07/20/2017
9:30 am - 11:30 am
Location
IML (Eggers Hall, room 062)
Category(ies)
A PivotTable is an interactive way to quickly summarize, analyze, explore, and present large amounts of data. You often use a PivotTable when you want to analyze related totals, especially when you have a long list of figures to sum and you want to compare several facts about each figure.
In this training session you will learn:
- How to design a PivotTable using data that is stored in an Excel file.
- How to add fields to the layout section of the design using the PivotTable Field List.
- The layout section includes a Filters area, Column area, Row area, and Values area.
- How to move (or pivot) the fields in the layout, allowing you to analyze your data in different ways.
- How to perform various tasks such as: sorting; filtering and grouping; changing summary functions.
- How to turn your PivotTable data into a PivotChart, which can help you visualize the PivotTable summary so that you can easily see comparisons, patterns, and trends.
- PivotTables and PivotCharts enable you to make informed decisions about critical data.
Please join us for this informative training session!