Excel 2013: Pivot Tables
With Curt Frye
Liked by 18,325 users
Duration: 4h 20m
Skill level: Intermediate
Released: 4/11/2013
Course details
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Welcome
- [Voiceover] Hi, I'm Curt Frye. Welcome to Excel 2013, Pivot Tables in Depth. In this course, I'll show you how to use pivot tables to gain valuable insights from your organization's data. I'll begin by showing you how to create a pivot table from data already in your Excel workbook. Then, using that knowledge as a base, I'll demonstrate how to create pivot tables using data from an external source. I'll enhance your ability to analyze your data by showing you how to reorganized or pivot a pivot table. After you've organized your pivot tables data you can sort and filter it's contents to develop useful insights into your business. I'll also show you how to create conditional formats that highlight subsets of your data, control your pivot table using macros, and summarize huge data sets using the power pivot add-in. Power pivot's capabilities have been extended with the new power view add-in. In short, I'll show you how to summarize and analyze data using one of Excel's most powerful and overlooked features.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.