YouTube Schedule Update

Just a quick update to let you know that I have added upload dates to the July schedule.  Check the YouTube page for details.

Posted in News and Updates | 5 Comments

Fun With (Excel) Dates

I have been asked how to go about extracting the actual date from a code that is in  a date format.   The intended outcome will be as shown below:

There are two important things to know.  One of them is that the code will always be entered in a consistent way.  The other is that you know which bit of the code is for the year, month and day (obviously).  In this example ’20110401′ the first 4 digits represent the year, the next 2 digits are the day and the final 2 digits are the month.  It doesn’t matter whether the code is entered as a number or as text, the following solution will work.

The Excel functions required are the date function DATE and the text functions LEFT, RIGHT and MID.  I’ll go into the use of these in a future video but, to cut to the chase Continue reading

Posted in Answers & Solutions | 1 Comment

YouTube schedule update

Hi. I’ve added a page that will detail my upcoming tutorials, so you’re not left wondering what’s coming next. Click here for the details (or click the YouTube tab above).

Posted in News and Updates | 2 Comments

Motion Training on Microsoft Excel, Access, PowerPoint – and other popular programs…

Welcome to the website of YouTube’s MotionTraining. This site will post regular updates about my channel and also contain useful help and information on a wide range of popular computer soiftware.

If you have found the video tutorials I have made helpful then I hope you will support my aims to build this site into a friendly and useful resource that will take away some of the day-to-day frustrations that using a computer – at work or home – can bring.

Some of the programs I have plans to produce training material on include:

Microsoft Office 2003, 2007 & 2010 (EXcel, Word, Access, PowerPoint, Outlook)
Adobe Photoshop
Adobe Indesign

On this site I will be selling training packages as well. Currenty I have one product, which is a Continue reading

Posted in News and Updates | 13 Comments