To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.
LessonsIn this course, you will learn advanced PivotTable features and create PivotCharts. PivotTables and PivotCharts are tools you can use to analyze your raw data, summarize data to analyze it, and organize the data in a way that can be meaningfully presented to others.
WHAT YOU'LL LEARN
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 and Creating PivotTables
- Prepare Data
- 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 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
WHO SHOULD ATTEND
Â Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.Â
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Global Knowledge Ottawa
360 Albert Street Suite 720