Tips & Tricks – Page 4 – Technical Forum

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

How to Add a New User Account in Windows 8 or Windows 8.1

How Tos Tips & Tricks Windows Tips October 25, 2023

If you just got your brand-new laptop or desktop today, chances are, your computer is shipped with the latest stable release of Windows 8. or Windows 8.1. In order to maximize your use of Windows 8/8.1, knowledge of basic Windows operations is of utmost importance. This article will describe how to add and manage user accounts in this new version of Windows. NOTE: These same procedures also apply in Windows 10 and 11 computers but the screenshots are made from a Windows 8.1 machine. How to Add and Manage User… Read More

How to Avoid Email Scam and Spam

Email Tips How Tos Tips & Tricks October 25, 2023

The email population is getting bigger as many people are getting or subscribing to an email account or accounts everyday. Also, there are several email providers today that allows people to create an email account with them for free. Gmail, Yahoo Mail, Hotmail and AOL are among them. This is also the main reason why hackers and spammers are targeting emails since hundreds of millions of people are using emails. Therefore, with this great number of emails out there, the more email addresses that the hacker can scrape the web… Read More