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

By Mandeep Mehta

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

- TODAY

- DAY

- MONTH

- YEAR

- DATE

- EDATE

- EOMONTH

- WEEKDAY

- WEEKNUM

- DATEVALUE

- NETWORKDAYS

- DATEDIF

Chapter 4 - TIME functions

- NOW

- HOUR

- MINUTE

- 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

-  

• Format: Paperback
• Language: English
• ISBN: 1484266129
• ISBN13: 9781484266120
• Release Date: January 2021
• Publisher: Apress
• Length: 255 Pages
• Weight: 0.90 lbs.
• Dimensions: 0.6" x 6.1" x 9.2"