Featured Formulas

Filter and exclude columns

In this example, the goal is to use a single formula to extract high-value projects and list them in a simple table. We also want to remove unnecessary columns to create a clean, uncluttered view. The solutions explained below are based on a combination of several functions in Excel, including...Read more

Featured Functions

Recent Articles

I teach Excel and just wanted to let you know that your website is the one I recommend to all my students. Thanks for the way you make Excel easy to understand.
Ken
I just wanted to THANK YOU so much for the superb articles you offer to assist those such as myself who seek to improve their expertise with Excel. Your articles are clear with such easy to follow examples which are relatable to real life problems that I find I need help with. My skill set has grown (and continues to grow) significantly with the input I have successfully gained from your fabulous site.
Leigh
Your site is GREAT and so refreshing compared to the rest of the stuff out there on Excel. The writing and explanations are clear, concise, and to the point!
Jeff

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