Advanced Functions Playlist

Excel Video 171 CHOOSE

You can’t CHOOSE an easier function to get started with Lookup & Reference functions than Excel Video 171. ...

Excel Video 172 Hyperlinks

Here’s a hyperlink to the discussion on hyperlinks in Excel Video 172. We’ll talk about the HYPERLINK...

Excel Video 173 reviews VLOOKUP, one of the most powerful Excel functions for medical practice managers. I...

VLOOKUP’s a great function, but when you try to copy a VLOOKUP formula, watch out for a gotcha you’ll see...

Excel Video 175 tackles HLOOKUP. HLOOKUP is very similar to VLOOKUP, so similar in fact that we’ll use the...

In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula,...

Excel Video 177 demonstrates an easy way to add a drop-down selection box to your worksheet. All of the...

Excel Video 178 introduces INDEX, a more flexible lookup function than VLOOKUP or HLOOKUP. One of the...

Watch Excel Video 179 to get started with MATCH, a flexible Excel function that can add power to other...

Excel Video 180 combines INDEX and MATCH to create a powerful, flexible lookup tool. Now that we’ve seen...

Excel Video 181 takes our INDEX and MATCH discussion one step further. Last time we used the MATCH function...

There are two tricks to watch for in Excel Video 182. First, we’ll use the fourth section of the INDEX...

Excel Video 183 uses INDEX and MATCH to look up which payer has the highest and lowest reimbursement for a...