
This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. If you...
This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. If you...
An easy formula that returns the day of the year for a given date. There's no built-in function in Excel that can do this. 1. Enter t...
This example shows you how to count the number of blank and nonblank cells in Excel. 1. The COUNTBLANK function counts the number of blan...
This example shows you how to create an array formula that sums the largest numbers in a range. 1. We use the LARGE function. For example...
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for ...
This example teaches you how to separate strings in Excel. The problem we are dealing with is that we need to tell Excel where we want ...
This example teaches you how to use the PERCENTILE and QUARTILE function in Excel. Below you can find a list of scores (green fill for illu...
This example shows the difference between the SUBSTITUTE function and the REPLACE function. 1a. If you know the text to be replaced, use ...
Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples. 1. We start simple. For example, we...
The TRIM function returns a string with extra spaces, starting spaces and ending spaces removed. The CLEAN function removes nonprintable ch...
When you add a trendline to an Excel chart, Excel can display the equation in a chart (see below). You can use this equation to calculate...
A quadratic equation is of the form ax 2 + bx + c = 0 where a ≠ 0. A quadratic equation can be solved by using the quadratic formula. You ...
To get the date of the last day of the month in Excel, use the EOMONTH (End of Month) function. 1. For example, get the date of the last ...
This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive. 1. Use the EXACT function (case-...
The INDIRECT function returns the reference specified by a text string. 1. For example, the INDIRECT function below reduces to =INDIRECT(...