Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Spreadsheet Basics!
You have completed Spreadsheet Basics!
Preview
There are many different spreadsheet programs, from free options like Google Sheets to industry-standards like Microsoft Excel. Learn about the options in this video.
Resources
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
There are countless software packages for
building and working with spreadsheets.
0:00
The most widely used spreadsheet software
is Microsoft Excel, it's everywhere and
0:05
is used extensively in most businesses.
0:10
And it has a very powerful
set of features and
0:12
it's the spreadsheet
software most people use.
0:14
In this course,
we're gonna use Google Sheet software.
0:16
It's free,
has all the functionality you will need,
0:19
and looks and works the same across
different types of computer systems.
0:22
Generally speaking, any spreadsheet
software that comes with your computer or
0:26
Google Sheets, which is free online,
0:30
are fine places to begin
learning how to use spreadsheets.
0:33
But if you're working with a large
amount of data and formulas
0:37
I'd argue it's probably worth investing
in more robust software than Sheets.
0:41
What software do you use
depends a lot on your use case,
0:46
as there are some industries with very
specialized spreadsheet software needs
0:50
where using more generic spreadsheet
software is impractical.
0:54
For example, you could build out an
inventory management spreadsheet in Excel.
0:58
But there is specialized software out
there that will allow you to do that
1:03
without Excel.
1:06
Another example,
is using a spreadsheet for
1:07
your accounting instead of
software like QuickBooks.
1:09
Here we are looking at
a blank Google sheet.
1:13
You can see the spreadsheet
title at the top.
1:16
You can rename the title
by clicking on it and
1:18
then entering whatever text
you want to have changed.
1:21
The menu bar includes different options
that will allow us to work with
1:26
the spreadsheet's data.
1:30
This is the menu bar right here.
1:31
These menu items are similar to those
you'd find in any spreadsheet software.
1:33
Under File, for example,
you can see some of the typical
1:38
options you may be familiar with like New,
Open, or Make a copy.
1:41
There is noticeable item
missing from file though, save,
1:45
fortunately Sheets automatically saves for
you, as seen right here.
1:50
Don't forget to save regularly
if you are using other software
1:56
as there is nothing
worse than losing work.
1:59
I do want to call out
something important here.
2:02
You'll notice that if you
scroll over the undo button,
2:04
there is also a Command Z in parentheses.
2:07
If you are using a PC,
2:10
it will say Control Z instead of Command,
this is a keyboard shortcut.
2:11
So to undo something, instead of having
to scroll through the Edit menu or
2:15
click on the toolbar I can just type
Command and Z at the same time to undo.
2:20
I can't stress enough how
important keyboard shortcuts are.
2:25
Learning and
2:29
using them will make you so much more
productive than simply using the menus.
2:30
They're so important, in fact,
I'll be talking about and
2:34
asking you to memorize them
throughout the course.
2:36
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up