Description
In this course, you will learn :
- how to use this powerful tool to uncover useful business intelligence
- shows how to create Pivot Table reports from internal Excel data and external data sources, how to use filters to focus on the most important data in the sheet, and how to use Pivot Chart reports to make visual presentations of data.
Syllabus :
1. Creating and Pivoting PivotTable Reports
- Introducing PivotTable reports
- Formatting data for use in a PivotTable report
- Creating a PivotTable report
- Pivoting a PivotTable report
- Configuring a PivotTable report
- Connecting to an external data source
- Consolidating data from multiple sources
- Updating and refreshing PivotTable data sources
- Managing PivotTables
2. Summarizing PivotTable Data
- Adding, removing, and positioning subtotals and grand totals
- Changing the data field summary operation
- Summarizing more than one data field
- Creating a calculated field
- Drilling down to the underlying data
- Grouping fields
- Using PivotTable data in a formula
3. Sorting and Filtering PivotTable Data
- Sorting PivotTable data
- Creating a custom sort order
- Filtering by selection
- Filtering by a rule
- Filtering with report filter fields
- Clearing and reapplying filters
4. Formatting PivotTable Reports
- Applying a style
- Creating and editing styles
- Changing the layout
- Changing the data field number format
5. Emphasizing Data Using Conditional Formatting
- Highlighting cells by applying a rule
- Highlighting the top or bottom value in a report
- Formatting cells using data bars
- Formatting cells using color scales
- Formatting cells using icon sets
- Editing conditional formatting rules
- Controlling how Excel applies multiple conditional formatting rules
- Deleting conditional formatting rules
6. Creating and Manipulating PivotChart Reports
- Creating a PivotChart report
- Pivoting a PivotChart report
- Filtering a PivotChart report
- Formatting a PivotChart report
- Changing the layout
- Changing the chart type
- Adding a trendline
7. Printing PivotTable and PivotChart Reports
- Printing a PivotTable report
- Printing each item on its own page
- Printing a PivotChart report