Excel: Data Analysis with Pivot Tables
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: Data Analysis with Pivot Tables to your Wishlist.

Add to Wishlist

Excel: Data Analysis with Pivot Tables

Get More From Your Excel With The Power Of PivotTables
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Created by Chip Reaves
Last updated 6/2017
English
Current price: $12 Original price: $20 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
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 Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
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 is the target audience?
  • Excel users
Compare to Other Pivot Tables Courses
Curriculum For This Course
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
About the Instructor
Chip Reaves
4.4 Average rating
956 Reviews
10,515 Students
40 Courses
Bigger-Brains

Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.

Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.

Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.