by Nate Moore | Sep 21, 2011 | Functions
If your compliance efforts need to be a little more random, watch Excel Video 194. I’ll start with a quick reminder that I’ve already covered some statistical functions relating to forecasting in Excel Videos 100-103. I won’t cover those function again in this series...
by Nate Moore | Sep 19, 2011 | Functions
SUMPRODUCT gives you two functions for the price of one in Excel Video 193. If you have two columns you want to multiply together and then get a total, you can always add a third column to multiply the first two columns and then sum the third column. If you need to...
by Nate Moore | Sep 14, 2011 | Functions
When you see =INT(A16/60)&”:”&IF(LEN(MOD(A16,60))=1,”0″&MOD(A16,60),MOD(A16,60)) in Excel Video 192, you’ll be glad you watched Excel Video 191! That big, long formula converts the minutes in cell A16 to an hours:minutes format....
by Nate Moore | Sep 12, 2011 | Functions
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...
by Nate Moore | Sep 7, 2011 | Functions
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...