by Nate Moore | Jun 15, 2011 | Functions
Excel Video 166 reviews four very basic Excel date functions, but we can combine the functions to make rolling reports update automatically. DATE is a function that lets you enter the year, month, and day separated by commas. Excel turns that information into a date....
by Nate Moore | Jun 13, 2011 | Functions
Excel Video 165 uses the WEEKDAY function to calculate which days are weekends to help you figure out call. The only trick to the WEEKDAY function is deciding which day of the week you want to call day 1. I typically use option 2 so that Saturdays are given the value...
by Nate Moore | Jun 8, 2011 | Functions
DATEVALUE doesn’t get the tax returns of the date your daughter just introduced, but Excel Video 164 does show you how to use DATEVALUE to change text to a date. Just like Excel Video 162 changed text to values with the VALUE function, DATEVALUE changes text to a...
by Nate Moore | Jun 6, 2011 | Functions
NOW and TODAY sounds like the name of a bad soap opera, but they’re two functions to get the current date and time that we’ll discuss in Excel Video 163. The NOW function retrieves the computer’s date and time, while TODAY retrieves the computer’s date. Note that you...
by Nate Moore | Jun 1, 2011 | Functions
Excel Video 162 helps you convert text to values and values to text. Before Excel 2007, I used the VALUE and TEXT functions a lot more than I do now. I’ll show you what I do now to convert values to text and text to values, and then I’ll show you how to use VALUE and...
by Nate Moore | May 30, 2011 | Functions
Excel Video 161 helps you repeat helps you repeat text as many times as you want you want. I don’t use the REPT function as much as I used to, but there are a few instances when you may find it helpful. Essentially REPT repeats whatever text you enter (remember to put...