Find and Select
This tutorial is going to review the Find & Select button in the Home section of the ribbon. Let’s say...
Start Learning
Calculate Work Days in Excel
Calculate Work Days in Excel Using the following Functions Learn how to calculate work days for a given year,...
Clear a filter in Excel
After filtering has been done, you might want to change or do away with the filtering. Clearing can...
MINUTE Function
The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59.
Tip Calculator Template
Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up...
CONCATENATE Function
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.
SUMIFS Function
The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to use...
Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
SUMPRODUCT Function
The SUMPRODUCT function in Excel is a useful tool when you are working with large data sets or multiple arrays. An array...
TEXT Function in Excel
Learn how to use the TEXT Function in Excel.
Excel Tutorials
Functions
MINUTE Function
The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59.
Match Function
Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once you...
CUMIPMT Function
How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the...
XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!
RAND Function
The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel, but can...
CONCATENATE Function
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together. Syntax: =CONCATENATE (text1, text2, , ...)...
Formulas
SUMPRODUCT and EXACT Formula
In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for...
Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
Reverse Compound Annual Growth Rate (CAGR)
Reverse Compound Annual Growth Rate is a calculation to determine the future value of your investment. In this calculation, the Compound Annual...
Calculate Private Mortgage Insurance (PMI)
Learn how to calculate Private Mortgage Insurance (PMI) on a new home purchase.
Compound Annual Growth Rate (CAGR)
The compound annual growth rate (CAGR) is an essential function regardless of industry. In this tutorial, we will cover how easy it...
LATEST Additions
Tip Calculator Template
Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up bills....
Sum if date is greater than
Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range if...
Calculate Work Days in Excel
Calculate Work Days in Excel Using the following Functions Learn how to calculate work days for a given year, or...
Sum if between
To sum if between in Excel, we need to use the SUMIFS Function and define our criteria.
_xlfn. prefix in Excel
The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.
Sum if greater than
To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use the...
SECOND Function
The SECOND function in Excel returns the second component of a specified time as a number between 0-59.