Excel 2003 Just the Steps For Dummies

Excel 2003 Just the Steps For Dummies

4.0 1
by Diane Koers
     
 
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

Overview

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

Product Details

ISBN-13:
9780764574887
Publisher:
Wiley
Publication date:
04/17/2006
Series:
For Dummies Series
Pages:
216
Product dimensions:
7.30(w) x 9.20(h) x 0.50(d)

Meet the Author

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988 that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics area of computing as well as providing training and support for Peachtree Accounting Software. Diane’s authoring experience includes over thirty books on topics such as PC Security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting, many of which have been translated into other languages such as Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and Little Joe, their Yorkshire Terrier.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Excel 2003 Just the Steps for Dummies 4 out of 5 based on 0 ratings. 1 reviews.
n99gk More than 1 year ago
Just received this book and Excel charts for dummies from the same place and the books seems to be better then what I though they would be. Could be a little faster in the mailing department since there isn't much snail mail these days but it's all good.