Excel: Data Analysis with Pivot Tables
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9 students enrolled

Excel: Data Analysis with Pivot Tables

Get More From Your Excel With The Power Of PivotTables
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9 students enrolled
Created by Chip Reaves
Last updated 6/2017
English
English [Auto-generated]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Prepare Data and Creating PivotTables
  • Work with Local and External Data Sources
  • Summarize, Organize, Filter, and Format PivotTables
  • Refresh and Change PivotTable Data
  • Work with PivotCharts
Requirements
  • The student will need basic computer knowledge.
  • A copy of Excel is recommended.
Description

Pivot Tables are the perfect tool to analyze large amounts of data in Excel.  Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data, and in this course Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016.  

Taught by Microsoft trainer Kathy Jones, Excel – Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts. 


Who this course is for:
  • Excel users
Course content
Expand 15 lectures 02:27:25
+ Pivot Tables
15 lectures 02:27:25
02: Create from Local Data Source
10:33
03: Create from Multiple Data Source
12:27
04: Create from External Sources
07:12
05: Summarize Table Data
09:54
06: Organize Pivot Table Data
12:19
07: Filter Data, Part 1
09:54
08: Filter Data, Part 2
12:46
09: Format Pivot Table
14:19
10: Refresh and Change Data
10:53
11: Pivot Options, Part 1
09:53
12: Pivot Options, Part 2
07:59
13: Creating a Pivot Chart
02:56
14: Manipulate Pivot Chart Data
08:06
15: Formatting a Pivot Chart
07:36