Excel 2007 Just the Steps For Dummies

Completely updated to reflect the many changes in the latest release of Excel, this helpful book presents readers with concise instructions for carrying out common Excel 2007 tasks An easy-to-navigate design features a two-column layout and is packed with step-by-step directions and illustrations that incorporate the notable changes to Excel 2007 Readers can pick the task, find it fast, and get it done quickly, all while gaining a clear understanding of Excel 2007 enhancements, such as a new user interface, improved charting and PivotTable capabilities, and better data exchange with XML

* Completely updated to reflect the many changes in the latestrelease of Excel, this helpful book presents readers with conciseinstructions for carrying out common Excel 2007 tasks* An easy-to-navigate design features a two-column layout and ispacked with step-by-step directions and illustrations thatincorporate the notable changes to Excel 2007* Readers can pick the task, find it fast, and get it donequickly, all while gaining a clear understanding of Excel 2007enhancements, such as a new user interface, improved charting andPivotTable capabilities, and better data exchange with XML

Introduction.Part I: Putting Excel to Work.Chapter 1: Working with Excel Files.Chapter 2: Entering Spreadsheet Data.Chapter 3: Building Formulas.Chapter 4: Protecting Excel Data.Part II: Sprucing Up Your Spreadsheets.Chapter 5: Formatting Cells.Chapter 6: Applying Additional Formatting Options.Chapter 7: Designing with Graphics.Chapter 8: Managing Workbooks.Part III: Viewing Data in Different Ways.Chapter 9: Changing Worksheet Views.Chapter 10: Sorting Data.Chapter 11: Creating Charts.Chapter 12: Printing Workbooks.Part IV: Analyzing Data with Excel.Chapter 13: Working with Outlines.Chapter 14: Filtering Data.Chapter 15: Creating PivotTables.Chapter 16: Building Simple Macros.Chapter 17: Saving Time with Excel Tools.Part V: Utilizing Excel with Other People andApplications.Chapter 18: Collaborating in Excel.Chapter 19: Integrating Excel into Word.Chapter 20: Blending Excel and PowerPoint.Chapter 21: Using Excel with Access.Part VI: Practical Applications for Excel.Chapter 22: Designing an Organization Chart.Chapter 23: Creating a Commission Calculator.Chapter 24: Tracking Medical Expenses.Chapter 25: Planning for Your Financial Future.Index.