|Author :||Jay R Carlson, MCSE, MCDBA, A+ Certified|
|CPE Credits :||2.0|
|IRS Credits :||0|
|Passing Score :||70%|
|Primary Subject-Field Of Study:||
Specialized Knowledge - Specialized Knowledge for Course Id 265
This document introduces you to using PivotTables and PivotCharts within Excel 2010. 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 document also instructs how to import data from an external source.
|Usage Rank :||0|
|Experience Level :||Overview|
|Additional Contents :||Complete, no additional material needed.|
|Additional Links :|
|Advance Preparation :||None.|
|Delivery Method :||Self-Study|
|Intended Participants :||Anyone needing Continuing Professional Education (CPE)|
|Revision Date :||28-Feb-2015|
|NASBA Course Declaration :||Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.|
|Approved Audience :||
NASBA QAS - NASBA Registry - 265
|Keywords :||Specialized Knowledge and Applications, Microsoft, Excel, 2010, PivotTables, PivotCharts, cpe, cpa, online course|
|Learning Objectives :||
• Create a PivotTable.
• Manipulate data in a PivotTable by moving columns and rows.
• Summarize Data by using common functions, such as Sum and Average.
• Manipulate data in a PivotChart.
• Customize the PivotChart design.
• Change the PivotChart type.
|Course Contents :||
Module 1: What is this Pivot Thing Anyway?
Overview of PivotTables and PivotCharts
Data from an External Data Source
Module 2: PivotCharts
Customizing the Chart
Refreshing a PivotTable / Chart