Microsoft Excel functions quick reference [electronic resource] : for high-quality data analysis, dashboards, and more / Mandeep Mehta.

Intro
Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: What Is an Excel Function?
What Is an Excel Function?
How to Use Excel Functions
Types of Excel Functions
Categories of Excel Functions
Summary
Chapter 2: Text Functions
LEFT Function
Syntax
Example
RIGHT Function
Syntax
Example
MID Function
Syntax
Example
UPPER Function
Syntax
Example
LOWER Function
Syntax
Example
PROPER Function
Syntax
Example
TRIM Function
Syntax
Example

LEN Function
Syntax
Example
FIND Function
Syntax
Example
SEARCH Function
Syntax
Example
CONCATENATE/ & Function
Syntax
Example
VALUE Function
Syntax
Example
TEXT Function
Syntax
Example
EXACT Function
Syntax
Example
REPLACE Function
Syntax
Example
SUBSTITUTE Function
Syntax
Examples
REPT Function
Syntax
Example
T Function
Syntax
Example
TEXTJOIN Function
Syntax
Example
Summary
Chapter 3: Date Functions
TODAY Function
Syntax
Example
DAY Function
Syntax
Example

MONTH Function
Syntax
Example
YEAR Function
Syntax
Example
EDATE Function
Syntax
Example
EOMONTH Function
Syntax
Example
WEEKDAY Function
Syntax
Example
WEEKNUM Function
Syntax
Example
DATE Function
Syntax
Example
DATEVALUE Function
Syntax
Example
WORKDAY Function
Syntax
Example
NETWORKDAYS Function
Syntax
Example
DATEDIF Function
Syntax
Example
Summary
Chapter 4: Time Functions
NOW Function
Syntax
Example
HOUR Function
Syntax
Example
MINUTE Function
Syntax
Example

SECOND Function
Syntax
Example
TIME Function
Syntax
Example
TIMEVALUE Function
Syntax
Example
Summary
Chapter 5: Named Ranges and Excel Tables
Named Ranges
Advantages of Named Ranges
Create a Named Range
Rules for Creating Names
Benefits of Named Ranges
Excel Tables
Benefits of Using Excel Tables
Creating a Table
Styling a Table
Renaming a Table
Adding a Reference to Another Table
Adding a Total Row to the Table
Summary
Chapter 6: Lookup & Reference Functions
VLOOKUP Function
Limitations of VLOOKUP
Syntax

Possible Causes of Value Not Found by VLOOKUP
Example
HLOOKUP Function
Syntax
Example
MATCH Function
Syntax
Example
INDEX Function
Syntax
Example
CHOOSE Function
Syntax
Example
FORMULATEXT Function
Syntax
Example
ADDRESS Function
Syntax
Note About Reference Style
A1 Reference Style
R1C1 Reference Style
Example
COLUMN Function
Syntax
Example
COLUMNS Function
Syntax
Example
ROW Function
Syntax
Example
ROWS Function
Syntax
Example
INDIRECT Function
Syntax
Example