50 Useful 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 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:	M.L. Humphrey
Publication date:	05/09/2019
Series:	Excel Essentials , #3
Pages:	148
Product dimensions:	7.50(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