| | Copyright |
| | The Missing Credits |
| | Introduction |
| | Part I: Worksheet Basics |
| | | Chapter 1. Creating and Navigating Worksheets |
| | | Section 1.1. Creating a Basic Worksheet |
| | | Section 1.2. Editing Data |
| | | Section 1.3. Navigating in Excel |
| | | Section 1.4. Saving Files |
| | | Section 1.5. Opening Files |
| | | Chapter 2. Adding Information to Worksheets |
| | | Section 2.1. Adding Different Types of Data |
| | | Section 2.2. Quick Ways to Add Data |
| | | Chapter 3. Moving Data Around a Worksheet |
| | | Section 3.1. Selecting Cells |
| | | Section 3.2. Moving Cells Around |
| | | Section 3.3. Adding and Moving Columns or Rows |
| | | Chapter 4. Managing Worksheets and Workbooks |
| | | Section 4.1. Worksheets and Workbooks |
| | | Section 4.2. Find and Replace |
| | | Section 4.3. Spell Check |
| | | Chapter 5. Formatting Cells |
| | | Section 5.1. Formatting Cell Values |
| | | Section 5.2. Formatting Cell Appearance |
| | | Chapter 6. Smart Formatting Tricks |
| | | Section 6.1. The Format Painter |
| | | Section 6.2. Styles and Themes |
| | | Section 6.3. Conditional Formatting |
| | | Chapter 7. Viewing and Printing Worksheets |
| | | Section 7.1. Controlling Your View |
| | | Section 7.2. Printing |
| | | Section 7.3. Controlling Pagination |
| | Part II: Formulas and Functions |
| | | Chapter 8. Building Basic Formulas |
| | | Section 8.1. Creating a Basic Formula |
| | | Section 8.2. Formula Shortcuts |
| | | Section 8.3. Copying Formulas |
| | | Chapter 9. Math and Statistical Functions |
| | | Section 9.1. Rounding Numbers |
| | | Section 9.2. Groups of Numbers |
| | | Section 9.3. General Math Functions |
| | | Section 9.4. Trigonometry and Advanced Math |
| | | Section 9.5. Advanced Statistics |
| | | Chapter 10. Financial Functions |
| | | Section 10.1. The World of Finance |
| | | Section 10.2. Financial Functions |
| | | Section 10.3. Depreciation |
| | | Section 10.4. Other Financial Functions |
| | | Chapter 11. Manipulating Dates, Times, and Text |
| | | Section 11.1. Manipulating Text |
| | | Section 11.2. Manipulating Dates and Times |
| | | Section 11.3. Math with Dates and Times |
| | | Section 11.4. Date and Time Functions |
| | | Chapter 12. Lookup, Reference, and Information Functions |
| | | Section 12.1. The Basic Lookup |
| | | Section 12.2. Advanced Lookups |
| | | Section 12.3. Information Functions |
| | | Section 12.4. Tutorial: Quickly Generating Invoices from a Product Catalog |
| | | Chapter 13. Advanced Formula Writing and Troubleshooting |
| | | Section 13.1. Conditions in Formulas |
| | | Section 13.2. Descriptive Names for Cell References |
| | | Section 13.3. Variable Data Tables |
| | | Section 13.4. Controlling Recalculation |
| | | Section 13.5. Solving Formula Errors |
| | Part III: Organizing Worksheets |
| | | Chapter 14. Tables: List Management Made Easy |
| | | Section 14.1. The Basics of tablesTables |
| | | Section 14.2. Sorting and Filtering a Table |
| | | Section 14.3. Dealing with Duplicate Rows |
| | | Section 14.4. Performing Table Calculations |
| | | Chapter 15. Grouping and Outlining Data |
| | | Section 15.1. Basic Data Grouping |
| | | Section 15.2. Grouping Timesavers |
| | | Chapter 16. Templates |
| | | Section 16.1. Understanding Templates |
| | | Section 16.2. Creating a New Workbook from a Template |
| | | Section 16.3. Creating Templates |
| | Part IV: Charts and Graphics |
| | | Chapter 17. Creating Basic Charts |
| | | Section 17.1. Charting 101 |
| | | Section 17.2. Basic Tasks with Charts |
| | | Section 17.3. Practical Charting |
| | | Section 17.4. Chart Types |
| | | Chapter 18. Formatting and Perfecting Charts |
| | | Section 18.1. Chart Styles and Layouts |
| | | Section 18.2. Adding Chart Elements |
| | | Section 18.3. Selecting Chart Elements |
| | | Section 18.4. Formatting Chart Elements |
| | | Section 18.5. Improving Your Charts |
| | | Section 18.6. Advanced Charting |
| | | Chapter 19. Inserting Graphics |
| | | Section 19.1. Adding Pictures to a Worksheet |
| | | Section 19.2. Excel's Clip Art Library |
| | | Section 19.3. Drawing Shapes |
| | Part V: Advanced Data Analysis |
| | | Chapter 20. Scenarios and Goal Seeking |
| | | Section 20.1. Using Scenarios |
| | | Section 20.2. Using Goal Seek |
| | | Section 20.3. Solver |
| | | Chapter 21. Pivot Tables |
| | | Section 21.1. Summary Tables Revisited |
| | | Section 21.2. Building Pivot Tables |
| | | Section 21.3. Multi-Layered Pivot Tables |
| | | Section 21.4. Fine-Tuning Pivot Table Calculations |
| | | Section 21.5. Filtering a Pivot Table |
| | | Section 21.6. Pivot Charts |
| | Part VI: Sharing Data with the Rest of the World |
| | | Chapter 22. Protecting Your Workbooks |
| | | Section 22.1. Understanding Excel's Safeguards |
| | | Section 22.2. Data Validation |
| | | Section 22.3. Locked and Hidden Cells |
| | | Chapter 23. Worksheet Collaboration |
| | | Section 23.1. Preparing Your Workbook |
| | | Section 23.2. Adding Comments |
| | | Section 23.3. Tracking Changes |
| | | Section 23.4. Sharing Your Workbook |
| | | Chapter 24. Querying Databases and XML Files |
| | | Section 24.1. Excel and Databases |
| | | Section 24.2. Understanding XML |
| | | Section 24.3. Excel and XML |
| | | Chapter 25. Exchanging Data with Other Programs |
| | | Section 25.1. Sharing Information in Windows |
| | | Section 25.2. Embedding and Linking Objects |
| | | Section 25.3. Transferring Data |
| | | Chapter 26. Connecting Worksheets to the Web |
| | | Section 26.1. Putting Worksheets on the Web |
| | | Section 26.2. Performing Web Queries |
| | | Section 26.3. Using Hyperlinks |
| | Part VII: Programming Excel |
| | | Chapter 27. Automating Tasks with Macros |
| | | Section 27.1. Macros 101 |
| | | Section 27.2. The Macro Recorder |
| | | Section 27.3. Macro Security |
| | | Section 27.4. Creating Practical Macros |
| | | Chapter 28. Programming Spreadsheets with VBA |
| | | Section 28.1. The Visual Basic Editor |
| | | Section 28.2. Understanding Macro Code |
| | | Section 28.3. Exploring the VBA Language |
| | Part VIII: Appendix |
| | | Appendix A. Customizing the Quick Access Toolbar |
| | | Section A.1. The Quick Access Toolbar |
| | Colophon |
| | Index |