102 Microsoft Excel Formulas & Functions Cheat Sheet [Free Download] - Ebooks Amazon Free

Trang

22 April, 2020

102 Microsoft Excel Formulas & Functions Cheat Sheet [Free Download]

102 Microsoft Excel Formulas & Functions Cheat Sheet [Free Download]

Do you use Excel Formulas daily at your job? Download my Excel workbook where I have listed 100+ common Microsoft Excel Formulas and Functions Cheat Sheet for your daily use.
Without Formulas, Microsoft Excel is just like a word processor. These are Excel formulas and functions that give life to the world’s most popular spreadsheet program.
People say if you learn 20-25 formulas, you can master Microsoft Excel. It is true in some sense. But I say at least learn these 102 Excel formulas; you will be a superuser of Excel.
Excel Formulas and Functions Cheat Sheet free download

Free download the Cheat Sheet

To make you able to use the workbook in your daily Excel, I have made the functions browse-able from one worksheet.

Function Categories in the Cheat Sheet (Worksheet)

I have categorized the Excel functions into 10 broad categories:

IS FUNCTIONS

Under IS FUNCTIONS, you will find the cheat sheet of the following functions:
  • ISBLANK
  • ISERR
  • ISERROR
  • ISEVEN
  • ISODD
  • ISFORMULA
  • ISLOGICAL
  • ISNA
  • ISNUMBER
  • ISREF
  • ISTEXT
  • ISNONTEXT

CONDITIONAL FUNCTIONS

Under CONDITIONAL, you will find a cheat sheet of the following functions:
  • AVERAGEIF
  • SUMIF
  • COUNTIF
  • AVERAGEIFS
  • SUMIFS
  • COUNTIFS
  • IF
  • IFERROR
  • IFNA

MATHEMATICAL FUNCTIONS

Under MATHEMATICAL, you will find the cheat sheet of the following functions:
  • SUM
  • AVERAGE
  • AVERAGEA
  • COUNT
  • COUNTA
  • MEDIAN
  • SUMPRODUCT
  • SUMSQ
  • COUNTBLANK
  • EVEN
  • ODD
  • INT
  • LARGE
  • SMALL
  • MAX
  • MAXA
  • MIN
  • MINA
  • MOD
  • RAND
  • RANDBETWEEN
  • SQRT
  • SUBTOTAL

FIND & SEARCH FUNCTIONS

Under FIND & SEARCH, you will find the cheat sheet of the following functions:
  • FIND
  • SEARCH
  • SUBSTITUTE
  • REPLACE

LOOKUP FUNCTIONS

Under LOOKUP, you will find the cheat sheet of the following functions:
  • MATCH
  • LOOKUP
  • HLOOKUP
  • VLOOKUP

REFERENCE FUNCTIONS

Under REFERENCE, you will find the cheat sheet of the following functions:
  • ADDRESS
  • CHOOSE
  • INDEX
  • INDIRECT
  • OFFSET

DATE & TIME FUNCTIONS

Under DATE & TIME, you will find the cheat sheet of the following functions:
  • DATE
  • DATEVALUE
  • TIME
  • TIMEVALUE
  • NOW
  • TODAY
  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND
  • WEEKDAY
  • DAYS
  • NETWORKDAYS
  • WORKDAY

MISC. FUNCTIONS

Under MISC., you will find the cheat sheet of the following functions:
  • AREAS
  • CHAR
  • CODE
  • CLEAN
  • TRIM
  • LEN
  • COLUMN
  • ROW
  • EXACT
  • FORMULATEXT
  • LEFT
  • RIGHT
  • MID
  • LOWER
  • PROPER
  • UPPER
  • REPT
  • SHEET
  • SHEETS
  • TRANSPOSE
  • TYPE
  • VALUE

RANK FUNCTIONS

Under RANK, you will get the cheat sheet of the following functions:
  • RANK
  • RANK.AVG
  • RANK.EQ

LOGICAL FUNCTIONS

Under LOGICAL, you will get the cheat sheet of the following functions:
  • AND
  • OR
  • NOT
  • And XOR
If find anything in my Excel Formulas Cheat Sheet workbook that has to be updated or edited, please let me know in the comments section. Hope it will help you to master Excel Formulas in an easy way!
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment

Recent Comments