
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 VLOOKUP Review
Excel Video 173 reviews VLOOKUP, one of the most powerful Excel functions for medical practice managers. I...
Excel Video 174 COLUMN with VLOOKUP
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 HLOOKUP
Excel Video 175 tackles HLOOKUP. HLOOKUP is very similar to VLOOKUP, so similar in fact that we’ll use the...
Excel Video 176 ROW with HLOOKUP
In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula,...
Excel Video 177 Drop-Down Selection Box
Excel Video 177 demonstrates an easy way to add a drop-down selection box to your worksheet. All of the...
Excel Video 178 INDEX
Excel Video 178 introduces INDEX, a more flexible lookup function than VLOOKUP or HLOOKUP. One of the...
Excel Video 179 MATCH
Watch Excel Video 179 to get started with MATCH, a flexible Excel function that can add power to other...
Excel Video 180 INDEX and MATCH
Excel Video 180 combines INDEX and MATCH to create a powerful, flexible lookup tool. Now that we’ve seen...
Excel Video 181 INDEX and MATCH x2
Excel Video 181 takes our INDEX and MATCH discussion one step further. Last time we used the MATCH function...
Excel Video 182 INDEX with Areas
There are two tricks to watch for in Excel Video 182. First, we’ll use the fourth section of the INDEX...