|Description Of The Book:|
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/.
Table of Contents:
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
If you are not happy with the product, you may return this within 15 days of receipt of the item with original packing and unused condition. Full refund or store credit will be issued against genuine returns.
We make sure all products sold by us are meeting the quality and does not have defects.
Any product found defective will be replaced free of cost.
We make sure that all products listed here are of the best quality available for that product/ price range.
We do not sell fake brands, cheap imitations or factory seconds.
All products are first quality products from the respective manufacturers.
Be the first to review this item.
To review this item, Please Sign In