Excel Formulas & Functions Tutorials
Learn the must know Excel formulas & functions and become better at Excel.
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. A Function is a predefined formula that is made available for you to use in Excel:
We use both terms (function and formula) interchangeably.
To learn more about specific Formulas more in depth, we have a lot of tutorials waiting for you below!
Top 10 Tutorials
- 101 Excel Formulas & Functions Examples– You will find 101 Excel formula & functions examples here for key formulas & functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more.Read more
- VLOOKUP Example: Vlookup with a Drop Down List– The VLOOKUP function in Excel can become interactive and more powerful when applying a Data Validation (drop down menu/list) as the Lookup_Value. So as you change your selection from the drop down list, the VLOOKUP value also changes.Read more
- VLOOKUP Multiple Columns – The VLOOKUP function can be combined with other functions such as the Sum, Max or Average to calculate values in multiple columns. As this is an array formula, to make it work we simply need to press CTRL+SHIFT+ENTER at the end of the formula. A very powerful feature for any serious analyst!Read more
- BETWEEN Formula in Excel – There is no explicit Between formula in Excel, however we can come up with creative ways to create this functionality.Read more
- Jump To A Cell Reference Within An Excel Formula– There is a cool tip where you can jump to the referenced cell or range within the formula and make your changes.Read more
- Advanced SUMPRODUCT Function: Sum Multiple Criteria – The SUMPRODUCT function is my favorite Excel function by a stretch! You can create some powerful calculations with the SUMPRODUCT function by creating a criteria for a selected array. For example, you can see how much sales your sales rep did in a particular region and for a particular quarter without having to create a Pivot Table.Read more
- Concatenate With A Line Break– Excel’s CONCATENATE functions joins two or more text strings into one string. The item can be a text value, number, or cell reference.Read more
- Named Ranges with Vlookup Formula – A Named Range makes it easier to understand Excel formulas, especially if the said formula contains an array argument. We can combine this with the VLOOKUP function.Read more
- Match Two Lists With The MATCH Function– I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2.Read more
- INDIRECT Function for Dependent Dropdown Lists in Excel– The INDIRECT function is really cool as it opens up a lot of interesting combinations in Excel. We will use the power of the INDIRECT function right now on creating Dependent Dropdown Lists.Read more