Popular Pages


Category Archives: Microsoft Office

The Missing Lync of Office Professional Plus 2010

Upon setting out to evaluate Microsoft Lync as a communicator, the first thing needed was a copy of Lync 2010. Surely then I could feed in my Microsoft ID and I would connect to the marvellous world of Microsoft Lync, also known as ‘not Messenger’.

Not Shipping with Professional Plus 2010

The first hurdle I discovered was that apparently I already had Lync, yet I didn’t have Lync. Office 365’s website clearly states that if I have Office 2010 Professional Plus installed, Lync will be included.

This was not the case, so I pushed forwards and installed Lync as a standalone on the two computers being used in the office. Note, both had Office 2010 Pro Plus installed, but did not have Lync on them. They were up to the latest service packs and there was no Lync option in the install features. Upon installing Lync, I was certain that the domain SIP services were correctly referenced, so I tried to start up Lync.

Starts off with a dead server

Didn’t ask for a password, and I couldn’t sign in.

So off to the backoffice we go, to see what is happening with the magical Lync services of Microsoft. Cannot sign in still. Eventually I go to check the settings some more, but don’t actually change anything and it starts working. Must have been down when I was trying to connect.

So finally I get in there, and learn some of the features.

Apparently Domains can be Federated now

It’s very much like Microsoft Messenger, the main difference being that Lync has a few nicer plugins. Another thing to be wary of, if you are using the Office365 Lync system, then there exists and option called ‘Domain Federation’. No, this doesn’t mean your domain is about to become a country. Presumably it’s the best word Microsoft could find to put in place of ‘Do you want Lync in your domain to talk to other domains?’

From that option, there’s a whitelist option, a blacklist option and an option to just shut yourself and your company away from the entire world. FYI, the ‘I want to shut myself away from the entire world’ option is the one that the people at Redmond decided would be the best  default option for most businesses, just another thing to keep you on your toes when setting this up.


One of the coolest features of Lync is the on board chat analyser, it’s not really necessary for a computer to tell you how much trust another person has of you, but it’s certainly nice to be reassured that a relationship is a good one.

This piece on technology is brought to you by Ryan, a writer and technician for one of the finest accounting firms in Perth.

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

Continue reading

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

Continue reading

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.

Continue reading

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

Continue reading

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.

Continue reading