Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Summarizing and Organizing Data in Excel

via Pluralsight

Overview

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.

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.

Topics:
  • Course Overview
  • Grouping Data and Outlining Your Data
  • Inserting Totals and Subtotals
  • Applying Conditional Formatting
  • Inserting Sparklines
  • Exploring Other Excel Capabilities

Taught by

Ben Howard

Related Courses

Reviews

Start your review of Summarizing and Organizing Data in Excel

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free