The Hidden Power of the MOD Function in Excel | Alan Murray | Skillshare

# The Hidden Power of the MOD Function in Excel

#### Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
5 Lessons (17m)
• 1. What is the MOD Function?

1:53
• 2. Example 1 - Extract the Time from a Date-Time Cell

2:21
• 3. Example 2 - Prevent the Entry of Odd Numbers in a Range

2:44
• 4. Example 3 - Calculate the Total Balls Bowled from Overs in Cricket

3:47
• 5. Example 4 - Sum Every Third Row in a List

6:07

In this class, we look at some examples of why we appreciate the MOD function in Excel.

It is a function with a very specific purpose, and many hidden (and very useful) reasons for its use.

In the class, we explain the MOD function and what its purpose is. We then go on to explain 4 different examples of how it could be useful in Excel.

As usual, the files I use in my video demonstrations are available to download and follow along from the project area of the class.

Check out the hidden power of the MOD function, and if you need anything please get in touch.

See you inside the class.