Summarizing and Organizing Data in Excel

A practical and pragmatic course exploring the features of Excel that allow you to organize, summarize, analyze, and visualize large amounts of data. Quickly learn how to turn data into insightful and powerful tables and charts.
Course info
Level
Beginner
Updated
Aug 20, 2019
Duration
1h 3m
Table of contents
Description
Course info
Level
Beginner
Updated
Aug 20, 2019
Duration
1h 3m
Description

Microsoft Excel is the world’s foremost desktop application for storing, organizing, and manipulating data. This course teaches you how you can use the features of Excel to quickly organize, summarize, analyze, and visualize data so that you can understand your data and gain meaningful insights into it. First, you will learn how to order and group the data so that related items appear together. Then, you will discover how to apply totals and sub-totals to it. Finally, you will explore how to visualize the data using Conditional Formatting and Sparklines. By the end of the course, you will have the skills and knowledge to understand and visualize your own data in Excel.

About the author
About the author

Ben is a Microsoft Project, Project Server/Online consultant, and Data Specialist with over 20 years of implementation experience. He has been a Microsoft MVP for nine years, as well as blogging on various project server scenarios, has articles published on the Microsoft Project User Group (MPUG), and is the author of Microsoft Project 2013 Plain & Simple.

More from the author
More courses by Ben Howard
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] so I expect you've got some Excel workbooks with a ton of data. And frankly, trying to review that data is simply overwhelming. In this course, I'll teach you how to organize the data into logical groups. Analyze it by quickly inserting subtitles, totals and how to spot trends and issues by using conditional formatting. Finally, I'll show you how to spark lines too neatly. Visualize a Siri's of data by using many grounds, and then additionally, I'll demonstrate how the majority of these features are instantly available using excels. Coolest feature. The quick analysis tool. Join may for this course and gain meaningful insights into your data so you can quickly identify opportunities issues on trends. From your information, your data will never be overwhelming again.