Suppose you want to adjust a project’s schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks. And you might be thinking now how you can do this as simple as possible…. …. and sometimes Excel Date’s seem a but of a mystery …. The DATE function is the solution. There are a lot of cool functions for dealing with dates in Excel. But this video shows you how to add Years, Months or Days [More]
This short video shows how to use the INDIRECT command in Excel to change the contents of a drop down list dynamically. This is an original Improve You Excel video that was originally recorded in Excecl 2003 but will work just as well in Excel 2007 and Excel 2010. The file used in this video can be download here I would love to hear what you think of this video – so please leave comments in the box below of use one of the social buttons on the right to register a positive vote for this video.
This video contains everything you need to know to have confidence with Excel Dates.  if  you sometimes find dates turn into long numbers or you have never tried to find the the difference between two sets of dates then this video is for you. The video initially talks about how Excel handles Dates internally and why it stores them as numbers.  It then goes on to tell you how to write equations to find the difference between two dates. On the way it also introduces you the ### problem in Excel and the shortcut key for entering today’s date into [More]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.