Posted by on

Very commonly you may be dealing with a spreadsheet of data, with many duplicates that you want to remove quickly. This happens often if you are dealing with mailing lists with repeated information (names, email addresses, zipcodes, etc.), an export of data from a system, or a report.

Instead of manually deleting duplicated data to trim down your spreadsheet, use the Remove Duplicates feature!

To demonstrate this feature, we have a simple two column spreadsheet.


You can see that the codes in Column A are duplicated, as well as some of the items in Column B. Note, however, that when codes are duplicated, not all the items are (e.g. the code for Strawberries is the same, but one is Strawberries – 1 pack and the other is Strawberries – 2 pack).

We’re going to quickly eliminate all rows that are duplicated in both columns.

  1. Select one of the cells in the spreadsheet.

Posted by on

used with permission from HP Technology at Work

When it comes to business email, change is in the air.

Web-based platforms have all but taken over the personal email market—Gmail alone has over 425 million active users worldwide and counting [1]. With Microsoft® also ending extended product support for Exchange Server 2003, now could easily seem like the perfect time to switch your office desktop email client and server to an online solution.

But most small businesses should think twice.

Solutions that are perfect for home use are often underpowered when it comes to getting office tasks done, and email is no exception. Here are the top ways desktop email clients and servers are still beating their browser-based challengers, and why they should still be your top choice for business email.

Desktop client advantages

  • Offline management: Whether you’re on the road, flying to a presentation, or just in a Wi-Fi dead zone, having local access to your messages and attachments means you can stay productive without having to worry about internet access.

Posted by on

MS-Office-2013-logoSince the announcement of Microsoft’s new options for their productivity software releases for this year, there has been a lot to consider.

The journalists and bloggers have been picking over the licensing agreements since the release and have found some changes that give pause. The eye-opener has been a limitation on transferability – you can only install your copy of Office on one machine and have to buy another license if you replace your machine with another (if you have to reinstall windows on the same machine, reinstalling Office is allowed). This is not necessarily new; there were some versions of Office 2010 that you could not transfer but, with Office 2013, this is your only option. That fact has raised a lot of ire. It has harsh implications on the right of second sale. In the past, many companies have marked their Office purchases as assets that could be sold.  Read more...

Posted by on

MS-Office-2013-logoMicrosoft announced the release of Office 2013 at the end of January. The new productivity suite is the first built to use on Windows 8. Also announced was the release of Office 365 for the home user. Office 365 has been around for a while, but only available to corporate clients. This new licensing level opens up Microsoft’s cloud based service to a wider audience at a monthly price that is competitive with the one time charge consumers are more familiar with. Being able to store documents in the cloud and access them anywhere pales next to one shocking feature – the ability to use Office 365 on up to 5 devices. It’s a smart move on their part, as the ability to access files over the cloud when you have to license your desktop, laptop, tablets and or smart phones individually.

Office Mobile is in development and rumored to be released in early 2013.  Read more...

Posted by on

office-logo-newA useful feature for collaboration in Office documents is the concept of markups. This feature allows you to track changes made to a document and even offers the ability to mark comments that can be made invisible when looking at the “final” product. When trading a file between people in the office, each can see the original structure of the document and where it was changed. One problem that has been cropping up is that these markups don’t always go away when you think they do.

When sending documents from Office 2010 users to Office 2007, we’ve seen problems wherein the document appears correctly in 2010, but when opened on Word 2007, it shows the revision history of the document – even if you have “track changes” turned off.  It can be a major embarrassment to find that a client or collaborator outside of the office might see changes and notes you didn’t intend for them to see.   Read more...

Posted by on

In response to an article at The Daily that Office for the iPad coming in the next few weeks, Microsoft denied it’s developing an iPad version of Office Suite; a move that suggests they want to strengthen their own attempt into the tablet arena. This comes as a curious and cynical play by the software giant. The market for tablet computing is growing quickly; the iPad is the front runner with current competition from Android and Kindle. Microsoft is set to throw their hat in the ring with its next release of Windows which has a heavy focus toward a tablet interface. (See the next article for information about Windows 8). What doesn’t make sense about this is there are ways to use Office products on an iPad using iPad workplace integration tools like Microsoft Remote Desktop Services (previously known as terminal server), or from companies like Citrix. The browser versions of office available on office 365 also work on Safari on the iPad as well.  Read more...

1 2 3