101 Most Popular Excel Formulas
Book Preface
Table of Contents
COPYRIGHT
SPECIAL SALES
MYEXCELONLINE ACADEMY COURSE
CONNECT WITH US
AUTHOR BIOGRAPHY
HOW TO USE THIS E-BOOK
Formulas VS Functions
FORMULA TIPS
The Function Wizard
F9 to Evaluate a Formula
Named Ranges
Absolute & Relative References
Evaluate Formulas Step By Step
Highlight All Excel Formula Cells
How to Convert Formulas to Values
How to Show & Hide Formulas in Excel
Jump to a Cell Reference in a Formula
LOOKUP FUNCTIONS
ADDRESS
CHOOSE
HLOOKUP
HYPERLINK
INDEX
INDEX-MATCH
INDIRECT
LOOKUP
MATCH
VLOOKUP
LOGICAL FUNCTIONS
AND
IF
IFERROR
OR
MATH FUNCTIONS
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
MOD
PERCENTAGE
RAND
RANDBETWEEN
ROUND
SUBTOTAL
SUMIF
SUMIFS
SUMPRODUCT
STATISTICAL FUNCTIONS
AVERAGE
LARGE
MAX
MEDIAN
MIN
SMALL
DATE & TIME FUNCTIONS
DATE
DATEDIF
DATEVALUE
DAY
DAY360
DAYS
ENDOFMONTH
HOUR
MONTH
NETWORKDAYS
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
TEXT FUNCTIONS
CLEAN
CONCATENATE
EXACT
FIND
LEFT
LEN
LOWER
MID
PROPER
REPLACE
RIGHT
SEARCH
SUBSTITUTE
TRIM
UPPER
VALUE
ISBLANK
ISERROR
ISNUMBER
ISTEXT
TYPE
OTHER FUNCTIONS
FV – Compound Interest
FV – Monthly Investment
EXCEL 2019
CONCAT
IFS
MAXIFS
MINIFS
SWITCH
TEXTJOIN
OFFICE 365 (AS OF SEPTEMBER 2018)
FILTER
RANDARRAY
SEQUENCE
SORT
SORTBY
UNIQUE
ADVANCED FORMULAS
3D Formulas
ARRAY Formulas
BETWEEN
Extract First Name from Full Name
Extract Last Name – REPLACE Function
GETPIVOTDATA
IF Combined With The AND Function
INDEX-MATCH 2 Criteria with Validation
Match Two Lists With MATCH Function
Named Ranges with VLOOKUP Function
REPT
Sum a Range Using the INDEX Function
SUMPRODUCT: Sum Multiple Criteria
SUMPRODUCT: Sum the Top 3 Sales
TIME – Get Elapsed Time
TRANSPOSE
VLOOKUP Approximate Match
VLOOKUP with a Drop Down List
VLOOKUP Multiple Columns
VLOOKUP with Multiple Criteria
Download Ebook | Read Now | File Type | Upload Date |
---|---|---|---|
Download here
|
Read Now | Epub | October 23, 2021 |
How to Read and Open File Type for PC ?