Excel: PivotTables in Depth Preview

Excel: PivotTables in Depth

With Curt Frye Liked by 15,604 users
Duration: 3h 50m Skill level: Intermediate Released: 11/17/2021

Start my 1-month free trial

Course details

Many Excel users aren’t sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable. Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.

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.

Sample certificate

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

Learner reviews

4.7 out of 5

2,515 ratings
  • 5 star
    Current value: 2,009 79%
  • 4 star
    Current value: 415 16%
  • 3 star
    Current value: 67 2%
  • 2 star
    Current value: 14 <1%
  • 1 star
    Current value: 10 <1%

Contents

What’s included

  • Practice while you learn 2 exercise files
  • Test your knowledge 8 quizzes
  • Learn on the go Access on tablet and phone
  • Stay up to date Continuing Education Units

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.