Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Start a free Basic 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.

0:00
Before we start digging into spreadsheets further,

0:03
let me cover some basic vocabulary.

0:05
Learning this handful of words will make it a lot easier to talk about and

0:10
learn how to use a spreadsheet.

0:12
Let me teach the vocabulary using a real spreadsheet.

0:15
If you'd like to follow along and explore the spreadsheet with me, you can open

0:18
a copy of this spreadsheet by clicking the link in the teachers' notes below.

0:21
This spreadsheet contains data on estimated population levels by country.

0:26
The data source is the United Nations and starts in 1950 and goes through 2015.

0:30
The data is in thousands.

0:33
So, here for Burundi, in 1950,

0:35
this would mean the estimated population then was 2,309,000.

0:39
Cells.

0:42
Cells are the graphical building blocks of a spreadsheet.

0:46
They are where you input data, and

0:47
a collection of cells make up this spreadsheet.

0:52
This is a cell.

0:53
This is a cell. These are all cells.

0:56
All of these spaces are cells with or without data in them.

1:01
Rows.

1:03
Rows are numbered on the left side of your screen, and

1:05
they collect cells horizontally.

1:08
So using this spreadsheet as an example, if we refer to row 5,

1:11
we're talking about the row with Djibouti's population data.

1:16
And all these cells that are now highlighted are included in row 5.

1:20
Note that row 2 is a special type of row that we call a data header row.

1:24
It provides labels for each of the columns that contain data.

1:29
Columns.

1:30
Columns are listed across the top of the spreadsheet just below the toolbar.

1:34
Each column is indicated by a different letter, A, B, C, and so on.

1:41
They are vertical collections of cells.

1:43
In this spreadsheet, when I say column E,

1:46
it means all these cells, everything for 1953.

1:50
Column and

1:51
row are how people typically refer to a cell when discussing spreadsheets.

1:55
You say the column name, then the row name for that cell.

1:59
So, for example you might say, if we look at D6 in this example,

2:04
it's showing 1 185, D6, Eritrea 1952, 1 185,

2:09
meaning the estimated population of Eritrea in 1952 in 1,185,000.

2:16
Or if I say let's look at cell A1, that would refer to this cell,

2:21
which is a blank cell.

2:23
Or, if I wanted to say at cell B4, it would mean Comoros in 1950.

2:31
The spreadsheet is the entire collection of data that you're looking at.

2:35
Most spreadsheet programs like Excel refer to this as a worksheet or workbook.

2:39
Google just calls it a spreadsheet.

2:42
A tab is just an organizational unit in a spreadsheet.

2:44
You can think of them of them sort of like different pages in the spreadsheet.

2:48
But be careful there.

2:49
Sometimes when you print a spreadsheet, there will be multiple pages per tab.

2:53
As you can see here, there are two tabs in this spreadsheet.

2:57
One contains data, and the other is blank.

3:00
But both are part of one spreadsheet.

3:03
Google calls these tabs sheets.

3:05
Using tabs wisely can help a lot with spreadsheet organization.

3:09
And I'll share a few examples of this later on in the course.

3:12
The next basic vocabulary item we want to cover is a formula.

3:16
A formula is an equation based on multiple cells.

3:20
Scrolling down here to a formula that we've prepopulated.

3:27
When I click on this cell, you'll see an equation up here on the top left.

3:32
That's a formula that's calculated in a total of all these cells.

3:36
Don't worry too much about how this equation works yet.

3:38
I'll teach you how to use and create formulas later in this course.

3:43
Formulas that are built into your spreadsheet software are called functions.

3:47
Different software may come with different functions, but by and large,

3:50
the same core group of functions exists, regardless of the software you're using.

3:54
Typically, functions will require you to input data in a particular way.

3:58
For example, a function called sum adds up a bunch of cells.

4:04
I utilize this function by clicking on this cell, pressing = then s.

4:11
The list that just popped up shows the functions I can use in this cell

4:14
that start with the letter s.

4:16
We'll go into more detail about how to use some of the most common functions later in

4:19
this course.

4:20
Manual input.

4:22
A manual input is just that a user has inputted data into a cell.

4:25
Here, I'm starting to add a new entry

4:31
To the population spreadsheet for a imaginary place called Treehouse Island.

4:37
So, I'm manually inputting data into cell B233 for a population of 1,000 in 1950,

4:43
and again, manually inputting data into cell C233 for

4:48
a population of 1,000 in 1951 for Treehouse Island.

4:53
Oftentimes, people will refer to a manually inputted piece of data as

4:56
a hardcoded number.

4:58
Note that this is different than a formula,

5:00
which computes a value based on other cells.

5:02
The importance of the distinction between a cell that has a manually inputted data

5:07
versus a cell that has a computed value will become increasingly clear over this

5:11
course.

5:11
Output.

5:13
An output is a cell with a value that is calculated based on data in other cells.

5:18
A function is an example of an output cell.

5:21
We input data manually or hardcode data.

5:24
The data and all these cells above row 237 are hardcoded, manually inputted data.

5:29
And then the output, in this example, is row 237,

5:32
which is calculating the sum of all the cells above it.
You need to sign up for Treehouse in order to download course files.
Sign up