Excel 2007 Formulas (Mr. Spreadsheets Bookshelf) - page 1
- Table of Contents
- Table of Contents
- Back Cover
- Excel 2007 Formulas
- Introduction
- What You Should Know
- What You Should Have
- Conventions in This Book
- How This Book Is Organized
- How to Use This Book
- About the Companion CD-ROM
- About the Power Utility Pak Offer
- Reach Out
- Part I: Basic Information
- Chapter 1: Excel in a Nutshell
- The Object Model Concept
- The Workings of Workbooks
- The Excel User Interface
- The Excel Help System
- Cell Formatting
- Worksheet Formulas and Functions
- Objects on the Drawing Layer
- Customization in Excel
- Internet Features
- Analysis Tools
- Protection Options
- Chapter 2: Basic Facts about Formulas
- Using Operators in Formulas
- Calculating Formulas
- Cell and Range References
- Making an Exact Copy of a Formula
- Converting Formulas to Values
- Hiding Formulas
- Errors in Formulas
- Dealing with Circular References
- Goal Seeking
- Chapter 3: Working with Names
- A Name s Scope
- The Name Manager
- Shortcuts for Creating Cell and Range Names
- Creating Multisheet Names
- Working with Range and Cell Names
- How Excel Maintains Cell and Range Names
- Potential Problems with Names
- The Secret to Understanding Names
- Advanced Techniques That Use Names
- Part II: Using Functions in Your Formulas
- Chapter 4: Introducing Worksheet Functions
- Function Argument Types
- Ways to Enter a Function into a Formula
- Function Categories
- Chapter 5: Manipulating Text
- Text Functions
- Advanced Text Formulas
- Custom VBA Text Functions
- Chapter 6: Working with Dates and Times
- Date-Related Functions
- Time-Related Functions
- Chapter 7: Counting and Summing Techniques
- Counting or Summing Records in Databases and Pivot Tables
- Basic Counting Formulas
- Advanced Counting Formulas
- Summing Formulas
- Conditional Sums Using a Single Criterion
- Conditional Sums Using Multiple Criteria
- Chapter 8: Using Lookup Functions
- Functions Relevant to Lookups
- Basic Lookup Formulas
- Specialized Lookup Formulas
- Chapter 9: Tables and Worksheet Databases
- Working with Tables
- Using Advanced Filtering
- Specifying Advanced Filter Criteria
- Using Database Functions
- Inserting Subtotals
- Chapter 10: Miscellaneous Calculations
- Solving Right Triangles
- Area, Surface, Circumference, and Volume Calculations
- Solving Simultaneous Equations
- Rounding Numbers
Similar products
Excel 2007 Bible
John Walkenbach's Favorite Excel 2007 Tips and Tricks (Mr. Spreadsheet's Bookshelf)
Learn Excel 2007 Essential Skills with The Smart Method: Courseware tutorial for self-instruction to beginner and intermediate level
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques