Loading…

Track Spreadsheets Fundamentals

Introduction to Data Summaries

8 / 13

Spreadsheets Fundamentals

Course Progress0/13

Getting Started

Introduction to Spreadsheets Understanding the Spreadsheet Interface

Working with Data

Sorting Data Filtering Data

Formatting

Format Numbers as Currency Format Numbers as Percentages Adjusting Decimal Places

Tables & Basic Summaries

Introduction to Data Summaries Creating a Summary Table

Basic Formulas

Introduction to Formulas SUM and AVERAGE Formulas MIN and MAX Formulas COUNT and COUNTA Formulas

Spreadsheets (Excel/Google Sheets)Spreadsheets FundamentalsTables & Basic Summaries

Introduction to Data Summaries

5 min read

Reading

Introduction to Data Summaries

Why Summarize Data?

Raw data tells a story, but summaries make it readable. Consider:

Raw Data (10 rows):

Transaction 1: $1,299.99
Transaction 2: $29.99
... (8 more rows)

Summary:

Total Sales: $3,137.91
Average Sale: $313.79
Transactions: 10

Which is easier to understand at a glance?

Types of Summaries

Aggregations

SUM - Add up all values
AVERAGE - Find the mean
COUNT - How many items
MIN/MAX - Smallest/largest values

Groupings

Sales by Category
Revenue by Month
Customers by Region

In This Module

You'll learn to create simple summaries using formulas. Later, you'll explore more advanced tools like Pivot Tables.

Lesson 1 of 2 in Tables & Basic Summaries