Office 2003 Visual Quick Tips
* 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
Table of Contents
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 A: Shortcuts.
Sign up now »
- FTLead Software EngineerSA
- FTWeb Developer- Drupal and PHP. Exciting new position- #2 in Dev team.$100k+SuperNSW
- FTSenior Python DeveloperNSW
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTOS Web Applications DeveloperNSW
- FTQuality ManagerSA
- FTSenior Python DeveloperNSW
- FTSenior Python Web Applications DeveloperNSW
- FTR&D EngineerSA
As users bring multiple devices to the workplace, IT departments need to have a single view of all their mobile devices. Find out how to build a secure and reliable ...
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
"Too little too late. Spice normally has better standards than this. I ..."
Spiceworks' free management software gets integrated MDM
- Commonwealth Bank leads four Australian brands in the 2013 top 100 Global brands list
- More Australians are using mobiles to connect to social media: report
- Oo.com.au partners with Responsys to overhaul digital customer strategy
- Coles Flybuys wins over Aussie consumers in new customer loyalty schemes report
- Tablet advertising exceeds smartphone spend in March quarter: IAB