EXACT Function
Excelbud -
0
The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If...
Start Learning
MAX Function
The Excel MAX function returns the largest numeric value in
a range of values. The MAX function ignores empty cells, the logical values,
TRUE...
Creating a Template in Excel
To create a new template in Excel, follow the steps below. In this example, we will be creating the structure for a...
AVERAGEIF Function
AVERAGEIF
(Arithmetic Mean) – Single Criteria IF statementUse the AVERAGEIF Function to find the arithmetic mean in Excel while...
Getting VBA setup in Excel
Setting up VBA does not require any special software installation.
The VBA development software is included with each package of the Microsoft
Office suite...
VBA Select Method
Selection is a method in Excel VBA that performs an action. You use the Select method to select a single cell or...
Create a Drop Down List
If you want to force user for selecting data from the fixed
data items and prevent user from entering custom data for any...
INDEX Function
INDEX Function in ExcelThe Index Function in Excel returns the value of an array given a specific row...
Named Ranges in Excel – Setup, Rules, and Uses
Learn how to use Named Ranges in Excel.
Excel Tutorials
Functions
Match Function
Match FunctionThe Match
Function searches for a specified value and returns relative position of that
value. It’s easier once you...
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!
COUNTIF Function
The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to...
CUMIPMT Function
How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the cumulative interest paid on a loan. This can be extremely useful...
Formulas
Annual Growth Rate in Excel
Annual Growth Rate in ExcelCalculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...
Calculate Private Mortgage Insurance (PMI)
Learn how to calculate Private Mortgage Insurance (PMI) on a new home purchase.
Compound Quarterly Growth Rate (CQGR)
Compound Quarterly Growth Rate (CQGR) in Excel is rather easy to calculate. This can be very useful to forecast potential income or...
SPLIT FIRST and LAST NAMES
Split First and Last nameThis tutorial covers how to split first and last names in excel.
Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
LATEST Additions
HOUR Function in Excel
What time is it? The HOUR Function can grab, you guessed it, the HOUR!
EDATE Function
The EDATE function in Excel takes a date and adds specified number of months.
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 Growth...
CONCAT Function
The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016 as a replacement/alternative...