Featured Formulas

Tiered discounts based on quantity

This example shows a workbook designed to apply discounts based on seven pricing tiers. The total quantity of items is entered as a variable in cell C4. The discount is applied via the unit costs in E7:E13, which decrease as the quantity increases. The first 200 items have an undiscounted price...Read more

Featured Functions

LAMBDA Function

The LAMBDA function provides a way to create a custom function in Excel. Once defined and named, a LAMBDA function can be used anywhere in a workbook. LAMBDA functions can be very simple or quite complex, stringing together many Excel functions into one formula. A custom LAMBDA function...Read more

Recent Articles

Internet is full of excel websites with excel classes but I have to say none of them is well made (at least for me). This instead is really great. It's now saved as first page in my browser...
Luca
Just wanted to send a shout out for your website. Whenever I think of something to try out in Excel, but not sure how to do it, your website is my first and only stop! I have it saved as a shortcut whenever I need to look something up! My skills have definitely improved since I started using your site last year!
Kevin
I just found your website. It is great help. I'm only sorry that I did not find it earlier - it would save me a days of struggling with excel.
Pawel

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