Excel Pivot Tables & Charts

This class shows how Excel can be used to analyze data using PivotTable and Charts. It covers these two topics in much more depth than the Excel Intermediate or Excel Advanced classes.

Training Class Goal

Students will come from this class with more confidence in using PivotTables and Charts and an understanding of how data in Excel can be displaying in a visual way.

Prerequisites

Understanding of Excel fundamentals including formatting, navigation, and basic formulas.

Training topics covered

• Pivot Tables training topics
  • Creating, sorting and filtering data
  • Formatting styles
  • Numbers, and layouts
  • Grouping data
  • Comparison and total options
  • Calculated fields and items
  • Combining multiple data sources
  • Conditional formatting
  • Other classes covering Pivot Tables
• Pivot Charts training topics
  • Creating charts
  • Modifying design layout and format
  • Creating charts from non-consecutive data
  • Drop-lines
  • Axis formatting
  • Replacing chart series with pictures or shapes
  • Analysis tools
  • Trending tools
  • Using secondary axis
  • Highlighting relationship differences with charts
  • Combining 2 charts into 1