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 Working with Tables in Excel 2010

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

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 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…]

How to Filter Records in an Excel 2010 Table with AutoFilter

Use the AutoFilter feature in Excel 2010 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…]

How to Filter Numbers in an Excel 2010 Table

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

Filtering by Date in an Excel 2010 Table

If your Excel 2010 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…]

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…]

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…]

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 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…]

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!