Microsoft Office 2003 Visual Quick Tips

by Kinkoph, Sherry Willard

• ISBN13: 9780470009253
• ISBN10: 047000925X
• Edition: 1st
• Format: Paperback
• Copyright: 2006-01-11
• Publisher: Visual

Summary

* Straight-forward task descriptions * Succinct explanations * Full-color screen shots * Numbered steps Learn How To: * Recover a File After Systems Failure * Change File Properties to Make Documents Private * Improve Your Database Productivity Using Access

Author Biography

Sherry Willard Kinkoph has written and edited more than 60 books over the past 10 years covering a variety of computer topics ranging from hardware to software from Microsoft Office programs to the Internet. Her recent titles include Teach Yourself Visually Premiere 6, Master Visually Dreamweaver MX and Flash MX, and Teach Yourself Visually Restoration and Retouching with Photoshop Elements 2. Sherry’s ongoing quest is to help users of all levels master ever-changing computer technologies. No matter how many times they — the software manufacturers and hardware conglomerates — throw out a new version or upgrade, Sherry vows to be there to make sense of it all and help computer users get the most out of their machines.

Table of Contents

Chapter 1: Lighten Your Workload with General Office Tips and Tricks.

Clear Your Screen of Default Task Panes.

Quickly Learn Shortcut Keys.

Simplify Repeated Tasks with Customized Menus.

Create a Customized Toolbar.

Create a Customized Toolbar Button.

Assign a Hyperlink to a Button.

Using an Office Program to Manage Computer Files.

Store Files in a Different Default Location.

Change File Properties to Make Documents Private.

Recover a File After a Systems Failure.

Convert Scanned Documents into Text Files.

Print Placeholders in Place of Graphics.

Using the Ungroup Command to Customize Clip Art.

Using Text Boxes to Position Clip Art.

Chapter 2: Timesaving Tricks and Tips for Word.

Utilize Status Bar Shortcuts.

Using the Work Menu to Add Favorite Files.

Remove a File from the Recent Files List.

Using the Zoom Options to Conserve Paper when Printing.

Navigate Long Documents with a Table of Contents.

Navigate Long Documents Using Bookmarks.

Using AutoText to Automate Repetitive Typing.

Remove a Text Hyperlink.

Keep Words Together with a Non-Breaking Space.

Control Sentence Spacing.

Track Word Count.

Check Your Document for Clichéd Text.

Using the Research Pane to Translate Text.

Add Line Numbers in the Document Margin.

Set Off a Paragraph with a Border.

Resume Numbering in an Interrupted Numbered List.

Quickly Insert Horizontal Lines.

Emphasize Paragraphs with Drop Caps.

Customize Comment Text.

Add Captions to Your Graphics.

Type Out a Table.

Keep Table Column Headings in Sight.

Place a Table within a Table.

Align Shapes with Grid Lines.

Add Gradient Fills to Text Boxes.

Create a Watermark.

Chapter 3: Increase the Power of Your Spreadsheet with Excel.

Automatically Open Your Favorite Workbook.

Access More Files by Increasing the Recent Files List.

Set a New Default Font and Size.

Change Gridline Color.

Increase Readability by Printing Gridlines.

Center Align Printed Data.

Print Formulas Instead of Formula Results.

Organize Worksheets by Color-Coding Tabs.

Change Default Column Labels.

Keep Cells in View with a Watch Window.

Protect Cells from Unauthorized Changes.

Freeze Headings for Easier Scrolling.

Wrap Text in Worksheet Cells.

Add Visual Interest with Slanted Text.

Magnify Cells with the Fit Selection Setting.

Add Pizzazz with a Background Picture.

Add a Calculator to the Excel Toolbar.

Center Text Across Columns without Merging Cells.

Add Comments to Formulas.

Turn Excel Data into a Pasteable Picture.

Generate Random Numbers in Your Cells.

Prevent Excel from Converting Fractions.

Retrieve a Stock Quote.

Count the Number of Days between Two Dates.

Join Text from Separate Cells.

Copy Page Setup Settings from One Worksheet to Another.

Find Data on Multiple Sheets with the VLookup Function.

Chapter 4: Enhance Your PowerPoint Presentations.

Turn a Word Outline into a PowerPoint Presentation.

Convert a Slide into a Bitmap Image.

Repeatedly Draw the Same Shape.

Create Evenly Spaced Duplicate Shapes.

Add Connector Lines to Objects.

Save File Size by Compressing Pictures.

Create Better-Looking Shadowed Text.

Turn a Photo into a Slide Background.

Tile a Picture in the Slide Background.

Enhance Presentations with Flash Movies.

Create Scrolling Credits.

Launch a Mini Slide Show Window.

Make Your Slide Show Start Automatically.

Using Word to Customize Handouts.

Chapter 5: Customize & Optimize Your Outlook Features.

Send Message Replies to Another Recipient.

Customize a Personal Distribution List.

Create a Custom Signature.

Clean a Mailbox of Space-Stealing Files.

Print a Master Copy of an Address Book.

Print a Contact Address on an Envelope or Label.

Display a Map to an Outlook Contact.

View a Calendar with Nonconsecutive Dates.

Display Two Time Zones.

Chapter 6: Improve Your Database Productivity Using Access.

Personalize a Database with a Custom Splash Screen.

Add Commonly Used Buttons to the Toolbox.

Open Access Objects with Disposable Toolbar Buttons.

Make a Database Window Work Like a Web Browser.

Zoom Entries for Easy Editing.

Automatically Open a Form at Startup.

Change a Form’s Tab Order.

Make a Form Interesting by Adding a Picture.

Automatically Open a Specific Record.

Set Up Forms to Close Automatically.

Add Ampersands to Caption Labels.

Save Time with Default Table Values.

Hide Existing Records in a Table.

Copy a Previous Record into a New Record.

Print a Table Relationships Map.

Using the Database Window to Append Records.

Optimize Performance by Reducing Database Size.

Using Input Masks to Control Users’ Table Data Entry.

Using Layout Preview to Quickly View a Report Layout.

View a Query or Report in Word or Excel.

Convert Forms and Reports into Web Pages.

Appendix.

Appendix A: Shortcuts.