Posts in Tips & Tricks

How to configure Gmail for POP3 and IMAP

When you are using a FREE version of Gmail, you can still add it to an email program like MS Outlook 2003/2007/2010, Mozilla Thunderbird and other email clients and be able to send and receive emails from their using POP3, SMTP and IMAP. Unlike Yahoo Mail, only paid versions called Yahoo Mail Plus can be added to a POP email client. If you want to add your Gmail account to your email client, whether it is MS Outlook 2003, 2007, 2010, Mozilla Thunderbird or others, you need to first configure… Read More

How to tell how long your Windows computer has been running

Have you experienced forgetting to turn off the computer that was left unused? Or using the computer for long hours that you worry if the hardware blows up with matching smoke and smelly fumes? Some computers, especially laptop computers can be used for long hours as they are not heating up so easily as compared to desktop computers. However, in case you need to inspect as to how long your Windows computer has been running, please do the following: If it has been too long already, you might decide to… Read More

How to share your Outlook.com or Hotmail.com Calendar

The calendar apps is now a built-in apps in computers and in other handy techy gadgets like tablets and smartphones. This means that you can easily have a calendar app in your device. This article describes how you can share your Hotmail or Outlook.com calendar. Reasons to Use a Calendar App Many people are using smart gadgets with free built-in calendar application but they did not even know about it. As a result, they just left the app unused. Here are some reasons why Calendars are useful in today’s inteconnected… Read More

How to Test Your Computer’s Memory (RAM) for Problems in a Windows computer

If you are using a Windows computer (Windows XP, Vista, 7 or 8) and you are getting this BSOD (Blue Screen of Death) on occasions, then one of the possible causes is a failing hardware component, especially the Random Access Memory or the so-called RAM. One way to test if your RAM sticks are causing your computer problem is by swapping your currently installed RAM sticks with your spare if you have some. With the spare RAM sticks installed, please observe if the computer is still freezing with the annoying… Read More

How to Set a Default Site URL for Every New Tab in Google Chrome

Have you been using Google Chrome when you browser websites or emails? Indeed, Chrome is one of the widely used and the fastest web browser that is free from Google. Besides being free and fast, it has cool features and add-ons to make your web surfing a better experience. The default behavior of Chrome is that, when you open it, it will not show any home page. Instead, it will show you a blank new tab. Basically, the page is not blank since it is showing Google as your default… Read More

How to Summarize Data in Excel Using Consolidate Command

Suppose you have a bunch of Excel data that are totally similar but needs to be created individually for some valid reasons. A good example is a purchase order. These POs can be created in individual sheets within one workbook, or spread across various workbooks. And in the course of time, you might want to collate the summary information to see how many of which inventory are moving in your business. The easiest way to collate such data or information is to use the Consolidate feature of Excel. Here are… Read More

How to Uninstall Windows Live Mail 2012

If you are using the latest version of Windows Live Mail – WLM 2012, then that is a good choice. Besides being free, it has a lot of features nearly comparable to commercial email clients like Microsoft Outlook 2007/2010. However, as you use it and your email accumulates, and when you install Windows Updates or MS Office updates, Windows Live Mail can behave erratically as an effect. Since Windows Live Mail 2012 is a Windows application, it is affected mostly by the changes you make in your Windows Operating System…. Read More

How to retrieve stored email passwords in Mozilla Thunderbird

Mozilla Thunderbird is one of the widely used email client today. Besides being free, it is fast, stable and reliable. However, as an email client, there are still people who want to access their emails in two ways: 1) using Thunderbird and 2) using a web browser. Using a web browser to access your email is very important for portability. Suppose that your Thunderbird is installed in your home desktop. When you are away from home, you need to use the web browser to access your emails outside Thunderbird. What… Read More

How To: Develop or write a proposal for a mobile app (native) for college IT course

Develop a proposal for a mobile app (native). The proposal will include: If you have such requirement in your College IT course, here is a sample proposal below. Apps Genie is pleased to submit a proposal for the development of a native mobile app to ABC Broadcasting Network. This proposal is valid for up to sixty days after being presented. Client Name Application Name: ABC Go! Apps Genie will design and develop a native mobile app for ABC Broadcasting Network. The native mobile app will be designed to provide their viewers access to current news and… Read More

How to use INDIRECT function to create references to other Excel files

MS Excel has a vast array of built-in functions that you can use in your formulas to manipulate your data. The main Excel function that I will demonstrate in this article is the INDIRECT function. This is a nice piece of tool to easily create references to external Excel files in your formulas. The INDIRECT worksheet function of MS Excel returns the contents of the specified reference and displays its contents. The INDIRECT worksheet function can be used to create “linked references” to other workbooks. Using the INDIRECT function, you… Read More