Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Learn the basic vocabulary to make it easier to talk about and learn how to use spreadsheets.
Example Google Sheets
- Population by Country (click this link to create your own copy of this spreadsheet.
Vocabulary
- Cell: the building blocks of a spreadsheet. Each cell holds one piece of data.
- Row: a horizontal collection of cells. Each row is identified by a number on the left side of the row.
- Column: a vertical collection of cells. Each column is identified by a letter at the top of the column.
- Spreadsheet: the entire collection of data. Most spreadsheet programs like Excel, refer to this as a worksheet or workbook. Google just calls it a spreadsheet.
- Tab: an organizational unit in a spreadsheet. You can think of them sort of like different pages in the spreadsheet.
- Formula: an equation based on multiple cells.
- Function: formulas that are built into your spreadsheet software are called functions.
- Manual Input: user inputted data into a cell. The difference between manually inputted data versus a cell with a computed value will become increasingly clear over this course.
- Output: a cell with a value that is calculated based on data in other cells. A function is an example of an output cell.
Before we start digging
into spreadsheets further,
0:00
let me cover some basic vocabulary.
0:03
Learning this handful of words will
make it a lot easier to talk about and
0:05
learn how to use a spreadsheet.
0:10
Let me teach the vocabulary
using a real spreadsheet.
0:12
If you'd like to follow along and explore
the spreadsheet with me, you can open
0:15
a copy of this spreadsheet by clicking
the link in the teachers' notes below.
0:18
This spreadsheet contains data on
estimated population levels by country.
0:21
The data source is the United Nations and
starts in 1950 and goes through 2015.
0:26
The data is in thousands.
0:30
So, here for Burundi, in 1950,
0:33
this would mean the estimated
population then was 2,309,000.
0:35
Cells.
0:39
Cells are the graphical building
blocks of a spreadsheet.
0:42
They are where you input data, and
0:46
a collection of cells
make up this spreadsheet.
0:47
This is a cell.
0:52
This is a cell.
These are all cells.
0:53
All of these spaces are cells with or
without data in them.
0:56
Rows.
1:01
Rows are numbered on the left
side of your screen, and
1:03
they collect cells horizontally.
1:05
So using this spreadsheet as an example,
if we refer to row 5,
1:08
we're talking about the row with
Djibouti's population data.
1:11
And all these cells that are now
highlighted are included in row 5.
1:16
Note that row 2 is a special type of
row that we call a data header row.
1:20
It provides labels for
each of the columns that contain data.
1:24
Columns.
1:29
Columns are listed across the top of
the spreadsheet just below the toolbar.
1:30
Each column is indicated by a different
letter, A, B, C, and so on.
1:34
They are vertical collections of cells.
1:41
In this spreadsheet, when I say column E,
1:43
it means all these cells,
everything for 1953.
1:46
Column and
1:50
row are how people typically refer to
a cell when discussing spreadsheets.
1:51
You say the column name,
then the row name for that cell.
1:55
So, for example you might say,
if we look at D6 in this example,
1:59
it's showing 1 185, D6,
Eritrea 1952, 1 185,
2:04
meaning the estimated population
of Eritrea in 1952 in 1,185,000.
2:09
Or if I say let's look at cell A1,
that would refer to this cell,
2:16
which is a blank cell.
2:21
Or, if I wanted to say at cell B4,
it would mean Comoros in 1950.
2:23
The spreadsheet is the entire collection
of data that you're looking at.
2:31
Most spreadsheet programs like Excel
refer to this as a worksheet or workbook.
2:35
Google just calls it a spreadsheet.
2:39
A tab is just an organizational
unit in a spreadsheet.
2:42
You can think of them of them sort of
like different pages in the spreadsheet.
2:44
But be careful there.
2:48
Sometimes when you print a spreadsheet,
there will be multiple pages per tab.
2:49
As you can see here,
there are two tabs in this spreadsheet.
2:53
One contains data, and the other is blank.
2:57
But both are part of one spreadsheet.
3:00
Google calls these tabs sheets.
3:03
Using tabs wisely can help a lot
with spreadsheet organization.
3:05
And I'll share a few examples
of this later on in the course.
3:09
The next basic vocabulary item
we want to cover is a formula.
3:12
A formula is an equation
based on multiple cells.
3:16
Scrolling down here to a formula
that we've prepopulated.
3:20
When I click on this cell, you'll see
an equation up here on the top left.
3:27
That's a formula that's calculated
in a total of all these cells.
3:32
Don't worry too much about
how this equation works yet.
3:36
I'll teach you how to use and
create formulas later in this course.
3:38
Formulas that are built into your
spreadsheet software are called functions.
3:43
Different software may come with
different functions, but by and large,
3:47
the same core group of functions exists,
regardless of the software you're using.
3:50
Typically, functions will require you
to input data in a particular way.
3:54
For example, a function called
sum adds up a bunch of cells.
3:58
I utilize this function by clicking
on this cell, pressing = then s.
4:04
The list that just popped up shows
the functions I can use in this cell
4:11
that start with the letter s.
4:14
We'll go into more detail about how to use
some of the most common functions later in
4:16
this course.
4:19
Manual input.
4:20
A manual input is just that a user
has inputted data into a cell.
4:22
Here, I'm starting to add a new entry
4:25
To the population spreadsheet for
a imaginary place called Treehouse Island.
4:31
So, I'm manually inputting data into cell
B233 for a population of 1,000 in 1950,
4:37
and again,
manually inputting data into cell C233 for
4:43
a population of 1,000 in 1951 for
Treehouse Island.
4:48
Oftentimes, people will refer to
a manually inputted piece of data as
4:53
a hard-coded number.
4:56
Note that this is
different than a formula,
4:58
which computes a value
based on other cells.
5:00
The importance of the distinction between
a cell that has a manually inputted data
5:02
versus a cell that has a computed value
will become increasingly clear over this
5:07
course.
5:11
Output.
5:11
An output is a cell with a value that is
calculated based on data in other cells.
5:13
A function is an example
of an output cell.
5:18
We input data manually or hard-code data.
5:21
The data and all these cells above row 237
are hard-coded, manually inputted data.
5:24
And then the output,
in this example, is row 237,
5:29
which is calculating the sum
of all the cells above it.
5:32
You need to sign up for Treehouse in order to download course files.
Sign up