Microsoft Excel 2016 - Data Analysis with Pivot Tables

Learn advanced PivotTable features and create PivotCharts to analyze your raw data, summarize data to analyze it, and organize the data in a way that can be meaningfully presented to others.

Course Outline

In 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.

OUTLINE
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.

Training Location

Online Classroom
your office

your city, your province
your country

Current price: $355.00

Regular price: $355.00

For more information, call 1-877-313-8881

Registration is fast, and will take approximately 3 minutes. There is no membership fee.

Course details

Course Start Date: 21-June-2024

Time: 08:30:00 - 16:30:00

Duration: 1 day 08:30 AM - 04:30 PM

Location: Virtual

Delivery Methods(s): Instructor Led

Discount Seats Available: 2

Category: Microsoft Excel Training

Cancellation Policy

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.

Additional Details

Pre-Requisites: 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.

Certificates Offered: Certificate of completion

This course is also scheduled on the following dates:

June 21st (Virtual)

September 13th (Virtual)