Excel 2007 Data

Sorted by:  

Cutting, Copying, and Pasting in Excel 2007

You can use the Cut, Copy, and Paste commands to move or copy information in an Office Excel 2007 worksheet. These commands use the Office Clipboard as a kind of electronic halfway house where the information [more…]

Filtering Numbers in an Excel 2007 Table

If you’re working with a large table of data in Excel 2007, you can apply number filters to columns that contain values to temporarily hide unwanted records. Excel provides several options for filtering [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…]

Creating Custom AutoFilters for Text in Excel 2007

Use the Custom AutoFilter dialog box in Excel 2007 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…]

Annotating with Text Boxes in Excel 2007

Text boxes in Excel 2007 are graphical boxes that you can use to add explanatory text or commentary to a worksheet or chart. Text boxes can be positioned wherever you like and can be formatted to match [more…]

Basic Data Editing in Excel 2007

When entering vast quantities of data in Microsoft Office Excel 2007, it’s easy for typos to creep into your work. How you correct mistakes in Excel 2007 depends upon whether you notice the error before [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…]

Excel 2007 Data Analysis For Dummies Cheat Sheet

Excel 2007 has great data analysis tools. You can create any statistic you want; just make sure that you know what the statistic means. For that, you need to know the statistical measures available, the [more…]

Adding a Data Table to an Excel 2007 Chart

Add a data table to a chart so you can easily see both the graphical chart data and the raw numeric data that created the chart. Adding a data table to an Excel 2007 chart is very easy, and this video [more…]

How to Create a Data List in Excel 2007

Creating a data list, or Excel table, can help you store a large amount of data consistently, as well as give you the ability to easily read, sort, and filter that information. This video tutorial shows [more…]

How to Create a Pivot Table in Excel 2007


Sign Up for RSS Feeds

Computers & Software
Win $500. Enter Now.

Inside Dummies.com