Microsoft Excel Functions Quick Reference: For High-quality Data Analysis, Dashboards, and More

Chapter 1 - What is an Excel function?

·         Excel formula definition

·         How to use an Excel formula

·         Different types of Excel functions

Chapter 2 -TEXT functions

·         LEFT

·         RIGHT

·         MID

·         UPPER

·         LOWER

·         PROPER

·         TRIM

·         LEN

·         FIND

·         SEARCH

·         CONCATENATE/&

·         VALUE

·         TEXT

·         EXACT

·         REPLACE

·         SUBSTITUTE

Chapter 3 - DATE functions

·         DAY

·         MONTH

·         YEAR

·         DATE

·         EDATE

·         EOMONTH

·         WEEKDAY

·         WEEKNUM

·         DATEVALUE

·         NETWORKDAYS

·         DATEDIF

Chapter 4 - TIME functions

·         NOW

·         HOUR

·         SECOND

·         TIMEVALUE

Chapter 5 - LOOKUP functions

·         VLOOKUP

·         HLOOKUP

·         MATCH

·         INDEX

·         CHOOSE 

Chapter 6 - AGGREGATE functions

·         SUM

·         SUMIF

·         SUMIFS

·         SUMPRODUCT

·         SUBTOTAL

·         COUNT

·         COUNTIF

·         COUNTIFS

·         AVERAGE

·         AVERAGEIF

·         AVERAGEIFS

·         AGGREGATE

Chapter 7 - LOGICAL functions

·