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

View first chapter and Table of Contents – FREE!

Excel Functions & Formulas in easy steps shows you how to use the power of Excel functions and formulas to take full advantage of this popular spreadsheet application. Learn how to:

•  Save time by utilizing Excel functions to carry out often-used operations, for error checking and tracing cells.
•  Build powerful spreadsheets using the features of Excel formulas.
•  Explore all the categories of Excel functions including financial, logical, mathematical, lookup and other data-related functions.
•  Review business-oriented scenarios and examples of functions in each of the groups.
• Create your own simple macros, and more.

Covering all recent versions of Excel including Excel in Office 365, this book will guide you through a myriad of Excel functions and formulas – clearly, concisely and in easy steps!

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.

Table of Contents

• Values and Formulas
• Managing Formulas
• Functions
• 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