Featured Formulas

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

Featured Functions

Recent Articles

Not normally one to reach out, but feel obliged to contact you and let you know how great your site is? I consider myself to pretty good with Excel, however find myself checking your website each time to check if there is an easier way, or for advice on complex formulas. You guys have been extremely helpful in taking my reporting tools and analysis to the next level!
Kristian
This site is perfect for me as a moderate Excel user who sometimes needs a formula that I cannot figure out on my own. It's clean, easy to use, comprehensive and doesn't have distracting material like many other Excel help sites.
Susan
I absolutely love getting your emails and insights.
SB

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