Includes over 250 Excel worksheet examples, ready to use files, and video tutorials. Numerous step-by-step instructions and actual, ready to use Excel screenshots of the input and output from the formulas.
1: Formulas in Excel
2: Logical Functions
3: Text Functions
4: Date and Time Functions
5: Basic Statistical Functions
6: Mathematical Functions
7: Basic Financial Functions.
8: Database Functions
9: Lookup and Reference Functions
10: Conditional Formatting with Formulas
11: Working with Array Formulas
12: Special Solutions with Formulas
13: User-defined Functions
14: Examples
Appendix: Excel Interface Guide
Index
Moriarty Brian :
Brian Moriarty is a Microsoft Office Specialist Master who has been
automating Office products for more than 20 years; he also teaches
employee groups at the corporate level.
Held Bernd :
Bernd Held is the author of more than 40 books and Microsoft has
recognized him as an MVP (Most Valuable Professional).
Richardson Theodor :
Theodor Richardson is the Associate Vice Chancellor for Academic
Affairs at South College and has written several books in areas of
computer science.
Ask a Question About this Product More... |