February, 2010

  • Excelling at Excel - How to quickly flip a chart

    Have you ever created a chart in Excel only to find that the items appear backwards from what you intended? This happened to me the other day, and I recalled that I had posted the solution as part of a larger tip on creating a Gantt chart from a schedule...
  • Use strikethrough to mark tasks done in Excel

    If you use Microsoft Excel to track tasks, you'll probably want to use Strikethrough to mark them as complete. Alas, the Strikethrough command does not appear conveniently on the Font section of the Ribbon as it does in Microsoft Word. There are three...
  • Set a picture as a background in OneNote

    If you want to overlay text over a picture in OneNote, the important thing is that you should NOT paste the picture into a container. You can cut and paste, drag and drop, or use the Insert menu and select Pictures and then the source ( From Files if...
  • Make a professional-looking e-mail signature in Outlook

    Is your signature plain and unengaging? Or just too informal for your business communications? There's an easy way to dress it up: Use the Business Card feature in Outlook 2007. You can include company logos or photos to make it match your printed cards...
  • Deleting a phantom image in Microsoft Word

    I recently had to edit a file that someone sent me. In it, there was an image I needed to replace - but for some reason the image would not select when I clicked directly on it, so there seemed to be no way to remove it. I even tried a Special find and...
  • Share your Outlook calendar with an e-mail snapshot

    If you've ever want to share your upcoming calendar with a colleague or customer, there's a feature in Outlook 2007 that makes this easy to do—even if the recipient isn't using Outlook themselves. It's called Calendar Snapshot, and it lets you choose...
  • Help Search find your documents when you need them

    Do you forget where you put things? I think most of us do, and it’s not because we’re getting older (although that doesn’t help). Most of us are busier than ever, and we’re so busy juggling projects that it can be tough to remember exactly where we saved...
  • Embedding documents in OneNote

    Let's say you're writing a training manual in OneNote. Supporting material such as a job description or report template might be best incorporated as an embedded Office document right alongside the section that describes hiring processes or provides a...
  • Ultimate power over your laptop: The Windows 7 Mobility Center

    Chances are your office doesn't allow pets (service animals excepted). Fortunately, laptops make wonderful pets. They'll follow you anywhere, glow warmly up at you, and be generally obedient. And while you don't need special kibble for this trusty pal...
  • Big screens and presentations—no sweaty palms required

    Among other things, Windows 7 addresses the second-most prevalent human phobia: Fear of the Big Screen Not Working During a Presentation. No one wants to look like a dim bulb. That Big, Eye-Popping Projector-and-Screen (or gargantuan monitor) in your...
  • Word to the wise: Inserting symbols

    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 . ---- When you're writing...
  • Find search terms more easily with Reading Highlight

    Recently, I shared some tips for tagging Word, Excel, and PowerPoint files to make searching in Windows easier. Today, I'm going to help you narrow in on what you're looking for when your search within a Word document returns several results. The usual...
  • Find, finding, found in Word

    One of the very first lessons I learned about computers is that they tend to take things very literally. You find that 0 and 1 are as different to the computer as 1 and 100. And that if you search for "run," the computer won't even think to...
  • What’s New in Windows 7— Wait, What?

    I know, I know, this blog is usually about Microsoft Office, but knowing your way around Windows 7 is a great way to get more done with Office. So watch this space for our weekly intrusions, and learn how to take full advantage of the new OS. Today, let...
  • Software Assurance Benefit #1: Get a copy of Office to use at home

    My name is Rosie and I am the Software Assurance Senior Marketing Manager at Microsoft. Suzanne asked me to post about some great benefits that Microsoft offers our customers who have an Enterprise Agreement with us. This is something that can help you...
  • Bookmark large documents

    Long Word documents can really give you a workout. Sometimes I see people who need to add something to the middle of a long Word document frantically scrolling with their mouse like a hamster on a wheel. There is a better way. You can set bookmarks anywhere...
  • Software Assurance Benefit #2: Get online training

    Yesterday, you learned about the Home Use Program and how Software Assurance can provide you with an inexpensive home license for Microsoft Office. The other benefit you are eligible for as part of Software Assurance is online training known as E-Learning...
  • Changing case in Word

    Have you ever accidentally typed a sentence with CAPS LOCK on? Wait, don't delete it and retype! Instead, select the sentence and look for this button on the Office ribbon in Word: The Change Case button has a number of useful options, just two clicks...
  • Keeping desktop clutter at bay with Windows 7

    With multi-tasking, the lifestyle of choice in cube farms everywhere, most of us keep a virtual pile of programs and documents and shortcuts on our Windows desktops. We know where everything is—sort of. It’s on the desktop (somewhere). The trick is focusing...
  • Presentations with pizzazz: Inserting a chart in PowerPoint

    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 are a preparing...