Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677
Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others.
TARGET AUDIENCE: Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
COURSE OBJECTIVES: Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data. You will:Prepare data for PivotTable reporting and create PivotTables from various data sources.Analyze Data Using PivotTables.Work with PivotCharts.
Preparing Data & Creating PivotTables
Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source