Tricks of the Microsoft Office Gurus

ISBN: 0789733692
EAN: 2147483647

Year: 2003
Pages: 129

Authors: Paul McFedries

BUY ON AMAZON

Tricks of the Microsoft Office Gurus: Business Solutions
Table of Contents
Copyright
About the Author
Acknowledgments
We Want to Hear from You
Introduction
What s in This Book
This Book s Special Features
Part I: Office 2003 Application Tricks
Chapter 1. Building Dynamic Documents in Word
AutoCorrect Tricks
Using Custom Document Properties
Using Fields to Insert Dynamic Data
Performing Calculations in Tables
Adding Dummy Text to a Document
Chapter 2. Analyzing Data with Excel
Performing a What-If Analysis
Working with Scenarios
Using Goal Seek for What-If Analysis
Solving Complex Problems with Solver
Analyzing Data with Lists
Chapter 3. Constructing Knockout Presentations in PowerPoint
Organizing Your Presentation
Advanced Slide Formatting and Design
Advanced PowerPoint Animation Techniques
Taking PowerPoint to the Next Level with Microsoft Producer
Chapter 4. Taming Access Data
Creating a Totals Query
Creating Queries That Make Decisions
Running Action Queries
Preventing Form Errors by Validating Data
Using Form Controls to Limit Data-Entry Choices
Creating a Multiple-Column Report
Adding Calculations to a Report
Creating a Shadow Effect for Report Text
Controlling Report Output
Chapter 5. Getting the Most Out of Outlook
Getting the Most Out of Email
Getting the Most Out of the Calendar
Getting the Most Out of Contacts
Part II: Office 2003 Sharing and Collaboration Tricks
Chapter 6. Office in Overdrive: Sharing Data Between Applications
Using the Office Clipboard
Inserting an Object from Another Application
More Office Tools for Sharing Data
Merging Data from Access, Excel, and Outlook
Chapter 7. Working as a Team: Collaborating with Other Users
Collaborating on a Word Document
Sharing Excel Workbooks
Collaborating via Outlook
Using SharePoint to Collaborate on Office Documents
Chapter 8. Office Without Borders: Using Office Documents on the Web
Converting Office Documents to Web Pages
Displaying Web Pages in Excel
Office and FTP
Inserting Hyperlinks into Office Documents
Chapter 9. Collaborating with a Tablet PC and OneNote
Office and Windows XP Tablet PC Edition
Using the Office Ink Tools
Collaborating with Ink
Collaborating with OneNote 2003
Part III: Office 2003 Customization Tricks
Chapter 10. Customizing Office to Suit Your Style
Displaying, Moving, and Sizing Toolbars
Menu and Toolbar Customization Options
Creating Custom Menus
Creating Custom Toolbars
Creating Custom Keyboard Shortcuts in Word
Customizing the Office Common Dialog Boxes
Chapter 11. Maximizing Office with VBA Macros
Using a VBA Macro
Recording a VBA Macro
Working with the Visual Basic Editor
Working with Macros
VBA Programming Basics
Chapter 12. Putting VBA to Good Use: Practical Macros Everyone Can Use
Word Macros
Excel Macros
Outlook Macros
Chapter 13. Taking Advantage of Access Macros
Writing Access Macros
Associating Macros with Events
Troubleshooting Macros
Summary of Macro Actions
Part IV: Office 2003 Security Tricks
Chapter 14. Securing Office 2003
Setting Document Security Options
Protecting Your Privacy
Controlling VBA Security
Chapter 15. Enhancing Outlook Email Security and Privacy
Guarding Against Email Viruses
Blocking Spam Messages
Maintaining Your Privacy While Reading Email
Sending and Receiving Secure Email
Appendix A. Working with the Windows Registry
Understanding the Registry
Taking a Tour of the Registry
Keeping the Registry Safe
Working with Registry Keys and Settings
Finding Registry Entries
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Y
Z