Special Edition Using Microsoft Excel 2002

There is a focus on applying real-world techniques to solve everyday business problems in this edition. It will provide the most extensive coverage ever found in one book on Microsoft Excel's functions, as well as professional modeling, charting, and formula techniques. No other Excel book on the market provides as much essential intermediate to advanced-level coverage.

Topics covered will include:

• Building Charts with Excel
• Professional Charting techniques
• Using Formulas and Functions
• Using PivotTables & PivotCharts
• Creating Gantt Charts
• Combining Excel with Other Office Applications

Downloads

SEExcel.exe (4.05 MB)

Tips

If you want readers to understand the overall content of an Excel worksheet, see what information is being stored, and go right to the bottom line, make column headings and titles stand out through use of boldfacing or by applying a dynamic font, and draw attention to the bottom line—totals and the results of important formulas.

If you're using Excel to create a fill-in form, using patterns in empty cells can tell the user not to use those cells, or create a visually interesting separation between parts of the form.

You can add a left and right bracket around any time or date code to make Excel show elapsed time. For example, if cell A1 contains 8/12/2001 10:15 and cell A2 contains 8/13/2001 9:42, and cell A3 contains =A2-A1, formatting cell A3 with [h]:mm:ss shows you how many hours, minutes, and seconds elapsed between the two dates.

In Excel, you can create subfolder(s) within the Templates folder to house new templates. Templates stored in the Templates folder appear on the General tab in the New dialog box; templates stored in a subfolder of Templates are listed on a separate tab named for the subfolder.

The Shift+F8 technique is a little-known Excel technique but is great for selecting multiple ranges without having to hold the Ctrl key. To use it on noncontiguous ranges, select the first range using whatever technique you want, press Shift+F8—the word Add appears on the status bar—and then select additional ranges using the mouse (no Ctrl key). When finished, press Shift+F8 again, or press the Esc key.

Table of Contents

Introduction.

I. GETTING STARTED WITH EXCEL.

II. FORMATTING AND PRINTING EXCEL WORKSHEETS.

III. USING FORMULAS AND FUNCTIONS.

IV. USING EXCEL'S ANALYSIS TOOLS.

V. CREATING AND MODIFYING CHARTS.

VI. USING EXCEL TO MANAGE YOUR BUSINESS.

VII. INTEGRATING EXCEL WITH OTHER APPLICATIONS.