Excel 2019 Formulas & Functions

by M L Humphrey

Overview

A guide to formulas and functions in Microsoft Excel 2019 by the author of the popular Excel Essentials series. Includes new functions such as IFS and TEXTJOIN. Approximately a hundred functions covered in total, sixty in detail

Product Details

ISBN-13:	9781637440421
Publisher:	M.L. Humphrey
Publication date:	01/04/2021
Series:	Excel Essentials 2019 , #3
Pages:	200
Product dimensions:	7.50(w) x 9.25(h) x 0.50(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, Basic Math Calculations, Where To Find Functions, Best Practices, Copying Formulas, Top 10 Functions, Base Functions, Logical* Functions IF Functions, Lookup Functions, Statistical Functions, More Math Functions, Text Functions, Date & Time Functions, Other Functions, When Things Go Wrong, Conclusion, Appendix A: Cell Notation, Index Of Functions, About The Author