Featured Formulas

Due date by category

In this example, the goal is to create a due date based on category, where each category has a different number of days allocated to complete a given task, issue, project, etc. The amount of time available to resolve each category is shown in column H, and categories is the...Read more

Featured Functions

Recent Articles

Just a quick note to let you know the hard work you've clearly put into your website is soooo valuable to folks like myself. This has very quickly become my favorite excel site! So clean, so devoid of excel-snobs arguing over best practices like so many forums, and so robust in the amount of topics you guys cover. Thank you!
Dustin
Thank you SO much for putting all of this information on the web!!! This is incredibly helpful for me, who is currently looking for a job, but hasn't kept up to date with Excel for a while. This is refreshing my memory, teaching me things I should've figured out before, and helping me feel better about myself and my job search!!
Vicki
I am new to your website, but must say that I find your material most informative.
Chris

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