How to Use Symbols and Special Characters in Excel

Jan 25, 2010 View Comments by Gilberto J Perera

The use of Special Characters is probably one of the least frequently accessed features in Excel, nevertheless it requires special attention because everyone should know how to insert special characters while using Excel, Word, PowerPoint, and other applications. We live in a world where everything is copyrighted, trademarked, and patented…so it is important that we [...]

How-to Read more

Use AutoFill and Save Time Entering Data in Excel

Jan 25, 2010 View Comments by Gilberto J Perera

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 [...]

How-to Read more

Use Validation Lists in Excel to Control User Input

Jan 25, 2010 View Comments by Gilberto J Perera

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 [...]

How-to Read more

Upload Your Picasa Photos to Facebook in a Snap

Jan 24, 2010 View Comments by Gilberto J Perera

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 [...]

How-to Read more

How to Configure and Use Video Chat in Gmail

Jan 19, 2010 View Comments by Gilberto J Perera

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 [...]

How-to Read more

How to Display Multiple Excel Windows in the Taskbar

Jan 07, 2010 View Comments by Gilberto J Perera

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 [...]

How-to Read more

How to Access God Mode in Windows 7

Jan 04, 2010 View Comments by Gilberto J Perera

While going through my RSS feeds this morning I found a very interesting article from Paul Thurott on his Supersite blog about Windows 7 God Mode. As soon as I got a chance I tested the instructions he provided and can confirm that there is indeed a God Mode that is available in Windows 7. [...]

How-to Read more

Help Me Spread Awareness About Fake Virus Scanner Scams

Dec 08, 2009 View Comments by Gilberto J Perera

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 [...]

How-to Read more

Use Rollip to Enhance Your Photographs Online

Dec 08, 2009 View Comments by Gilberto J Perera

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 [...]

How-to, Reviews Read more

Use Jump Lists in Windows 7

Dec 07, 2009 View Comments by Gilberto J Perera

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 December [...]

How-to Read more