Preview
Video Player
00:00
00:00
Welcome and Prerequisites
1:02In this video, we'll introduce the concepts covered in this workshop and identify the prerequisites needed before starting this workshop.
[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