SUMPRODUCT Function
The SUMPRODUCT function in Excel is a useful tool when you are working with large data sets or multiple arrays. An array...
Start Learning
Autofilter in Excel
AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to use...
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!
Round Numbers in Excel
Rounding numbers in excel is critical in order to make spreadsheets look more professional.
“We can’t connect to” in Excel
"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are...
Add Text to Beginning Number in Excel
Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number...
What is VBA in Excel?
VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s...
COUNTIF Function
The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to...
If Function
The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value...
Excel Tutorials
Functions
Average Function
AVERAGE (Arithmetic Mean) Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up a list of numbers and...
DATEVALUE Function
The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text)
SUMIF Function
The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators...
FLOOR Function
The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...
CUMIPMT Function
How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the...
Data Validation Techniques in Excel
We are going to cover Data validation techniques in Excel. Data validation is a very important feature of Excel document. This feature helps to prevent user from entering invalid data on the cell....
Formulas
Subtract If Greater than Zero
Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...
Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
SPLIT FIRST and LAST NAMES
Split First and Last name This tutorial covers how to split first and last names in 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...
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
NPER Function
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of...
“We can’t connect to” in Excel
"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are you...
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent...
YEARFRAC Function
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:
Add Text to End Number in Excel
Easily learn to Add Text to the End of a Number in Excel. This simple trick will allow you to format numbers with...
Add Text to Beginning Number in Excel
Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number with...
YEAR Function
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the...
Delete Multiple Rows of data
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there are...
Separate Numbers after a symbol
This quick tutorial will demonstrate how to separate numbers after a symbol in Excel. In our example, we have a list of Serial...