2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)
Conventions and Features Used in This Book
- Sidebars
Chapter 1: Overview of the 2007 Microsoft Office System
- Rounding Out the Office System Programs
Chapter 2: The 2007 Office System User Interface-What’s Changed, What’s the Same
- Keyboard Shortcuts in the 2007 Office Release
Chapter 3: Managing Security and Privacy in the 2007 Office System
- Content from the Outside
- Don’t Forget Security Updates
- Digitally Signing a Macro Project
- Additional Privacy Options for Word
- What IRM Won’t Do for You
Chapter 4: Collaborating and Sharing with Others
- Small Business or Individual? Go Live.
Chapter 5: Organizing and Finding Information in Microsoft Office OneNote
- OneNote Options
- Sharing Audio or Video Recordings
- OneNote Calculations
- Entering Information with a Pen
- Storing Shared Notebooks on a Windows SharePoint Services Site
Chapter 6: Working as a Team in a Microsoft Office Groove Workspace
- Why You Need a Groove Account
- About Groove Security
- Navigating Together
- Ways to List Workspaces in the Workspace List
Chapter 7: Sharing and Communicating Using Microsoft Office Groove
- Using a Subfolder as a File-Sharing Workspace
- Integrating Windows Messenger and Groove
- Contact-Naming Conflicts
Chapter 8: Mastering Page Setup and Pagination
- Binding Documents
- Creating a Page or Section Border
- Working with Field Codes in Headers and Footers
- Making Room for Line Numbers
Chapter 9: Outlining Documents for Clarity and Structure
- Forget What’s on the Clipboard?
Chapter 10: Advanced Layout and Formatting
- Including Watermarks in Document Headers
- Converting a Frame to a Text Box
Chapter 11: Revising Documents Using Markup Tools
- Inserting Voice and Handwritten Comments
- Comments, Revisions, and the Document Inspector
Chapter 12: How to Work a Worksheet and a Workbook
- Navigating Multiple Selections
- Go To Special Keyboard Shortcuts
- Smart Tags
- Dragging Worksheets Between Workbooks
Chapter 13: Building Formulas
- Practical Concatenation
- Rules for Naming
- Troubleshooting
- Selecting Cells While a Dialog Box Is Open
- No More Natural-Language Formulas
- Are Your References Qualified?
- Multithreaded Calculation
- A Single-Cell Array Formula Application
Chapter 14: Using Functions
- Automatic Range Expansion
- A MOD Example
- Try Your Luck
- Using the Flexible MROUND Function
- AVERAGE vs. AVG
- An ISERR Example
Chapter 16: Introduction to PowerPoint 2007
- Data That Could Be Lost or Changed in PowerPoint 2007
- Double Design Tabs?
- Before Publishing to a Slide Library, Read This
Chapter 17: Working with Text
- Add the Same Effect to Text in Multiple Places
- Working with the SmartArt Text Pane
- Slow Performance and Contextual Spelling
Chapter 18: Working with Objects, Diagrams, and Charts in PowerPoint 2007
- Sizing Photos
- Add Clips to Your Clip Organizer
Chapter 19: Collaborating and Sharing
- Working with Office Groove 2007
- What IRM Can-and Can’t-Do
- Preventing Changes Using the Mark As Final Command
Chapter 20: Working with External Data in PowerPoint 2007
- Multimedia Formats
Chapter 21: Setting Up and Presenting a Slide Show
- Slide Size and Orientation
Chapter 27: Creating Your Database and Tables
- Choosing Field Names
- Nulls and Zero-Length Strings
Chapter 28: Creating and Working with Simple Queries
- Understanding Field Names and Captions
Chapter 29: Building a Form
- Some Key Form Design Terms
Chapter 31: VBA Primer
- Setting Up the Sample Document
Категории