102 Useful Excel 365 Functions

Introduction, Cell Notation and Copying Formulas, How Formulas and Functions Work, How To See a Formula, Basic Math Calculations, Where To Find Functions, When Things Go Wrong, A Warning and Best Practices, Excel Function Notation, Top Functions To Know, The SUM Function, The PRODUCT Function, The SUMPRODUCT Function, The AVERAGE and AVERAGEA Functions, The MEDIAN, MODE.SNGL, and MODE.MULT Functions, The FREQUENCY Function, The MIN and MINA Functions, The MAX and MAXA Functions, The ROUND, ROUNDUP, and ROUNDDOWN Functions, The COUNT, COUNTA, and COUNTBLANK Functions, The LARGE and SMALL Functions, The RANK.AVG and RANK.EQ Functions, The RAND and RANDBETWEEN Functions, The UPPER, LOWER, and PROPER Functions, The LEN Function, The LEFT, RIGHT, and MID Functions, The EXACT Function, The TEXT Function, The TODAY and NOW Functions, The YEAR, MONTH, DAY, HOUR, MINUTE and SECOND Functions, More on Dates In Excel, The COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, and MAXIFS Functions, The IF and IFS Functions, The XLOOKUP, VLOOKUP, and HLOOKUP Functions, The TRIM Function, The TEXTJOIN, CONCATENATE, and CONCAT Functions, The TRUE and FALSE Functions, The AND and OR Functions, The IFNA and IFERROR Functions, The CONVERT Function, The NA Function, The INDEX and MATCH Functions, The SWITCH and CHOOSE Functions, Fast Thirty-Four Functions, Conclusion, Index, About the Author