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

 

 

Table of Contents

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 and Applications.

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.