Microsoft Office 2011 for Mac: Visual QuickStart Guide

13. Working with Tables

In This Chapter

About Tables 242

Creating a Table 243

Entering and Editing Data 244

Formatting a Table 245

Changing a Table’s Size 246

Filtering a Table 247

Sorting a Table 248

Calculated Columns 249

Adding a Total Row 250

Data Validation 251

Many worksheets are simply lists of information, such as address data and club membership rosters. Such lists typically include few calculations, if any. A spreadsheet program is very adept at managing lists—considerably more so than a word processing program, for instance.

Because so many people use spreadsheets to create and manage lists, Microsoft introduced list management features in Excel 2001. In Excel 2011, lists are now called tables, adapting the Office 2007 (Windows) ...