Excel 2007 Data

View:  
Sorted by:  

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

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

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

Filtering an Excel 2007 Pivot Chart

Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show [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…]

Naming a Cell or Range in Excel 2007

Assign a descriptive name to a cell or range in Excel 2007 to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of [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…]

Using Excel 2007’s Goal Seek Feature

The Goal Seek feature in Excel 2007 is a what-if analysis tool that enables you to find the input values needed to achieve a goal or objective. To use Goal Seek, you select the cell containing the formula [more…]

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

Inserting Cells, Rows, or Columns in Excel 2007

If you need to add new data within an existing Microsoft Office Excel 2007 worksheet, you can insert new cells, columns, or rows rather than going through all the trouble of moving and rearranging several [more…]

Creating a Scenario Summary Report in Excel 2007

After using Scenario Manager to add scenarios to a table in a worksheet, you can have Excel 2007 produce a summary report. This report displays the changing and resulting values not only for all the scenarios [more…]

Selecting Cells in Excel 2007

Before you can enter your worksheet data in Microsoft Office Excel 2007, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [more…]

Listings:1-2526-5051-65
Advertisement

Sign Up for RSS Feeds

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

Inside Dummies.com