Featured Formulas

Left lookup with INDEX and MATCH

In this example, the goal is to lookup data to the left of an ID that appears as the last column in the table. In other words, we need to locate a match in column E, then retrieve a value from a column to the left. This is one of those problems that is...Read more

Featured Functions

RANK Function

The RANK function returns the numeric rank of a number when compared to a list of other numbers. You can use RANK when you want to assign a rank to a list of numeric values. RANK works fine with sorted or unsorted data. It is not necessary to sort the values in the list before...Read more

Recent Articles

New Excel Functions

Nearly 50 new functions have been added to Excel! This is not your Dad's Excel anymore – a lot has changed. This article takes a quick tour of the new functions, with links to more detailed information....Read more

I sincerely want to register my profound gratitude to Dave and Lisa. There are many features so unique about the tutorials in Exceljet: the simplicity, down-to-earth approach and the connection between the instructor and the learner.
John
I felt compelled to send my thanks for your clear, informative, concise, and just very helpful videos. I have been thrust a data management assignment without training and far outside my usual duties, so these have been invaluable.
Zoë
What a great website. I'm an Excel trainer and your website helped me populate a sample company worksheet with random departments. Thanks.
Lloyd

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