Spreadsheet Basics

Focused View

Michael Watson

1:41:45

238 View

1 Introducing Spreadsheets

S1V1-What is a spreadsheet.mp4

02:02

S1V2-Choosing Spreadsheet Software.mp4

02:39

S1V3-Basic Spreadsheet Vocabulary .mp4

05:37

2 Getting Started With Spreadsheets

S2V1-Adding Data to A Spreadsheet.mp4

02:18

S2V2-Calculating Totals With SUM.mp4

04:03

S2V3-Calculating Averages and Median Values.mp4

03:38

S2V4-Sorting & Filtering.mp4

06:39

S2V5-Cell Referencing.mp4

07:37

3 Spreadsheet Functions & Shortcuts

S3V1-Introducing Functions.mp4

04:24

S3V2-The IF Function.mp4

04:26

S3V3-The COUNT Function.mp4

01:02

S3V4-The EDATE Function.mp4

02:18

S3V5-The SUMIF Function.mp4

02:41

S3V6-The CHOOSE Function.mp4

02:37

S3V7-The ROUNDDOWN & ROUNDUP Functions.mp4

01:52

S3V8-Keyboard Shortcuts.mp4

08:06

4 Spreadsheet Best Practices

S4V1-Spreadsheet Formatting Best Practices.mp4

03:59

S4V2-Saving Spreadsheet Data.mp4

01:33

S4V3-Input and Output Tabs.mp4

05:23

S4V4-Spreadsheet Templates.mp4

04:20

S4V5-Comments and Notes.mp4

04:14

5 Build a Spreadsheet

S5V1-Finding and Importing Data.mp4

04:02

S5V2-Formatting the Spreadsheet.mp4

07:28

S5V3-Adding Functions and Formulas.mp4

08:06

S5V4-Conclusion.mp4

00:41

Description

About this Course

A spreadsheet is an electronic document that arranges data in a table by using columns and rows. Among other things, spreadsheets let you store, manipulate, share and analyze data. They're used in business to help make complicated decisions like where to open a new restaurant location, where to build a wind farm, or where to expand a business' marketing efforts. Spreadsheets aren't just for business use either. A household expense spreadsheet can help you determine when you will be able to afford a new car or take your next trip.

In this course, you'll learn the basics of spreadsheets including the parts of a spreadsheet, spreadsheet vocabulary, how to import data, how to make complex calculations, how to reference data in different cells, and how to use spreadsheet functions. You'll also learn best practices for formatting spreadsheets, protecting your data, and more, all using Google Sheets, which is free and very similar to Excel. When you're done you'll have built an entire spreadsheet complete with data, complex functions and formulas and colorful and meaningful formatting.

What you'll learn

Spreadsheet concepts and vocabulary
Importing data into a spreadsheet
Using functions and formulas to analyze data
Formatting spreadsheets
Spreadsheet best practices

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Excel

Michael Watson

Instructor's Courses

Michael Watson is the former CFO & COO of Treehouse. Before joining Treehouse he worked in private equity in Asia. He is a graduate of Tufts University and has an MBA from INSEAD. He loves sports and the great outdoors.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.