Jan 20, 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...
Jun 23, 2013
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...
Feb 23, 2013
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,...
Jan 15, 2013
**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...
Nov 4, 2012
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...