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

Excel for iPhone

Microsoft recently released Office Mobile for iPhone. It’s free but is currently only available to Office 365 subscribers. Three apps are currently supported – Word, PowerPoint and Excel In this first version, functionality is very basic, but Microsoft has...

Define a Validation List Using a Name

When creating a validation list, it is often neater to store the source of the list on a separate worksheet, away from the main data. In Excel 2007 and earlier, you can’t store the “list source” on a different sheet to where the list will be used,...

Sorting IP Addresses in Excel

**Download this tutorial (zipped PDF)** A question came up on my Twitter feed this week – how to sort a list of IP Addresses in Excel. On the face of it, this should be simple. However, because Excel treats the IP addresses as text strings, not numbers, the sort...

Shading Alternate Rows in Excel

In Excel 2007 and above, it’s easy to shade alternate rows by creating a Table. However in earlier versions it was necessary to use a combination of conditional formatting and the MOD function. Note that this method will work in 2007 and above as an alternative...