📊 Microsoft Excel for Beginners

1. What is Excel?

Microsoft Excel is a spreadsheet program used to organize, calculate, and analyze data. You can use it for:

• Budgets
• Lists (contacts, tasks, inventory)
• Charts and graphs
• Basic calculations (math, percentages, averages, etc.)

---

2. Opening Excel

• Windows: Start Menu → search Excel → open.
• Mac: Finder → Applications → Excel.
• Choose a Blank Workbook to start fresh.

---

3. Layout of Excel

• Workbook = your file (like a Word document).
• Worksheet (Sheet1, Sheet2, …) = pages inside the workbook.
• Cell = a box where a row and column meet.
  • Example: A1 means Column A, Row 1.
• Formula Bar = shows what’s inside a cell.
• Ribbon Tabs = Home, Insert, Page Layout, Formulas, Data, Review, View.

---

4. Entering Data

• Click a cell and type (text or numbers).
• Press Enter (move down) or Tab (move right).
• Example:
  • A1: Name
  • B1: Age
  • C1: City
  • A2: John
  • B2: 25
  • C2: London

---

5. Basic Formatting

• Bold, Italic, Underline: Use the Home tab.
• Column width: Drag the line between column letters.
• Cell color & borders: Make tables easier to read.
• Number formats: Change numbers to currency, percentage, or date.

---

6. Simple Calculations

Excel uses formulas (always start with =).
Examples:

• =A1+B1 → adds two cells.
• =A1*B1 → multiplies.
• =SUM(A1:A10) → adds values in A1 through A10.
• =AVERAGE(B2:B5) → finds the average.

---

7. AutoFill (Quick Copy)

• Type 1 in A1, 2 in A2.
• Select both → drag the small square (bottom-right corner) down → numbers continue (3, 4, 5…).
• Works for days, months, formulas, etc.

---

8. Sorting & Filtering

• Highlight your data → go to Data Tab:
  • Sort A-Z (alphabetical/lowest to highest).
  • Filter (show only certain rows, like “only people from London”).

---

9. Creating Charts

• Highlight your data.
• Go to Insert Tab → Charts (Column, Bar, Line, Pie).
• Excel creates a chart automatically.

---

10. Saving & Printing

• File → Save As → choose location & name.
• .xlsx is the default format.
• File → Print to print your worksheet.

---

⌨️ Handy Shortcuts

• Ctrl + C / Ctrl + V → Copy / Paste
• Ctrl + Z / Ctrl + Y → Undo / Redo
• Ctrl + A → Select All
• Ctrl + P → Print
• Ctrl + S → Save

---

✅ Practice Idea for Beginners:
Create a simple monthly budget:

• Column A: Item (Rent, Groceries, Transport, Entertainment).
• Column B: Cost.
• Use =SUM(B2:B5) to calculate total expenses.
• Make a Pie Chart of your expenses.