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.

Formatting

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

Options

Settings

Other word processing tutorials

Pages

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

Editing

 

Formatting

Printing

Formulas

  • 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

Functions

Data

Reviewing

Charts/Graphs

What-If Analysis

Options

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 videolan.org, VLC is a good video player that is free and available for Windows and Mac.

Windows

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 http://handbrake.fr/downloads.php. 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  http://download.videolan.org/pub/libdvdcss/1.2.11/win64/libdvdcss-2.dll 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.