50 Useful Excel Functions

50 Useful Excel Functions

by M.L. Humphrey


View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Thursday, June 20


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 Useful Excel Functions, M.L. Humphrey walks you through fifty of the most useful functions within Excel from IF to VLOOKUP to CONCATENATE to TRIM to SUMIFS, COUNTIFS, and AVERAGEIFS.

By the time you finish this guide you will understand how formulas and functions work within Excel, have a solid grasp of how to use fifty of the top 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: 9781950902026
Publisher: Muffie Lynn Humphrey
Publication date: 05/09/2019
Series: Excel Essentials , #3
Pages: 148
Product dimensions: 7.52(w) x 9.25(h) x 0.32(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: SUM, PRODUCT, SUMPRODUCT, AVERAGE, AVERAGEA, MEDIAN, MODE, MODE.SNGL, MODE.MULT, MIN, MINA, MAX, MAXA, ROUND, ROUNDUP, ROUNDDOWN, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, UPPER, LOWER, PROPER, LEFT, RIGHT, MID, TRIM, CONCATENATE, TEXT, TODAY, NOW, IF, VLOOKUP, AND, OR, TRUE, FALSE, NA, RAND, RANDBETWEEN, RANK, RANK.EQ, RANK.AVG, SMALL, LARGE, Other Functions, Combining Functions, When Things Go Wrong, Conclusion, Appendix A: Cell Notation, Alphabetical Listing of Functions Covered

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews