1. All topics
  2. Business
  3. Business Software and Tools
  4. Spreadsheets
Excel PivotTable Quick Tips Preview

Excel PivotTable Quick Tips

With Jess Stratton Liked by 7,048 users
Duration: 16m Skill level: General Released: 2/15/2022

Start my 1-month free trial Buy for my team

Course details

Excel PivotTables–which allow you to quickly calculate and analyze large amounts of data–are one of the most powerful features of Microsoft’s ubiquitous spreadsheet tool. But many users have only a basic understanding of how PivotTables work. In this course, instructor Jess Stratton offers a plethora of bite-sized tips designed to deepen your understanding of how PivotTables work and how to use them more effectively.

Learn how to properly format data and create a basic PivotTable in Excel. Discover ways to adjust, rearrange, and group data to calculate and summarize values that you can put to use on the job. Get tips on data filtering and sorting, conditional formatting, and using PivotCharts and slicers. Along the way, Jess shows how to deal with common PivotTable error messages, such as invalid field names and overlapping reports. By the end of this course, you’ll be able to create more robust PivotTables in minutes—just in time for that next meeting.

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

7,393 ratings
  • 5 star
    Current value: 5,753 78%
  • 4 star
    Current value: 1,242 17%
  • 3 star
    Current value: 321 4%
  • 2 star
    Current value: 36 <1%
  • 1 star
    Current value: 41 <1%

Contents

What’s included

  • Test your knowledge 6 quizzes
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

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

Download on the App Store Get it on Google Play