📊 Excel-18

✨ Project Description

Excel-18 is a practical guide to working with Tables in Microsoft Excel. Find step-by-step instructions, clear explanations, and screenshots to help you analyze and organize your data efficiently.

📚 Goal: Master Tables, Quick Analysis Tool, Structured References, and using tables as source data in Excel!

---

📒 Table of Contents

• Create a Table
• Sorting Data
• Filtering Data
• Total Row
• Table Name
• AutoExpansion
• Structured References
• Tables as Source Data
• Quick Analysis Tool
• Formatting
• Screenshots
• Requirements
• Author

---

🔲 Create a Table

1. Click any cell inside your data set.
2. On the Insert tab, click Table (or press Ctrl + T).

3. Excel selects the data automatically. Check 'My table has headers' and click OK.

Result:

---

↕️ Sorting Data

To sort by Last Name first and Sales second:

1. Click the arrow next to Sales and choose Sort Smallest to Largest.
2. Click the arrow next to Last Name and choose Sort A to Z.

Result:

---

🔎 Filtering Data

To filter for USA only:

• Click the arrow next to Country and check only USA.

Result:

---

➕ Total Row

Add a total row to your table:

1. Select any cell in the table.
2. On the Table Design tab, check Total Row (or press Ctrl + Shift + T).

3. Click any cell in the last row to select a summary function (Sum, Average, Count, etc.).

---

🏷️ Table Name

Every table has a unique name you can use in formulas. You can also rename your table.

Example: Count records in Table1:

---

➕ AutoExpansion

Tables in Excel expand automatically when new rows or columns are added.

1. Select a cell inside the table.
2. Press Ctrl + Shift + T to remove the total row.
3. Add a new entry (e.g., type "Baker" in cell A16)—Excel auto-formats the new row.

📝 Note: New rows are part of the table. All related formulas update automatically.

---

📐 Structured References

Use structured references for clear, dynamic formulas in tables.

1. Type "Bonus" in cell E1—Excel formats it as a new column.

2. Enter the formula in cell E2:

   =0.02*[Sales]
   

   and press Enter.

Excel fills the formula down automatically.

To sum the Sales column using structured references:

📝 Tip: Enter =SUM(Table1[ and Excel shows available structured references. Formulas update when your table grows.

---

📊 Tables as Source Data

1. Select a cell in your data.
2. Press Ctrl + T to insert a table.
3. Press Enter.

4. Go to Insert > Charts and click Column > Clustered Column.

Result:

Add new data (e.g., type "Jul" in cell A8), and your chart updates automatically.

---

⚡ Quick Analysis Tool

Use the Quick Analysis tool for instant calculations and visualizations.

Instead of a total row, quickly calculate totals with Quick Analysis:

1. Select a range and click the Quick Analysis button.
2. Click Totals > Sum to total columns.

Add a running total:

---

📋 Tables (Quick Analysis)

1. Select a range and click the Quick Analysis button.
2. Click Tables > Table to insert a table quickly.

---

🎨 Formatting (Quick Analysis)

1. Select a range and click the Quick Analysis button.
2. Click Data Bars to highlight values visually.

💡 Shortcut: Press Ctrl + Q to select your data and open Quick Analysis.

You can also add charts, pivot tables, sparklines, color/icon sets, and more.

---

📷 Screenshots

All screenshots used above are available in the /Screenshots folder.

---

ℹ️ Requirements

• Microsoft Excel (best: 2021/365 for modern features)
• Windows OS recommended

---

👨‍💻 Author

Project and documentation by Kuba27x
Repository: Kuba27x/Excel-18

---