LESSONS 1. Intro 2. Cell Referencing 3. Data Types 4. Operators 5. Functions 6. Intro To Logic 7. Simple Math 8. Math & Logic 9. Changing Text 10. Replacing Text 11. Splitting Text 12. Joining Text 13. Sorting Data 14. Rearranging Data 15. Looking Up Data

A spreadsheet is essentially a big table with a lot of rows and columns.

Where the rows and columns meet and form a rectangle is called a 'cell'.

Spreadsheets can hold, calculate, analyze, or visualize data.

Doing these things in the right way allows you to:

• Generate quotes
• Manage a budget
• Complete keyword research, or even
• Create games

Learning how to use spreadsheets unlocks a world of potential that, in a business environment, gives you a sort of superpower.

The 'spreadsheet person' in a business is invaluable as they organize and automate away time-consuming processes, ultimately saving the business money. And, if something breaks (which it eventually will), the business needs their 'spreadsheet person' to save the day.

That's why each Google Sheets 101 lesson has a built-in spreadsheet. This spreadsheet doesn't have all of the features of an actual spreadsheet, but it's got more than enough to teach you the basics.

In each lesson you'll learn a spreadsheet concept and immediately complete exercises related to that concept.

To move on to the next lesson, you must correctly complete the current lesson's exercise.

You can select cells by clicking on them while the formula bar is empty (the selected cell/s will have a blue border): You can then enter formulas into the selected cell using the formula bar: When the correct formula is entered, the next lesson becomes available: Now let's get started:

Next Lesson