Excel 2013: How To Use Conditional Formatting

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...

Convert a PDF to Excel

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...

Adding Up Time Over 24 Hours

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...

Perfectly Time Your PowerPoint Narration

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...

4 Awesome Features of Excel 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...

Understanding VLOOKUP and HLOOKUP

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...