Introduction to Excel Tables

Excel Tables are a very useful tool that Microsoft introduced in Excel 2007.

In this 12 minute introductory video we cover 4 areas where Excel Tables provide benefits over ordinary ranges:

• Data Entry - How Tables can help with manual data entry and improve spreadsheet readability
• Data Analysis - The features of a Table that help with Data Analysis (including auto-updated charts)
• Formula Auditing - Structured References to help with formula readability and auditing
• Presentation - How Tables make formatting fast and convenience (including auto-banded rows)

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]