Featured Formulas

Miscellaneous

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

More Formulas

Featured Videos

More Videos

Featured Functions

Text

TEXT Function

The TEXT function in Excel is a tool for formatting numbers, dates, and times as text. The purpose of the TEXT function is to convert a number to text using a specified format code. TEXT is most often used to control the formatting of a number embedded into a text string. However, TEXT is also a...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I just want to say THANK YOU !!!!!! for creating such a great website, that is free, and easy to follow and understand. I use your site all the time, and I recommend your website to my colleagues and employees.
Mike
I just leaned over to tell my colleague that any time I have a question on how to execute something in excel, I type my topic into google with "Exceljet" in the search and my answer is right there waiting for me. It is an incredible service and sometimes I feel like I am able to ask you my questions directly since the material is thorough, very well presented, and so easy for me to understand.
Kevin
I love to use excel and use it a lot in my work. Your tips, tricks and examples have helped me enormously.
Lisa
More Testimonials

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