2.5 hours







Chip Reaves

Get More From Your Excel With The Power Of PivotTables

Expected learning & outcomes

  • Prepare Data and Creating PivotTables
  • Work with Local and External Data Sources
  • Summarize, Organize, Filter, and Format PivotTables
  • Refresh and Change PivotTable Data
  • Work with PivotCharts

    Skills you will learn

    Analysis, Data Analysis, Reporting

    About this course

    Pivot Tables are the perfect tool to analyze large amounts of data in Excel.  Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data, and in this course Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016.  

    Taught by Microsoft trainer Kathy Jones, Excel – Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts. 


    Lore delivers value at the intersection of learning, interests and skills.

    Learn from Domain Experts

    Access learning options recommended by industry experts, professionals and thought leaders.

    Search & Compare

    Quickly search, select and add learning options to your learning list.

    Personalize your feed

    Tell us more about yourself to access the latest learning options, curated just for you.