Using Tables in Excel 2010

View:  
Sorted by:  

How to Filter an Excel 2010 Table by Color

If you've applied color to fonts or cells in an Excel 2010 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…]

How to Create Custom AutoFilters for Text in Excel 2010

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method for more flexibility when filtering text [more…]

How to Create Custom AutoFilters for Numbers in Excel 2010

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method when you want to filter data based on a range [more…]

How to Create a Table in Excel 2010

You can create a table in Excel 2010 to help you manage and analyze related data. The purpose of an Excel table is not so much to calculate new values but rather to store lots of information in a consistent [more…]

How to Add Records to an Excel 2010 Table

After you've created an Excel 2010 table, you can choose from several methods for adding records to the table. Before you add records, the range must already be formatted as a table. To format a worksheet [more…]

How to Find Records in an Excel 2010 Table

When you work with Excel 2010 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…]

How to Edit Records in an Excel 2010 Table

As you work with Excel 2010 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…]

How to Query an Access Database Table in Excel 2010

Excel 2010 can import data from an Access 2010 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…]

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

In Excel 2010, 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. [more…]

How to Create a Pivot Table in Excel 2010

A pivot table is a special type of summary table that's unique to Excel. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas to perform [more…]

How to Format an Excel 2010 Pivot Table

Excel 2010 makes formatting a new pivot table you've added to a worksheet as quick and easy as formatting any other table of data. The PivotTable Tools Design tab includes special formatting options for [more…]

Filtering and Sorting an Excel 2010 Pivot Table

You can filter and sort the data in an Excel 2010 pivot table to display a subset of data arranged the way you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field [more…]

Using Slicers to Filter Pivot Tables in Excel 2010

Slicers are a new feature in Excel 2010 that you can use to filter your pivot tables. Slicers make it a snap to filter the contents of your pivot table on more than one field. Because slicers are Excel [more…]

How to Modify and Pivot Fields in an Excel 2010 Pivot Table

Pivot tables are much more dynamic than standard Excel 2010 tables because they are so easy to manipulate and modify. Excel makes it just as easy to change which fields from the original data source are [more…]

Modifying a Pivot Table's Summary Function in Excel 2010

By default, Excel 2010 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you include in a pivot table. Some pivot tables, however, require the use of another summary [more…]

How to Apply a Table Style to an Excel 2010 Table

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

Using Advanced Table Filtering in Excel 2010

With Excel 2010's advanced filtering methods, you can specify complex filtering criteria and designate a specific area of your worksheet to manage your criteria selections when filtering table data. Use [more…]

Advertisement
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com