This hands-on course is intended to teach employees advanced features of Excel, including the following topics. Completion of Excel: Intermediate or similar familiarity with Excel is strongly encouraged. The class is PC-based.
Learn to analyze and summarize worksheet data using pivot tables and pivot charts.
- What Is a Pivot Table?
- What Is a Pivot Chart?
- What Is the Power Pivot Add-in?
- Why Summarize List Data?
- Preparing a List for Analysis
- Working with Fields
- Creating a Pivot Table Using the Recommended PivotTables Feature
- Creating a Blank Pivot Table
- Formatting a Pivot Table
- Sorting Pivot Table Data
- Filtering Data in a Pivot Table
- Filtering with Slicers
- Filtering with Timelines
- Refreshing Pivot Table Data
- Changing the Data Source
- Grouping Dates in Pivot Tables.
- Using Drill Down
- Creating Pivot Charts.
- Setting Pivot Table Options