Excel 2007[c] The Missing Manual
![Excel 2007[c] The Missing Manual](/icons/blank_book.jpg "Excel 2007[c] The Missing Manual"){kind=icon}
- Excel 2007: The Missing Manual
- Table of Contents
- 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
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
- Key #1: Delight Your Customers with Speed and Quality
- When Companies Start Using Lean Six Sigma
- Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
- The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
- Six Things Managers Must Do: How to Support Lean Six Sigma