How Tos – Page 4 – Technical Forum

How to remove WinZip Registry Optimizer malware

How Tos Tips & Tricks Windows Tips October 28, 2023

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 October 28, 2023

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 October 28, 2023

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 October 27, 2023

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 October 27, 2023

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 October 27, 2023

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 October 27, 2023

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

How to Secure Your Gmail Account After Being Hacked

Email Tips How Tos Tips & Tricks October 27, 2023

Email accounts including the very popular Gmail are very vulnerable to hacking attacks that lead to account compromise. In fact, many Gmail users are simply using their Gmail accounts but are unaware that their accounts were already tampered or accessed by someone somewhere. There are several indications or manifestations when your Gmail account was actually hacked or compromised. For more information as to “How to Tell When Your Gmail Account Was Hacked or Compromised”, please refer to the suggested article. If you have confirmed that indeed your Gmail account was… Read More

How to Backup Windows Live Mail Emails? Where Are these Emails Stored?

Email Tips How Tos Tips & Tricks Windows Tips October 25, 2023

Windows Live Mail 2012 is the current version of Microsoft’s free email program that serves as the successor of the widely used Outlook Express in Windows XP. It was called Windows Mail in Windows Vista and then turned as Windows Live Mail as part of the free software suite called Windows Essentials 2012. If you are using Windows Live Mail, have you ever wondered where are your emails stored so that you can backup them manually? Yes, if you know the actual location of your Windows Live Mail emails, you… Read More

How to Add and Configure Yahoo! Mail in Outlook 2010/2007

Email Tips How Tos MS Office Tips Tips & Tricks Windows Tips October 25, 2023

There is a big change in Yahoo Mail that came with the changes that Yahoo made with their interface in the past few months ago. These days, FREE Yahoo Mail users can now use POP and SMTP email clients to access their emails. This feature was previously available for paid version of Yahoo Mail only. Prepare Your Yahoo Mail Account for POP/SMTP Access Allow your Yahoo Mail account first to be accessed using a POP email software like MS Outlook 2007/2010/2013, Windows Live Mail, Thunderbird, etc. This is done by… Read More