The need to analyze data and gain actionable insight is greater than ever. This course will teach you to harness the power of advanced PivotTable features and create PivotCharts to gain a competitive edge. You will not only be able to summarize data for analysis but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
Learning Objectives »
- Prepare data and build PivotTables from multiple sources
- Analyze data by using PivotTables
- How to work with PivotCharts
Course Agenda
Preparing Data and Creating PivotTables
- Organizing Data for Your Workflow
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Source
Analyzing Data by Using PivotTables
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
Working with PivotCharts
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
