Cover image for Microsoft Office 2003 top 100 simplified tips & tricks
Microsoft Office 2003 top 100 simplified tips & tricks
Gunter, Sherry Kinkoph.
Personal Author:
Publication Information:
Hoboken, N.J. : Wiley Pub., [2003]

Physical Description:
240 pages : illustrations ; 26 cm
General Note:
"From Marangraphics & Wiley Publishing, Inc."

Includes index.
Title Subject:
Added Corporate Author:
Format :


Call Number
Material Type
Home Location
Item Holds
HF5548.4.M525 K65 2003 Adult Non-Fiction Non-Fiction Area

On Order



This full-colour, step-by-step consumer guide to using Office X is for visual learners who want a straightforward show me, don't tell me why approach. Featuring screen shots with specific, numbered instructions showing the actions needed to perform to execute certain tasks, the material covers the top 100 useful techniques that can be performed in Office.

Reviews 1

Library Journal Review

Expect demand for guides on components of the newest version of Microsoft Office, as workplaces begin upgrading and PC manufacturers begin bundling. For medium and larger public libraries, the three entries in the "Top 100" series will make useful supplements for patrons who are comfortable with the basics of earlier Office versions; most of the content is not unique to v.2003. Each book contains illustrated, step-by-step tips to make tasks easier, shows advanced ideas, and demonstrates new features. Difficulty levels of each are noted, and "Did You Know?" sections add extra information. Word includes tips ranging from creating custom images for bullets to using an Outlook address on a Word-printed envelope, while Excel furnishes basic keyboard shortcuts and information on converting work sheets into lists, among other things. Office clues readers into areas like customizing menus and toolbars and converting Access forms or reports to web pages; appendixes cover keyboard shortcuts and a brief introduction to Picture Manager. For all libraries, the two updated Visual QuickStart titles are typically screenshot and step-by-step-instruction heavy; tips offer extra guidance. Outlook's introduction lists new features in each Outlook version from 1998 to 2003, an appendix explains program configuration, and the rest of the book covers common functions and tasks. Its index leaves something to be desired, e.g., there is no entry under "Viruses," although a section does discuss viruses and blocked email attachments; the text's coverage of some new 2003 features is also lacking. Not an essential purchase. Word's introduction highlights new and improved features, the text covers everything from text formatting basics to customizing Word's features, and its appendix covers menus and keyboard shortcuts; clear and recommended for beginners to intermediate users. More thorough than the QuickStart Outlook guide, How To Do provides clear explanations of why and how features work, tips and sidebars for further information, and step-by-step instructions on completing common tasks. It also discusses new features, e.g., the Research Pane; recommended for all libraries. Show Me takes a whirlwind tour of Office programs, employing common tools and features and using programs together. Task-based chapters provide a nice overview of the basics of each program; appendixes outline Office Specialist exams and contain a troubleshooting, question-based index to answers in the text. Step-by-step instructions, extensively labeled screen shots, added information tips, and See Also notes make this a useful introduction. For adventuresome beginners to advanced users, Complete Reference begins with a summary of new features, moves on to the typical explanation of the interface and of relational databases in general, and then goes through various applications. The CD holds sample files and a "quick reference" in PDF format; exercises assist in self-study. For larger libraries. (c) Copyright 2010. Library Journals LLC, a wholly owned subsidiary of Media Source, Inc. No redistribution permitted.

Table of Contents

1 Lighten Your Workload with General Office Tips and Tricks
Task #1 Clear Your Screen of Default Task Panesp. 4
Task #2 Quickly Learn Shortcut Keysp. 6
Task #3 Simplify Repeated Tasks with Customized Menusp. 8
Task #4 Create a Customized Toolbarp. 10
Task #5 Create a Customized Toolbar Buttonp. 12
Task #6 Assign a Hyperlink to a Buttonp. 14
Task #7 Using an Office Program to Manage Computer Filesp. 16
Task #8 Store Files in a Different Default Locationp. 18
Task #9 Change File Properties to Make Documents Privatep. 20
Task #10 Recover a File After a Systems Failurep. 22
Task #11 Convert Scanned Documents into Text Filesp. 24
Task #12 Print Placeholders in Place of Graphicsp. 28
Task #13 Using the Ungroup Command to Customize Clip Artp. 30
Task #14 Save a WordArt Object as a Graphic Filep. 32
Task #15 Using Text Boxes to Position Clip Artp. 34
2 Timesaving Tricks and Tips for Word
Task #16 Utilize Status Bar Shortcutsp. 38
Task #17 Using the Work Menu to Add Favorite Filesp. 40
Task #18 Speed Up Tasks with Macro Buttonsp. 42
Task #19 Remove a File from the Recent Files Listp. 44
Task #20 Using the Zoom Options to Conserve Paper when Printingp. 45
Task #21 Navigate Long Documents with a Table of Contentsp. 46
Task #22 Navigate Long Documents Using Bookmarksp. 48
Task #23 Using AutoText to Automate Repetitive Typingp. 50
Task #24 Remove a Text Hyperlinkp. 52
Task #25 Keep Words Together with a Non-Breaking Spacep. 53
Task #26 Control Sentence Spacingp. 54
Task #27 Track Word Countp. 55
Task #28 Add Fake Textp. 56
Task #29 Look up a Synonymp. 57
Task #30 Check Your Document for Cliched Textp. 58
Task #31 Using the Research Pane to Translate Textp. 60
Task #32 Add Line Numbers in the Document Marginp. 62
Task #33 Set Off a Paragraph with a Borderp. 64
Task #34 Resume Numbering in an Interrupted Numbered Listp. 66
Task #35 Quickly Insert Horizontal Linesp. 67
Task #36 Emphasize Paragraphs with Drop Capsp. 68
Task #37 Customize Comment Textp. 70
Task #38 Add Captions to Your Graphicsp. 72
Task #39 Type Out a Tablep. 74
Task #40 Keep Table Column Headings in Sightp. 75
Task #41 Place a Table Within a Tablep. 76
Task #42 Align Shapes with Grid Linesp. 77
Task #43 Add Gradient Fills to Text Boxesp. 78
Task #44 Create a Watermarkp. 80
Task #45 View Multiple Pages in Print Layout Viewp. 84
3 Increase the Power of Your Spreadsheet with Excel
Task #46 Automatically Open Your Favorite Workbookp. 88
Task #47 Access More Files by Increasing the Recent Files Listp. 89
Task #48 Set a New Default Font and Sizep. 90
Task #49 Change Gridline Colorp. 92
Task #50 Increase Readability by Printing Gridlinesp. 93
Task #51 Center Align Printed Datap. 94
Task #52 Print Formulas Instead of Formula Resultsp. 95
Task #53 Organize Worksheets by Color-Coding Tabsp. 96
Task #54 Change Default Column Labelsp. 97
Task #55 Keep Cells in View with a Watch Windowp. 98
Task #56 Protect Cells from Unauthorized Changesp. 100
Task #57 Freeze Headings for Easier Scrollingp. 102
Task #58 Wrap Text in Worksheet Cellsp. 103
Task #59 Add Visual Interest with Slanted Textp. 104
Task #60 Magnify Cells with the Fit Selection Settingp. 106
Task #61 Add Pizzazz with a Background Picturep. 107
Task #62 Restrict Cell Entries with Data Validationp. 108
Task #63 Add a Calculator to the Excel Toolbarp. 110
Task #64 Center Text Across Columns without Merging Cellsp. 112
Task #65 Add Comments to Formulasp. 113
Task #66 Turn Excel Data into a Pasteable Picturep. 114
Task #67 Add a Camera to the Excel Toolbarp. 116
Task #68 Generate Random Numbers in Your Cellsp. 118
Task #69 Prevent Excel from Converting Fractionsp. 119
Task #70 Using the Text to Speech Tool to Read Back Cellsp. 120
Task #71 Retrieve a Stock Quotep. 122
Task #72 Count the Number of Days Between Two Datesp. 124
Task #73 Join Text from Separate Cellsp. 125
Task #74 Copy Page Setup Settings from One Worksheet to Anotherp. 126
Task #75 Find Data on Multiple Sheets with the VLookup Functionp. 128
4 Enhance Your PowerPoint Presentations
Task #76 Turn a Word Outline into a PowerPoint Presentationp. 132
Task #77 Convert a Slide into a Bitmap Imagep. 134
Task #78 Repeatedly Draw the Same Shapep. 136
Task #79 Create Evenly Spaced Duplicate Shapesp. 137
Task #80 Add Connector Lines to Objectsp. 138
Task #81 Alter Clip Art Colors to Match the Slide Designp. 140
Task #82 Save File Size by Compressing Picturesp. 142
Task #83 Create Better-Looking Shadowed Textp. 144
Task #84 Turn a Photo into a Slide Backgroundp. 146
Task #85 Title a Picture in the Slide Backgroundp. 148
Task #86 Enhance Presentations with Flash Moviesp. 150
Task #87 Create Scrolling Creditsp. 152
Task #88 Launch a Mini Slide Show Windowp. 156
Task #89 Make Your Slide Show Start Automaticallyp. 157
Task #90 Using Word to Customize Handoutsp. 158
5 Outlook Techniques
Task #91 Send Message Replies to Another Recipientp. 162
Task #92 Customize a Personal Distribution Listp. 164
Task #93 Create a Custom Signaturep. 166
Task #94 Clean a Mailbox of Space-Stealing Filesp. 170
Task #95 Print a Master Copy of an Address Bookp. 172
Task #96 Print a Contact Address on an Envelope or Labelp. 173
Task #97 Display a Map to an Outlook Contactp. 174
Task #98 View a Calendar with Nonconsecutive Datesp. 175
Task #99 Display Two Time Zonesp. 176
Task #100 Print a Blank Monthly Calendarp. 178
6 Improve Your Database Productivity Using Access
Task #101 Personalize a Database with a Custom Splash Screenp. 182
Task #102 Add Commonly Used Buttons to the Toolboxp. 184
Task #103 Open Access Objects with Disposable Toolbar Buttonsp. 186
Task #104 Make a Database Window Work Like a Web Browserp. 188
Task #105 Zoom Entries for Easy Editingp. 189
Task #106 Automatically Open a Form at Startupp. 190
Task #107 Change a Form's Tab Orderp. 191
Task #108 Automatically display Form Combo Boxesp. 192
Task #109 Make a Form Interesting by Adding a Picturep. 194
Task #110 Automatically Open a Specific Recordp. 196
Task #111 Set Up Forms to Close Automaticallyp. 198
Task #112 Add Ampersands to Caption Labelsp. 200
Task #113 Save Time with Default Table Valuesp. 201
Task #114 Hide Existing Records in a Tablep. 202
Task #115 Copy a Previous Record into a New Recordp. 203
Task #116 Print a Table Relationships Mapp. 204
Task #117 Using the Database Window to Append Recordsp. 206
Task #118 Optimize Performance by Reducing Database Sizep. 207
Task #119 Using Input Masks to Control Users' Table Data Entryp. 208
Task #120 Add a Background Image to a reportp. 210
Task #121 Using Layout Preview to Quickly View a Report Layoutp. 212
Task #122 View a Query or Report in Word or Excelp. 213
Task #123 Convert Forms and Reports into Web Pagesp. 214
Task #124 Open Word or Excel with a Form Buttonp. 216
Task #125 Link Tables from Another Databasep. 218
A Appendix A Keyboard Shortcuts
General Office Shorcutsp. 222
Word Shortcutsp. 223
Excel Shortcutsp. 224
PowerPoint Shortcutsp. 225
Outlook Shortcutsp. 226
Access Shortcutsp. 227
B Appendix B Improving Pictures with Microsoft Office Picture Manager
Introducing the Microsoft Office Picture Managerp. 228
Crop a Picture to Remove Unwanted Areasp. 229
Remove Red Eyep. 230
Resize a Picturep. 231