Explore Data with PivotTables in Microsoft Excel
Offered By: Pluralsight
Course Description
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 and it’s 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 at best difficult and at worst impossible. 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 you can analyze the data in a PivotTable, 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. When you’re finished with this course, you’ll have the skills and knowledge of PivotTables needed to gain meaningful insights into large Excel datasets.
Around 90% of the world’s business data is held in Excel and it’s 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 at best difficult and at worst impossible. 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 you can analyze the data in a PivotTable, 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. When you’re finished with this course, you’ll have the skills and knowledge of PivotTables needed to gain meaningful insights into large Excel datasets.
Syllabus
- Create Your First PivotTable 23mins
- Analyze and Find Answers Using a PivotTable 23mins
Taught by
Ben Howard
Related Courses
Introduction to DatabasesMeta via Coursera Analyzing Big Data with SQL
Cloudera via Coursera Query Client Data with LibreOffice Base
Coursera Project Network via Coursera Unix Command Course for Beginners
Udemy Excel For Beginners! Top 30 Hottest Tutorials,Tips & Tricks!
Udemy