Microsoft Office Productivity
When you click on the Office button in any 2007 program, you will see a list of your most recently opened documents. You can ‘pin’ a document for quick access. Once you have done this, no matter how many documents you open, those that are pinned will remain in your ‘Recent’ documents list. This example is shown using Excel 2007, but will work in all Office 2007 programs.
There is a quick way to compare information in the columns (or rows) of an Excel Worksheet. This will work in Excel 2003, Excel 2007, and Excel 2010.
A new feature has been added to Office 2010. You can now recover documents (presentations, and spreadsheets) that have not been saved. There is a feature called
It is possible in Office 2010 to quickly insert a screen shot or screen clipping into your presentation, document or e-mail. Located on the “Insert” tab is a “Screenshot” button. This can be a great tool when you need to capture all or part of a window. This example is shown using PowerPoint 2010, but also works in Outlook 2010, Word 2010, and OneNote 2010.
In all Office 2010 programs (Outlook, Word, Excel, PowerPoint), you can customize the Ribbon and add a new tab. You can add any/all commands to this new tab. We recommend adding the commands that you use the most, and maybe some commands that do not appear in the Ribbon at all. This works for Outlook 2010, Excel 2010, PowerPoint 2010, and Publisher 2010.