Explore Data with PivotTables in Microsoft Excel

Overview

Do you feel like you're drowning in data? This course will teach you how to create and customize PivotTables, filter and sort data, use calculated fields, and generate insightful reports to enhance your decision making.

Around 90% of the world’s business data is held in Excel, making it one of the most widely used tools for data storage, analysis, and reporting due to its versatility and ease of use.

However, the sheer quantity of data in an Excel report can make gaining meaningful insights challenging. In this course, Explore Data with PivotTables in Microsoft Excel, you’ll learn to easily summarize and gain insights into large Excel datasets.

First, you’ll explore how to create PivotTables.

Next, you’ll discover how to analyze data in a PivotTable, including creating sums, averages, and more. Finally, you’ll learn how to filter and sort data in a PivotTable, allowing you to quickly find answers to specific questions.

By the end of this course, you’ll have the skills and knowledge needed to gain meaningful insights into large Excel datasets using PivotTables.

University:

Provider:

Pluralsight

Categories:

Data Analysis Courses, Business Intelligence Courses, Data Visualization Courses, Microsoft Excel Courses, Data Sorting Courses, Spreadsheets Courses, PivotTables Courses, Data Filtering Courses

Subjects