Featured Formulas

Detailed LET function example

In this example, we have a simple set of data in B5:D16 that includes ID, Name, and Points. The goal is to generate a custom message for any name in the list by entering a valid ID in cell G5. The message uses the name from column C and the points in column D like this:

...Read more

Featured Functions

UNIQUE Function

The Excel UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will "spill" onto the worksheet into a range...Read more

Recent Articles

I am deeply grateful for this website. I went from being an Excel novice starting out at my current job to working my way up the ladder as an Excel pro! It even has me considering database management and data science as a career. Thank you, and keep up the great work!!!
Tamar
Thank you so much for making this information so easy to find and understand. Your examples and explanations are concise and clear. Your site is bookmarked. Thank you! Thank you!
Sally
I found Exceljet through a google search when I was trying to figure out the correct syntax for a formula. Of course, when you do a search in this manner, several options pop up. Well, after looking at several websites that allegedly had the answer to my question, I finally took a gander at your site. BINGO!! Exceljet had the answer because you provide very detailed explanations AND examples. My problem solved. After that experience, I always turn to Exceljet first. So far, I have not had to look any further.
Barbara

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