Excel: PivotTables in Depth

Start my 1-month free trial
  • Course details

    Many Excel users have a fear of PivotTables. This course provides a thorough introduction to this powerful and overlooked feature and, for more advanced students, shows how to use macros and the data model to extend PivotTables even further. Instructor Curt Frye demystifies PivotTables, using real-world examples that empower students to make the most of their time with the program and to analyze their data effectively. Learn how to evaluate and summarize data, sort and filter results, format your PivotTables with styles and conditional formatting, and visualize your analysis with PivotCharts.

    Note: This course was recorded in Office 365. However, anyone using Excel 2019, Excel 2016, and even prior editions of Excel should be able to follow along with the course contents.

    Instructor

    • Click here to view Curt Frye’s instructor page

      Curt Frye

      Online course developer, freelance writer, and speaker. MBA.

      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 Lynda.com 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.

    Skills covered in this course

  • Work in depth with PivotTables

    - [Curt] Excel PivotTables are a powerful tool for evaluating data within your business or organization. Mastering the skills you need to manage PivotTables effectively will let you work quickly and make great decisions. In this course I'll use real-world examples to demonstrat how you can apply the incredible power of Excel PivotTables to your data. Join me at LinkedIn Learning for an introduction to the essential skills that will let you unlock the power and flexibility that comes with Excel PivotTables for Office 365.

  • 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.

    Watch this course anytime, anywhere. Get started with a free trial today.

Contents