Find Duplicate And Filter Cell By Color in Excel 2007/2010

Removing or identifying duplicate values in a Excel sheet is very difficult task, most people do it by using the formula of “countif”, but Excel 2007 / 2010 has introduced a new function of “conditional formatting”

Conditional formatting is tool which format cell or cells on conditioned specified, Excel 2007 / 2010 has provided new function of highlighting duplicated cells, this function highlight all duplicate value in selected cells to use this function, go to “Home” Tab select all cells in which you want to find duplicate, then click on Conditional formation > highlighting cell rules > Duplicate values

Read moreFind Duplicate And Filter Cell By Color in Excel 2007/2010

How to Troubleshoot Microsoft Word 2007?

Microsoft Word 2007 is enriched with many outstanding and useful features that leads to efficient management of your documents. With the help of Word 2007, you can download template documents by connecting to the Internet, latest clip arts, online dictionary and images directly from the Microsoft Office official website. Already built templates are quite handy in saving a lot of useful time needed to create them. Apart from these and other various remarkable features, Word 2007 also provide built in support to fix various bugs that you may encounter while using Word 2007. Word 2007 is bundled with Microsoft Office Diagnostic Tool. Word 2007 troubleshooting tool is very easy to use and i have illustrated these easy steps in the lines below which will help you to troubleshoot Microsoft Word 2007 using Microsoft Diagnostic Tool.

Find Emails And Documents Faster With Lookeen

lookeen_logo (RGB) Lookeen is a Microsoft Office add-in compatible Office 2003, 2007 and 2010. The basic purpose of Lookeen is to find emails and conversations faster. Although we have Microsoft’s own Instant search plugin for Outlook and also Xobni which we have reviewed earlier. I got a comment in the same article suggesting about Lookeen which I had never heard of before so I tried it out and here’s what I have found out about Lookeen.

lookeen2010_screen outlook2010 3

Read moreFind Emails And Documents Faster With Lookeen

How To Hide/Unhide Columns/Rows/Cells In Microsoft Excel 2007

Excel spreadsheets are very often being shared so you don’t want complete data in the sheet to be shared/printed. For this purpose, there is hide/unhide utility in Excel 2007.

Hide the Column/Row

1- Select the column/row with left click and then right click will give you the option to hide the column.

Read moreHow To Hide/Unhide Columns/Rows/Cells In Microsoft Excel 2007

5 Ways To Save An Excel 2007 Workbook

I was searching for how many ways we can save an excel workbook. It’s always interesting to know more ways to save as we can use any one of them whenever we feel easy. Let’s discuss the ways I have discovered.

1- Save

To save a document, just click on the Office Orb button on the top left of Microsoft Excel and select Save from the menu. This will save the document. If the document has already been saved, Excel will not ask for file path to save. Rather it will save it automatically replacing the existing file.

Read more5 Ways To Save An Excel 2007 Workbook

Full Download Of Windows Live Essentials Wave 4 beta Setup

windows live essentials Microsoft has recently released Windows Live Essentials Wave 4 beta. this version of Windows Live Essentials include the following programs:

Windows Live Family Safety
Windows Live Mail
Windows Live Messenger
Windows Live Movie Maker
Windows Live Photo Gallery
Windows Live Sync
Bing Bar
Windows Live Writer
Microsoft Office Outlook Connector Pack
Messenger Companion
Microsoft Silverlight

Read moreFull Download Of Windows Live Essentials Wave 4 beta Setup

Blogging with Microsoft Word 2007

Microsoft Office suit is a collection of several noteworthy and remarkable tools including Microsoft Word, Microsoft PowerPoint, and Microsoft Excel. Microsoft Office tools are used for compilation of documents, presentations, spreadsheet, database management, drawing, designing and much more. Today I am writing about a new feature in Microsoft Word which is best known for creating documents. Microsoft Office 2007 provides a new and unique feature of blogging, i.e., you can use Microsoft Word as a tool for blogging. Thus, If you are looking to post a article to your blog website, you can easily do so through Microsoft Word 2007 as an alternative to Word press or blogger. Moreover with the help of blogging feature, you can even add categories to your posts.

How To Fix Images Not Displaying In Microsoft Word 2007

Recently one of my colleagues came to me complaining about malfunctioning Microsoft Word document. He was saying that his Microsoft Word 2007 was not showing any images. He downloaded the document multiple times but to no avail. He also tested the document on another machine but the document was opening fine on the other machine and was showing images properly.

Read moreHow To Fix Images Not Displaying In Microsoft Word 2007