2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)

ISBN: 0735623244
EAN: 2147483647

Year: 2007
Pages: 299

BUY ON AMAZON

Table of Contents
Back Cover
2007 Microsoft Office System Inside Out
About the CD
Using the CD
System Requirements
Support Information
Conventions and Features Used in This Book
Design Conventions
Introduction
Who This Book Is For
How This Book Is Organized
Part 1: Getting Started
Chapter 1: Overview of the 2007 Microsoft Office System
The New World of Work
The New Microsoft Office User Interface
The New Microsoft Office XML File Formats
What Else is New?
Chapter 2: The 2007 Office System User Interface-Whats Changed, Whats the Same
A Quick Tour and Comparison
The Ribbon and Command Tabs
Customizing the Quick Access Toolbar
The Microsoft Office Button and Menu
Working in Context: More Tabs, Plus Some Menus and Toolbars
Galleries and Live Preview
Getting Help
Chapter 3: Managing Security and Privacy in the 2007 Office System
Setting Your Privacy Options
Removing Hidden Data and Personal Information from Microsoft Office Documents
Applying Information Rights Management
Assigning a Password to a Document
Avoiding Phishing Schemes
Part 2: Collaboration Essentials
Chapter 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
Chapter 5: Organizing and Finding Information in Microsoft Office OneNote
Adding Notes and Information to a Notebook
Finding Your Information
Using a Notebook on More Than One Computer
Working as a Team with Office OneNote 2007
Chapter 6: Working as a Team in a Microsoft Office Groove Workspace
Getting Started with Groove
Setting Up a Groove Account
The View from the Launchbar
Groove Workspace Basics
Outfitting a Groove Workspace with Tools
Chapter 7: Sharing and Communicating Using Microsoft Office Groove
Managing Groove Communications
Working with Groove Contacts
Introducing the Groove Forms Tool
Managing Workspace Archives and Templates
Part 3: Word
Chapter 8: Mastering Page Setup and Pagination
Basic Page Setup Options
Changing Margins and Orientation
Selecting a Paper Size and Source
Controlling Page and Section Breaks
Working with Varying Page Settings
Including Headers and Footers
Working with the Document Grid
Adding and Controlling Line Numbers
Chapter 9: Outlining Documents for Clarity and Structure
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
Chapter 10: Advanced Layout and Formatting
Using Backgrounds and Watermarks
Controlling Text Placement and Formatting with Text Boxes, Shapes, 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
Chapter 11: Revising Documents Using Markup Tools
Familiarizing Yourself with Markup Tools
Using the Highlight Tool
Adding and Managing Comments Effectively
Tracking Changes
Comparing and Combining Documents
Part 4: Excel
Chapter 12: How to Work a Worksheet and a Workbook
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
Chapter 13: Building Formulas
Using Functions: A Preview
Working with Formulas
Worksheet Calculation
Using Arrays
Linking Workbooks
Creating Conditional Tests
Chapter 14: Using Functions
Exploring the Syntax of Functions
Inserting Functions
Understanding Mathematical Functions
Understanding Text Functions
Understanding Logical Functions
Understanding Information Functions
Understanding Lookup and Reference Functions
Chapter 15: Analyzing Data with PivotTable Reports
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
Part 5: PowerPoint
Chapter 16: Introduction to PowerPoint 2007
Customizing Office PowerPoint 2007
File Formats
Formatting
PowerPoint 2007 Views
Themes
Tables
Custom Slide Layouts
PowerPoint 2007 Slide Libraries
Program Recovery
Chapter 17: Working with Text
Finding and Replacing Words or Phrases
Creating and Saving Customized Theme Fonts
Formatting with WordArt
Adding Punch to Your Bulleted Lists
Writing on Slides During a Presentation
Using Headers and Footers
Working with Proofing Tools
Chapter 18: Working with Objects, Diagrams, and Charts in PowerPoint 2007
Adding Clip Art
Using SmartArt
Adding Sounds
Including Movies
Playing with Animations
Animating SmartArt Graphics
Creating Charts and Diagrams
Chapter 19: Collaborating and Sharing
Working with Windows SharePoint Services
Reviewing, Approving, and Tracking Changes
Protecting Your Document
Securing Your Presentation
Using the Document Inspector
Chapter 20: Working with External Data in PowerPoint 2007
Working with Excel 2007
Working with Access 2007
Blocking and Unblocking External Content
Using Trusted Locations
Setting Up Security Alerts and Trusted Publishers
Chapter 21: Setting Up and Presenting a Slide Show
Creating Custom Slide Shows
Adding Transitions
Using Presenter View
Working with Photo Albums
Exploring Printing Options
Part 6: Outlook
Chapter 22: Introducing Outlook 2007
Instant Search
Calendar Changes
E-Mail Changes
Color Categories
Collaboration and Sharing Improvements
Overview of Outlook 2007 Capabilities
How Outlook Stores Data
Understanding Messaging Protocols
Security Provisions in Outlook
Options for Starting Outlook
Chapter 23: Finding and Organizing Messages
Flagging and Monitoring Messages and Contacts
Grouping Messages by Customizing the Folder View
Filtering a View Using Categories
Managing E-Mail Effectively
Chapter 24: Securing Your System, Messages, and Identity
Protecting Messages with Digital Signatures
Signing Messages
Encrypting Messages
Protecting Data with Information Rights Management
Chapter 25: Collaboration with Outlook and Windows SharePoint Services
Setting Up Alerts
Working with Shared Documents
Working with Shared Contacts
Copying Contacts from Windows SharePoint Services 2.0 to Outlook
Linking a Team Calendar to Outlook
Configuring Alerts in Outlook
Using Outlook to Work with SharePoint Libraries and Files
Part 7: Access
Chapter 26: Exploring the New Look of Access 2007
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
Chapter 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
Chapter 28: Creating and Working with Simple Queries
Selecting Data from a Single Table
Testing Validation Rule Changes
Working in Query Datasheet View
Chapter 29: Building a Form
Starting from Scratch-A Simple Input Form
Working with Quick Create Commands and the Form Wizard
Simplifying Data Input with a Form
Chapter 30: Constructing a Report
Using the Report Command
Using the Report Wizard
Building a Report in Layout View
Part 8: Microsoft Office Programming Primer
Chapter 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
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
Chapter 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
Installing and Configuring the 2007 Office System
Changing Your 2007 Office System Setup
Index to Troubleshooting Topics
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
List of Figures
List of Tables
List of Code Examples
List of Sidebars
CD Content