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.
About the Author
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