May, 2010

  • Excelling in Excel: How to flip a column of data

    I watch Twitter for interesting Microsoft Office productivity tips and problems, and I found one that's apparently a common issue: flipping a column of data in Excel. If you simply want to reverse a list that's already in numeric or alphabetical order...
  • Use Outlook Reading Pane without marking messages as read

    If you like to browse incoming messages in Outlook 2007 using the reading pane but don't want them automatically marked as read, go to Tools , Options , click to the Other tab (in Outlook 2010, click to File , Options , Advanced ): Click the Reading Pane...
  • Mark your comments when replying to Outlook messages

    If you answer e-mail questions "inline" - that is, inside of the sender's original quoted message - you should use Outlook comments. This marks your insertions with your name so that the recipient(s) can quickly spot your notes and you don't...
  • Save time typing with AutoText in Microsoft Word

    If you frequently type the same phrases, instructions, or boilerplate copy (think legalese!) into your Microsoft Word documents, you should be using AutoText. This is similar to Quick Parts in Microsoft Outlook , but there’s an easy shortcut to access...
  • Control where attachments go in Outlook 2007

    You may have noticed that e-mail attachments in Outlook 2007 can appear in one of two places. They may appear in an Attachment line at the top of the mail or wherever you want in the body of the message. At first glance there may not seem to be any rhyme...
  • Track your time with the Outlook Journal

    Outlook contains a great feature if you bill by the hour or want to see where all of the time in your work day goes. It's called Journal, and it can actually track your work activities not just in Outlook but also Access, Excel, PowerPoint, and Word....
  • Excelling at Excel - Turning your data into a meaningful PivotChart

    As we've seen in our examination on how to analyze your data , PivotTables are great when you want to dig into the numbers. But what if you want to present your data in a meaningful way for, say, an executive PowerPoint presentation. You could make a...
  • Force reviewers to track changes in Word

    If you're tired of asking people who review your documents to track their changes only to have them forget, you could try a couple of different approaches. If you go to the Review tab and turn on Track Changes right before you save the final version to...
  • Clear the e-mail clutter with Ignore and Move in Outlook 2010

    If you're like me, you spend a chunk of your day sifting through your e-mails looking for the ones that require action and deleting the ones that don't pertain to you. Well, that's what I used to do, anyway. With Outlook 2010, if a mail conversation comes...
  • Insert a screenshot in Word 2010

    In honor of the Office 2010 business launch today, here’s our first Office 2010 tip! We’ll start sprinkling these in for those users who have adopted Office 2010 or are thinking about it – but we’ll still post tips that work in Office 2007 for the foreseeable...
  • Presentations with pizzazz: Recording narration in PowerPoint 2007

    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 . ---- Wouldn't it be...
  • Let your devices take center stage with Windows 7

    If you've ever plugged a printer, music player, camera, phone, or other device into your PC and wondered what to do next, you're going to like Device Stage . This clever but unassuming tool works with your devices to give each its own "device home...
  • Action Center: Keeping Windows 7 smooth and secure

    Windows 7 makes it easier to stay on top of those little problems and opportunities that crop up from time to time on any PC. Here's how: 1. Less distraction. When an issue or important message comes up, Windows 7 won't distract you with an annoying pop...
  • Getting started with conversations in Outlook 2010

    One of the big new features in Office 2010 is the conversation view, which has been greatly expanded in Outlook 2010 to provide a rich manageable view of related messages regardless of where they reside in mail folders. This provides a whole new way to...
  • What's new in Office 2010 for productivity fans

    With Microsoft Office 2010 launching Wednesday for businesses and June at retail, we thought we'd take a moment to tell you about the exciting new features that will help you get your job done! I’ve been lucky enough to have been using Office 2010 for...
  • Translate text in Word

    If you work in multiple languages or just want to occasionally translate a word or phrase you find on the Internet, Microsoft Word has built-in tools to help you out. In Word 2007, you can select Arabic, French, or Spanish translations to appear as a...
  • Saving Word documents in portable formats

    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. ---- If you've ever been...
  • Achieving Ultimate Clarity - textwise, that is - with ClearType

    I'm probably showing my age here, but I can remember a time when everyone used cathode ray tube (CRT) monitors with their computers. While a few specialized uses for them remain, these potential yacht anchors have been widely replaced by flat panel LCD...
  • Excelling at Excel - Getting started with PivotTables: fields and areas

    Last week, we overcame one of the main obstacles to understanding and getting good value out of Excel PivotTables: optimizing your data . With that done, let's look at the fields required to make a useful PivotTable. If you followed along with my example...
  • Find stuff more easily by customizing the Start Menu in Windows 7

    With just about any task done with a PC, getting started means finding programs, documents, and other files. Windows 7 makes getting started easy with its flexible Start Menu—and customizing it for your work style is absolutely worth the few moments it...
  • Find your place in Word

    If you work in long Word documents, you're probably already using Bookmarks . Even if you are, you may still want to quickly find the last place you were working. This is an easy thing to do, both in Word 2007 and Word 2010. Press Shift F5 right after...