Pivot Table Example - Sales by sales person
In this video, we show how to analyze sales data by salesperson, region, and month & year.
Dave Bruns
Pivot Table Example - IMDB Movie data
In this video, we look at how to use a pivot table to analyze movie data by rating, runtime, genre, and more.
AVERAGEIFS Function
The AVERAGEIFS function calculates the average of cells in a range that meet multiple conditions, referred to as criteria. Each condition is provided with a separate range and criteria. To define criteria, AVERAGEIFS supports various...Read more
How to count items in a filtered list
In this video we show you how to add a message at the top of a filtered list that displays total and visible items in the list.
How to calculate and highlight expiration dates
In this lesson we look at how to generate an expiration date in the future, how to calculate "days remaining," and how to highlight dates that are "expired" or "expiring soon" with conditional formatting...
MOD Function
The MOD function returns the remainder after division. For example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1.
The MOD function takes two arguments: number and divisor. Number is the number to be divided, and divisor is...Read more
Get most recent day of week
In this example, the goal is to create a formula that will return the most recent day of the week, given a date and a target day of the week, abbreviated as "dow" in the generic formula. Excel tracks the day of the week internally as a specific number for each of the seven days. By default,...Read more
Get next day of week
In this example, the goal is to get the next specified weekday, starting on a given start date. So for example, with a valid start date in column B, we want to be able to ask for the next Monday, the next Tuesday, the next Wednesday, and so on. This article describes two different ways of...Read more
Sequence of weekends
The goal is to generate a series of sequential weekend days (Saturday and Sunday) with a formula. The start date is entered in cell B5. The number of dates to create (n) is entered in cell B8. If either of these two values are changed, a new list of weekend dates should be generated. In the...Read more
Date is same month and year
In this example, the goal is to mark dates in column D with an "x" when they have the same year and month as the date in cell B5. We don't care at all about the day. At a high level, we can easily use the IF function to return "x" for qualifying dates, so the challenge is in creating a logical...Read more