Posts in MS Office Tips

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 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 Add and Configure Yahoo! Mail in Outlook 2010/2007

Email Tips How Tos MS Office Tips Tips & Tricks Windows Tips

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 Check Your Mailbox Size in Microsoft Outlook 2010

Email Tips How Tos MS Office Tips Tips & Tricks Windows Tips

If you are using the well know and widely used email program – MS Outlook 2010 or the latest version, you might be enjoying its whole bunch of features. Indeed the product has evolved so much over the years. However, you need to monitor the size of your mailboxes so that they don’t get bloated over time. This is especially true if you have email accounts set up as POP or POP3. In MS Outlook, you have the option to add several email accounts. These email accounts also have the… Read More

Microsoft Word Tip: How to insert a Word file into another Word file to avoid copy and paste

How Tos MS Office Tips Tips & Tricks Windows Tips

There are certain times that we need to insert several pages or blocks of texts or paragraphs from one Word document to another. This is easily done using the conventional Copy & Paste method. But how about if you need an entire document to be appended to an existing Word document? In the scenario described, the copy and paste method can still be used since you can easily select all the text in the document and copy them, then paste them in the other document at insertion point. However, there… Read More

Microsoft Word Tip: Repair damaged and corrupted MS Word files easily and quickly

How Tos MS Office Tips Tips & Tricks Windows Tips

It is really frustrating when an MS Word file that you have worked for several hours, days or weeks will no longer open after MS Word gives an error message. This usually happens when MS Word crashed, or when your computer crashed while the Word file is still open. Repair Microsoft Word documents with ease. Easy Word Recovery offers step-by-step recovery for corrupted and erased documents made by all versions of Microsoft Word up to Word 2010. State-of-the-art Word repair algorithms enable surefooted recovery of badly damaged documents as well… Read More

Outlook Tip: Moving sent emails to Inbox

Email Tips How Tos MS Office Tips Tips & Tricks

When you are using MS Outlook of any version (2003, 2007, 2010, etc.), it is a common experience that when you send an email, a copy of the sent email is saved in the Sent Items folder. This is the default behavior. What if you want Outlook to move it to your Inbox folder so that you can keep an eye on the progress of your communication? If you are using MS Outlook in a business setup, you might want to place the sent email to your Inbox. For what… Read More

How to count or calculate “unique” data in Excel (count duplicate data once)

How Tos MS Office Tips Tips & Tricks

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 combine text in Excel cells so easily

How Tos MS Office Tips Tips & Tricks

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