I admit that at first I was no fan of Microsoft Office 2007 system. After a
week or so, however, I came to like the new UI with its Ribbon interface more
than the Office 2003 UI. Still, for much of that first week, I struggled to
remain productive while I learned the interface. Some of the features I commonly
use were easy to find, but I spent a lot of time searching for others. Knowing
where to find some of the capabilities you really need can make you more productive
from the start.
10. Recent documents—One thing you might wonder about in Office
2007 is where your list of recent documents went. In earlier versions of Office,
the list of recent documents appears at the bottom of the File menu. To see
Office 2007's greatly expanded recent-documents list, you need to click the
Office button in the upper-left corner.
9. Saving documents in Office 2003 format—Users who still have
earlier versions of Office will have trouble reading files that you save in
Office 2007's new native file format. To save documents to an earlier format,
use the Office button's Save As option. To change the default format, click
the Office button, then the Options button; select Save; and change the Save
files in this format setting.
8. Word count—My favorite feature of Word 2007 is the way it
handles word counts. In Word 2003, you need to use the Word Count option in
the Tools menu to see the current document's word and page count. In Word 2007,
however, the word count is always visible at the bottom-left corner of the document
window.
7. Excel pivot tables—The new UI has moved Excel's familiar PivotTable
option. In Excel 2003, you create pivot tables by clicking Data, then clicking
PivotTable and PivotChart Report. With Excel 2007, you can open the Create
PivotTable dialog box by clicking the Ribbon's Insert tab, then clicking PivotTable.
6. Printing envelopes—Word 2003's Envelopes and Labels dialog
box is under the Tools menu, in the Letters and Mailings option. Word 2007 moves
the envelope printing function to the Ribbon's Mailings tab. Click the Envelopes
icon in the Create group to display the Envelopes and Labels dialog box and
set your printing options.
5. Access reports—One of Microsoft Access's greatest strengths
has always been its easy-to-use report design tool. You can't miss the report
designer in Access 2003 because it's always right in front of you on the Access
main menu. To find the report design tool in Access 2007, you'll need to go
to the Ribbon's Create tab.
4. PowerPoint design layouts—Microsoft Office PowerPoint's handy,
preformatted design layouts were the first things I looked for in PowerPoint
2007. In PowerPoint 2003, you applied different slide layouts by clicking Format,
Slide Layout. With PowerPoint 2007, you need to do a bit more digging. The slide
layouts are on the Ribbon's Home tab under the Layout drop-down menu in the
Slides group.
3. Word styles—In Word 2003, styles are under the Format, Styles
and Formatting option. For Word 2007, styles have been moved to the Ribbon's
Home tab. After clicking the tab, you need to click the arrow in the lower-right
corner of the Styles group to display the Styles window.
2. Text to Table—Another feature that I use frequently is Word's
Text to Table conversion feature. With Word 2003, you can convert text to a
table by clicking Table, Convert, Text to Table. In Word 2007, the text-to-table
conversion feature is available on the Ribbon's Insert tab under the Table,
Convert Text to Table option.
1. Excel macros—Finding out how to edit your macros is something
you'll probably need pretty quickly when you start using Excel 2007. To edit
macros in Excel 2003, you choose Macro from the Tools menu. To record macros
in Excel 2007, you need to use the Ribbon's Developer tab, which isn't shown
by default. To display the Developer tab, you have to click the Office button;
choose Excel Options, Popular; then select the Show Developer tab in the
Ribbon check box. Macro creation and editing options are on the Developer
tab.