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

PIVOTBY Function

The PIVOTBY function is designed to summarize data by grouping rows and columns. The result is a dynamic summary table created with a single formula. The result from the PIVOTBY function is similar to the output from a Pivot Table, but without formatting. The table returned by the PIVOTBY...Read more

Recent Articles

Each time I need to solve a formula problem, your site is always giving me the right solution or pointing me out in the right direction. It is awesome. Thanks a lot!
Jose
I just wanted to say your site is excellent and a life saver. Clear explanations with worked examples.
Simon
I’ve been in and out of the courses a lot since I signed up. Your short courses make it SO EASY to take a little break from work and go through one. I then bookmark them to go back through, just to cement the concepts. I so appreciate being able to do that since setting aside an hour or so is just not doable now. This way, I get a nice break, I learn something, it’s so much more retainable because of the brevity. Just a perfect platform.
Peg

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