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 formula & 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.

## 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:

**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 free example tutorial & downloadable Excel workbook for you to practice!

**Want to know how to use the 5 Most Used Excel Formulas and Functions?**

**Want to know how to use the 5 Most Used Excel Formulas and Functions?**

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

**Watch on YouTube**and give it a thumbs up 👍

## 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

## Post Reviews

## Excellent place to learn more about excel

Simple approach and excellent examples to explain the details

## Excel function and formulas

A proven step by step guide to creating Excel Formulas in SECONDS!