Table of Contents

Tricks of the Microsoft® Office Gurus: Business Solutions
By Paul McFedries
...............................................
Publisher: Que
Pub Date: April 12, 2005
Print ISBN: 0-7897-3369-2
Pages: 552

Table of Contents  | Index

		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