January, 2011

  • Send OneNote pages to email, blogs, even mobile phones

    OneNote 2010 builds on past versions to offer more flexibilty in letting your access and share the notes and articles you jot down or type up. For most of your sharing options, go to the File menu and select Send : E-mail Page will put your selected page...
  • Mastering tabs in Excel

    If you store data on multiple sheets (or tabs), you may have noticed you can drag then into a different order. But did you know you can duplicate them, color them, and even quickly move them to a different document? To copy a tab, select it, right click...
  • Participate in 'Clean Out Your Inbox Week'

    Taking control of your Inbox is a perennial topic, one that we’ve addressed several times with our Inbox bootcamp and New Year’s clean-up resolution . MSNBC has a fresh take on how to deal with your overflowing inbox and calls for workers to take part...
  • Speed up common browsing tasks with Accelerators

    Copy. Change windows. Paste. Click. Repeat. Most of us follow this familiar routine hundreds of times a week, just to perform some common online task—such as looking up the meaning of an unfamiliar term or emailing helpful content to a colleague. It's...
  • Formula Watch: Turn off rounding with TRUNC

    If you work with currency, you may have noticed that the default behavior in Excel is to round up cents. This may work in most situations, but if you ever want to truncate the value without rounding, you'll want to use the TRUNC function. For instance...
  • Present to a remote audience over the Internet with PowerPoint 2010

    If you want to let remote team members watch your presentation, PowerPoint 2010 has a great feature for you. All they need to view your slideshow is Internet access, a Live ID (or account on another supported presentation service), and the latest version...
  • Add impact to your Word documents with Text Effects

    Have you ever noticed that glowing button on your ribbon in Word 2010? It’s the gateway to a number of Text Effects that you can use to dress up your documents: Let’s say you’re making a flier for the company picnic. A nice bright sunny theme might brighten...
  • Dress up your Excel documents with headings

    Excel can be used for just about anything—lists, charts, tables, and more—but if you plan on printing or sharing your masterpiece, you’re going to want to dress it up and label things for others. Neatness counts! One of the quickest ways to improve any...
  • Whom do you trust? Internet Explorer can help you decide

    Like it or not, wariness is the watchword in cyberspace these days. There are just too many pranksters and other undesirable types who want our personal information, our money, or perhaps our signature on a Florida swampland deed of sale. Maybe all three...
  • A quicker way to fill down in Excel

    For those of you familiar with the double-click trick in Excel, there’s a faster way that is very effective particularly when duplicating text down one or more rows. A colleague of mine uses it when localizing text strings that are stored in Excel; he...
  • Make universal changes quickly in PowerPoint

    Do you spend a lot of time making your slides uniform in PowerPoint? If so, perhaps you’re not familiar with the Slide Master. No, that’s not what people call me. It’s a feature that lets you edit all of the master slides in your deck. Then all slides...
  • 8 tips for power-conscious road warriors

    It's Friday, and there's just one thing between you and that fabulous ski weekend you've got planned: an assignment due to the boss at 5:00 today. You are, however, on a plane—and will be for most of the day. To meet the deadline and hit the slopes on...
  • Formula Watch: Hide customer data with CONCATENATE

    Privacy is an important watchword these days, and Excel can help you hide sensitive customer information such as Social Security Numbers or credit card numbers. Simply use CONCATENATE to combine a generic text string representing the missing digits with...
  • Use Clean Up to zap unnecessary mails in Outlook 2010

    It's January, so you've no doubt resolved to take control of your Inbox (a perennial favorite that never goes out of style!). One tool that can help is the Clean Up button in Outlook 2010. First, select a mail folder you want to clean up. While it can...
  • Casual Friday: Making eye-catching signs in Word

    Most people think of Microsoft Word as an application for authoring business documents, but it can be used to send all sorts of messages – including reminders to turn off the office coffee pot when you pour the last cup of the day, ensure the new pet...
  • Link related sections in OneNote

    If you’re writing a manual or other form of documentation that discusses definitions or processes that are detailed in other parts of your OneNote document, you can (and probably should) link them. That way, if someone is reading along and spots an unfamiliar...
  • Hey! How come this won’t print???

    According to my informal survey around the office, the number-one nightmare suffered by modern workers includes three things. First, a deadline—rapidly approaching, or already past. Next, a document—presentation handouts, a budget summary, a performance...
  • New Year's resolutions you can resolve with Office and Windows

    It's 2011, and if you're like me, you know there are some things you should have mastered last year that you didn't get to - so you resolve to tackle them when the calendar rolls over. Here are 65 popular tasks we frequently hear that customers want to...