Furnishes answers to frequently asked questions about Excel 2010, encompassing information on building workbook files; adding, copying, and deleting worksheets; entering and editing data; creating formulas and functions; and formatting spreadsheets.
;Front Matter — Introduction — Basic Information.
Excel in a Nutshell — Basic Facts about Formulas — Working with Names — Using Functions in Your Formulas.
Introducing Worksheet Functions — Manipulating Text — Working with Dates and Times — Counting and Summing Techniques — Using Lookup Functions — Tables and Worksheet Databases — Miscellaneous Calculations — Financial Formulas.
Borrowing and Investing Formulas — Discounting and Depreciation Formulas — Financial Schedules — Array Formulas.
Introducing Arrays — Performing Magic with Array Formulas — Miscellaneous Formula Techniques.
Intentional Circular References — Charting Techniques — Pivot Tables — Conditional Formatting and Data Validation — Creating Megaformulas — Tools and Methods for Debugging Formulas — Developing Custom Worksheet Functions.
Introducing VBA — Function Procedure Basics — VBA Programming Concepts — VBA Custom Function Examples — Appendixes.
Appendix A: Excel Function Reference — Appendix B: Using Custom Number Formats — Appendix C: Additional Excel Resources — Appendix D: What’s on the CD-ROM? — Index — Wiley Publishing, Inc.
End-User License Agreement — Power Utility Pak v7.