Microsoft Excel 2000

Eliminating Repetitive Entries

Eliminate repetitive entry of the same text string when entering data in a list. Right-click in a blank cell and choose Pick From List to display a drop-down list of all previous entries for that column.

AutoCalculate

Use AutoCalculate to automatically total the values of highlighted cells and display that value in the status bar. Right-click on that value and you'll see a list of other operations, including Average, Count, and Max and Min. Select one and AutoCalculate will perform that operation instead.

Finding Values using AutoFilter

Use AutoFilter to find the top or bottom values in a numerical range. With AutoFilter activated (select Data/Filter/AutoFilter), choose Top 10 from the drop-down list in the column containing the values you wish to filter. Choose filter for the top or bottom values, the number of elements you want to see, and whether you want to filter by actual value or percentile.

Quickly Finding Files

Find the file you're looking for even if you can't remember the exact name. Use the File/Open dialog to select files based on Text or Property and Last Modified values. The search dialogs also include a drop-down button that displays the most recent searches executed.

Moving through the Workbook

Move between multiple sheets within a workbook by right-clicking on the VCR-style controls in the left-hand corner of the status bar. Excel displays a list of all sheets in the workbook; select the one you want and Excel takes you there.

Legend of Data Maps

To display the more informative full legend of a data map, rather than the default "compact" version, double-click to activate your map, right-click on the legend and select Edit. In the Edit Legend dialog, turn off the Use Compact Format option. Customize your legend text.

Maps Values

To display labels or data values for your Data Map, double-click to activate your map and select Tools/Labeler. To display the names of geographical features on your map (states, countries and so on), choose Map Feature Names. To display data values, select Values From. Hover your mouse over the map to see the labels.

Data in Reverse

To reverse the order of data in a chart, select the Categories in Reverse Order option in the Format Axis dialog. Double-click to activate your chart, select the axis you wish to reverse, click the right mouse button, and select Format Axis. (You can also double-click to activate your chart and double-click on the axis.) Choose the Scale tab and click the Values in Reverse Order box.

Joining Text and Data

Use the ampersand character (&) to join text and data. For example, if the value in cell D10 is 500 and you want another cell to display this as "500 dollars," choose that other cell and enter the formula +D10&" dollars" and press Enter.

Copying Page Setup

Copy all Page Setup properties-headers, footers, margins and so forth-from one worksheet to another. Activate the sheet that has the Page Setup properties you wish to copy. Choose File/Page Setup and click on OK in the dialog box. Activate the sheet to which you want to apply this setup. Choose Edit/Repeat Page Setup or press CTRL+Y.

PivotTable Data

After creating a PivotTable, double-click in any cell to create a list of all the data records behind that cell. The new list is added to your workbook on a separate sheet.

Return Home

 Services & Pricing | Our Classes
  Contact Us | Site Map