10 practical uses of MOD function in Excel is explained in this video.
(0:00) Intro
(1:48) 1. Filter Multiples of a specific number
(3:49) 2. Extract Time from a cell containing date and time
(5:31) 3. Most recent Weekday
(6:36) 4. Convert Seconds to Hours, Minutes & Seconds
(7:52) 5. Restrict the entry of Decimal numbers
(9:07) 6. Highlight every nth row of a data set
(10:21) 7. Repeat each Serial number ‘n’ number of times
(11:46) 8 & 9. Sum and Count of Odd and Even numbers
(14:59) 10. UnPivot Data from Columns to Rows

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

#excel #microsoftoffice course #MODFunctionInExcel