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: Using Excel Functions.
Chapter 5: Protecting Excel Data.
Part II: Sprucing Up Your Spreadsheets.
Chapter 6: Formatting Cells.
Chapter 7: Applying Additional Formatting Options.
Chapter 8: Designing with Graphics.
Chapter 9: Managing Workbooks.
Part III: Viewing Data in Different Ways.
Chapter 10: Changing Worksheet Views.
Chapter 11: Sorting Data.
Chapter 12: Creating Charts.
Chapter 13: Printing Workbooks.
Chapter 14: Saving Time with Excel Tools.
Part IV: Analyzing Data with Excel.
Chapter 15: Working with Outlines.
Chapter 16: Filtering Data.
Chapter 17: Creating PivotTables.
Chapter 18: Building Simple Macros.
Part V: Utilizing Excel with Other People and Applications.
Chapter 19: Collaborating in Excel.
Chapter 20: Integrating Excel into Word.
Chapter 21: Blending Excel and PowerPoint.
Chapter 22: Using Excel with Access.
Part VI: Practical Applications for Excel.
Chapter 23: Creating a Commission Calculator.
Chapter 24: Tracking Medical Expenses.
Index.