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, April 15


A guide to fifty of the most useful functions in Microsoft Excel. Includes a basic overview of how formulas and functions work in Excel as well as a separate chapter discussing each of the fifty featured functions. Written using Excel 2013.

Product Details

ISBN-13: 9781950902026
Publisher: M.L. Humphrey
Publication date: 05/09/2019
Series: Excel Essentials , #3
Pages: 148
Sales rank: 927,775
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

Customer Reviews