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...
by Nate Moore | Aug 17, 2011 | Functions
Just because Excel Video 184 starts into what Excel calls Math & Trig functions, don’t skip these videos. I promise not to get into cotangents and logarithms. There are several powerful features in this section of formulas that can make a medical practice...
