- 2007 Microsoft® Office System 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
- 1. Introduction
- 1. Getting Started
- 1. Overview of the 2007 Microsoft Office System
- 2. The 2007 Office System User Interface: What’s Changed, What’s the Same
- 3. Managing Security and Privacy in the 2007 Office System
- 2. Collaboration Essentials
- 4. 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
- 5. Organizing and Finding Information in Microsoft Office OneNote
- Organizing a OneNote Notebook
- Adding Notes and Information to a Notebook
- Adding and Working with Text Notes
- Tagging Types of Notes
- Printing to OneNote
- Embedding References to Files
- Using Office OneNote and Office Outlook Together
- Inserting Audio or Video Recordings
- Adding Information to a Notebook from the Web
- Capturing Information on Your Windows Mobile–Powered Device
- Inserting an Image in a Notebook
- Creating a Drawing in OneNote
- Creating and Working with Tables in OneNote
- Finding Your Information
- Using a Notebook on More Than One Computer
- Working as a Team with Office OneNote 2007
- 6. Working as a Team in a Microsoft Office Groove Workspace
- 7. Sharing and Communicating Using Microsoft Office Groove
- 4. Collaborating and Sharing with Others
- 3. Word
- 8. Mastering Page Setup and Pagination
- 9. Outlining Documents for Clarity and Structure
- Outlining Enhancements in Word 2007
- Creative Outlining with Word 2007
- Eleven Reasons to Outline Your Next Complex Document
- Viewing a Document in Outline View
- Creating a New Outline
- Choosing Outline Display
- Working with Headings in Outline View
- Displaying Outline and Print Layout View at the Same Time
- Changing Your Outline
- Printing Your Outline
- Using the Document Map vs. Using Outline View
- 10. Advanced Layout and Formatting
- Layout and Design Fundamentals
- Using Backgrounds and Watermarks
- Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames
- Creating Text Boxes
- Inserting Text into Text Boxes and Shapes
- Using Floating Frames for Comments, Footnotes, Tables, and Fields
- Formatting Text Boxes and AutoShapes
- Linking Text Boxes to Flow Text from One Text Box to Another
- Moving Between Linked Text Boxes
- Copying or Moving Linked Text Boxes
- Breaking Text Box Links
- Deleting Linked Text Boxes Without Losing Text
- Switching Between Text Boxes and Frames
- Configuring Word 2007 Layout Options
- Commanding Attention with Borders and Shading
- Adding a Simple Border
- Creating Enhanced Borders
- Creating Partial Borders
- Using a Page Border
- Adding Borders to Document Sections and Paragraphs
- Adjusting Border Spacing
- Inserting Graphical Horizontal Lines
- Adding Borders to Pictures
- Adding Table Borders
- Applying Shading Behind Content
- 11. Revising Documents Using Markup Tools
- Benefits of an Organized Revision Process
- Familiarizing Yourself with Markup Tools
- Using the Highlight Tool
- Adding and Managing Comments Effectively
- Configuring Reviewers’ User Names
- Configuring Colors Associated with Reviewers
- Allowing Reviewers to Use Only the Comments Feature
- Inserting Standard Comments
- Configuring Comment Balloon and Reviewing Pane Options
- Reviewing Comments
- Deleting Comments
- Printing Comments
- Saving a Document with Comments as a Web Page
- Tracking Changes
- Comparing and Combining Documents
- 4. Excel
- 12. How to Work a Worksheet and a Workbook
- Moving Around Regions
- Understanding Selection
- Techniques for Entering Data
- Managing Worksheets
- Viewing Worksheets
- Protecting Worksheets
- Managing Multiple Workbooks
- Opening Multiple Windows for the Same Workbook
- Hiding and Protecting Workbooks
- 13. Building Formulas
- Formula Fundamentals
- Understanding the Precedence of Operators
- Using Cell References in Formulas
- Editing Formulas
- Understanding Error Values
- Using Functions: A Preview
- Working with Formulas
- Naming Cells and Cell Ranges
- Using Names in Formulas
- Defining and Managing Names
- Editing Names
- Workbook-Wide vs. Worksheet-Only Names
- Creating Names Semiautomatically
- Naming Constants and Formulas
- Creating Three-Dimensional Names
- Using Names in Formulas
- Creating a List of Names
- Replacing References with Names
- Using Go To with Names
- Getting Explicit About Intersections
- Creating Three-Dimensional Formulas
- Formula-Bar Formatting
- Using Structured References
- Naming Cells and Cell Ranges
- Worksheet Calculation
- Using Arrays
- Linking Workbooks
- Creating Conditional Tests
- Formula Fundamentals
- 14. Using Functions
- Using the Built-In Function Reference in Excel
- Exploring the Syntax of Functions
- Inserting Functions
- Understanding Mathematical Functions
- Understanding Text Functions
- Understanding Logical Functions
- Understanding Information Functions
- Understanding Lookup and Reference Functions
- 15. Analyzing Data with PivotTable Reports
- Introducing PivotTables
- Creating a PivotTable
- Rearranging PivotTable Fields
- Refreshing a PivotTable
- Changing the Numeric Format of PivotTable Data
- Choosing Report Layout Options
- Formatting a PivotTable
- Displaying Totals and Subtotals
- Sorting PivotTable Fields
- Filtering PivotTable Fields
- Changing PivotTable Calculations
- Grouping and Ungrouping Data
- Displaying the Details Behind a Data Value
- Creating PivotCharts
- 12. How to Work a Worksheet and a Workbook
- 5. PowerPoint
- 16. Introduction to PowerPoint 2007
- 17. Working with Text
- 18. Working with Objects, Diagrams, and Charts in PowerPoint 2007
- 19. Collaborating and Sharing
- 20. Working with External Data in PowerPoint 2007
- 21. Setting Up and Presenting a Slide Show
- 6. Outlook
- 22. Introducing Outlook 2007
- 23. Finding and Organizing Messages
- 24. Securing Your System, Messages, and Identity
- Configuring HTML Message Handling
- Protecting Messages with Digital Signatures
- Signing Messages
- Understanding S/MIME and Clear-Text Options
- Adding Your Digital Signature
- Setting Global Security Options
- Creating and Using Security Profiles
- Reading Signed Messages
- Changing Certificate Trust Relationships
- Configuring CA Trust
- Configuring CA Trust for Multiple Computers
- Viewing and Validating a Digital Signature
- Encrypting Messages
- Protecting Data with Information Rights Management
- 25. Collaboration with Outlook and Windows SharePoint Services
- Understanding Windows SharePoint Services Collaboration
- Setting Up Alerts
- Working with Shared Documents
- Working with Shared Contacts
- Linking a Team Calendar to Outlook
- Configuring Alerts in Outlook
- Using Outlook to Work with SharePoint Libraries and Files
- Connecting a SharePoint Library to Outlook
- Downloading Files from a SharePoint Library to Outlook
- Opening Files from a SharePoint Site in Outlook
- Editing Files from a SharePoint Site in Outlook
- Removing SharePoint Files in Outlook
- Removing SharePoint Folders in Outlook
- Using E-Mail to Add a File to a SharePoint Library
- 7. Access
- 26. Exploring the New Look of Access 2007
- Opening Access for the First Time
- Getting Started—A New Look for Access
- Understanding Content Security
- Understanding the New Ribbon Feature
- Understanding the New Navigation Pane
- Using the Single-Document vs. Multiple-Document Interface
- Modifying Global Settings via the Access Options Dialog Box
- 27. Creating Your Database and Tables
- Creating a New Database
- Creating Your First Simple Table by Entering Data
- Creating a Table Using a Table Template
- Creating a Table in Design View
- Defining Fields
- Defining a Primary Key
- Defining a Table Validation Rule
- Understanding Other Table Properties
- Defining Relationships
- Adding Indexes
- Setting Table Design Options
- Creating a Default Template for New Databases
- Printing a Table Definition
- Database Limitations
- 28. Creating and Working with Simple Queries
- Selecting Data from a Single Table
- Testing Validation Rule Changes
- Working in Query Datasheet View
- Moving Around and Using Keyboard Shortcuts
- Working with Subdatasheets
- Changing Data
- Working with Hyperlinks
- Sorting and Searching for Data
- Sorting Data
- Searching For and Filtering Data
- Using Find
- Filtering by Selection
- Using the Filter Window
- Using Filter By Form
- 29. Building a Form
- Forms and Object-Oriented Programming
- Starting from Scratch—A Simple Input Form
- Working with Quick Create Commands and the Form Wizard
- Simplifying Data Input with a Form
- 30. Constructing a Report
- 8. Microsoft Office Programming Primer
- 31. 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
- 32. 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
- 31. VBA Primer
- A. Appendix: Installing and Configuring the 2007 Office System
- B. Index to Troubleshooting Topics
- C. About the Authors
- D. Choose the Right Book for You
- Index
- About the Author
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- 26. Exploring the New Look of Access 2007
An important part of privacy is ensuring that your personal information—your e-mail address, a credit card account number, even just your name—is known only to the people you decide to give it to and only in the places where you want it. These days, protecting your privacy can also mean avoiding unwanted advertising or marketing—a lot of which comes across the Internet.
One of the assumptions that underlie the design of the 2007 Office system is that users of the programs are connected to the Internet while they work or have regular access to the Internet. Microsoft has built in certain services that rely on users being connected, services such as displaying updated templates from Microsoft Office Online, up-to-date online Help content, even a product improvement program that you can voluntarily join. To use these services, however, you sometimes need to grant permission to Microsoft to collect data or to maintain the state of the software that you’re running. One of the ways that you can control what information Microsoft sends to you and that you send to Microsoft is to review the settings for privacy options in the Trust Center. The Privacy Options page in the Trust Center (as it’s displayed in PowerPoint) is shown in Figure 3-9.
Note
For more information about the Document Inspector, see "Removing Hidden Data and Personal Information from Microsoft Office Documents".
Note
In OneNote, Project, and SharePoint Designer, you can view privacy options by clicking Privacy Options on the Help menu.
Some privacy options affect what information and files are downloaded from or sent to Microsoft. Other options, especially those for Word, can help protect your privacy when you share files with other people. Here’s a summary of the privacy options you can set. (You can read a little about particular items on the Privacy Options page by clicking the icon at the right of the option’s name.)
Search Microsoft Office Online For Help Content When I’m Connected To The Internet Downloads up-to-date online Help from Office Online. You must be connected to the Internet to receive the download. Only the article that you select in the Help system’s Search results box is downloaded.
Update Featured Links From Microsoft Office Online (applies to Access, Excel, PowerPoint, Word, and Visio) Downloads headlines and featured templates from Office Online. You must be connected to the Internet to receive the downloads.
Download A File Periodically That Helps Determine System Problems Allows a file to be downloaded from Office Online to your computer so that if your computer becomes unstable or crashes, the Microsoft Office Diagnostics tool runs to help diagnose and repair the problem for you. By selecting this option, you allow Microsoft to ask you to send error reports for certain types of error messages that you might receive. When you send a report, the data can help Microsoft understand and try to fix the problem. You also allow Microsoft to provide you with up-to-date online Help information that helps to troubleshoot the problem on your computer.
Sign Up For The Customer Experience Improvement Program By selecting this option, you allow Microsoft to collect information from your computer, including error messages that are generated by its software, the kind of computer equipment you are using, whether your computer is having any difficulty running Microsoft software, and whether your hardware and software respond well and perform quickly. In general, this information is collected once each day. The information is sent to Microsoft anonymously and is not used in advertising or sales.
Check Microsoft Office Documents That Are From Or Link To Suspicious Web Sites (applies to Access, Excel, InfoPath, PowerPoint, Visio, and Word) Enables spoofed Web site detection to help protect you from phishing schemes. When Office detects a link to a Web site with a spoofed domain name, you are notified in a security alert. The spoofed Web site detection check is performed locally on your computer. This feature does not send any information to Microsoft.
Additional Privacy Options for Word
Here are some additional privacy options that you can select for your work in Word:
Warn Before Printing, Saving, Or Sending A File That Contains Tracked Changes Or Comments. By selecting this option, you see a warning if you try to print, save, or send a document that contains revision marks or comments. Material marked for deletion might be confidential or out of date. Comments might include information that is best kept among the people who reviewed the document.
Store Random Number To Improve Merge Accuracy. This option increases your chances of getting good results when you merge tracked changes from multiple reviewers.
Make Hidden Markup Visible When Opening Or Saving. Ensures that you see all tracked changes that remain in a document when you open or save it. Seeing the remaining changes lets you remove any unwanted revisions before you send the document out for review.
Remove Personal Information From File Properties On Save. This option is available only if you are working with a document that was created in an earlier version of Microsoft Office and you used this option in that version to remove personal information. To remove personal information from this document, click Document Inspector.
Inside Out: The Office 2007 Privacy Statement
Most commercial Web sites post a privacy statement (a link to the statement often appears at the bottom of the page) that describes what personal data is collected by the Web site and how that data is to be used. You can view the privacy statement for the 2007 Office system in several ways. In the Trust Center, you can access the privacy statement by using the link that appears on the Trust Center’s home page, shown here. (You can also access the privacy statement by searching in the online Help for privacy statement.)
When you click the link in the Trust Center, you’ll see a one-page summary of the privacy practices followed by Microsoft in publishing the 2007 Office release. The summary page provides links to the full statement for those interested in reading all the details.
-
No Comment