Advanced Excel Formulas & Functions are a must know feature in Microsoft Excel that allows you to quickly analyze your data in many forms. Once you learn how to construct Excel Formulas & Functions, your Excel skills & level will increase exponentially.
Below you will find 101 Excel formulas & functions examples for key formulas & functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more. You will also find Excel formulas with examples in Excel sheet free download!
Table of Contents
See how easy it is to learn the Top Excel Formulas here…
Formulas VS Functions
You most probably have heard the words Formulas & Functions both being used in Excel. What is the difference between them?
A Formula is an expression which calculates the value of a cell and a Function is a predefined formula that is made available for you to use in Excel. Below is an example of both but we use both terms (Formulas & Functions) interchangeably:
Watch our free training video on how to master the most popular Excel Formulas
DATE & TIME
DateDif
EndOfMonth
Time
Weekday
Weeknum
Workday
Year
LOGICAL
And
If
If, And
Iferror
 LOOKUP
Array, Lookup
Hlookup
Iferror, Vlookup
Index
Index, Match
Indirect
Match
Multiple Criteria, Vlookup
Offset
Pivot Table, GetPivotData
Sum, Lookup
Vlookup
Xlookup
 MATH
Average
Count
CountA
CountBlank
CountIf
CountIfs
Mathematical Formulas
Mod
Percentage
Rand
Randbetween
Round
Subtotal
Sumifs
Sumproduct
 OTHER
3D
Array
Chart
Convert, Values
Evaluate
Find & Select
FV
Reference
Show, Hide
Transpose
Type
Value
 TEXT
Between
Clean
Concatenate
Data Cleansing, Trim
Extract, Find, Left
Left
Len, Length
Proper
Remove
Remove, Substitute
Replace
Replace, Cleanup
Right
Substitute
Substitute, Trim
Text
Upper
Click on any Excel formula & function link below and it will take you to the advanced Excel formulas with examples in Excel sheet free download for you to practice!
3DÂ
And
ArrayÂ
Array, LookupÂ
IfÂ
If, AndÂ
IferrorÂ
Iferror, VlookupÂ
IndexÂ
Index, MatchÂ
IndirectÂ
LeftÂ
Len, LengthÂ
MatchÂ
Mathematical FormulasÂ
ModÂ
Multiple Criteria, VlookupÂ
OffsetÂ
PercentageÂ
Pivot Table, GetPivotDataÂ
ProperÂ
RandÂ
RandbetweenÂ
ReferenceÂ
SortÂ
SortbyÂ
SubstituteÂ
Substitute, TrimÂ
SubtotalÂ
Sum, LookupÂ
SumifsÂ
SumproductÂ
TextÂ
TimeÂ