Date Archives October 2023

How to Change or Update your Gmail Password

Email Tips How Tos Tips & Tricks

Everyday thousands of email accounts are being hacked or compromised. This figure includes Yahoo Mail, Hotmail, AOL, Gmail, and many others. One of the basic step or best practice to secure your email account is to change your password regularly. This article shows how to change the password in a Gmail account. Remember to always use a strong password so that your account will take thousands or millions of years for a hacker to hack. For more information about creating secure passwords, read this article. Changing your Gmail Password You can… Read More

How to Check your AOL Subscription Bill

Email Tips How Tos Tips & Tricks Windows Tips

One way to keep your online subscriptions healthy and in good standing is to ensure that you are paying your accounts payables on time, whether online or other means. This is true for AOL service subscription as well. In order to keep your AOL subscription in good standing, make it a habit to check your bill and make the necessary payments. The following procedures will describe how to check your AOL subscription billing. First, it is recommended that you use a web browser like Internet Explorer, Google Chrome, Mozilla Firefox… Read More

How to Block Pop-up Windows in Mozilla Firefox

How Tos Tips & Tricks Windows Tips

Mozilla Firefox is one of the most widely used web browser in the world. Besides from being free, it is fast, reliable and is supported by several functionality expanders called plugins or add-ons which like Firefox, are also free. Even if Firefox is a stable and always up-to-date browser, it is still prone to the attacks of malicious websites. Most attacks are in the form of unwanted advertising through pop-ups. In order to protect your Firefox browser from these annoying pop-ups, you can configure it to block all pop-ups and… Read More

How to remove WinZip Registry Optimizer malware

How Tos Tips & Tricks Windows Tips

WinZip Registry Optimizer is basically not a malware, it is a legitimate registry cleaner. However, it is a troublemaker for most Windows users, it is not a recommended tool. A better registry cleaner could be CCleaner from http://piriform.com. If you are infected by a copycat, fake WinZip Registry Optimizer, which is a malware, here are the things that you can notice or observe: Do these sound familiar? To completely remove the infection, here are the steps: A. Boot your computer into Safe Mode with Networking Step 1: Turn ON your computer or… Read More

How to extract whole numbers from decimal digits in Microsoft Excel

How Tos MS Office Tips Tips & Tricks

In daily spreadsheet tasks, you will encounter various types of data. Suppose you have a column of numeric data of formatted in 3 decimal points like the table below: Suppose you need to use the WHOLE number parts of the data in column C (Average) in the table above, how would you do it? Using the Round Function If you vaue the decimal digits of your data and want to include them in the computation of the resulting whole numbers, you need to use the ROUND() function. In Excel, the… Read More

How to extract the unique values or data in a column with duplicate data

How Tos MS Office Tips Tips & Tricks

Suppose you have a spreadsheet at work and one of the columns contain a huge list of account numbers being exported from your company’s accounting system that contains a lot of duplicates. And you are tasked to extract the UNIQUE account numbers in this huge list. If the list is just a short one, like 50 rows or 100, you can easily use the Conditional Formatting that highlights all duplicates, then you can manually delete the highlighted duplicates until no marked cells are left. This can be done easily with… Read More

How to recover deleted contacts in Gmail

Email Tips How Tos Tips & Tricks

One of the problems that Gmail users like you are facing is when they find out that their contacts are missing. This normally happens when your Gmail account is hacked or compromised. The hacker could have deleted emails and contacts giving you the headache. To recover the deleted contacts, please do the following steps: Step 1: Go to this link and then sign in to your Gmail account: http://gmail.com Step 2: When signed in, click on the Gmail link right below the Google icon or logo Step 3: In the pull-down menu that shows… Read More

How to multitask in Yahoo Mail using email tabs

Email Tips How Tos Tips & Tricks

Since the upgrade of Yahoo Mail to its new interface or look-and-feel, emails only display in the main window. When you open other emails, the previously opened one will be replaced with the new one. This is not as productive if your work is dependent on some amount of emails. That is, if you receive and process hundreds of emails everyday, this behavior will badly affect your performance. You might end up buying an email program like MS Outlook 2013. Now, Yahoo Mail offers tab browsing of emails. That is,… Read More

How to extract text to the right of a character in Microsoft Excel cells?

How Tos MS Office Tips Tips & Tricks Windows Tips

Suppose you have a list of text data in Excel columns that you want to work with and you need to extract only a portion of the text following a specific pattern. This pattern can vary, like a specific character, a particular number of characters, or whatever your actual data is. It is the very first and important step that you can decipher the actual pattern of your data so that you can build the correct formula to manipulate the data. See for instance the sample column of data below:… Read More

How to Enable and Disable System Icons in the System Tray in Windows Computer

How Tos Tips & Tricks Windows Tips

In the default Windows installation, basic functions and settings are already in place. Among these are the system icons located in the system tray or the items shown in the far right of the taskbar of Windows. When you install software programs in your computer, some of them automatically create their corresponding icon in the system tray. Over time, and as you install more of these programs, your system tray will be filled with various icons. To manage your system icons in your system tray, here are the steps: Step… Read More