Learn Excel with clear examples and bite-sized videos.
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
The Excel shortcuts you really should know
A curated guide to the most useful Excel shortcuts for Windows and Mac, with explanations, tips, and videos. Covers navigation, selection, data entry, formatting, formulas, and more.Read more
Topics By Category
User Testimonials
My sincere appreciation for the help on this problem. It is a great time saver and I will use this tip literally everyday.
Bob
Thank you. I now can use index match with multiple criteria. I feel i have just jumped to next level Excel expert.
Emily
Awesome! I'm helping with a project and needed to compile 13 employees' working hours, by month, for an entire fiscal year. I started out doing this manually, then found this page. It took a little reworking the function to suit my needs, but when I got it... there was some fist-pumping. You just saved my afternoon!
Chris
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.
