Featured Formulas

INDEX and MATCH exact match

In this example, the goal is to look up various information about a random group of popular movies from the 1990s. The information to retrieve includes the year released, the rank against the other movies in the list, and worldwide gross sales. To retrieve this information, we are using an INDEX...Read more

Featured Functions

IMAGE Function

The IMAGE function is Excel's solution for adding images to a worksheet with a formula. IMAGE is similar in some ways to HTML's <img> tag, which is used to add images to an HTML page. Like the <img> tag, the IMAGE function allows you to set the image path and provide options for fit...Read more

Recent Articles

I do really appreciate the work you have done. It is a cut above everything else out there.
Doug
Every time I come up with a tricky issue you always seem to have the answer and the solutions are so clear. Happened again today. Please keep up the great work - I owe you free drinks for life!
Pravin
Brilliant page! Thank you for always helping me whenever I am stuck! Keep doing the good work, much grateful!
Richa

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