See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
The Productivity Hub
Office for Mac 2011
Browse by Tags
The Productivity Hub
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...
9 Jun 2011
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...
31 May 2011
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 detail. Fortunately...
24 May 2011
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 your Home tab...
19 May 2011
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...
2 May 2011
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...
25 Apr 2011
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...
19 Apr 2011
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 reviewed...
28 Feb 2011
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...
28 Dec 2010
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 Access 2010...
8 Nov 2010
Make large slide decks more manageable in PowerPoint 2010
If you're a power user of PowerPoint, you've no doubt run into some of these scenarios: Collaborating on a slide presentation with one or more colleagues Creating a master deck to generate smaller presentation decks customized for specific audiences Moving slides around to different sections, organized...
20 Sep 2010
Use OneNote to collaborate on PowerPoint presentations
If you're working on a team PowerPoint presentation, you could just use the built-in comments feature. But coupling PowerPoint with OneNote adds the ability to quickly notate and even draw on slides with your collaborators! The quickest way to do this is to use the Print feature in either PowerPoint...
9 Sep 2010
Word to the wise: Using the Insert Comment feature in Word
Today, we have a guest blogger. Elyssa is an editor and project manager at Brainstorm, a leading provider of online and onsite software training and one of our partners that provides customized content for your Productivity Hub. ---- For my job, I review other people's written work quite a bit, making...
2 Jul 2010
Outlook Rules That Rule - Forward mails based on keywords
I keep a lookout for useful Outlook rules (and anything else that keeps my Inbox manageable) and recently stumbled across a great, practical one. If you receive mails from customers or other sources that require a response or action and have team members who are subject matter experts to help you deal...
19 Jan 2010
Collaborate with difficult people the Crabby way
If you haven't read any Crabby Office Lady articles or posts, you really should. I’m going to be lazy today – the Lazy Office Lady – and invite you to read Crabby's excellent column on how to collaborate without ever having to see anyone. She covers Meeting Workspaces, Document Workspaces, Live Meeting...
15 Oct 2009
Use Smart Tags to collaborate with colleagues - right from your documents
I am sitting in training where I just learned the coolest thing. Our Unified Communications product manager just showed us how we can see presence information within our Office documents. This is useful if you ever need to collaborate on a document – say a proposal, presentation, business strategy, budget...
2 Oct 2009
© 2013 Microsoft
Manage Your Profile