Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program's functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient.Microsoft Excel Functions Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format.

Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and lookup and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions.

This book's extensive examples make it an excellent tutorial for all Excel users who want to understand, create, and apply formulas. Intermediate and advanced users will find Microsoft Excel Functions & Formulas an excellent reference to many of the program's advanced formulas and functions.
Bernd Held is one of the leading authorities on Microsoft Office software in Germany, especially Microsoft Excel. The author of more than 40 books and 800 articles and reviews for various publications, he is also a professional consultant specializing in training and customized solutions for a variety of businesses. For the past eight years, Microsoft has recognized him as an MVP (Most Valuable Professional). He lives in Germany with his wife, son, and daughter. His web site is http://held-office.de/.

Chapter 1: Formulas in Excel

Chapter 2: Logical Functions

Chapter 3: Text Functions

Chapter 4: Data and Time Functions

Chapter 5: Basic Statistical Function

Chapter 6: Mathematical Functions

Chapter 7: Basic Financial Functions

Chapter 8: Database Functions

Chapter 9: Lookup and Reference Functions

Chapter 10: Conditional Formatting with Formulas

Chapter 11: Working with Array Formulas

Chapter 12: Special Solutions with Formulas

Chapter 13: User-defined Functions

Chapter 14: Examples

Index