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...
by Nate Moore | Jun 27, 2011 | Functions
The time formatting we reviewed in the last Excel Video has a catch we’ll discuss in Excel Video 169. As long as there are less than 24 hours (or 60 minutes or 60 seconds), the formatting we introduced in the last Excel Video works just fine. As soon as you go over 24...
by Nate Moore | Jun 22, 2011 | Functions
Make the most of your TIME by watching Excel Video 168. I’ll cover three time related functions in this video. First, the TIME function lets you enter and/or calculate time in Excel, very similar to what we did with the DATE function in the last two Excel Videos. The...
by Nate Moore | Jun 20, 2011 | Functions
When we last left our heroes in Excel Video 166, we had a clever formula that automatically updated after entering data in one cell. In Excel Video 167, we’ll go one step further and automatically calculate that cell as well. When you open the spreadsheet now, all of...
