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 changes that have been made since you last…


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 date, time, or number format: You can simply select a pre-set…


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, click the small arrow next to the Find button on…


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 region engineering departments. Or whatever else they need. These lucky people probably…


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 2007 and Excel 2010. First, let’s look at the less…


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 first column to keep your bearings. No worries, there’s…


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 the photos, and document details about the…


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’s a quick way to do this. Simply select and…


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 useful for maintaining its efficiency and responsiveness. Here are some of the most…


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: Don’t worry, this just sets your default….