A comprehensive guide to Excel functions and formulas that will help you to build more powerful spreadsheets and make the most of Excel once you've mastered the basics.
(+VAT where applicable)
Publication: August 2020
Information about In Easy Steps ebooks and PDFs, terms and conditions - please read before purchasing
About the book
Excel Functions & Formulas in easy steps shows you how to get the most of Excel, once you’ve mastered the basics. You will learn how to build more powerful spreadsheets using the features of Excel formulas, and explore all the categories of Excel functions including financial, logical, mathematical, and data related functions. Then, review business-oriented scenarios and examples of functions in each of the groups, and consider the additional facilities offered through user-defined functions.
The topics covered apply to all recent versions of Microsoft Excel.
Table of Contents
- Values and Formulas
- Managing Formulas
- Math & Trig and Logical
- Date & Time and Text
- Financial and Statistical
- Lookup & Reference and Information
- Database and Engineering
- Compatibility, Cube and Web
- User Defined Add-ins and Macros
- Support and References
About the author
Michael Price is an accomplished author, IT journalist and systems consultant with a wide experience of computing systems ranging from mainframes to personal computers. He's also a successful author with several best-selling In Easy Steps books to his credit, including earlier editions of Excel in easy steps.