by Nate Moore | Jul 13, 2011 | Functions
VLOOKUP’s a great function, but when you try to copy a VLOOKUP formula, watch out for a gotcha you’ll see in Excel Video 174. When you copy most formulas in Excel, Excel updates the references as you copy. That’s not true with VLOOKUP. When you copy a VLOOKUP formula,...
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...
by Nate Moore | Jun 29, 2011 | Functions
It won’t take HOURs to explain HOUR, MINUTE, and SECOND in Excel Video 170. All three functions are very simple. The format is = HOUR(cell reference). MINUTE and SECOND work the same way. You’ll see how I use each of the three functions to pull the respective piece of...