by Nate Moore | Jul 11, 2011 | Functions
Excel Video 173 reviews VLOOKUP, one of the most powerful Excel functions for medical practice managers. I initially covered VLOOKUP starting with Excel Video 61. Now that we have more background there are several more tricks we can use to make lookups even more...
by Nate Moore | Jul 6, 2011 | Functions
Here’s a hyperlink to the discussion on hyperlinks in Excel Video 172. We’ll talk about the HYPERLINK function first. It’s pretty straightforward, but inserting a hyperlink from the Insert tab on the ribbon is even faster. The reason I show you the HYPERLINK function...
by Nate Moore | Jul 4, 2011 | Functions
You can’t CHOOSE an easier function to get started with Lookup & Reference functions than Excel Video 171. The CHOOSE function simply gives Excel which number in a list of items to choose from. You can enter up to 254 items in the list and tell Excel which item...
