Category Archives: featured

Learn Photography

Photography is a very popular hobby and there are a few things you can do to improve your photographs. There are a few things that are the things you have to get right like correct exposure, sharp focus and keeping it steady.

There is also what you do with the photographs afterwards such as Photoshop and Lightroom. Knowing some basic techniques can make a huge difference. Photoshop can look daunting but I can assure you it does not have to.

Here some tutorials to get you started. We are adding to this list all the time.

Learn Word

This must be one of the most used programs both at home and at work. A lot can be done with Microsoft Word and many of you may just use a small fraction of its features.

Here are some tutorials that will help you use these features or give you some insight into what Word can do.


Mail Merge

  • Getting Started with Mail Merge – Word 2003 | Word 2010
  • Creating a Letter with Mail Merge –  Word 2003 | Word 2010
  • Creating an Email Mailshot using Mail Merge – Word 2003 | Word 2010



Other word processing tutorials


Pages for iPad

Learn Excel

Excel is a very powerful program that can do from the most basic calculations to advanced functions, it can create charts, do what-if analysis and help organise and interpret your data, and that is just scratching the surface.


Here are some Excel video tutorials to help you out.

Getting Started






  • 3D Formulas – Using values from different worksheets and workbooks in one formula
  • Formula Auditing – visually see how you created a formula with this useful tool





What-If Analysis


Macros and VBA (Visual Basic for Applications)

Getting Photos and Video from iPhone to Your Computer

Lets face it so many of us have a huge number of photos and video on our iPhones and iPads, it is just so tempting to click that shutter when we see something we like. The problem is we either want to back them up, and there is no doubt we should all do that, or just copy them to the computer so we can use them somewhere else such as in a video editor or Photoshop.

Some of you may email them to yourself which can take time, but there is a better way, here is how you can do it on a PC or Apple Mac

Here is a video to show you how.

Fix Problem with Handbrake

If you have Handbrake for ripping DVDs then you might need this fix to make it work. People who have used Handbrake sometimes say that their videos are broken up or pixelated.

Here is a solution that has worked for many people who have dropped me a line about it.

One thing that used to work is installing VLC from, VLC is a good video player that is free and available for Windows and Mac.


This fix will also help if you have been getting the error message “Your source may be copy protected, badly mastered or in a format which Handbrake does not support”

Here are the step by steps to get things up and running.

  1. Download and install the 64 bit version of Handbrake for Windows from Make a note of which folder you install it in. By default it is usually  C:\Program Files\Handbrake.
  2. You need a file which is libdvdcss.dll and you need the 64-Bit version which is available from VideoLan at and move or copy it to your Handbrake folder that you noted above.As mentioned it is usuallyC:\Program Files\Handbrake.
  3. The file you have downloaded is called libdvdcss-2.dll which needs to be renamed to to libdvdcss.dll in your Handbrake folder, this is the folder you just copied the file to.
  4. Now try it on a short clip, if you have one, to test it out. I use a short clip so that I can see if has worked without having to wait for a whole film to be converted.


Restricting Access for Children to iPhone, iPod touch and iPad

Children have a habit of doing things you don’t want them to whether it is surfing the Internet or downloading movies, TV shows or apps. On an Apple device like an iPhone, iPod touch or iPad they could be buidling up huge costs on your account. You can also set a monthly spend using iTunes which will help keep spending under control. Here I show you how to keep children safe on these devices and also keep your wallet in check. If you want to set up an iTunes account for a child without a credit card see this tutorial – click here.