Excel 2010: The Missing Manual - page 1
- Excel: The Missing Manual
- Excel: The Missing Manual
- Table of Contents
- Copyright
- The Missing Credits
- About the Author
- About the Creative Team
- Acknowledgements
- The Missing Manual Series
- Introduction
- What Excel Is all About
- About This Book
- Safari-Enabled
- 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. Formatting Worksheets
- Section 4.1. Formatting Cell Values
- Section 4.2. Formatting Cell Appearance
- Section 4.3. Smart Ways to Apply Formatting
- Chapter 5. Managing Worksheets and Workbooks
- Section 5.1. Worksheets and Workbooks
- Section 5.2. Find and Replace
- Section 5.3. Spell Check
- Chapter 6. Viewing and Printing Worksheets
- Section 6.1. Controlling Your View
- Section 6.2. Printing
- Part II: Formulas and Functions
- Chapter 7. Building Basic Formulas
- Section 7.1. Creating a Basic Formula
- Section 7.2. Formula Shortcuts
- Section 7.3. Copying Formulas
- Chapter 8. Math and Statistical Functions
- Section 8.1. Rounding Numbers
- Section 8.2. Groups of Numbers
- Section 8.3. General Math Functions
- Section 8.4. Trigonometry and Advanced Math
- Section 8.5. Advanced Statistics
- Chapter 9. Financial Functions
- Section 9.1. The World of Finance
- Section 9.2. Financial Functions
- Section 9.3. Depreciation
- Section 9.4. Other Financial Functions
- Chapter 10. Manipulating Dates, Times, and Text
- Section 10.1. Manipulating Text
- Section 10.2. Manipulating Dates and Times
- Section 10.3. Math with Dates and Times
- Section 10.4. Date and Time Functions
- Section 10.5. Analysis ToolPak Date Functions
- Chapter 11. Lookup, Reference, and Information Functions
- Section 11.1. The Basic Lookup
- Section 11.2. Advanced Lookups
- Section 11.3. Information Functions
- Section 11.4. Tutorial: Quickly Generating Invoices from a Product Catalog
- Chapter 12. Advanced Formula Writing
- Section 12.1. Conditions in Formulas
- Section 12.2. Descriptive Names for Cell References
- Section 12.3. Variable Data Tables
- Section 12.4. Controlling Recalculation
- Section 12.5. Solving Formula Errors
- Part III: Organizing Worksheets
- Chapter 13. Data Lists
- Section 13.1. The Basics of Data Lists
- Section 13.2. The Data Form
- Section 13.3. Sorting and Filtering a List
- Section 13.4. Performing List Calculations
- Chapter 14. Grouping and Outlining Data
- Section 14.1. Basic Data Grouping
- Section 14.2. Grouping Timesavers
