As a frequent user of Excel I find that one of the most useful features is AutoFill. When preparing spreadsheets for presentations or when your organizing data to keep a sense of sanity, AutoFill will simplify that task. AutoFill will ensure data integrity and will maintain order when data series require it. In the example…Continue Reading

If you create spreadsheets in Excel and would like a way to ensure that data entered by others is consistent, you can use data validation lists to specify the items that can be entered into a specific cell. Data Validation lists work by allowing users to specify a list of data that is allowed in…Continue Reading

If you use Picasa to manage your photos and Facebook to share them with friends and family, then you definitely need to follow this guide, it will make your life simpler. Picasa uploader is simply a button that is added to Picasa’s menu that allows you to upload pictures directly to Facebook using Picasa, no…Continue Reading

If there is one thing I absolutely love about Google products it’s their simplicity and integration, instead of installing a third-party application or manufacturer’s clumsy software you can use your webcam with Gmail within a browser window to chat with friends using video. The how-to below will walk you through the steps necessary to configure…Continue Reading

I often work with multiple Excel windows at any given time and I have found that I work best with Excel when all open windows are displayed on the Windows Taskbar (see screenshot below for illustration). The default setting for this feature groups all Excel windows (or workbooks) into one Taskbar button. This can be…Continue Reading

Do you want total control over every aspect of Windows 7? You need God Mode. The guide below will show you how to create the necessary shortcut to access God Mode on your Windows 7 machine. If you have any insight about this feature or find anything interesting, please share and post it the comments…Continue Reading

In an effort to educate computer users about the potential dangers of fake virus scanner pop-ups and how to close the pop-ups without infecting their computers I put together a one page PDF that summarizes the threat and lists some steps to help mitigate its impact. The idea came from a similar campaign that was…Continue Reading

The other day I came across Rollip.com, a very easy to use online photo manipulation site that allows users to choose from 40 different filter effects ranging from vintage effects to black and white conversion. I found the website fast and easy to use. I personally like to use programs like Picasa to do my…Continue Reading

Now that we’ve become familiar with the components of the Taskbar, lets discover some of the new and exciting features Microsoft included with the Windows 7 Taskbar. In this section we’ll cover Jump Lists. The following is part of a series of articles that will mirror an electronic book that I’m set to release in…Continue Reading

If you use Google Calendar as frequently as I do then you need to be familiar with all methods of retrieving your calendar information. Google Calendar provides users with various methods of viewing calendar information. One such method involves SMS or Short Message Service (text messages) which can be sent to a designated Google number…Continue Reading

Before we jump into the Windows taskbar how-to’s let’s review what the taskbar is and the components that make up this powerful desktop component. The following is part of a series of articles that will mirror an electronic book that I’m set to release in December of this year. The eBook’s main focus will be…Continue Reading

The how-to below is a email request from one of the readers of GilsMethod.com. The readers asks; Gil, when I have several word document windows open my OS/Computer tends to make them all one tab instead of separating them. how can I make them separate? Windows Vista has a setting that allows you to group the same…Continue Reading