Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my 1-month free trial

Excel 2016: Pivot Tables in Depth

Course by: Curt Frye
Excel 2016: Pivot Tables in Depth Watch preview
  • Course details

    Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.


    • Curt Frye

      Curt Frye

      Freelance writer, course developer, and speaker.
      View on LinkedIn

      Curt Frye is the president of Technology and Society, Incorporated.

      He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.

      View all courses by Curt Frye

    Skills covered in this course

  • Welcome

    - [Voiceover] Hi, I'm Curt Frye. Welcome to Excel 2016 Pivot Tables in Depth. In this course, I will show you how to use pivot tables to analyze your data. I'll start by showing you how to create pivot tables, manage pivot table options, and use pivot table data and formulas. I'll also show you how to sort and filter pivot table data, create custom styles for your pivot tables, and apply conditional formats that change your data's appearance based on its value. Chapter 6 shows you how to create pivot charts, change your pivot chart's layout and formatting, and add a trend line to project future values. Chapters 8 and 9 show you how to control your pivot tables by using macros, creating a simple presentation kit, and creating relationships between Excel tables that have fields in common. All of these methods provide the power and flexibility you need to analyze your data so you can make good decisions for your company. I'm sure that you'll find that your time with Excel 2016 Pivot…

  • 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.
    Download the exercise files for this course. Get started with a free trial today.
  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents