Google Sheets is like Excel, but free and online. You can use it from any computer, share it easily, and it works great for most spreadsheet tasks. I use it almost as much as Excel, and for many things, I actually prefer it.

This course will teach you the basics of Google Sheets. By the end, you'll be able to create spreadsheets, use formulas, and organize data.

Getting Started

Access Google Sheets:

1. Go to sheets.google.com
2. Sign in with your Google account (or create one)
3. Click "Blank" to create a new spreadsheet

Interface: Google Sheets looks similar to Excel - rows, columns, cells. The basics are the same.

Lesson 1: Entering Data

Click on a cell and start typing. Press Enter to move down, Tab to move right. It's that simple.

Try this: In cell A1, type "Name". In B1, type "Age". In C1, type "City". You've created column headers. Now add some data below.

Lesson 2: Basic Formatting

Make your spreadsheet look better:

• Bold: Select text, press Ctrl+B (or click the B button)
• Font size: Use the toolbar to change size
• Colors: Use the fill color button to color cells
• Alignment: Use alignment buttons to align text

Try making your headers (row 1) bold. Select row 1, then click the Bold button.

Lesson 3: Your First Formula

Formulas make spreadsheets powerful. All formulas start with an equals sign (=).

Try this: In cell A1, type 10. In cell B1, type 20. In cell C1, type:

Press Enter. Cell C1 should show 30. That's a formula!

Basic math operators:

• + for addition
• - for subtraction
• * for multiplication
• / for division

Lesson 4: Common Formulas

Google Sheets has built-in formulas (functions):

SUM: Adds numbers together

AVERAGE: Finds the average

MAX: Finds the largest number

MIN: Finds the smallest number

COUNT: Counts how many cells have numbers

Try this: Enter numbers 5, 10, 15, 20, 25 in cells A1 through A5. Then in cell A6, type =SUM(A1:A5). You should get 75. Change one of the numbers, and watch A6 update automatically!

Lesson 5: Copying Formulas

One of Google Sheets' best features: you can copy formulas and they automatically adjust.

1. Enter numbers in A1, A2, A3 (like 10, 20, 30)
2. In B1, type =A1*2 (multiplies A1 by 2)
3. Select B1, press Ctrl+C to copy
4. Select B2 and B3, press Ctrl+V to paste

Google Sheets automatically changes the formula - B2 will have =A2*2, B3 will have =A3*2. This is called relative referencing, and it's super useful.

Lesson 6: Working with Ranges

A range is a group of cells. You write it as "first cell:last cell":

• A1:A10 - cells A1 through A10 (a column)
• A1:D1 - cells A1 through D1 (a row)
• A1:D10 - a rectangle from A1 to D10

You can select ranges by clicking and dragging, or by typing the range in formulas.

Lesson 7: Sorting Data

Sort your data to organize it:

1. Select all your data (including headers)
2. Go to Data → Sort range
3. Choose which column to sort by
4. Choose ascending (A-Z, 1-10) or descending (Z-A, 10-1)
5. Click Sort

Google Sheets keeps rows together when sorting, so your data stays organized.

Lesson 8: Filtering Data

Filters let you show only certain rows:

1. Select your data
2. Go to Data → Create a filter
3. Little arrows appear in your headers
4. Click an arrow to filter that column
5. Uncheck items you want to hide

This is great for large datasets - you can focus on what you need without deleting anything.

Lesson 9: Sharing and Collaboration

This is where Google Sheets shines - easy sharing and collaboration:

1. Click the "Share" button (top right)
2. Enter email addresses or get a link
3. Choose permissions (viewer, commenter, editor)
4. Click Send or Copy link

Multiple people can edit the same spreadsheet at the same time. You'll see their cursors and changes in real-time.

Lesson 10: Creating a Simple Budget

Let's put it all together. Create a simple budget:

1. In A1, type "Item"
2. In B1, type "Amount"
3. In A2-A5, enter: "Rent", "Food", "Transport", "Entertainment"
4. In B2-B5, enter amounts (like 1000, 300, 200, 100)
5. In A6, type "Total"
6. In B6, type =SUM(B2:B5)

You've created a budget that automatically calculates the total. Change any amount, and the total updates!

Google Sheets vs Excel

Google Sheets advantages:

• Free
• Works online (access from anywhere)
• Easy sharing and collaboration
• Automatic saving
• Works on any device

Excel advantages:

• More advanced features
• Better for complex data analysis
• Works offline
• More powerful formulas and functions

For most people, Google Sheets is enough. Excel is better for advanced users or complex analysis.

Tips for Using Google Sheets

• Use keyboard shortcuts: Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save - though it auto-saves)
• Organize from the start: Create folders and organize your spreadsheets
• Use templates: Google Sheets has templates for common tasks - use them!
• Learn formulas gradually: Start with SUM and AVERAGE, then learn more as you need them
• Use comments: Right-click a cell → Comment to add notes