Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

# Spreadsheet Basics Course (How To)

via Treehouse

### Overview

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

• Importing data into a spreadsheet
• Using functions and formulas to analyze data

### Syllabus

What are spreadsheets? Why do we use them? And how can they help you make better data-driven decisions?

Chevron 5 steps
• #### What is a spreadsheet?

2:02

2:39

5 questions

5:37

5 questions

Get started with spreadsheets and learn how to add data, create basic calculations, determine averages, sort and filter information, and how to reference data inside individual spreadsheet cells.

Chevron 7 steps

2:18

4:03

3:38

5 questions

6:39

7:37

• #### Getting Started With Spreadsheets Review

8 questions

Spreadsheet functions give you the power to perform complex calculations on data. You can use them to derive totals, count the number of records, round numbers up and down and add complex logic to process data in different ways depending on their values.

Chevron 10 steps

4:24

4:26

1:02

2:18

7 questions

2:41

2:37

1:52

8:06

• #### Review More Spreadsheet Functions

6 questions

Supercharge your spreadsheet use with best practices in formatting data, using templates, adding comments and notes, and using tabs to track inputs and outputs.

Chevron 6 steps

3:59

1:33

5:23

4:20

4:14

• #### Review Formatting Best Practices

5 questions

Walk through the process of creating a spreadsheet from start to finish. Find and import data; format the spreadsheet; and use formulas and functions to give the data meaning.

Chevron 5 steps

4:02

7:28

8:06

0:41