Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

The Essentials of Creating and Working with Tables in Excel 2007

If you know the essentials of creating and working with tables in Excel 2007 you can organize your data into easily read and understood tables. Your data is only useful if you can easily make sense of the numbers. Use tables to help you manage your data.

How to Create a Table in Excel 2007

You can create a table in Excel 2007 (a list or database in previous Excel versions) to help you manage and analyze related data. The purpose of an Excel table is not so much to calculate new values but [more…]

How to Add Records to an Excel 2007 Table

After you’ve created an Excel 2007 table (using the Table button on the Insert tab), you can choose from several methods for adding records to the table. Before you add records, the range must already [more…]

How to Find Records in an Excel 2007 Table

When you work with Excel 2007 tables, you can use keystrokes or a data form to move through table records until you find the one you want to edit or delete. In larger tables, you can use search criteria [more…]

Editing Records in an Excel 2007 Table

As you work with Excel 2007 tables, you will often find the need to edit or delete records and perform routine maintenance on the table. You can edit the records manually in the worksheet or use a data [more…]

Applying a Table Style to an Excel 2007 Table

In Excel 2007, you can apply a predefined table format to a data table. The Format as Table feature displays an extensive Table gallery with the formatting thumbnails divided into three sections — Light [more…]

Filtering Records in an Excel 2007 Table with AutoFilter

Use the AutoFilter feature in Excel 2007 to hide everything in a table except the records you want to view. Filtering displays a subset of a table, providing you with an easy way to break down your data [more…]

Filtering by Color in an Excel 2007 Table

If you’ve applied color to fonts or cells in an Excel 2007 table, you can filter the table to display a subset of the data with the colors you specify. The rows that do not match the criteria you specify [more…]

Filtering Numbers in an Excel 2007 Table

If you’re working with a large table of data in Excel 2007, you can apply number filters to columns that contain values to temporarily hide unwanted records. Excel provides several options for filtering [more…]

Filtering by Date in an Excel 2007 Table

If your Excel 2007 table includes columns with dates or times, you can filter the table to display a subset of the data with the dates or times you specify. The rows that do not match the criteria you [more…]

Using Advanced Filtering in Excel 2007

You can specify complex filtering criteria in Excel 2007 and designate a specific area of your worksheet to manage your criteria selections when filtering table data by using advanced filtering methods [more…]

How to Import Online Data into Excel 2007 with a Web Query

In Excel 2007, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. To create a new [more…]

Querying an Access Database Table in Excel 2007

Excel 2007 can import data from an Access 2007 database table into a worksheet, a process known as making an external data query. After importing the data into Excel, you can then use the Filter buttons [more…]

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!