Featured Formulas

If cell begins with x, y, or z

The goal is to take a specific action when a value begins with "x", "y", or "z". As is often the case in Excel, there are multiple ways to approach this problem. The simplest way is to use the OR function with the LEFT function to create the required logical test. Another option is to...Read more

Featured Functions

TRIMRANGE Function

The TRIMRANGE function removes empty rows and columns from a range of data. Given a range or array, it will exclude empty rows and/or columns and return a "trimmed" range that contains only data. The beauty of TRIMRANGE is that it will track the data in a worksheet as it changes. When data...Read more

Recent Articles

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
Thank you so much for your universal formula on the page "Rank with ordinal suffix." It was exactly what I needed.
Grateful reader
I really appreciate your delivery of the videos, the clean and sharp documentation and pleasant to the eye website, uncluttered, direct, short and snappy. From what I've checked out elsewhere nothing compares...
Christina

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