**👋 Welcome to your first step into the world of Google Sheets! If you’ve used Excel before, you’ll feel right at home. If not, no worries — this guide is designed for complete beginners 💡.** 🖥️ **1. What is Google Sheets?** 📌 Google Sheets is a **free, cloud-based spreadsheet tool** from Google. It allows you to: ✅ Store data online ✅ Collaborate in real-time ✅ Create charts & reports ✅ Automate tasks with formulas & scripts 🔗 Access here → Google Sheets 📝 **2. Getting Started with the Interface** 🎨 When you open Google Sheets, you’ll see: * 🟩 **Cells** – Small boxes where you type data * 🔠 **Columns (A, B, C… )** – Vertical sections * 🔢 **Rows (1, 2, 3… )** – Horizontal sections * 📊 **Formula Bar** – Where you write formulas 👉 Think of it as a big table where each box has a unique address (Example: `B2` = Column B, Row 2). 🔤 **3. Entering & Formatting Data** 📥 **Typing Data** * Type numbers, text, or dates directly into cells. * Press **Enter** to move down, or **Tab** to move right. 🎨 **Formatting Tricks** * 🖍️ Change text color, bold, italic → Toolbar buttons * 🎯 Align text (left, center, right) * 🟨 Highlight with background colors 👉 Try this: Type your name in a cell, make it **bold + green**, and center it! ➕ **4. Basic Formulas You Must Know** Formulas always start with `=` 📌 **Examples:** * ➕ `=SUM(A1:A5)` → Adds numbers in cells A1 to A5 * 📊 `=AVERAGE(B1:B10)` → Finds average of numbers * 🔍 `=COUNT(C1:C20)` → Counts how many cells have numbers * ❓ `=IF(D1>50,"Pass","Fail")` → Checks condition 👉 Practice: Type numbers in column A and use `=SUM(A1:A5)` 🔎 **5. Sorting & Filtering Data** 📋 If you have a list (like names & marks), you can: * 🔼 Sort A → Z (alphabetical or smallest to largest) * 🔽 Sort Z → A (reverse order) * 🎭 Use Filters to show only what you need (e.g., marks > 50) 👉 Example: Try making a list of friends’ names and ages, then sort by age. 📈 **6. Creating Your First Chart** Data looks better when visualized 📊 * Select your data range * Go to **Insert → Chart** * Choose chart type: Bar, Line, Pie 👉 Example: Enter sales data (Jan, Feb, Mar) and make a bar chart. 🌟 **7. Practice Task for You** 🧑💻 Create a small **Student Marks Sheet**: * Names in Column A * Marks in Column B * Use `=AVERAGE(B1:B5)` for class average * Highlight students who scored less than 40 in red (conditional formatting) * Create a bar chart of marks

🟢 Google Sheets Basics – Step 1 to Start Your Journey 🚀

B4ALLB4U

👋 Welcome to your first step into the world of Google Sheets!
If you’ve used Excel before, you’ll feel right at home. If not, no worries — this guide is designed for complete beginners 💡.

🖥️ 1. What is Google Sheets?

📌 Google Sheets is a free, cloud-based spreadsheet tool from Google. It allows you to:
✅ Store data online
✅ Collaborate in real-time
✅ Create charts & reports
✅ Automate tasks with formulas & scripts

🔗 Access here → Google Sheets

📝 2. Getting Started with the Interface

🎨 When you open Google Sheets, you’ll see:

🟩 Cells – Small boxes where you type data
🔠 Columns (A, B, C… ) – Vertical sections
🔢 Rows (1, 2, 3… ) – Horizontal sections
📊 Formula Bar – Where you write formulas

👉 Think of it as a big table where each box has a unique address (Example: B2 = Column B, Row 2).

🔤 3. Entering & Formatting Data

📥 Typing Data

Type numbers, text, or dates directly into cells.
Press Enter to move down, or Tab to move right.

🎨 Formatting Tricks

🖍️ Change text color, bold, italic → Toolbar buttons
🎯 Align text (left, center, right)
🟨 Highlight with background colors

👉 Try this: Type your name in a cell, make it bold + green, and center it!

➕ 4. Basic Formulas You Must Know

Formulas always start with =

📌 Examples:

➕ =SUM(A1:A5) → Adds numbers in cells A1 to A5
📊 =AVERAGE(B1:B10) → Finds average of numbers
🔍 =COUNT(C1:C20) → Counts how many cells have numbers
❓ =IF(D1>50,"Pass","Fail") → Checks condition

👉 Practice: Type numbers in column A and use =SUM(A1:A5)

🔎 5. Sorting & Filtering Data

📋 If you have a list (like names & marks), you can:

🔼 Sort A → Z (alphabetical or smallest to largest)
🔽 Sort Z → A (reverse order)
🎭 Use Filters to show only what you need (e.g., marks > 50)

👉 Example: Try making a list of friends’ names and ages, then sort by age.

📈 6. Creating Your First Chart

Data looks better when visualized 📊

Select your data range
Go to Insert → Chart
Choose chart type: Bar, Line, Pie

👉 Example: Enter sales data (Jan, Feb, Mar) and make a bar chart.

🌟 7. Practice Task for You

🧑‍💻 Create a small Student Marks Sheet:

Names in Column A
Marks in Column B
Use =AVERAGE(B1:B5) for class average
Highlight students who scored less than 40 in red (conditional formatting)
Create a bar chart of marks