We select and review products independently. When you purchase through our links we may earn a commission. Learn more.
X
X
The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

Sign Up Here arrow indicating signup email field.

Use Excel to Calculate How Many Days Until an Event

Excel stores dates as integers. By default, Excel uses “1” to represent 01/01/1900 and each day after that is one greater. Type in 01/01/2000 and switch the format to “Number” and you’ll see “36526” appear. If you subtract 1 …

How to Do a Linear Calibration Curve in Excel

Excel has built-in features that you can use to display your calibration data and calculate a line-of-best-fit. This can be helpful when you are writing a chemistry lab report or programming a correction factor into a piece o…

How to Calculate a Z-Score Using Microsoft Excel

A Z-Score is a statistical value that tells you how many standard deviations a particular value happens to be from the mean of the entire data set. You can use AVERAGE and STDEV.S or STDEV.P formulas to calculate the mean and…

How to Sort Values in Microsoft Excel

Excel has “Sort A to Z” and “Sort Z to A” features that let you sort values alphabetically or numerically, and a “Custom Sort” feature that lets you sort using multiple criteria.  Here’s how to use them….

How to Set the Rounding Precision in Excel

Setting the rounding precision forces Excel to always round numeric values to a specified number of digits following the decimal, saving you from having to use the ROUND function on each formula. Here’s how it works….

How to Calculate a Weighted Average in Excel

A weighted average is one that takes into account the importance, or weight, of each value. This article will show you how to use Excel’s SUMPRODUCT and SUM functions individually and how to combine the two to calculate a wei…

How to Use the FREQUENCY Function in Excel

Excel’s FREQUENCY function lets you count how many times values fall within specific ranges. For example, if you had the ages of a group of people in your spreadsheet, you could figure out how many people fall into different …
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read billions of times. Want to know more?