Featured Formulas

Dynamic array

Biggest gainers and losers

In this example, the goal is to display the biggest 3 gainers and losers in a set of data where Start and End columns contain values at two points in time, and Change contains the percentage change in the values. The data in B5:E16 is defined as an Excel Table...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I work for a large corporation where I am the Excel Guru and I think my skill level is advanced. This makes it difficult when I do run into issues because I have no one to go to for advice. Luckily you have been there to help me solve an issue via your site. I have been following you for years. Much of what I know comes from you and a few others. I would say I have learned the most from you. Much appreciation for the work you and wife do.
John
I am deeply grateful for this website. I went from being an Excel novice starting out at my current job to working my way up the ladder as an Excel pro! It even has me considering database management and data science as a career. Thank you, and keep up the great work!!!
Tamar
My sincere appreciation for the help on this problem. It is a great time saver and I will use this tip literally everyday.
Bob
More Testimonials

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