Excel Tables

Turn ordinary data into a super-powered table!

---

What is an Excel Table?

A special format that makes your data:

• Look better
• Easier to manage
• Auto-expand when you add rows
• Formulas auto-fill

---

Create a Table

1. Click anywhere in your data
2. Press Ctrl + T
3. Check "My table has headers"
4. Click OK

---

Table Benefits

---

Table Styles

After creating a table:

1. Click inside the table
2. Go to Table Design tab
3. Pick a style you like!

---

Total Row

Add totals with one click:

1. Click in the table
2. Table Design → Check Total Row
3. Click dropdown in total row to choose:
   • Sum
   • Average
   • Count
   • Min/Max

---

Table Names

Every table has a name (like "Table1").

To rename:

1. Click in table
2. Table Design → Table Name box
3. Type new name (e.g., "SalesData")

Use table names in formulas: =SUM(SalesData[Amount])

---

Structured References

Tables use column names in formulas:

Normal: =SUM(B2:B100)

Table: =SUM(Table1[Sales])

Much easier to read!

---

Add New Data

Just type below the table — it auto-expands!

No need to:

• Extend formulas
• Update ranges
• Reformat

---

Remove Table (Keep Data)

Want data without table format?

1. Click in table
2. Table Design → Convert to Range
3. Data stays, table features removed

---

Quick Reference

---

Summary

• Ctrl + T creates a table
• Auto-filter, auto-expand, auto-format
• Use Total Row for quick calculations
• Tables make formulas easier to read
• Best for any data you'll update often