Excel Formulas And Functions Fd, 5e (For Dummies)

Bluttman, Ken

ISBN 10: 1119518253 / ISBN 13: 9781119518259

Published by For Dummies, 2018

About this Item

A copy that has been read, but remains in clean condition. All pages are intact, and the cover is intact (including dust cover, if applicable). The spine may show signs of wear. Pages can include limited notes and highlighting, and the copy can include "From the library of" labels or limited small stickers. Book may have a remainder mark or be a price cutter. Seller Inventory # CU-06-06-06-0459

Bibliographic Details

Title: Excel Formulas And Functions Fd, 5e (For ...

Publisher: For Dummies

Publication Date: 2018

Binding: Soft cover

Condition: Good

Edition: 5th or later Edition

About this title

Synopsis:

Put the power of Excel functions to work in your formulas There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions. With this book, you'll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel. Step-by-step instruction on Excel's 150 most useful functions Each function is illustrated by helpful, real-world examples 85 specialized functions are described in abbreviated form Includes Excel's must-know functions This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel's powerful built-in functions.

From the Back Cover:

• Understand how functions work within a formula
• Take full advantage of built-in Excel functions
• Evaluate and forecast investments and expenses

Put Excel's powerful functions to work for you!

Excel contains a whopping 400+ built-in functions. Now before your eyes glaze over, this book has sorted out the 150 most useful ones and provided step-by-step instructions on how to use each within a formula. Helpful, real-world examples show you how to take advantage of Excel's power for basic tasks, like determining your business's average sale, computing classroom grades, forecasting college expenses, determining the REAL cost of large credit card purchases, or just cataloging your recipe collection. Add Excel to your team!

Inside...

• Essential Excel functions
• Real-world examples using each function in a formula
• Using Excel to make decisions
• Saving time with function tools
• Calculating interest rates
• Applying significance tests
• Working with database functions