Select Page

August 2019 Trend Payer Mix

Podcast: Play in new window | DownloadSubscribe: Android | RSS There are two ideas in today’s BIG Ideas podcast based on a visit I made to a practice in the Southeast last week.  First, their data was in the cloud, which often makes it difficult to get the...

Excel Video 78 Data Tables

Excel Video 78 explains Data Tables. Data Tables are an easy way to show the data you’re charting as part of the chart. The more features you add to a chart, less room there is for the actual chart. Watch Excel Video 78 to see how to include the Chart Legend as part...

Excel Video 69 VLOOKUP x 2

Truth in advertising. Excel Video 69 is more complicated than most of these videos. I have a detailed table of partner’s equity transactions during the year and want to write one formula to pull specific rows and columns out of the detailed table to get a summary of...

Excel Video 68 Nesting Functions in VLOOKUP

Excel Video 68 shows how to nest functions, or put a function inside another function, in Excel. VLOOKUP is a powerful function, but it is even more powerful if you can combine other Excel functions inside VLOOKUP. In Video 68, we have a table of patients and ICD-9...

Excel Video 67 VLOOKUP in Two Tables

Excel Video 67 is a practical example of how an anesthesiology practice uses VLOOKUP in two different tables to make sure they aren’t missing any patients. Every month the practice compares a hospital report of patients treated to a practice report of patients treated...

Excel Video 66 When VLOOKUP is True

Excel Video 66 shows an example when you’ll want to find an approximate match (TRUE) instead of an exact match (FALSE) with VLOOKUP. The example shows some patient satisfaction scores from a survey. The survey answers range from 1 to 5, but the values go out to one...