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 Intermediate Spreadsheets!
You have completed Intermediate Spreadsheets!
Preview
In this video, we'll introduce the concepts covered in this workshop and identify the prerequisites needed before starting this workshop.
Intermediate Spreadsheets Workshop
Make a copy of this Google Sheets workbook to follow along.
Prerequisites
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
[MUSIC]
0:00
Hello World.
0:09
My name is Richard and
I'm an instructor at Treehouse.
0:10
In this workshop we will explore some
intermediate spreadsheet concepts using
0:13
Google Sheets.
0:17
More specifically, we'll learn about
lookup functions, conditional formatting,
0:19
pivot tables, and data validation.
0:23
Now, this workshop is intended to expand
your existing knowledge of spreadsheets.
0:26
If you need a refresher,
0:31
check out the Teacher's Notes for
links to our intro spreadsheet courses.
0:32
If you have a working knowledge of
Microsoft Excel, you should be fine.
0:36
I'll link to the Excel
basics course as well.
0:40
I have included the Google Sheets
workbook we will use for
0:44
this workshop in the Teacher's Notes.
0:46
Make a copy in your personal Google Drive,
so you can follow along.
0:49
Rename it if you wish, so
that it's easy to find later.
0:53
In the next video,
we'll get started with lookup functions.
0:57
See you there.
1:00
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