Book description
Learn everything you need to know for creating dynamic, robust, more secure documents with the 2007 Microsoft Office system--from the inside out! This book packs in hundreds of time-saving solutions, troubleshooting tips, and the workarounds you need for creating and sharing powerful documents and templates--all in concise, fast-answer format. Ideal for users with more advanced experience using either the 2007 Office suites or earlier editions of Office, this comprehensive guide moves beyond the basics. You will learn how to use Microsoft Office Word 2007, Microsoft Office Excel® 2007, and Microsoft Office PowerPoint® 2007 to create exactly the document you need--from business communications to sophisticated business reports and professional-looking presentations. You'll learn how to create templates and custom macros and how to build custom add-ins. You'll even learn how to exploit new XML document formats. Plus, you'll get tools, eBooks, and more on the companion CD. With INSIDE OUT, you get all muscle and no fluff!
Table of contents
-
Advanced Microsoft® Office Documents 2007 Edition Inside Out
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- A Note Regarding Supplemental Files
- Acknowledgments
- About the CD
- Conventions and Features Used in This Book
- Introduction
-
1. Document Essentials
- 1. Introducing the 2007 Microsoft Office System
- 2. Understanding Electronic Documents
-
3. Collaborating and Sharing with Others
- Understanding and Using the 2007 Office System Collaboration Environments
- Creating and Using Shared Workspaces with Windows SharePoint Services
- Creating and Using Groove Workspaces
- Using Office OneNote 2007 as a Collaboration Tool
-
2. Word
- 4. Building Easy-to-Manage, Robust Documents
- 5. Styles
-
6. Tables
- Chapter Assumptions
- What’s New for Tables in Word 2007
- The Great Document Organizer
- Key Practices for Creating Tables That Work
- Using Tables to Create Page Layout
- Formatting Financial Tables
- Managing Tables from Other Sources
- 7. Managing Graphics
- 8. Sections
- 9. Quick Parts
- 10. Reference Tables and Tools
- 11. Content Controls: Creating Forms and Then Some
- 12. Planning Your Documents
-
3. Excel
- 13. Data-Based Documents: Formatting and Managing Worksheets
-
14. Working with Data
- Chapter Assumptions
- What’s New for Number Crunching in Excel 2007
- Using Tables as a Data Tool
- Creating Formulas—Working with Functions
- Simplifying Data Organization
- When You Need to Use External Data
- 15. Charts
- 16. Powerful Reporting, Easier Than You Think: A PivotTable Primer
- 17. The Excel–Visio Connection
-
4. PowerPoint
- 18. Creating Professional Presentation Graphics
- 19. Slides and Presentations
-
5. Templates, Automation, and Customization
- 20. The Many Faces of Microsoft Office Templates
-
21. VBA Primer
- When and Why to Use VBA
- Introduction to the VBA Language and Code Structure
- Understanding and Using the Visual Basic Editor
-
Writing, Editing, and Sharing Simple Macros
- Creating Modules and Starting Procedures
- Objects, Properties, and Methods
- Object Models
- Using Auto Lists
- Variables
- Constants
- Collection Objects
- Grouping Statements
- Loops
- Conditional Structures
- Operators
- Message Boxes and Input Boxes
- Running One Macro from Another
- Setting Macros to Conditionally Stop Executing Commands
- Running Macros and Compiling Projects
- Understanding Errors
- Creating Error Handlers
- Getting Help
- Saving and Sharing Macros
- Using VBA to Save Time on Document Production and Troubleshooting
- Introduction to Using Events
- Creating UserForms (Dialog Boxes)
- Next Steps for Working with Automation in Microsoft Office
-
22. Office Open XML Essentials
- Chapter Assumptions
- XML Basics for Reading Your Documents
- Getting to Know the Office Open XML Formats
- Editing and Managing Documents Through XML
- Customizing the Ribbon
- Binding Data to Content Controls
- Next Steps for Working with the Office Open XML Formats
- 23. Using VBA and XML Together to Create Add-Ins
- Index to Troubleshooting Topics
- About the Author
- Choose the Right Book for You
- Index
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Product information
- Title: Advanced Microsoft® Office Documents 2007 Edition Inside Out
- Author(s):
- Release date: March 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735622852
You might also like
book
Special Edition Using WordPerfect Office X3
Special Edition Using WordPerfect Office X3 is crammed full of tips, tricks, and practical examples that …
book
Office 2003 XML
In Microsoft's Office 2003, users experience the merger of the power of the classic Office suite …
book
XML in Office 2003: Information Sharing with Desktop XML
Co-authors are the world-renowned inventor of markup languages and a developer of the W3C XML Schema …
book
Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed
Get expert techniques and best practices for creating professional-looking documents, slide presentations, and workbooks. And apply …