Description:
This course introduces you to using Pivot Tables and Pivot Charts within Excel 2016. You will learn how to use pivots to manipulate data available in an Excel spreadsheet. You will work with columns and rows, and learn how to summarize data, such as the Sum and Average functions. You will learn how to open and use PivotChart Tools, including chart types, chart designs, and add chart titles. This training will also instruct how to import data from an external source.

Delivery Method: Online Interactive Self Study

Level: Overview

Prerequisites: None

Advanced Preparation: None

Policies: Click here

Author: Jay R. Carlson

Category: Computer Software

Field of Study: Computer Software and Applications

Passing Score: 70%

Publication Date: 11/01/2016

For More Detail: Click here

If you are unable to view PDF then right click the mouse and click save link as

Objectives:
1. Recognize what a PivotTable does.
2. Recognize steps to create PivotTables and PivotCharts.
3. Identify how to manipulate data in a PivotTable and PivotCharts.
4. Recognize common functions, such as Sum and Average.

For More Objectives: Click here

If you are unable to view PDF then right click the mouse and click save link as

NASBA: Yes

QAS: Yes

CPA: Suitable for all CPAs

IRS: No IRS credit for Enrolled Agents.