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Â