August, 2010

  • Use OneNote to take and crop screenshots

    If you're still using the PrntScn button in Windows to take screenshots, you're missing out one of the best kept secrets of OneNote: its screen clipping tool. You don't even need to be running OneNote to use it (as long as it's installed!). Just press...
  • Minimize the Outlook Ribbon

    One of the first things you’ll notice about Outlook 2010 is that Outlook now looks like the rest of the Office applications: it has a Ribbon. Most people discover that they looove the Ribbon. It gives them quick access to features they may not have known...
  • Casual Friday: Create an allowance chart in Excel

    A colleague of mine shared this handy Excel tip he uses to reward good behavior and chore performance to calculate his child's weekly allowance. He started it when his son was only about three years old, using fun stickers to mark simple chores and good...
  • Keyboard shortcuts in Windows 7

    Remember the first time you took that shortcut to the office supply store? The one that cuts behind the nursery and requires a quick jog right where the dry cleaner used to be and is now a coffee place? Chances are, that first time you tried saving time...
  • Quickly make the Quick Access Toolbar your own

    If you've never customized the Quick Access Toolbar, you're neglecting one of the best tools for easily getting to your favorite commands in Office. Fortunately, there's a very quick way to remedy this. This tip works for both Office 2007 and Office 2010...
  • Formula Watch: Use the Cell function to check column width, column number, and more

    If you want to know more about the size, color, and contents of your cells in Excel, you should get to know the Cell function. For instance, to find out how wide a column is, just enter this into one of its cells: =CELL("width") If you want...
  • Oops – pressed send too soon, again.

    Do you ever have one of those days where nothing seems to go right? We all have bad days every now and then, but what’s worse is when evidence of your bad day makes it into an email. If you have ever hit the Send button, only to realize seconds later...
  • Upgrading and getting started with Office 2010

    Making the move to Office 2010? Here are some tips and new features you'll encounter. Scenario #1 – Moving from Office 2003: You will be amazed by the range of new features – and you won’t even have to get used to your File tab being gone (it left in...
  • Add more social network connections to Outlook 2010

    Two more social networks have been released for Outlook 2010. You can now add Outlook Social Connector support for Facebook and Windows Live Messenger in addition to the LinkedIn and MySpace plug-ins that were released previously. Once you've entered...
  • Display calendar, tasks or whatever you want when launching Outlook

    Normally, when you launch Outlook it opens to your Inbox. But perhaps you'd prefer it open to your Calendar so you can see what meetings you have today, or Tasks so you can review your To Do list on start up? This is easy enough to do. In Outlook 2007...
  • How Windows 7 can make Office users even more efficient

    There are several features in Windows 7 that complement or expand the functionality of Office. Here are a few of my favorites: Jump lists. Dock your Office applications to the taskbar by right-clicking their icons while they are open and selecting Pin...
  • Format your cells for Zip codes, phone numbers and SSNs

    Unless you're brand new to Excel, you probably know that you can right click a cell or a range of selected cells, pick Format Cells and choose whether a field is a number (and set the number of decimal places), currency, text, or percentage. But did you...
  • Managing devices with Windows 7

    These days, walking down the street can require advanced juggling skills. It takes real coordination to make sure your phone, digital camera, MP3 player, camcorder, and 3D glasses are all functioning correctly and attached as required. And, chew gum too...
  • Customize and backup your Office 2010 ribbons

    If you are a fan of the Office Ribbon, you have an unprecedented amount of control over it in Office 2010. If the default Ribbon doesn't offer up your favorite commands, you can simply create custom tabs and groups to easily access your favorite features...
  • Word to the wise: Punch up your documents with clip art

    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. ---- In my job, I produce...
  • Prepare to upgrade with Office Migration Planning Manager 2010

    If you're getting ready to upgrade to Office 2010 and want to check whether your macros and documents will make the transition without modification, Microsoft has the free Office Migration Planning Manager 2010. It even includes the Office File Converter...
  • Formula Watch - Automatically translate dates to days of the week in Excel

    If you're working in an Excel document that contains lots of dates and find yourself checking the calendar to see what day of the week each one falls on, there's a much easier way. A simple formula can save minutes, maybe even hours of your life you'd...