28 Jan 2014
Conditional Formatting enables you to apply formatting to a cell (for example, background colour, font, text colour, bold, etc) if a condition or set of conditions are true. For example, “apply a red background to A1 if it contains the word COMPLETE and a green...
26 Jan 2014
All recent versions of Excel have the ability to create a PDF of your spreadsheet without requiring 3rd Party tools. In this short video tutorial, in addition to demonstrating how to do this, I also show how to convert a PDF into an editable Excel file using a free...
23 Jan 2014
A question that is often asked is “when I add up times and the total comes to more than 24 hours, why does it not show correctly?”. To answer this, I’m using a timesheet as an example: **Download the spreadsheet here** My working day is split into 2...
20 Jan 2014
Yesterday I was creating a piece of elearning using Adobe Captivate. I had a file that consisted of 33 slides along with a 6 minute MP3 of my narrative. When viewed by end users, the eLearning had to move from one slide to the next with no intervention from the...
6 Apr 2013
Microsoft recently released Excel 2013 for Windows. The application contains a whole slew of new features. I’ve produced 4 free short video tutorials that cover the key features: Flash Fill – this is awesome! Timeline Slicers Quick Analysis Pivot...
24 Mar 2013
In this tutorial of almost 20 minutes, I show you: – Several practical examples of when and how to use the VLookup and HLookup functions – The differences between the 2 functions – The difference between TRUE and FALSE (4th Argument) The video was...
