Posts in MS Office Tips

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

How to Summarize Data in Excel Using Consolidate Command

How Tos MS Office Tips Tips & Tricks Windows Tips

Suppose you have a bunch of Excel data that are totally similar but needs to be created individually for some valid reasons. A good example is a purchase order. These POs can be created in individual sheets within one workbook, or spread across various workbooks. And in the course of time, you might want to collate the summary information to see how many of which inventory are moving in your business. The easiest way to collate such data or information is to use the Consolidate feature of Excel. Here are… Read More

How to use INDIRECT function to create references to other Excel files

How Tos MS Office Tips Tips & Tricks Windows Tips

MS Excel has a vast array of built-in functions that you can use in your formulas to manipulate your data. The main Excel function that I will demonstrate in this article is the INDIRECT function. This is a nice piece of tool to easily create references to external Excel files in your formulas. The INDIRECT worksheet function of MS Excel returns the contents of the specified reference and displays its contents. The INDIRECT worksheet function can be used to create “linked references” to other workbooks. Using the INDIRECT function, you… Read More

MS Outlook: How to remove published calendars to stop Outlook prompt to sign in

Email Tips How Tos MS Office Tips Tips & Tricks

There are a lot of MS Outlook users that are using calendar for their various calendaring activities. However, due to various sync problems especially when calendars are published online and accessed by multiple devices, MS Outlook can become erratic. Though these procedures were done using Outlook 2007 and 2010, they could still be applicable in the newer versions of Outlook. One major problem with MS Outlook calendars is when a Windows Security pop up appears asking you to enter your username and password. And when you attempt to sign in,… Read More

How to Easily Extract Images and other Embedded Files from DOCX, XLSX and PPTX files

How Tos MS Office Tips Tips & Tricks Windows Tips

Have you ever wondered how you can easily extract the embedded images, graphs, illustrations or drawings in your MS Word document, your MS Excel workbook, or your MS PowerPoint presentation files? With embedded images, you might explore copying the image and pasting it to MS Paint and then saving each one at a time. This conventional process is tedious and time consuming. Imagine if your MS Word document has 50 embedded pictures in it. You need to copy 50 times, paste to MS Paint 50 time, and then save the… Read More

Microsoft Word: Printing extra page showing Filename, Directory, Template & other stuffs

How Tos MS Office Tips Tips & Tricks

If you are having trouble printing your MS Word document because there is always an extra page printing last, the page which contains text information about the Filename, Directory, Template and other related information, the problem is not with your printer, not with your printer settings or the document being printed. The problem is in your MS Word settings itself. The screen shot below is an example of an extra page that is printed by MS Word each time you print your document: If you are seeing this extra page… Read More

Microsoft Excel Tips: How to calculate the number of days, months or years between two dates

How Tos MS Office Tips Tips & Tricks

One of the fundamental questions that Excel users may find themselves asking is “How to calculate the number of years, months, or days between two given dates?” This article will show the ways or methods in calculating days, months or years between 2 given dates. There are certain situations when you want to know the number of days, months or years. For instance, in computing rentals or amortizations, in comparing usage or consumption, and many other scenarios, knowing how to calculate the days, months and even years will be vital…. Read More

Microsoft Excel Tip: How to lock cells and make them un-editable

How Tos MS Office Tips Tips & Tricks

There are certain times and conditions when you feel the need that other people can only edit or add and modify data from selected cells in your Excel sheet. The rest of the cells in the sheet or workbook must be un-editable. Example of these Excel sheets are survey questionnaires wherein other people can just input their answers but not alter the questions. Others can be a fillable form wherein other people can just enter their personal or other information but the form content and layout are locked for editing…. Read More