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

Excel 2010 Data

View:  
Sorted by:  

How to Use Paste Special in Excel 2010

Microsoft Excel 2010 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 the cell [more…]

How to Use the Clipboard Task Pane in Excel 2010

The Office Clipboard can store multiple cuts and copies from any Microsoft Office program running under Windows, not just Excel 2010. In Excel, this means that you can continue to paste stuff from the [more…]

How to Drag and Drop Data in Excel 2010

Drag-and-drop is a mouse technique that you can use in Excel 2010 to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving cell [more…]

Using Undo and Redo in Excel 2010

The Undo feature in Excel 2010 can quickly correct mistakes that you make in a worksheet. The Redo button lets you "undo the Undo." The Undo button appears next to the Save button on the Quick Access toolbar [more…]

Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010

Excel 2010's AutoCorrect feature already knows to automatically fix two initial capital letters in an entry, to capitalize the names of the days of the week, and to replace a set number of text entries [more…]

Moving Excel 2010 Data from Rows to Columns and Back Again

In Excel 2010, you can transpose worksheet data if you want to change the data structure so that the row headings appear as column headings, or vice versa. Excel 2010 provides the Transpose command in [more…]

How to Check Your Spelling in Excel 2010

Microsoft Excel 2010 includes a built-in spell checker that can catch and correct spelling errors and typos in your worksheets. Excel 2010's spell checker normally looks for misspellings only in the current [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…]

How to Create Custom AutoFilters for Text in Excel 2010

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method for more flexibility when filtering text [more…]

How to Create Custom AutoFilters for Numbers in Excel 2010

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method when you want to filter data based on a range [more…]

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

Listings:1-2526-5051-64
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

Dummies.com Sweepstakes

Win $500. Easy.