Module 4 – Working with Tables

Excel Tables are one of the most powerful tools for organizing, analyzing, and updating data. Unlike normal ranges, Tables automatically expand, apply formatting, update formulas, and provide structured references that make your spreadsheets more reliable and easier to maintain.

In this module, you will learn how to:

• Convert a normal range into an Excel Table
• Use Table features such as sorting, filtering, and banded rows
• Apply and customize Table styles
• Use structured references in formulas
• Add and remove columns dynamically
• Use the Total Row for automatic calculations

Excel Tables are essential for anyone working with real datasets, reports, dashboards, business analysis, or automation. Once you understand how they work, they become an indispensable tool in your workflow.

---

Lessons in This Module

• Lesson 4.1 – Creating and Formatting Tables
• Lesson 4.2 – Sorting and Filtering in Tables
• Lesson 4.3 – Structured References
• Lesson 4.4 – Total Row and Automatic Calculations
• Lesson 4.5 – Adding and Removing Columns

---

Internal Links

If you missed any previous lessons, you can review them here:

• Lesson 3.5 – Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)
• Lesson 3.6 – Logical Functions (IF, AND, OR)

---

Next Lesson

Lesson 4.1 – Creating and Formatting Tables