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

How to Take a Better Selfie

Posted on April 26, 2014 by garysch

So many of us enjoy taking photos and video and this includes taking of ourselves too, yes, selfies. The word that has now made it into the Oxford English Dictionary, who would have thought. Selfie, short for self portrait, seems … Continue reading →

Posted in camera, digital photography, Iphone, photography, Samsung Galaxy S4, Smartphone, social media | Tagged , , , | Leave a comment

Scam: Phone Call Telling You That There is a Problem with Your Windows PC

Posted on April 18, 2014 by garysch

If you get a call saying you have a problem with your Windows computer just hang up. I’ve heard of people getting calls like this before but it happened to me today and I knew exactly what they were up … Continue reading →

Posted in Technology, windows 7, Windows 8.1 | Tagged , | Leave a comment

Photography: Using a Polarizing Filter

Posted on April 17, 2014 by garysch

This week I had to photography something in a glass cabinet, this can be tricky due to reflections and glare off the glass. To reduce this I used a polarising filter. Polarizing filters help reduce glare and reflections off water … Continue reading →

Posted in digital photography, dslr, photography | Tagged , , , | Leave a comment

Syncing Office for iPad with Your Mac

Posted on April 16, 2014 by garysch

If you have got Office for iPad you’ll have soon realised how useful it is and in my opinion better than the other programs that try and use Office files like Word, Excel and PowerPoint. You’ll also have noticed it … Continue reading →

Posted in Excel, iPad, Microsoft Office, PowerPoint, word | Tagged , , , , | Leave a comment

Excel: Inserting, Editing and Deleting Comments

Posted on April 12, 2014 by garysch

Excel can contain lots of information and sometimes it would be handy to add a note to various cells within the worksheet as reminders, things to check, how you created a formula or even where you got the resources for … Continue reading →

Posted in Excel | Tagged , , , , , | 1 Comment

Protecting Worksheets in Excel

Posted on April 6, 2014 by garysch

Protecting worksheets in Excel allows you to stop anything being changed on a worksheet or specifying that particular cells can be changed whilst others cannot. This is very useful if you want to make sure that certain cells are not … Continue reading →

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

Excel: Formatting Numbers – How to Set Decimal Places

Posted on March 25, 2014 by garysch

If you have entered a number that has a number of decimal places or you have a result from a formula and it has a number of decimal places you might want to set the number of decimal places. You … Continue reading →

Posted in Uncategorized | Leave a comment

Formatting Dates in Excel

Posted on March 21, 2014 by garysch

If you add a date to Excel it may not come up the way you want it to look. It is pretty clever it usually remembers the way you typed in the date and remembers the format, the problem is … Continue reading →

Posted in Uncategorized | Leave a comment

Creating a Good Password

Posted on March 20, 2014 by garysch

If someone gets hold of your password they can do a lot of damage to you or your business. This can be taking control of email, website, bank accounts, you name it. The damage can be to your reputation if … Continue reading →

Posted in Uncategorized | 2 Comments

How to Use Excel PivotTables

Posted on February 17, 2014 by garysch

Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick … Continue reading →

Posted in Excel, Microsoft Access, Microsoft Office | Tagged , , , , | 1 Comment