Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


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

  • Course Start Date: Dec. 11
  • Location: Virtual (Map)
  • Time: 4:00 pm - 5:30 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 90 minutes
    04:00 PM - 05:30 PM EST
  • Delivery Method(s):Virtual Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft Excel Training

 
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 ]

On Line Instructor Led
Your Home or Office
Your City, Your Province
Your Country   --- ---


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
11-December-2014 $85 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course currently does not have any dates other than this one scheduled. Please call 1-877-313-8881 to enquire about future dates.

Not interested in this Course?

Tell us why:

This page has been viewed 14 times.