Featured Formulas

Sum by year

In this example, the goal is to calculate a total for each year that appears in column F. All data is in an Excel Table called data in the range B5:D16. The main challenge is that we have dates in column B, but we don't have separate year...Read more

Featured Functions

DATEDIF Function

The DATEDIF function is designed to calculate the difference between two date values in years, months, or days. The result from DATEDIF is a number that corresponds to the time unit requested. DATEDIF is a versatile function that can be used in financial analysis, project planning, age...Read more

Recent Articles

I must say that literally right now, at the writing of this message, within 12 hours of purchase of your Core Pivot video series, I am RIFLING through my previously dreaded sales report analysis. I have only watched the first 3 videos, and know I haven't scratched the surface of capabilities, so I look forward to watching the entire video series. But the value of my purchase of your Core Pivot video has already paid for itself within 12 hours of purchase.
Brandon
I don't often do this, but i've subscribed to your tips for a little while now. I think they come from Dave. I just wanted to say these are absolutely awesome and they have significantly helped me build my excel skills.
Mike
I just want you to know that ExcelJet has quite honestly changed my life...I now have my own business as a bookkeeper. Bookkeeping requires Excel on a DAILY basis to manipulate data & get it in and out of QuickBooks. I use conditional formatting, INDEXMATCH, VLOOKUP, IFS, everything I have learned from ExcelJet. The 2-3 minute courses are a dream ..... I could open up 5 and watch them and come back later. Plus you are all super organized & clear in how you teach Excel. Watching videos on YouTube piecemeal from many different instructors never worked for me. ExcelJet was the real deal!!
Ainsley

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