Summarizing and Organizing Data in Excel

Focused View

Ben Howard

1:02:37

51 View

00. Course Overview

00. Course Overview.mp4

01:06

01. Grouping Data and Outlining Your Data

00. Why Summarize and Outline Your Data - .mp4

01:40

01. Introduction to Grouping and Outlining.mp4

04:49

02. Demo - Creating Groups and Outlines.mp4

05:36

03. Demo - Removing Groups and Outlines.mp4

03:00

02. Inserting Totals and Subtotals

00. Introduction to Totals and Subtotals.mp4

02:55

01. Demo - Quick Analysis Tool.mp4

03:31

02. Looking Deeper into Totals and Subtotals.mp4

03:22

03. Demo - Subtotals and Totals.mp4

07:32

03. Applying Conditional Formatting

00. Introduction to Conditional Formatting.mp4

05:17

01. Demo - Conditional Formatting with the Quick Analysis Tool.mp4

02:26

02. Demo - Advanced Conditional Formatting.mp4

05:17

04. Inserting Sparklines

00. Introduction to Sparklines.mp4

01:58

01. Demo - Sparklines.mp4

04:18

02. Demo - Advanced Sparklines.mp4

06:30

05. Exploring Other Excel Capabilities

00. Exploring Other Excel Capabilities.mp4

03:20

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Excel

Ben Howard

Instructor's Courses

Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 14 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.