Featured Formulas

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

I really value they way your information is laid out and the samples and explanations - it is really user friendly!! It has helped me navigate many challenges and understand so much more about Excel. Excel has really complimented my efforts to support more efficiencies and leadership in the area I work (therapy team supporting students and teachers in schools).
Kevin
Just wanted to let you know how much I appreciate the deep dive into Excel. Your examples are clear and allow me to play with my own data and not spend hours in frustration Googling what I’m trying to do.
Dawn
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

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