2007 Microsoft Office System Step by Step

2007 MicrosoftВ® Office System Step by Step

ISBN: 0735622787
EAN: 2147483647

Year: 2004
Pages: 231

Authors: Online Training Solutions Inc., Curtis D. Frye, Joan Preppernau, Joyce K. Cox, Steve Lambert

BUY ON AMAZON

Table of Contents
Back Cover
The 2007 Microsoft Office System Step by Step
A Tour of the Office 2007 User Interface
The New File Menu
Quick Access Toolbar
New View Controls
Key Points
Information for Readers Running Windows XP
Getting Help
Using the Books CD
Features and Conventions of This Book
Quick Reference
Part I: Microsoft Office Word 2007
Chapter 1: Exploring Word 2007
Working in the Word Environment
Opening, Moving Around in, and Closing a Document
Displaying Different Views of a Document
Creating and Saving a Document
Previewing and Printing a Document
Key Points
Chapter 2: Editing and Proofreading Documents
Making Changes to a Document
Inserting Saved Text
Finding the Most Appropriate Word
Reorganizing a Document Outline
Finding and Replacing Text
Correcting Spelling and Grammatical Errors
Finalizing a Document
Key Points
Chapter 3: Changing the Look of Text
Quickly Formatting Text and Paragraphs
Manually Changing the Look of Characters
Manually Changing the Look of Paragraphs
Creating and Modifying Lists
Key Points
Chapter 4: Presenting Information in Columns and Tables
Presenting Information in Columns
Creating a Tabular List
Presenting Information in a Table
Formatting Table Information
Performing Calculations in a Table
Using a Table to Control Page Layout
Key Points
Part II: Microsoft Office Excel 2007
Chapter 5: Setting Up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
Key Points
Chapter 6: Working with Data and Data Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining a Table
Key Points
Chapter 7: Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
Key Points
Chapter 8: Changing Document Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to a Document
Key Points
Part III: Microsoft Office Access 2007
Chapter 9: Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table by Using a Template
Manipulating Table Columns and Rows
Key Points
Chapter 10: Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool
Refining Form Properties
Changing the Arrangement of a Form
Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
Adding a Subform to a Form
Key Points
Chapter 11: Locating Specific Information
Sorting Information in a Table
Filtering Information in a Table
Filtering Information by Using a Form
Locating Information That Matches Multiple Criteria
Creating a Query Manually
Creating a Query by Using a Wizard
Performing Calculations by Using a Query
Key Points
Chapter 12: Keeping Your Information Accurate
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List
Updating Information in a Table
Deleting Information from a Table
Preventing Database Problems
Key Points
Part IV: Microsoft Office PowerPoint 2007
Chapter 13: Starting a New Presentation
Quickly Creating a Presentation
Creating a Presentation Based on a Ready-Made Design
Converting an Outline to a Presentation
Reusing Existing Slides
Key Points
Chapter 14: Working with Slide Text
Entering Text
Editing Text
Adding and Manipulating Text Boxes
Correcting and Sizing Text While Typing
Checking Spelling and Choosing the Best Words
Finding and Replacing Text and Fonts
Changing the Size, Alignment, Spacing, and Look of Text
Key Points
Chapter 15: Adjusting the Slide Layout, Order, and Look
Changing the Layout of a Slide
Rearranging Slides in a Presentation
Applying a Theme
Switching to a Different Color Scheme
Using Colors That Are Not Part of the Scheme
Adding Shading and Texture to the Background of a Slide
Key Points
Chapter 16: Delivering a Presentation Electronically
Adapting a Presentation for Different Audiences
Rehearsing a Presentation
Preparing Speaker Notes and Handouts
Preparing a Presentation for Travel
Showing a Presentation
Key Points
Part V: Microsoft Office Outlook 2007
Chapter 17: Getting Started with Outlook 2007
Connecting to Your Primary E-Mail Account
Troubleshooting the Startup Wizard
Connecting to Additional E-Mail Accounts
Creating Additional Outlook Profiles
Personalizing Your Outlook Workspace
Exploring the Advanced Toolbar
Key Points
Chapter 18: Sending E-Mail Messages
Working in the Message Window
Creating and Sending Messages
Attaching Files to Messages
Creating and Formatting Business Graphics
Personalizing the Appearance of Messages
Adding Signatures to Messages Automatically
Key Points
Chapter 19: Managing Your Inbox
Quickly Locating Messages
Arranging Messages in Different Ways
Organizing Messages by Using Color Categories
Organizing Messages in Folders
Archiving Messages
Key Points
Chapter 20: Managing Appointments, Events, and Meetings
Working in the Calendar Item Windows
Scheduling and Changing Appointments
Scheduling and Changing Events
Scheduling, Updating, and Canceling Meetings
Responding to Meeting Requests
Key Points
Chapter 21: Managing Your Calendar
Displaying Different Views of a Calendar
Defining Your Available Time
Printing a Calendar
Sending Calendar Information in an E-Mail Message
Linking to an Internet Calendar
Working with Multiple Calendars
Key Points
Glossary
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Y
Z
List of Figures
List of Examples
List of Sidebars
CD Content