Excel 2003 Just the Steps for Dummies

Description

Easy steps for creating spreadsheets you can really use

  Simple steps...

  ...for great results

  Use AutoOutline
* Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet.
* AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail.
* To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.)
* To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings.
* To remove the AutoOutline, choose Data Group and outline Clear Outline.

  Get ready to
* Format cells and data
* Build formulas and functions
* Save time with Excel tools
* Add color graphics toyour spreadsheets
* Analyze your data
* Create charts and PivotTables

CONTENTS:

Introduction.

  Part I: Putting Excel to Work.

  
Chapter 1: Working with Excel Files.

  
Chapter 2: Entering Spreadsheet Data.

  
Chapter 3: Building Formulas.

  Part II: Sprucing Up Your Spreadsheet.

  
Chapter 4: Formatting Cells and Data.

  
Chapter 5: Adding Color and Graphics.

  
Chapter 6: Working with Workbooks.

  Part III: Viewing Data in Different Ways.

  
Chapter 7: Changing Worksheet Views.

  
Chapter 8: Sorting Data.

  
Chapter 9: Creating Charts with Excel.

  
Chapter 10: Printing Workbooks.

  Part IV: Analyzing Data with Excel.

  
Chapter 11: Working with Outlines.

  
Chapter 12: Filtering Data.

  
Chapter 13: Creating Pivot Tables.

  
Chapter 14: Building Simple Macros.

  
Chapter 15: Saving Time with Excel Tools.

  Part V: Practical Applications for Excel.

  
Chapter 16: Creating a Commission Calculator.

  
Chapter 17: Tracking Medical Expenses.

  
Chapter 18: Planning for Your Financial Future.

  
Chapter 19: Integrating Excel into Word.

  
Chapter 20: Blending Excel and PowerPoint.

  
Chapter 21: Using Excel with Access.

  Index.