Pivot Table Example - Voting results
In this video, we look at how to use a pivot table to analyze voting data, including winning vote by percentage, and breakdown by age and gender.
Dave Bruns
Pivot Table Example - Instrument readings
In this video, we look at how to use a pivot table to analyze instrument measurements. This data consists of temperature readings taken in a green house over a period of days.
Pivot Table Example - Sales by sales person
In this video, we show how to analyze sales data by salesperson, region, and month & year.
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