Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Learn to analyze and summarize worksheet data using pivot tables and pivot charts.


 
Course Outline
Objective

Learn to analyze and summarize worksheet data using pivot tables and pivot charts.

Course Description

Do you need to analyze data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.

Attend this course if you want to:


Learn why and when you might want to use a pivot table or pivot chart.
Set up your data properly before creating the pivot table or chart.
Create a pivot table.
Modify and format a pivot table.
Filter and sort data in a pivot table.
Refresh a pivot table to reflect changes in the source data.
Chang the data source.
Copy a pivot table to another location.
Group pivot table items.
Drill down to view details.
Create calculated fields and items.
Create and modify a pivot chart.
Customize pivot table options.
Prerequisites & Certificates
Pre-Requisites

Comfortable with Excel and its formatting capabilities.
Comfortable with basic functions & formulas.
Comfortable working with Excel worksheets and workbooks.

Certificates offered

Certificate of Completion


Cancellation Policy
If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.

Map & Reviews
Elert & Associates Technology Training
[ View Provider's Profile ]

Reviews
 
Should be a N/A option for Facility feedback section, this course was done online. I indicated average, but I this is not accurate as I was not in a classroom setting.
Reviewed by 2014
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 3007 times.