Featured Formulas

Count cells not between two numbers

The goal of this example is to count the number of values recorded over 5 days that do not fall between two numbers, a low value, and a high value. In other words, to count values that are "out of range". Note that each row, labeled A-G, has its own low and high...Read more

Featured Functions

HYPERLINK Function

The HYPERLINK function creates a hyperlink from a given destination and "friendly name", which is simply the link text. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to other cells in a workbook, other sheets, named...Read more

Recent Articles

Just wanted to say thank you for this extraordinary resource and awesome examples; the examples you guys give here are some of the clearest and best on the internet. Exceljet and Stackoverflow are really my go-to for any kind of learning.
Weiqi
I thoroughly enjoy watching the videos you provide on your website...Your videos make learning featres in Excel easier than reading instructions. Being able to see something demonstrated makes all the difference.
NG
This is such an elegant, simple solution. Truly a thing of beauty! Thank you for this website!
Phil

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages