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 [...]
I have recently become a book addict. For anyone who knows me well, you can pick yourself up off the floor now – I hardly ever read books unless the subject involves Manchester United (although I did once pick up John Grisham’s The Firm and couldn’t put it down).
This morning one of my colleagues asked what time it was in a certain part of the world. I typed the name of the place followed by “Current Time” into the Google search box. Google responded by displaying the current time for that location above it’s normal results list.
Absolute cell references allow you to “fix” part or all of a cell reference in a formula. This can be a great time-saver when copying formulas, however, there is more to it than meets the eye…
Using a combination of the ROW and MOD functions and Conditional Formatting, you can easily shade alternative rows in Excel, making a list of data easier to read.