Featured Formulas

Featured Functions

TRIMRANGE Function

The TRIMRANGE function removes empty rows and columns from the outer edges of 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...Read more

Recent Articles

I recently graduated undergrad with a major in Finance and began work as an entry-level management consultant. Both roles require quite a bit of excel and I just wanted to reach out and say thank you for this resource! Your explanations are extremely straightforward, helpful, and often help me solve problems I had a difficult time with. I give you tons of credit for the excel abilities I have today!
Cameron
I just wanted to say thank you for the useful tutorials...This info is really useful for me at the moment because I'm just starting my first job while I'm not yet graduated from college.
Andrea
Appreciate your website as a guide to trying to solve challenges. I use regularly as needed and generally find the basics I need to build formulas. It's magnificent and I just want to say thanks.
Rean

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