50 More Excel Functions

by M L Humphrey

Overview

Microsoft Excel is an incredibly powerful tool. And even knowing just the basics of how to use it can help tremendously with your career and your finances.

But mastering Excel functions can help you take that basic understanding to an entirely new level.

In 50 More Excel Functions, M.L. Humphrey continues with the work started in 50 Useful Excel Functions and walks you through fifty more useful Excel functions.

By the time you finish this guide you will understand how formulas and functions work within Excel, have a solid grasp of fifty more Excel functions, know how to find other functions you might need, and know how to troubleshoot a function that isn't working for you.

So if you're ready to take your understanding of Excel to that next level, then this is the book for you.

Product Details

ISBN-13:	9781950902736
Publisher:	M.L. Humphrey
Publication date:	07/30/2019
Series:	Excel Essentials , #4
Pages:	156
Product dimensions:	7.50(w) x 9.25(h) x 0.44(d)

About the Author

M.L. Humphrey is a former stockbroker with a degree in Economics from Stanford and an MBA from Wharton who has spent close to twenty years as a regulator and consultant in the financial services industry.

Table of Contents

Introduction, How Formulas and Functions Work, Where To Find Functions, Formula and Function Best Practices, Copying Formulas, EXCEL FUNCTIONS: IFNA, IFERROR, NOT, HLOOKUP, TRANSPOSE, INDEX, MATCH, LEN, SEARCH, FIND, EXACT, CONVERT, ABS, MOD, QUOTIENT, TRUNC, INT, POWER, SQRT, PI, SQRTPI, EXP, LOG, LN, LOG10, FACT, COMBIN, COMBINA, PV, NPV, FORECAST, FREQUENCY, How Excel Handles Dates, DATE, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, WEEKDAY, WEEKNUM, ISOWEEKNUM, DAYS, DAYS360, EDATE, EOMONTH, NETWORKDAYS, NETWORKDAYS.INTL, WORKDAY, WORKDAY.INTL, Other Functions, Combining Functions, When Things Go Wrong, Conclusion, Appendix A: Cell Notation, Alphabetical Listing of Functions Covered