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...
by Nate Moore | Sep 5, 2011 | Functions
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...
by Nate Moore | Aug 31, 2011 | Functions
Have you ever brought a report to a physician who said, “That’s great. Now that you can do x, can you do y?” Excel Video 188 does the same thing. Now that we can do an average with one condition, we’ll take it to the next level and calculate averages with multiple...
by Nate Moore | Aug 29, 2011 | Functions
You can go immediately to being an above-AVERAGE Excel user by learning AVERAGEIF in Excel Video 187. The structure of AVERAGEIF is very similar to SUMIF from Excel Video 184. We’ll apply AVERAGEIF to a list of OR start times to calculate the average start time, the...
by Nate Moore | Aug 24, 2011 | Functions
You can’t COUNT all of the ways COUNTIF can help you in your practice. Excel Video 186 reviews both COUNTIF and COUNTIFS. These functions are easier to use than SUM and SUMIF since the counting functions don’t have a separate criteria range and sum range. You simply...
by Nate Moore | Aug 22, 2011 | Functions
If you liked Excel Video 184 and want to have multiple criteria in your SUMIF formula, watch Excel Video 185. The function is called SUMIFS and it’s new in Excel 2007. SUMIFS lets you have up to 127 criteria in a SUMIF function. If you need anywhere near that many...
