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...
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...
MONTH Function
The MONTH function in Excel returns the month component of a specified date as a number between 1-12.
CONCATENATE Function
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.
FLOOR Function
The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...
Universal Basic Income from a Republican?
Could a Universal Basic Income work in the US?
How are dates stored in Excel?
Learn how dates are stored sequentially in Excel.
Mortgage Calculator in Excel
Need to figure out how much home you can afford? Let's create a mortgage calculator in excel. Want it be flexible and...
TEXT Function in Excel
Learn how to use the TEXT Function in Excel.
Excel Tutorials
Functions
EDATE Function
The EDATE function in Excel takes a date and adds specified number of months.
DSUM Function
The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.
WEEKDAY Function
The WEEKDAY Function in Excel returns an integer that represents a day of the week.
AVERAGEIF Function
AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while...
TIMEVALUE Function
The TIMEVALUE function in Excel converts a time written as text into Excel time.
DATEVALUE Function
The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text - Date in text format.
Formulas
Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
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...
Summing Only Positive or Negative Values
Learn how to sum only positive or negative values in excel. If you are an avid excel user,...
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...
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...
LATEST Additions
Rule of 500 Calculator – Astrophotography
The Rule of 500 Calculator in Excel is a simple document to let you quickly determine the maximum shutter speed for shooting Astrophotography....
Full-Frame Crop Factor Calculator in Excel
Easily determine the Full-Frame Crop Factor of your various lenses using the following calculator in Excel. If you shoot with a Full-Frame or...
PPMT Function
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine...
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...