Description
Book SynopsisThis condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates.
The
Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrate
Table of ContentsChapter 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
· IF
· IFS
· AND
· OR
· NOT
· IFERROR
· IFNA
· SWITCH
Chapter 8 – REFERENCE functions
· INDIRECT
· ADDRESS
· OFFSET
· ROW
· ROWS
· COLUMN
· COLUMNS
Chapter 9 – MATH functions
· ABS
· INT
· TRUNC
· ROUND
· ODD
· EVEN
· POWER
· PRODUCT
Chapter 10 – INFORMATION functions
· CELL
· ISBLANK
· ISERROR
· ISEVEN
· ISODD
· ISFORMULA
· ISLOGICAL
· ISNA
· ISNONTEXT
· ISNUMBER
· ISTEXT
· N
· TYPE
Chapter 11 – MEGA-Formula
· What is Mega formula?
· How to create a mega formula
· Examples
Chapter 12 – Array formula
· What is an array formula?
· Advantages and disadvantages
· Examples
Appendix A – Formula Reference ready reckoner
