Blog
Library

Excel: Data Analysis with Pivot Tables

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration

    02:27:32

  • 0 Students Enrolled

Description

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. 

Who this course is for:

  • Excel users

Basic knowledge
  • The student will need basic computer knowledge
  • A copy of Excel is recommended

What will you learn
  • 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
Course Curriculum
Number of Lectures: 15 Total Duration: 02:27:32
Reviews

No Review Yet