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

HYPERLINK Function

The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor text. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to other cells in a workbook, other sheets, named...Read more

Recent Articles

Thank you for all the work you do. The help you provide with your page is not only very helpful but very professional and outstanding.
Juan
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 just wanted to take a moment to thank you for the amazing work you do. Sharing knowledge is one of the most generous things anyone can do, and you do it with real mastery. Your contributions have helped me immensely with challenging tasks, and I’m sure they’ve been just as valuable to many.
Esdras

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