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.
