The Productivity Hub
How to help your PC help you
Yesterday, I looked up to see Kate, my next-door-cube neighbor, peering at me over the partition....
Author: Jeff at MSFT Date: 12/15/2010
Move paragraphs up and down quickly in Word
The numbered sort technique is useful when you need to carefully plot the restructuring of a long,...
Author: Suzanne100 Date: 12/14/2010
Working with styles in OneNote 2010
One significant improvement to OneNote in Office 2010 is the addition of styles, which can be used...
Author: Suzanne100 Date: 12/13/2010
Sorting paragraphs in Word
If you frequently restructure your documents and prefer not to cut and paste many paragraphs around,...
Author: Suzanne100 Date: 12/10/2010
Quickly combine notes and other elements in OneNote
When you work in OneNote, it's easy to create lots of separate boxes for your text, images, and...
Author: Suzanne100 Date: 12/09/2010
A decidedly easy way to speed up your PC
No matter how powerful, sometimes a desktop or laptop can get overwhelmed by too many applications,...
Author: Jeff at MSFT Date: 12/08/2010
Formula Watch: Keep an eye on large and small values with MIN and MAX
If you just want to spot check the smallest and largest values in a selected range of Excel cells,...
Author: Suzanne100 Date: 12/07/2010
Enhance your images with Artistic Effects
If you have an image that you want to imbue with new life or perhaps alter for a special event or...
Author: Suzanne100 Date: 12/06/2010
Casual Friday: Mail merge for the holidays
If you've never used mail merge, this is the time of year where it really makes sense to learn this...
Author: Suzanne100 Date: 12/03/2010
Using AutoCorrect with your own custom codes
You've no doubt had AutoCorrect save you from typographical errors, letting you know with its...
Author: Suzanne100 Date: 12/02/2010
Windows Explorer shares travel tips
A Feature Interview—with a Windows 7 feature! Here at Microsoft we like to think of our features as...
Author: Jeff at MSFT Date: 12/01/2010
Convert text slides into engaging SmartArt in PowerPoint
If your PowerPoint slides are packed with engaging ideas that no one reads because your audience...
Author: Suzanne100 Date: 11/30/2010
Recover and compare autosaves in Office 2010
If you've ever wished you could roll back or view an earlier draft of a work in progress, there is a...
Author: Suzanne100 Date: 11/29/2010
Keeping Internet Explorer at the top of its game
Even the most gifted performers need a little help from their friends sometimes—even the...
Author: Jeff at MSFT Date: 11/24/2010
Formula Watch: Using NOW to timestamp your Excel documents - plus shortcuts
If you want to record the time and date while working in Excel, you can use the =NOW() function....
Author: Suzanne100 Date: 11/23/2010
View and edit styles quickly in Word 2010
If you create your own custom styles or just want a quick way to view and modify existing ones, you...
Author: Suzanne100 Date: 11/22/2010
Casual Friday: Make your own holiday cards
You probably think of PowerPoint as simply a tool for presentations. But with its powerful layout...
Author: Suzanne100 Date: 11/19/2010
Remove formatting, hyperlinks, and comments in Excel
Clearing out cells of font mismatches, fill colors, hyperlinks, comments, and conditional formatting...
Author: Suzanne100 Date: 11/18/2010
Four ways to sweep away desktop clutter in Windows 7
It seems like only yesterday we explored ways to get things done more quickly despite desktop...
Author: Jeff at MSFT Date: 11/17/2010
Use Outlook OFT files to prepare mails for others to send
We've discussed how to use Outlook OFT files for creating reusable mail templates when you, say,...
Author: Suzanne100 Date: 11/16/2010
Save time saving Office 2010 documents to SharePoint
If you frequently save documents to a team SharePoint site, you may be able to add a shortcut to...
Author: Suzanne100 Date: 11/15/2010
Dress up your Word documents with Drop Cap
ou've probably seen books that started each chapter with a large letter. If you want that same...
Author: Suzanne100 Date: 11/12/2010
Get reminded if you forget an attachment before you send
If you've ever meant to send a file to someone only to receive a reply mail that you forgot to...
Author: Suzanne100 Date: 11/11/2010
Print Excel table headers on every page
If you're printing a long spreadsheet in Excel and want to have the same header row across the top...
Author: Suzanne100 Date: 11/10/2010
Formula Watch: Control rounding with CEILING and FLOOR
If you round decimal places away and want full control over which way they go (up or down), you...
Author: Suzanne100 Date: 11/09/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,...
Author: Suzanne100 Date: 11/08/2010
Casual Friday: Use Excel to track party prep tasks
If you've been using Excel for more than a little while, you've probably created task lists in it....
Author: Suzanne100 Date: 11/05/2010
Adjusting your default paste options in Office
If you spend a lot of time removing the formatting from text that you copy into Office documents...
Author: Suzanne100 Date: 11/04/2010
Windows 7 Replay: Counting sheep with Sleep and Hibernate
Here's a classic tip you might have missed: Snoozing on the job can be career-limiting—but not for...
Author: KeithPranghofer Date: 11/03/2010
Add a watermark to your Word documents
If you have documents that you want to mark as DRAFT or CONFIDENTIAL before printing, you can...
Author: Suzanne100 Date: 11/02/2010
Introducing Office for Mac 2011
The latest version of Microsoft Office on the Macintosh just launched, and it is designed to help...
Author: Suzanne100 Date: 11/01/2010
Embed the file path in your Word documents
This next tip is for you if you've ever looked at a printed Word document and wondered, "Where...
Author: Suzanne100 Date: 10/29/2010
Make room for wide objects in Word
You've probably printed wide Word documents in landscape mode, and you may have even changed a whole...
Author: Suzanne100 Date: 10/28/2010
Create an organizational chart
Managing your team's organizational chart is a simple task in Word, Excel, or PowerPoint. This tip...
Author: Suzanne100 Date: 10/27/2010
Formula Watch - Autonumber your rows and then convert them to values
If you've ever wanted to have a number column that automatically updated as you inserted new rows,...
Author: Suzanne100 Date: 10/26/2010
Get started with Quick Steps in Outlook 2010
Quick Steps in Outlook 2010 can really save you time with customizable shortcuts that perform...
Author: Suzanne100 Date: 10/25/2010
Casual Friday: Transform your Excel comment boxes into fun shapes
The default rectangular comment boxes in Excel are fine for your typical business use case scenario,...
Author: Suzanne100 Date: 10/22/2010
Quickly spell check all worksheets in Excel
If you run the spelling checker on your Excel worksheets (a good idea, even if you are an expert...
Author: Suzanne100 Date: 10/21/2010
Windows 7 Replay: Ultimate power over your laptop, the Windows 7 Mobility Center
Here's a classic tip you might have missed: Chances are your office doesn't allow pets (service...
Author: KeithPranghofer Date: 10/20/2010
Quickly remove all headers and footers in Word
We've looked at the Document Inspector as a tool for preparing Office documents for public release....
Author: Suzanne100 Date: 10/19/2010
Insert new pages right where you want them in OneNote 2010
In past versions of OneNote, you had to click the New Page button at the top of a section and then...
Author: Suzanne100 Date: 10/18/2010
Keep your Outlook meeting requests in your Inbox
By default, Outlook deletes meeting request mails once you've accepted or declined the invite. This...
Author: Suzanne100 Date: 10/15/2010
Work with metric units, picas, or points in Word
If you'd prefer to resize your images or use a ruler with centimeters, millimeters, picas, or...
Author: Suzanne100 Date: 10/14/2010
Display word counts in your Word documents
If you need to deliver articles with specific target lengths, it can be helpful to track word counts...
Author: Suzanne100 Date: 10/13/2010
Formula Watch: Picking random numbers in Excel
If you ever need a random number - say to pick a place for lunch, flip a coin, or select someone for...
Author: Suzanne100 Date: 10/12/2010
Accessing and pinning recent documents in Office 2010
If you're a veteran of Office 2007, you may be used to having your most recently accessed documents...
Author: Suzanne100 Date: 10/11/2010
Casual Friday: Make PowerPoint the life of the party
Whether you're throwing a company party, wedding, shower, or birthday bash, PowerPoint can add life...
Author: Suzanne100 Date: 10/08/2010
Hide formatting and other tracked changes selectively in Word
When you're reviewing a document with tracked changes (or editing a document yourself), do you ever...
Author: Suzanne100 Date: 10/07/2010
Windows 7 Replay: Big screens and presentations—no sweaty palms required
Here's a classic tip you might have missed: Among other things, Windows 7 addresses the second-most...
Author: KeithPranghofer Date: 10/06/2010
Quickly create tables in Word and Outlook using text
If you want to add a quick table in a Microsoft Word document or Outlook message without having to...
Author: Suzanne100 Date: 10/05/2010