Excel 2010 Data

View:  
Sorted by:  

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

Using Excel 2010's Cell Comment Feature

You can add a cell comment — an electronic version of a sticky note — to any cell in an Excel 2010 worksheet. Comments allow those reviewing a worksheet to provide instruction, for example, noting how [more…]

How to Apply a Table Style to an Excel 2010 Table

In Excel 2010, you can apply a predefined table format to a cell range. The Format as Table feature displays an extensive Table gallery with formatting thumbnails divided into three sections — Light, Medium [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…]

Speeding Data Entry with Excel 2010's AutoFill Feature

Use Excel 2010's AutoFill feature to quickly create a series of entries based on the data you enter in one or two cells. AutoFill works with days of the week, months of the year, and yearly quarters. If [more…]

Using Advanced Table Filtering in Excel 2010

With Excel 2010's advanced filtering methods, you can specify complex filtering criteria and designate a specific area of your worksheet to manage your criteria selections when filtering table data. Use [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…]

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