Excel 2010 formulas /

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.

Bibliographic Details
Main Author:	Walkenbach, John
Format:	eBook
Language:	English
Published:	Hoboken, NJ : Wiley Pub., [2010]
Series:	--For dummies. Wiley Online Library.
Subjects:	Microsoft Excel (Computer file) Microsoft Excel (Computer software) Business > Computer programs. Electronic spreadsheets. Business > Computer software. Spreadsheet software. Electronic books.
Online Access:	Connect to the full text of this electronic book

Table of Contents:

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