Select Page

Excel Video 191 INT, LEN, and MOD

Invest 4 minutes to learn about 3 functions by watching Excel Video 191. The payoff will be next time when we use all three to convert minutes to an hours:minutes format. INT simply rounds a number down to the nearest integer. LEN calculates the length, or number of...

Excel Video 190 Rounding

ROUNDUP every medical practice manager you know to watch Excel Video 190. Many of you may be familiar with the ROUND function in Excel. The syntax is simply =ROUND(number you want to round, number of digits to round to). If the number of digits is 0, Excel rounds to...

Excel Video 189 Counting in Excel

COUNT on Excel Video 189 to keep you out of trouble with Excel’s count functions. Today I’ll spend a few minutes reviewing three different counting functions in Excel. COUNT does just what you’d expect; it counts the number of cells in a range. The catch is that COUNT...