Excel 2019 Functions: 70 Top Excel Functions Made Easy

by Nathan George

Overview

Leverage the Full Power of Excel Functions

Excel 2019 Functions provides a detailed walkthrough of 70 of the most useful Excel functions, including many tips to enable you to maximize the power of Excel through the use of functions.

This book provides a detailed description of each function, its arguments, and its use is demonstrated with fitting examples. Learn how to use functions like VLOOKUP, IFS, COUNTIFS, DATEDIF, NETWORKDAYS, FIND, NPV, SUMIFS etc. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.

Achieve More with Less Effort

Learn new functions introduced in Excel 2016 and 2019 like the IFS functions that make it easier to create powerful formulas much simpler syntax.

Excel 2019 Functions will be a great reference guide for you whether you're a beginner or already skilled with Excel. By the time you finish this guide, you will understand how functions work in Excel, how to find the right functions, and how to combine them in solving complex problems.

This book comes with downloadable Excel practice files for all examples. Hence, you can follow the tutorials without needing to create the examples from scratch in Excel. You can also copy the tried and tested formulas and use them in your own workbooks.

In this book, you'll learn how to:

• Find and enter functions in Excel.
• Use lookup and reference functions to find and reference values in your formulas.
• Use logical functions to execute conditional statements and calculations.
• Deploy IFS functions in place of convoluted nested functions for more efficient and robust formulas.
• Use a wide array of date and time functions to address all kinds of date calculations.
• Manipulate text strings with text functions.
• Carry out financial calculations with special financial functions.
• And much more...

Buy now to get started today!

Product Details

ISBN-13:	9781916211322
Publisher:	Gtech Publishing
Publication date:	08/25/2019
Series:	Excel 2019 Mastery , #3
Pages:	198
Product dimensions:	6.00(w) x 9.00(h) x 0.42(d)

Table of Contents

Introduction

Who Is This Book For?

How to Use This Book

Assumptions

Practice Files

Chapter 1: How to Enter a Formula

The Insert Function Dialog Box

Chapter 2: Lookup and Reference Functions

VLOOKUP Function

HLOOKUP Function

MATCH Function

CHOOSE Function

TRANSPOSE Function

ADDRESS function

FORMULATEXT Function

COLUMNS Function

ROWS Function

INDEX Function

Chapter 3: Logical Functions

IF Function

Nested IF Functions

Advanced IF Functions

IFS Function

SWITCH Function

IFERROR Function

AND Function

OR Function

Chapter 4: Math Functions

SUM Function

SUMIF Function

SUMIFS Function

AGGREGATE Function

MOD Function

RANDBETWEEN Function

ROUND Function

ROUNDUP Function

ROUNDDOWN Function

SQRT Function

Chapter 5: Statistical Functions

COUNT Function

COUNTIF Function

COUNTIFS Function

COUNTA Function

COUNTBLANK Function

AVERAGE Function

AVERAGEIF Function

AVERAGEIFS Function

MAX, MIN, MEDIAN Functions

MAXIFS, MINIFS Functions

Chapter 6: Date and Time Functions

Date Formats

DAY, MONTH, YEAR Functions

DATE Function

DATEDIF Function

DAYS Function

EDATE Function

DATEVALUE Function

NETWORKDAYS Function

NOW Function

TODAY Function

TIME Function

Chapter 7: Text Functions

FIND Function

FINDB

CONCAT Function

TEXTJOIN Function

TRIM Function

UPPER, LOWER Functions

LEN Function

MID Function

PROPER Function

LEFT, RIGHT Functions

LEFTB, RIGHTB Functions

Chapter 8: Financial Functions

Definitions

PV Function

FV Function

NPV Function

PMT Function

SLN Function

SYD Function

DB Function

DDB Function

Afterword: Getting More Help with Functions

Appendix: Keyboard Shortcuts (Excel for Windows)

Glossary

Other Books by Author