At work, our team has recently started to offer eLearning courses. These courses are “bite-sized” (typically 15-20 minutes) modules, covering topics such as File Management, Excel formulae and setting mailbox permissions in Outlook.
Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand. Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope [...]
The Save As PDF command in MS Office 2007 allows you to create a PDF from a Microsoft Office document even if you haven’t got Adobe Acrobat installed. However, if the Office document contains images (and the images have been inserted using the Insert > Image command rather than copy and paste), the image in [...]
I’ve been asked a couple of times lately how to mirror text in PowerPoint 2007.
Although I started using a Mac in 2006, I still work in a Windows world so in order to keep my hand in, I decided I’d install Windows 7 – as a virtual machine inside VMWare Fusion, although the fact that I’d agreed to deliver a presentation on running Windows 7 in a virtualised environment [...]
I recently received a call from a customer who was having a problem creating hyperlinks in PowerPoint 2007. She had a slide which was, in essence, a table of contents in that it contained links to all the other slides in the presentation. However, there was one hyperlink that would not work.
As a user of iCal (at home) and Outlook (at work) it would be incredibly useful to be able to display my work calendar in iCal (and via a Mobile Me sync, on the iPhone too). I don’t need the ability to sync – it is really just a case of wanting to have my [...]
When it comes to taking screen captures, Windows users have had to rely on the PrintScreen key or purchase/download a third-party application. My favourite app for taking screen captures on Windows is Hypersnap, although there are several others – some are free and some are paid-for.
One of the features of Excel is the ability to hide cells. However, if you copy a range that contains hidden cells and paste the selection elsewhere, you get all the rows including the hidden ones. This short tutorial will show you how to copy just the visible cells.
Today was my last day at work for 2008 and so I’d set aside some time for those end-of-year-admin jobs…empty my Inbox (no I didn’t just press CTRL + A and hit the Delete key, nor did I move everything to a “do not process until 2009″ folder), tidy my “My Documents folder, set my [...]