Author Archives: garysch

Unknown's avatar

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com

Convert FLV, Flash Videos, to MP4 Using Handbrake

Posted on December 14, 2014 by garysch

At one point Flash videos were the way to watch videos on the Internet and I created loads to load up onto many websites for clients I created videos for. However, we want videos to play on many more devices … Continue reading →

Posted in video | Tagged , , , | Leave a comment

Useful Site of Excel Functions

Posted on December 11, 2014 by garysch

Excel is such a useful program but many people using it only scratch the surface. One of the most useful things about Excel are its functions for doing calculations. They are basically built in formula to work out everything from … Continue reading →

Posted in Excel, Excel Functions, Microsoft Office | Tagged , , , , | Leave a comment

Convert a Pages Document to Word or PDF

Posted on December 2, 2014 by garysch

Pages is such a useful app, and nicely priced too. It has the advantage of connecting up with the iCloud which means I can work on documents on my Mac, iPhone or iPad. It all seems to work seamlessly. However, … Continue reading →

Posted in Pages, PDF, word | Tagged , , , | Leave a comment

Mail Merge Using Microsoft Word and Excel

Posted on November 2, 2014 by garysch

We see it everyday, personalised emails, letters and brochures sent to us. It makes it feel like someone has made the extra effort to write to us. As it happens this is quite easy to do using a feature in … Continue reading →

Posted in Excel, Microsoft Office, microsoft word, Office 2010, word, word 2010 | Tagged , , | 1 Comment

A Quick Look at Instant Hotspot and Handoff on Your iOS Device and Mac

Posted on October 25, 2014 by garysch

One of the things that really used to bug me was if I was out and needed to connect my MacBook Pro or iPad to my iPhone so I could go the internet. I know wifi is in a lot … Continue reading →

Posted in Handoff, Instant Hotspot, iOS, iOS 8, iPad, Iphone, iPhone 6, iPhone 6 Plus, mac os x, Yosemite | Tagged , , , , , , , , , , | Leave a comment

How to Use the SUMPRODUCT Function in Excel

Posted on October 19, 2014 by garysch

Many people will have at least two columns or rows of numbers that first need multiplying together and then totalling up. In most cases they will create a formula that multiplies them together and then use the SUM function to … Continue reading →

Posted in Excel, Excel Functions, Microsoft Office | Tagged , , , , , | Leave a comment

Swapping SIM and Keeping Number

Posted on September 21, 2014 by garysch

SIM swap O2

Posted in Uncategorized | Leave a comment

The iPhone 5S is Still a Good Phone

Posted on September 19, 2014 by garysch

As people scramble to get the latest iPhone 6 and iPhone 6 plus there are many who are just getting into the idea of getting an iPhone like my aunt. She’s retired and is really embracing the iPad she has … Continue reading →

Posted in Iphone, iPhone 5S, iPhone 6, iPhone 6 Plus | Tagged , , | Leave a comment

iCloud Backup Extra Space

Posted on September 18, 2014 by garysch

I have been using iCloud to back up my iOS devices like my iPhone and iPad and needed more than the free 5GB capacity. Although this works for many my devices needed more than that. I always felt it was … Continue reading →

Posted in iCloud, iOS, iOS 7, iOS 8, iPad, Iphone | Tagged , , | Leave a comment

iOS 8 Features

Posted on September 17, 2014 by garysch

Are you ready for iOS 8. Hope you’ve backed up you iOS device already or at least do it before you upgrade. Anyway as it is due out today I thought I’d point out some of the features that perhaps … Continue reading →

Posted in iOS, iOS 8, iPad, Iphone | Tagged , | Leave a comment