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

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

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

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

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

Playing What-If with Excel 2007’s Data Tables

With Excel 2007’s data tables, you enter a series of possible values that Excel plugs into a single formula so you can perform what-if analysis on the data. What-if analysis enables you to explore the [more…]

Evaluating Scenarios with Excel 2007’s Scenario Manager

Excel 2007’s Scenario Manager lets you create and save sets of different input values that produce different calculated results as named scenarios (such as Best Case, Worst Case, and Most Likely Case). [more…]

How to Add Data Visualizations in Excel 2007

In Excel 2007, you can instantly apply data visualizations to cells by using data bars, color scales, and icon sets that help you quickly understand data variations in your tables. Excel provides several [more…]

How to Use Excel 2007’s Research Task Pane

Excel 2007 includes the Research task pane that you can use to search for information from online resources, such as the Encarta Dictionary, Thesaurus, MSN Money Stock Quotes, and the Encarta Encyclopedia [more…]

Using Boolean Expressions in Data Analysis with Excel 2007

Excel 2007 data analysis tools include Boolean expressions, of course. To construct a Boolean expression, such as when you filter criteria, use a comparison operator and then a value in the comparison [more…]

Excel 2007's Quick Data Analysis from the Status Bar

Excel 2007 can tell you quite a bit about a selected range of cells just from the status bar. When you select cells that have data in them, Excel's status bar can tell you some useful information about [more…]

Statistics Terms to Know when Using Excel 2007 Data Analysis Tools

With the data analysis tools available in Excel 2007, you can create spreadsheets that show the details of any statistic you can create a formula to find — and you can find any number. It helps to know [more…]

Sign Up for RSS Feeds

Computers & Software