Featured Formulas

Sequence of days

The goal is to generate a series of sequential dates with a formula. In the current version of Excel, the easiest method is to use the SEQUENCE function. SEQUENCE can return all dates at the same time into a range on the worksheet. In older versions of Excel without the SEQUENCE function, you...Read more

Featured Functions

TEXTBEFORE Function

The TEXTBEFORE function extracts text that occurs before a given delimiter. When multiple delimiters appear in the text, TEXTBEFORE can return text before the nth occurrence of a delimiter. TEXTBEFORE can also extract text that occurs before a given delimiter when counting...Read more

Recent Articles

New Excel Functions

Nearly 50 new functions have been added to Excel! This is not your Dad's Excel anymore – a lot has changed. This article takes a quick tour of the new functions, with links to more detailed information....Read more

Knowing your site is the best thing that ever happened to me since I started using excel.
MJM
I think your descriptions of excel formulas and how to apply formula combinations are the easiest to follow on the web. I must use your website at least 2-3 times a week!
Tony
Your tip on the scroll lock helped me a lot this afternoon. I really appreciate it.
Seth

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