Excel 2019 Formulas & Functions

· Excel Essentials 2019 Book 3 · M.L. Humphrey
3.0
1 review
Ebook
199
Pages
Eligible

About this ebook

In this final book of the Excel Essentials 2019 series, Excel 2019 Formulas and Functions, M.L. Humphrey takes a deeper dive into how formulas and functions work in Microsoft Excel.

Learn the difference between formulas and functions and how to find any function you need in Excel as well as how to troubleshoot common issues with formulas and functions.

Approximately sixty functions are covered in detail, including functions like IFS and TEXTJOIN that were added for Excel 2019. In total, over a hundred functions are covered in this book.

By the time you’re done you should be comfortable working with formulas and functions in Excel, know how to use the most common functions, and know how to find others when you need them.

keywords: microsoft excel 2019, formulas, functions, TEXTJOIN, IFS, TRIM, CONVERT, ROUND, RANDBETWEEN, VLOOKUP, SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS, MAXIFS, SWITCH, CHOOSE, TRANSPOSE, INDEX, MATCH, MEDIAN, MODE.MULT, FORECAST.LINEAR, FREQUENCY, SUMPRODUCT, FACT, COMBIN, WEEKDAY, WEEKNUM, NETWORKDAYS.INTL, troubleshooting errors, copying formulas, cell notation

Ratings and reviews

3.0
1 review

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.

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets
Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
Laptops and computers
You can listen to audiobooks purchased on Google Play using your computer's web browser.
eReaders and other devices
To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.