Category Archives: Uncategorized

Protecting Your Computer from Cyber Attacks

Posted on June 3, 2014 by garysch

I’m sorry if I sound like a broken record but the news is regularly alerting us to threats to steal our information, access our bank accounts or take control of our computers. So what do you do about it? Well … Continue reading →

Posted in Uncategorized | Leave a comment

How to Turn a Custom Function into an Add-In

Posted on June 1, 2014 by garysch

Custom functions as you will gave seen from my previous post are really useful, however, you may want to make them available to all of your workbooks or distribute them to other people such as colleagues or classmates. To do … Continue reading →

Posted in Uncategorized | Leave a comment

VBA: Understanding Variables

Posted on May 27, 2014 by garysch

If you are getting into macros then you need to know about programming in Visual Basic for Applications (VBA) and with that you need to know about variables. VBA is a great tool for automating so many tasks in Microsoft … Continue reading →

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, PowerPoint, Uncategorized, VBA, Visual Basic for Applications, word, word 2010 | 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

Excel: Using Data Tables

Posted on January 13, 2014 by garysch

Analyzing data in Excel is one of its great features and there are a number of tools for doing this, aside from sometimes just changing a value and seeing what happens. If you have done this then there is an … Continue reading →

Posted in Excel, Uncategorized | 1 Comment

Excel: Using the HLOOKUP Function

Posted on December 23, 2013 by garysch

Some time ago I did a tutorial on VLOOKUP and have finally got around to doing one on the HLOOKUP function. It is very similar except that the data is in columns as opposed to rows as you would find … Continue reading →

Posted in Uncategorized | Leave a comment

How to Get Your Apps, Music, Movies and TV Shows Back on Your iPhone and iPad

Posted on August 29, 2013 by garysch

Have you bought a new iPhone or iPad, perhaps you have deleted an app, song, movie or TV show you didn’t mean to or just have had to restore the device and need to get this content back. Well thanks … Continue reading →

Posted in Uncategorized | Leave a comment

Sharing Files and Folders Using Dropbox

Posted on May 13, 2013 by garysch

Dropbox is an excellent tool for storing files online, in addition it is also really easy to share files and folders with family, friends, clients and colleagues. If they have a Dropbox account then they can share the same folder … Continue reading →

Posted in Uncategorized | Leave a comment