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