Select Page

Excel Video 188 AVERAGEIFS

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...

Excel Video 187 AVERAGEIF

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...

Excel Video 186 COUNTIF and COUNTIFS

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...

Excel Video 185 SUMIFS

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...

Excel Video 184 SUMIF

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...