Featured Formulas

Clean and reformat telephone numbers

In this example, the goal is to clean up telephone numbers with inconsistent formatting and then reformat the numbers in the same way. In practice, this means we need to start by removing the extra non-numeric characters, including spaces, dashes, periods, and parentheses. Once these...Read more

Featured Functions

SEQUENCE Function

The SEQUENCE function generates a list of sequential numbers in an array. The array can be one-dimensional, or two-dimensional, controlled by rows and columns arguments. SEQUENCE can be used on its own to create an array of sequential numbers that...Read more

Recent Articles

Thank you so much Dave, this is going to save me hours of work.
Catriona
Just wanted to say your website is an amazing resource and I'm glad to have found it. Thank you for making it free.
Douglas
Exceptional content on Dynamic Arrays. I banged my head on my desk for hours this evening trying to migrate a financial model from traditional reference-based formulas to a much cleaner set of LET() and dynamic arrays function combinations. Your examples on BYROW() are simply stunning. Thank you so much!
JP

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