Data

Create a Pivot Table in Excel 2007

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

Filtering and Sorting an Excel 2007 Pivot Table

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

How to Install the Excel 2007 Analysis ToolPak

The Analysis ToolPak is an Excel 2007 add-in program that adds extra financial, statistical, and engineering functions to Excel's pool of built-in functions. The tools included in the Analysis ToolPak [more…]

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

Comparing Two Excel 2007 Worksheets Side by Side

You can use the View Side by Side command button on the View tab in Excel 2007 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button [more…]

How to Create a One-Variable Data Table in Excel 2007

To create a one-variable data table to perform what-if analysis in Excel 2007, you enter a series of input values either across columns of a single row or down the rows of a single column. The formulas [more…]

Formatting a Pivot Table in Excel 2007

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

Managing Range Names in Excel 2007

If you’ve created a number of range names in an Excel 2007 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook [more…]

Splitting Data into Multiple Columns in Excel 2007

Use the Convert Text to Columns Wizard in Excel 2007 when you need to split combined data into separate columns, such as a first name and last name; or city, state, and zip code. This type of combined [more…]

Sorting Excel 2007 Data on Multiple Columns

If your Excel 2007 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [more…]

Inserting Subtotals in an Excel 2007 Worksheet

You can use Excel 2007’s Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

Modifying a Pivot Table's Summary Function in Excel 2007

By default, Excel 2007 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you assign as the Data Items in a pivot table. Some pivot tables, however, require the use [more…]

Protecting Cell Data in Excel 2007

After you finalize an Excel 2007 worksheet by reviewing formulas and proofing text, you should consider protecting the document to guard against any unplanned changes. Each cell in the worksheet can be [more…]

Using Paste Special in Excel 2007

Microsoft Office Excel 2007 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only [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…]

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

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 Insert Symbols and Special Characters in Excel 2007

Excel 2007 makes it easy to enter symbols, such as foreign currency indicators, as well as special characters, like trademark and copyright symbols, into Excel's cells. These symbols are available in the [more…]

How to Create a Two-Variable Data Table in Excel 2007

To create a two-variable data table to perform what-if analysis in Excel 2007, you enter two ranges of possible input values for the same formula: a range of values for the Row Input Cell in the Data Table [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 Create a Data List in Excel 2007

Sorting Excel 2007 Data on a Single Column

You may find data in an Excel 2007 worksheet easier to view if it’s sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [more…]