Posts in MS Office Tips

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

Microsoft Excel: How to apply conditional formatting to a cell based on values of another cells or range?

How Tos MS Office Tips Tips & Tricks

There are times in our spread sheet that we need to format the cells or cell range based on certain conditions. These conditions however pertain to the contents of the cells that you are to format. This is when Conditional Formatting is very useful. For instance, format the cell range G5:G50 if the values in the individual cells is less than 70%. If you are a teacher calculating the students grade in Excel and you want to automatically color the final grade with dark red if they are faling grades, like below… Read More

Microsoft Excel: The imaginary cell borders are gone. How to show them back?

How Tos MS Office Tips Tips & Tricks

We are used to seeing cells in MS Excel with a light gray borders. These are called “grid lines”. They are just there as a default behavior of MS Excel to provide visual boundaries among cells. These grid lines are NOT actually being printed by default, they are just visual aide to users to visually see the boundaries between cells. When your Excel settings are messed up and you end up with just a plain white worksheets without those cell boundaries or grid lines, here are the steps to show… Read More