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:
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?
*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***