Featured Formulas

Rank and score with INDEX and MATCH

In this example, the goal is to assign points based on a ranked score. The scores to rank are in column C, and the calculated Rank is in column D. Points are awarded based on the table in G5:H10. Both tblData (B5:E15) and tblPoints (G5:H10) are...Read more

Featured Functions

SEQUENCE Function

The SEQUENCE function generates a list of sequential numbers in an array. The array can be one-dimensional, or two-dimensional, controlled by rows and columns arguments. SEQUENCE can be used on its own to create an array of sequential numbers that ...Read more

Recent Articles

I've been pushing my knowledge of excel all of my working life. Your explanations are clear, without razzle-dazzle or long-winded preambles. Thanks!
David
I really like these videos. They are short, simple, and to the point. Makes for easy understanding.
Lee
My number one Excel resource! You are my go-to resource for solving thorny Excel problems. You've never let me down.
David

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