---

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