Posts in MS Office Tips

Microsoft Outlook keeps prompting for password. Not using Exchange. I cannot access Credential Manager

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

There is a very common issue with Microsoft products: bugs. I am very sorry to single it out but reality speaks and I believe you also have “buggy experiences” with your Microsoft software. When it comes to Microsoft Outlook software, versions 2007, 2010, 2013 and later, some people got annoyed with a perpetual prompt for network password as shown in the image at the left. You might be reading this because you too are having the same problem. That is not surprising, as thousands of people are searching for a… Read More

Microsoft Office Tips: How to Install and Use Microsoft Office Organization Chart Creator

How Tos MS Office Tips Tips & Tricks Windows Tips

Some people are looking for organizational charting software to create the organization chart of their company or organization. Organizational chart software come in various forms: freeware, shareware, free trials and proprietary or commercial. There are also online org chart tools that allow you to create your chart using your web browser. However, whether you are trying to create a corporate organization chart, or an org chart of your small group, you can create these org charts in MS Word. There are 3 ways that you can do this in MS… Read More

How to Simply Move your Email Messages from Windows Live Mail to MS Outlook

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

If you are using Windows Live Mail and you have already accumulated a lot of email messages, you might wonder how you can transfer all your existing email messages to your MS Outlook when you decide to discontinue your Windows Live Mail. The process is straightforward especially if Windows Live Mail and MS Outlook 2007, 2010 or 2013 are both installed in the same computer. If MS Outlook is not installed on the same computer where Windows Live Mail is installed, the process detailed below is not applicable. Instead, you… 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 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