Featured Formulas

Extract numbers from text

In this example, the goal is to extract the numbers from a set of property listings which describe the number of bedrooms and bathrooms, the size of the house in sq. ft., and the size of the lot in acres. Traditionally, this kind of problem has been quite difficult in Excel because each number...Read more

Featured Functions

FILTER Function

The FILTER function "filters" data based on one or more conditions, and extracts matching values. The conditions are provided as logical expressions that test the source data and return TRUE or FALSE. The result from FILTER is an array of matching values from...Read more

Recent Articles

I absolutely love the examples you provide on this site! Has helped me with numerous problems I have encountered.
James
I’d like to congratulate you both on your videos. They are so well done, with very good examples, very easy to follow, with the right length, etc. It’s a very educational work.
Paloma
This is the best learning resource I have stumbled upon in many years during the process of my Excel learning.
Anchery

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