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...
by Nate Moore | Aug 15, 2011 | Functions
Excel Video 183 uses INDEX and MATCH to look up which payer has the highest and lowest reimbursement for a given CPT code. You’ll see in Excel Video 183 that I have a variety of statistical information about how different payers reimburse for a given CPT code. By...
by Nate Moore | Aug 10, 2011 | Functions
There are two tricks to watch for in Excel Video 182. First, we’ll use the fourth section of the INDEX function so we can look in multiple areas in our spreadsheet for data. To look in multiple areas, first define each area in the first parameter of the INDEX...
by Nate Moore | Aug 8, 2011 | Functions
Excel Video 181 takes our INDEX and MATCH discussion one step further. Last time we used the MATCH function to calculate the row for INDEX to use. In this video, I’ll demonstrate how to use MATCH to provide both the row and column in an INDEX function. By using MATCH...
by Nate Moore | Aug 3, 2011 | Functions
Excel Video 180 combines INDEX and MATCH to create a powerful, flexible lookup tool. Now that we’ve seen both INDEX and MATCH in the last two Excel Videos, the trick is to combine the function to create a lookup tool. Remember INDEX asks for the area to look in and...
