If you have been using Hotmail for a long time and you are now faced with the new Outlook.com interface, with its great feature set, you might be overwhelmed. One important feature in particular, you might be complaining about your emails stacked in groups. This is called “conversation” mode of display. Compared to the old classic Hotmail, when people sends you emails and you reply to each of them, each email received is listed individually. With this new Outlook.com feature, it is now listed in “conversation” view. See the screen… Read More
Date Archives October 2023
How to count or calculate “unique” data in Excel (count duplicate data once)
Have you ever faced an Excel situation wherein you need to count or calculate rows and columns of data uniquely? Or in other way of saying — to count duplicate data only once? This can done using “Pivot Table” approach, but Excel also has several formulas that you can exploit to come up with the same results. Suppose you are operating an online store. Your website’s back-end e-commerce system reports sales per item and per day, like the table below: Suppose further that you want to know how many unique… Read More
How to Defragment Drive C
As your computer is used, many times data are written to your hard disk drive. These happen when you create a file and save it to your hard drive, when you copy files from external drives like portable hard disk drives or USB Flash drives, when you download files from the internet, and many other sources. On the other hand, many times data are also removed or deleted from the disk drive. These happen when you delete a file or files and moved them to your Recycle Bin, when you… Read More
How to combine text in Excel cells so easily
Suppose that you are working with an Excel sheet where a column of cells contain various text entries. And one of your tasks is to combine the text contents of the cells into one summary cell. How are you gonna do it in Excel? What formulas or functions will you be using? Using CONCATENATE Function When working with text in Excel, CONCATENATE function will simply combine the contents of cells into one. The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers,… Read More
How to completely remove Ask.com toolbar and nuisance from your Windows computer
You might wonder how in the world you got the Ask.com thingy that annoys you when you browse the internet. Ask.com is a legitimate toolbar and you can get it in many ways. However, removal of this thing can be tricky or troublesome. A. Uninstall Ask.com Toolbar from Control Panel First, go to your Control Panel and open Programs and Features to see the list of all programs installed in your computer. Normally, Ask.com will not be listed there. But check for any program in the list where the “Publisher”… Read More
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