Featured Formulas

Cash denomination calculator

In this example, the goal is to build a "cash denomination calculator." A cash denomination calculator is a tool for counting and verifying cash amounts. It can calculate the denominations needed to achieve a certain cash value. It can also perform the reverse calculation and determine the...Read more

Featured Functions

IMAGE Function

The IMAGE function is Excel's solution for adding images to a worksheet with a formula. IMAGE is similar in some ways to HTML's <img> tag, which is used to add images to an HTML page. Like the <img> tag, the IMAGE function allows you to set the image path and provide options for fit...Read more

Recent Articles

Just wanted to say a big "T H A N K Y O U!" for the great work that you are doing here. Your hours rounding formula explanation just made my day!
Klaus
I just wanted to add my comment to the many many others who appreciate the clear concise and informative information here. I find these days when I'm looking for help on excel I start by searching exceljet. Great stuff I'm a fan.
Barnaby
I've used your site for years but just thought that perhaps you might welcome hearing how I return to yours time and time again as my first choice when I'm either learning a new Excel function, or refreshing my memory. I continue to be impressed by every aspect of your site and how user-friendly it is -- from the size and choice of font, to the page organization, to the speed and clarity of the videos, and of course to the organization and clarity of the explanations.
Anna

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