Featured Formulas

Look up entire column

In this example, the goal is to look up and retrieve an entire column of values in a set of data. For example, when a value like "Q3" is entered into cell H4, all values in the range E5:E16 should be returned. For convenience and readability, quarter (C4:F4) and ...Read more

Featured Functions

HYPERLINK Function

The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor 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

So thanks again for your great tip. You are my go-to page for the excel function help, because your explanations are clear, concise, to the point and give you several viewpoints of the same function that helps you construct what you really need.
Stijn
I wanted to reach out to let you know what a fantastic resource this site has been for me over the years. I find myself back here every time I am certain Excel *can* do something, I just don't know *how*. You also seem to have an uncanny knack for sending newsletters that highlight the perfect solution for my latest Excel challenge! My colleagues think I am some sort of Excel wizard, but I tell them I just have a really good resource (and yes, I share it with them!)
Christy
Just wanted to send you a thank you note for your website. It is very well presented, and has nice features and very good examples. I particularly like the one I found this week for "Get work hours between dates and times". It was perfect to calculate the time a business passenger flew "during their personal time", i.e. a passenger took the 6am flight, while his normal workday starts at 8am. Very clever formula. I have been a regular user of your website over the years.

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