Synopses & Reviews
Easy steps for creating spreadsheets you can really use
...for great results
- 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
introduction with standard headings
* This concise reference offers readers step-by-step instructions for tackling key tasks in Excel, the industry-standard spreadsheet software
* An unbeatable bargain-priced reference for anyone who needs to tackle Excel fundamentals such as entering data, creating formulas, formatting worksheets, sorting and filtering data, generating charts, and printing
* Provides readers with Just the Steps that are essential to accomplishing specific tasks and achieving competency in Excel
* The new landscape layout offers an easy-to-follow, two-column design with numbered steps listed in the left column and visual elements presented in the right column
About the Author
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.
Table of Contents
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.