Featured Formulas

Simple investing worksheet

A while back, I got from a reader about investing for his grandkids. The email asks the following question:

I hope you can assist me with an Excel calculation. I am keen to show my grandchildren the power of compound interest and the value of investing (patiently) for the...Read more

Featured Functions

FILTER Function

The FILTER function "filters" data based on one or more conditions, and extracts matching values. The conditions are provided as logical expressions that test the source data and return TRUE or FALSE. The result from FILTER is an array of matching values from...Read more

Recent Articles

Just wanted to drop you a short e-mail to say how useful I have found several of you video tutorials. Thank you! I really found the "Choose" function video especially useful in applying financial quarters (UK!) and this led me on to finding formulas for financial year.
Paul
I have learned so much from @exceljet newsletters. Just "Index Match" has brought my Excel skills to an entirely new level, my bosses think I'm a magician now. Thank you, keep them coming!
terrwils
I have been using Excel for years, but some of the functions I use sparingly and sometimes forget some of the finer points. For a quick refresher I visit Exceljet. It has become my fave place for quick refreshers.
Richard

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