
More Excel Functions Playlist
Excel Video 190 Rounding
ROUNDUP every medical practice manager you know to watch Excel Video 190. Many of you may be familiar with...
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...
Excel Video 192 Convert Minutes to Hours:Minutes
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...
Excel Video 193 SUMPRODUCT
SUMPRODUCT gives you two functions for the price of one in Excel Video 193. If you have two columns you want...
Excel Video 194 RANDBETWEEN
If your compliance efforts need to be a little more random, watch Excel Video 194. I’ll start with a quick...
Excel Video 195 LARGE and SMALL
There are a LARGE number of ways to use these two functions and it only takes a SMALL amount of time to learn...
Excel Video 196 Ranking
Want to RANK higher in your Excel knowledge? Watch Excel Video 196. Excel uses RANK functions to show how...
Excel Video 197 Tracing Precedents and Dependents
Need a crystal ball with a rear view mirror? Watch Excel Video 197. Excel Video 197 starts our discussion...
Excel Video 198 Error Checking
I can’t help you with your shortstop’s errors, but Excel Video 198 will try to fix your spreadsheet’s...
Excel Video 199 Showing and Evaluating Formulas
Watch Excel Video 199 to see two quick ways to better understand the formulas on your spreadsheet. The first...