On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

- Excel has a function called MOD.…If you happen to see a description of it,…it might not grab your attention.…For example, on the formula's tab in the ribbon,…if you click the Reference button.…If you happen to be looking at some of the math functions,…in this list is a function called MOD.…When you see what it does, you might say,…"Well, why would I ever use that?"…MOD function returns the remainder from division.…Don't we usually wanna know what the actual result is?…We don't care about the remainder…but it does have an application and a couple of them.…

Here's one.…Imagine, we got a warehouse and we're moving the warehouse…so we got to pack up all the items we have there.…Let's imagine the items aren't terribly large.…and they ideally are stored in boxes or containers.…So we've got 162 of these items here.…Our boxes can hold just 16 items.…We'd like to know how many items are leftover after packing.…So if we decide 162 by 16, we get 10…with a remainder of two.…So we do want to know how many will have left over.…

Resume Transcript Auto-Scroll

Author

Released

12/10/2014

Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.