Featured Formulas

Combine data in multiple worksheets

The goal is to combine data from different worksheets with a formula. Note that we are not restructuring the data in any way, we are simply combining data in different worksheets that already have the same structure. At a high level, the formula we are using combines data from multiple sheets...Read more

Featured Functions

SUMPRODUCT Function

The SUMPRODUCT function multiplies arrays together and returns the sum of products. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 ranges or arrays can be supplied. When you first encounter...Read more

Recent Articles

For sharing your knowledge of Excel. I'm learning a lot and so excited. Your information is nicely explained and I'm able to understand.
Babs
I've just found your ExcelJet site, and I find it amazing. I currently work in Finance for a big international company and your contents have helped me a lot on my daily work.
Victor
Just wanted to drop a quick thanks for being a couple epic excel teachers. My schedule doesn't really allow for day classes covering stuff I may already know so when I need help on a specific 'how do I do this?' I google it and look for Exceljet. Super clean instruction, great examples, you two are lifesavers.
Guy

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