Restrict data entry in Excel with lists

I recently shared how you can restrict data input in Excel to certain number ranges, such as whole number percentages. But what if you’re dealing with a strict set of values, like product names, and you don’t want users to be able to create any new variations when entering data? That’s easy to do too….


Compare and merge slides in PowerPoint 2010

One of the little trumpeted but extremely valuable features in PowerPoint 2010 is the ability to compare and merge slides from separate decks. To use this feature, first open your main presentation file and go to the Review tab. Click the Compare button: Select the file you wish to compare it with and click Merge:…


Restrict data input in Excel

We all enter bad data into Excel from time to time. Maybe you’re rushing, or someone distracts you, or you’ve just been doing it too long without a break. And when you open a document up to colleagues to help maintain, your data is only as good as their level of training and attention to…


Restrict style changes in Word

If you want to limit the use of styles and themes in a Word document that you and your teammates are collaborating on, there’s a tucked away feature that does just that – and it works in both Word 2007 and Word 2010. First, click the tiny launcher button below the Change Styles button on…


Create a Calendar Group in Outlook 2010

If your team always seems to be out-of-sync, create a Calendar Group to quickly pull up everyone’s schedule in one view. First, go to Calendar in Outlook 2010, click Calendar Groups, and Create New Calendar Group: Give it a name and then select all of the people you want to add from the address book….


Save time when reviewing tracked changes in Word

If you review and Accept/Reject changes regularly, here’s a quick tip to add some time back to your week and reduce wear and tear on your clicking finger. Don’t accept any changes as you read through the feedback from your stakeholders, just reject the ones you don’t want. Then click the arrow under the Accept…


Office 365 public beta is now available

The cloud-based version of Microsoft Office and related services, called Office 365, is now in public beta. This means you can sign up to try the subscription service, which offers your favorite Office applications plus SharePoint, Exchange, and Lync services via the Web using most devices. This delivers unprecedented access to your documents, e-mail, calendars,…


Review changes by author in OneNote 2010

If you work in shared notebooks, it can be helpful to see what changes have been made by your collaborators. If it’s not enabled, go to the Share menu in OneNote 2010 and turn off Hide Authors: This will reveal vertical lines with initials next to any changes that have been made since you last…


Mark finished documents as final in Office 2010

Locking down Office documents isn’t new, but Office 2010 offers a quicker, more informal method to discourage editing once a document is finished: You can mark it as final. This does away with the need to create and remember a password or set complicated permissions. It won’t prevent editing or copying if a teammate or…


Publish your Access database to SharePoint

If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services. If you don’t already have a database, you can quickly create one from a template. In…