February, 2011

  • Sleep and Hibernate in Windows 7: The Great Debate

    And now, another instructive encounter with a Windows feature! Today I'm moderating one of the most eye-opening debates of the decade, between a pair of venerable Windows 7 features: Sleep and Hibernate . Let's listen in. JG: Candidates, you each have...
  • Copy all highlighted text in your Word document

    You probably already use the highlighter pen tool to mark up favorite phrases or passages needing work in your Microsoft Word documents. But did you know that you can quickly select and copy all of your highlighted text to a new document? In Word 2010...
  • Link your PowerPoint presentations to improve flow

    You know that awkward pause during team presentations when one team member hands off to another, and there is much squabbling to bring up the correct presentation? That's because most people don't realize you can easily link slide decks to each other...
  • Create Search Folders in Outlook 2010

    If you find yourself scouring your Inbox and various Outlook folders for specific types of mails, there is an easier way. You can create Search Folders for all sorts of common tasks, and then they'll just be a click away! Consider these ideas for useful...
  • Move rows around quickly in Excel

    If you're like me, when working with rows of data in Excel, you often find you want to reorder them. For instance, let's say you're tracking transactions from different cliients. You could just sort by that column, but if you want to group your customers...
  • Save time with overtype mode in Office

    Depending on your editing style, you may prefer overtype mode - which lets you type over characters instead of always inserting new ones. This may be particularly helpful when working in a document that serves as a template, such as a Microsoft Word form...
  • Print just one page in Outlook 2010

    Have you ever wanted to print just the first page of an email message? Most of the time, right? You may not realize it, but there is a place to select this in Outlook 2010. Just go to File , Print (or press Ctrl-P) and then click Print Options : Directly...
  • Make your Excel rows and columns consistent

    As you enter data into cells in your Excel worksheet, you may notice that your rows change height - which can lead to a sloppy presentation if you're sharing the data. Likewise, you may want to adjust your column widths to make them more consistent. There...
  • Filter or remove duplicates from your Excel data

    If you're wading through your Excel data and find a lot of redundant entries, you have two options to narrow your focus. You can filter and hide any duplicate rows, or just delete any repeated entries completely. Best of all, these work in both Excel...
  • Get organized with Windows 7 libraries

    There are those among us who carefully lay out hierarchies of folders, each clearly named, in which to store the many documents we create. These folks can very quickly access, for example, the budget spreadsheets from Q2, three years ago, for the Southwest...
  • Control the date format in your Outlook calendar

    If you want to adjust the date display in your Outlook calendar, the place to make the change is not in Outlook but your Windows control panel. From the Start menu, select Control Panel . Now click Clock, Language, and Region : Here you'll pick Change...
  • 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...
  • Casual Friday: Using PowerPoint as a picture library

    Most people think of PowerPoint as just a presentation tool, but it makes a great picture library as well. You can paste images into it and include all sorts of notes about when and how the pictures were taken or created, add the names of the people in...
  • Create a custom view of your data in Access on SharePoint

    Awhile back, we shared how to publish your Access database to SharePoint . Once you and your team are working in it, you may find things a bit overwhelming. There may be different fields for different teams, and - unlike with Excel - you can't lock the...
  • Turn Formula AutoComplete on and off in Excel

    If you're a formula pro, you may find that the AutoComplete feature gets in the way more than it helps. To turn it off, go to File , Options , Formulas in Excel 2010 (look under the Office button in Excel 2007) and uncheck the box next to Formula AutoComplete...
  • Keep your Windows 7 machine in the fast lane

    Windows 7 is speedy—this we know the moment we fire it up the first time. With use, however, any system can slow down, even with a powerhouse operating system installed. Fortunately, along with its blazing speed, Windows comes with tools and techniques...
  • Research words, concepts, and even companies right inside of Word

    You know that Microsoft Word contains a dictionary, because you've no doubt used it to spellcheck your documents. But did you know you can access full definitions, a thesaurus, online research, and even company profiles - often without leaving Word? This...
  • Formula Watch: TRIM and CLEAN your Excel data

    If you import data into Excel or just have a lot of different people working in the same worksheet, you may sometimes find unnecessary spaces, numbers entered as text, and other irregularities. Fortunately, there's a simple set of functions that can take...
  • Six handy keyboard shortcuts for Windows 7

    Give hardworking mice the rest they deserve! Just about every Windows user develops a favorite set of timesaving keyboard shortcuts—but you may be a holdout. And, no, there's no requirement to give two 10-minute breaks per 8-hour shift to your mouse....
  • Improve the quality of your emails

    Do you ever get the feeling that you send mails too quickly, before they are fully proofread and the recipient list scrubbed of any non-essential personnel? Are there are times you wish you could take back a mail and start over? Sure, you can recall messages...