Excel 2010 Data Analysis

View:  
Sorted by:  

Adding the Excel Camera Tool to the Quick Access Toolbar

The Excel Camera tool enables you to take a live picture of a range of cells that updates dynamically while the data in that range updates. Although Microsoft doesn't include the Excel Camera tool in the [more…]

Setting Up Your Baseline in Excel Sales Forecasting

You need to provide a solid baseline (history) in order for your Excel forecast functions to work accurately in Excel sales forecasting. This chart shows you some ways to arrange data for your baseline [more…]

The Analysis ToolPak in Excel Sales Forecasting

The Analysis ToolPak in Excel sales forecasting figures out what's going on with your data without your having to enter formulas. Excel's Analysis ToolPak has three useful tools for directly forecasting [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 One-Variable Data Table in Excel 2010

To create a one-variable data table to perform what-if analysis in Excel 2010, 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…]

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

To create a two-variable data table to perform what-if analysis in Excel 2010, 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 Built-in Add-In Programs in Excel 2010

Add-in programs are small modules that extend the power of Excel 2010 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three [more…]

How to Use Excel 2010's Goal Seek Feature

The Goal Seek feature in Excel 2010 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…]

How to Create a Scenario Summary Report in Excel 2010

After using Scenario Manager to add scenarios to a table in a worksheet, you can have Excel 2010 produce a summary report. This report displays not only the changing and resulting values for all the scenarios [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 Create and Format a Pivot Chart in Excel 2010

After you create a pivot table in Excel 2010, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [more…]

How to Evaluate Scenarios with Excel 2010's Scenario Manager

Excel 2010's Scenario Manager enables you to create and save sets of different input values that produce different calculated results as named scenarios [more…]

How to Show Trends Visually with Excel 2010's Sparklines

Excel 2010 introduced sparklines, a new type of information graphic that represents trends or variations in collected worksheet data. Sparklines are tiny graphs [more…]

How to Filter an Excel 2010 Pivot Chart

Just as you can filter an Excel 2010 pivot table to display a subset of data, you also can filter a pivot chart so that it shows just the information you want it to show. When you graph the data in an [more…]

How to Split Data into Multiple Columns in Excel 2010

Use the Convert Text to Columns Wizard in Excel 2010 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…]

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