Cheat Sheet

Microsoft Office 2008 for Mac All-in-One For Dummies

From Office 2008 for Mac All-in-One For Dummies by Geetesh Bajaj, Jim Gordon

Get the most out of Microsoft Office 2008 for Mac with handy tips for working in Office in general as well as word-processing in Word, making spreadsheets in Excel, creating PowerPoint slides, and e-mailing with Entourage.

Tips that Work throughout Office 2008 for Mac

Use these common commands and features throughout all of Office 2008 for Mac’s applications.

Command/Feature How to Access It
Undo Look for the Undo button on the Standard toolbar or press the keyboard combination Command-Z.
Multiple Undo Click the tiny triangle next to the Undo button to see a pop-up menu of available Undo actions.
Select All Choose Edit→Select All or press Command-A to select everything in your document, including tables, charts, pictures, and other objects.
Help Free training movies and online courses are now available in Office 2008 Help. Click the Help button on any of the toolbars and explore topics under Popular Training. You'll also find them in Help search results.
Pop-up menus Right-click or Control-click just about anywhere on the screen to get context-sensitive menus.
Copy Press Command-C.
Cut Press Command-X.
Paste Press Command-V.
Menu bar Press Control-F2 to activate the menu bar. Then use the arrow keys to navigate the menu and press the spacebar to activate a menu item.
Dock Press Control-F3 to activate the Dock. Then use the arrow keys to navigate the menu and press the spacebar to activate a menu item.

Tips and Tools for Working with Word 2008 for Mac

Improve word-processing efficiency in Word 2008 for Mac with these handy commands and tools.

Print Layout view Choose View→Print Layout to work with word processing documents the traditional way.
Notebook Layout view Choose View→Notebook Layout for taking typed notes and recording audio notes of meetings and classes.
Publishing Layout view Choose View→Publishing Layout to make newsletters and other publications.
Customize keyboard shortcuts Choose Tools→Customize Keyboard to set up keyboard shortcuts.
Customize menus and toolbars Choose View→Customize Menus and Toolbars to create and fine-tune your menus and toolbars.
Change font sizes Use the slider bar on the Formatting Palette.
Display Reference Tools Press Option-Command-R to display Reference Tools on the Object Palette.

Tips and Tricks for Excel 2008 for Mac

How to stay in charge of spreadsheets in Excel 2008 for Mac? Use these quick steps for your most common activities.

Rename a worksheet Double-click a sheet tab to change its name.
Edit cells Double-click a cell to edit the cell formula or cell contents on the worksheet.
File timesaver Save your files as Excel Binary Workbook (.xlsb) to get a much smaller file that opens and saves faster.
Create table rows and columns Choose Insert→List to start the List Wizard, which helps you create row and column tables for your data.
Alternative menu options Hold down the Shift key while navigating Excel’s menus to see alternative options.

Perfecting PowerPoint 2008 for Mac Presentation Skills

Learn how to spruce up your slide presentations with these handy PowerPoint 2008 for Mac features.

Cross-platform presentations To play your presentations on other platforms, install Flip4Mac, a free QuickTime codec that enables you to play Windows Media Video format in QuickTime.
Print handouts To print handouts with lines for taking notes, choose File→Print. Look for the Print What pop-up menu and choose Handouts (3 Slides per Page).
Create a PowerPoint package To create a package that has all DRM-free media properly linked, choose File→Save As. In the Format pop-up menu, choose PowerPoint Package.
Notes Page View Choose View→Notes Page to work in a special view that allows you to see your slide and create extensive notes.

Entourage 2008 for Mac Basics

Manage and manipulate your e-mail, calendar, and contacts with these Entourage 2008 for Mac tips.

Customize toolbars Choose View→Customize Toolbar.
Work offline If you lose your Internet connection, choose Entourage→Work Offline. Choose the same menu option again when you can reconnect. Entourage records all your actions while you’re away so you can even create and queue mail messages and Calendar invitations.
Search Press Command-F to initiate a powerful search within Entourage.
Start a new project Choose New→Project from the File menu.
Create rules Choose Tools→Rules to make all sorts of rules to automate Entourage.
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.