Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Joyce Cox Joan Lambert and Curtis D. Frye
Microsoft® Office Professional 2010 Step by Step
Microsoft® Office Professional 2010 Step by Step
A Note Regarding Supplemental Files
Introducing Microsoft Office Professional 2010
Certification
For More Information
Microsoft Word 2010 Step by Step
Microsoft Excel 2010 Step by Step
Microsoft PowerPoint 2010 Step by Step
Microsoft Outlook 2010 Step by Step
Microsoft Access 2010 Step by Step
Let’s Get Started!
Modifying the Display of the Ribbon
Dynamic Ribbon Elements
Changing the Width of the Ribbon
Adapting Exercise Steps
Features and Conventions of This Book
Using the Practice Files
Getting Help
Getting Help with This Book
Getting Help with Office 2010
More Information
1. Microsoft Office Professional 2010
1. Explore Office 2010
Working in the Program Environment
Changing Program Settings
Customizing the Ribbon
Customizing the Quick Access Toolbar
Key Points
2. Work with Files
Creating and Saving Files
Opening, Moving Around in, and Closing Files
Viewing Files in Different Ways
Key Points
2. Microsoft Word 2010
3. Edit and Proofread Text
Making Text Changes
Finding and Replacing Text
Fine-Tuning Text
Correcting Spelling and Grammatical Errors
Inserting Saved Text
Key Points
4. Change the Look of Text
Quickly Formatting Text
Changing a Document’s Theme
Manually Changing the Look of Characters
Manually Changing the Look of Paragraphs
Creating and Modifying Lists
Key Points
5. Organize Information in Columns and Tables
Presenting Information in Columns
Creating Tabbed Lists
Presenting Information in Tables
Formatting Tables
Key Points
6. Add Simple Graphic Elements
Inserting and Modifying Pictures
Changing a Document’s Background
Inserting Building Blocks
Adding WordArt Text
Key Points
7. Preview, Print, and Distribute Documents
Previewing and Adjusting Page Layout
Controlling What Appears on Each Page
Printing Documents
Preparing Documents for Electronic Distribution
Key Points
3. Microsoft Excel 2010
8. Set Up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2010 Program Window
Zooming In on a Worksheet
Arranging Multiple Workbook Windows
Adding Buttons to the Quick Access Toolbar
Customizing the Ribbon
Maximizing Usable Space in the Program Window
Key Points
9. Work with Data and Excel Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining Excel Tables
Key Points
10. Perform 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
11. Change Workbook Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Excel Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to Worksheets
Key Points
12. Focus on Specific Data by Using Filters
Limiting Data That Appears on Your Screen
Manipulating Worksheet Data
Selecting List Rows at Random
Summarizing Worksheets with Hidden and Filtered Rows
Finding Unique Values Within a Data Set
Defining Valid Sets of Values for Ranges of Cells
Key Points
4. Microsoft PowerPoint 2010
13. Work with Slides
Adding and Deleting Slides
Adding Slides with Ready-Made Content
Dividing Presentations into Sections
Rearranging Slides and Sections
Key Points
14. Work with Slide Text
Entering Text in Placeholders
Adding Text Boxes
Editing Text
Correcting and Sizing Text While Typing
Checking Spelling and Choosing the Best Words
Finding and Replacing Text and Fonts
Key Points
15. Format Slides
Applying Themes
Using Different Color and Font Schemes
Changing the Slide Background
Changing the Look of Placeholders
Changing the Alignment, Spacing, Size, and Look of Text
Key Points
16. Add Simple Visual Enhancements
Inserting Pictures and Clip Art Images
Inserting Diagrams
Inserting Charts
Drawing Shapes
Adding Transitions
Key Points
17. Review and Deliver Presentations
Setting Up Presentations for Delivery
Previewing and Printing Presentations
Preparing Speaker Notes and Handouts
Finalizing Presentations
Delivering Presentations
Key Points
5. Microsoft OneNote 2010
18. Explore OneNote 2010
Navigating in the OneNote Program Window
Working in the OneNote Program Window
Working from the Ribbon and Quick Access Toolbar
Working in the Backstage View
Exploring OneNote in the Default Notebook
Customizing OneNote
Key Points
19. Create and Configure Notebooks
Creating a Notebook for Use by One Person
Creating a Notebook for Use by Multiple People
Sharing a New or Existing Notebook
Managing a Shared Notebook
Creating Sections and Pages
Creating Pages and Subpages
Naming Sections and Pages
Creating Sections and Section Groups
Key Points
20. Create and Organize Notes
Working with Note Containers
Entering Content Directly onto a Page
Referencing External Files
Creating Handwritten Notes
Inserting Images
Formatting Notes, Pages, and Sections
Paragraph Formatting
Outline Levels
Page and Section Backgrounds
Sending Content to OneNote
Collecting Screen Clippings
Collecting Web Notes
Capturing Audio and Video Notes
Taking Notes on the Side
Key Points
6. Microsoft Outlook 2010
21. Send and Receive E-Mail Messages
Creating and Sending Messages
Addressing Messages
Troubleshooting Message Addressing
Troubleshooting the AutoComplete Address List
Troubleshooting Multiple Recipients
Troubleshooting the Address Book
Entering Content
Saving and Sending Messages
Attaching Files to Messages
Viewing Messages and Message Attachments
Configuring Reading Pane Behavior
Viewing Reading Pane Content
Marking Messages as Read
Single Key Reading
Viewing Message Participant Information
Presence Icons
Contact Cards
The People Pane
Responding to Messages
Key Points
22. Store and Access Contact Information
Saving and Updating Contact Information
Creating Contact Records
Address Books
Contacts and Suggested Contacts Address Books
Custom Address Books
Global Address Lists
Communicating with Contacts
Initiating Communication from Contact Records
Selecting Message Recipients from Address Books
Displaying Different Views of Contact Records
Printing Contact Records
Key Points
23. Manage Scheduling
Scheduling and Changing Appointments
Scheduling and Changing Events
Scheduling Meetings
Responding to Meeting Requests
Displaying Different Views of a Calendar
Views
Arrangements
Using the Date Navigator
Key Points
24. Track Tasks
Creating Tasks
Creating Tasks from Scratch
Task Options
Creating Tasks from Outlook Items
Updating Tasks
Removing Tasks and Items from Task Lists
Managing Task Assignments
Tasks You Assign to Others
Tasks Other People Assign to You
Displaying Different Views of Tasks
Key Points
7. Microsoft Access 2010
25. Explore an Access 2010 Database
Working in Access 2010
Understanding Database Concepts
Exploring Tables
Exploring Forms
Exploring Queries
Exploring Reports
Previewing and Printing Access Objects
Key Points
26. Create Databases and Simple Tables
Creating Databases from Templates
Creating Databases and Tables Manually
Manipulating Table Columns and Rows
Refining Table Structure
Creating Relationships Between Tables
Key Points
27. Create Simple Forms
Creating Forms by Using the Form Tool
Changing the Look of Forms
Changing the Arrangement of Forms
Key Points
28. Display Data
Sorting Information in Tables
Filtering Information in Tables
Filtering Information by Using Forms
Locating Information That Matches Multiple Criteria
Key Points
8. Microsoft Publisher 2010
29. Get Started with Publisher 2010
Starting New Publications
Using Templates
Importing Word Documents
Storing Personal and Company Information
Previewing and Printing Publications
Checking Publications
Working with Advanced Printer Settings
Key Points
30. Create Visual Interest
Working with Text Boxes
Manipulating Text Boxes
Formatting Text for Visual Impact
Working with WordArt
Working with Graphics
Working with Shapes
Manipulating Shapes
Connecting and Grouping Shapes
Working with Ready-Made Visual Elements
Key Points
31. Create Colorful Cards and Calendars
Creating Folded Cards
Choosing a Design or Layout
Changing the Color Scheme
Using Non–Color-Scheme Colors
Choosing Text
Creating Postcards
Using Mail Merge
Using Catalog Merge
Creating Calendars
Adding Captions, Credits, and Copyrights
Changing Page Backgrounds
Working with Master Pages
Key Points
Index
About the Authors
Copyright
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Index
Next
Next Chapter
Index
A
A3 Paper slide size,
Setting Up Presentations for Delivery
,
Setting Up Presentations for Delivery
A4 Paper slide size,
Setting Up Presentations for Delivery
,
Setting Up Presentations for Delivery
.accdb file name extension,
Working in Access 2010
,
Creating Databases from Templates
accent colors,
Using Different Color and Font Schemes
Accept button (Outlook),
Tasks Other People Assign to You
accepting meeting requests,
Responding to Meeting Requests
accepting tasks,
Tasks Other People Assign to You
Access 2010,
Working in Access 2010
closing,
Working in Access 2010
Access Help button,
Working in Access 2010
Access icon,
Working in Access 2010
Access Options dialog box,
Creating Databases from Templates
Access Services,
Creating Databases from Templates
active cells,
Moving Data Within a Workbook
,
Moving Data Within a Workbook
,
Limiting Data That Appears on Your Screen
in cell group,
Moving Data Within a Workbook
in filtering,
Limiting Data That Appears on Your Screen
active document, closing,
Opening, Moving Around in, and Closing Files
Active view (Calendar),
Views
ActiveSync icon (OneNote),
Managing a Shared Notebook
Add Holidays to Calendar dialog box,
Scheduling and Changing Appointments
add-ins (Word),
Changing Program Settings
adding values together,
Creating Formulas to Calculate Values
Address Block button (Publisher),
Using Catalog Merge
address blocks,
Using Catalog Merge
Address Book button,
Global Address Lists
,
Selecting Message Recipients from Address Books
,
Selecting Message Recipients from Address Books
address books,
Troubleshooting the Address Book
,
Troubleshooting the Address Book
,
Viewing Messages and Message Attachments
,
Contacts and Suggested Contacts Address Books
,
Contacts and Suggested Contacts Address Books
,
Contacts and Suggested Contacts Address Books
,
Custom Address Books
,
Custom Address Books
adding contacts to,
Viewing Messages and Message Attachments
adding to default search list,
Troubleshooting the Address Book
Contacts,
Contacts and Suggested Contacts Address Books
creating,
Custom Address Books
custom,
Custom Address Books
overview of,
Contacts and Suggested Contacts Address Books
search order, changing,
Troubleshooting the Address Book
Suggested Contacts,
Contacts and Suggested Contacts Address Books
addressing e-mail messages,
Troubleshooting the AutoComplete Address List
,
Troubleshooting the AutoComplete Address List
,
Saving and Sending Messages
,
Selecting Message Recipients from Address Books
AutoComplete,
Troubleshooting the AutoComplete Address List
comma-separating addresses,
Troubleshooting the AutoComplete Address List
adjusting columns to fit contents,
Manipulating Table Columns and Rows
adjusting shapes,
Drawing Shapes
Advanced Filter dialog box,
Finding Unique Values Within a Data Set
–
Finding Unique Values Within a Data Set
,
Finding Unique Values Within a Data Set
,
Finding Unique Values Within a Data Set
Advanced Filter Options button,
Filtering Information by Using Forms
,
Locating Information That Matches Multiple Criteria
Advanced Filter/Sort command,
Locating Information That Matches Multiple Criteria
advanced options (Word),
Changing Program Settings
Advanced View Settings dialog box,
Displaying Different Views of Contact Records
advertisement building blocks,
Working with Ready-Made Visual Elements
Advertisements button (Publisher),
Working with Ready-Made Visual Elements
AGGREGATE function,
Summarizing Worksheets with Hidden and Filtered Rows
–
Finding Unique Values Within a Data Set
,
Finding Unique Values Within a Data Set
Align button (Publisher),
Working with Graphics
Align Center button (Word),
Presenting Information in Tables
Align Center Right button (Word),
Presenting Information in Tables
,
Formatting Tables
Align Text Left button (PowerPoint),
Changing the Alignment, Spacing, Size, and Look of Text
Align Text Right button (PowerPoint),
Changing the Alignment, Spacing, Size, and Look of Text
aligning labels in forms,
Changing the Arrangement of Forms
aligning pictures,
Working with Graphics
,
Working with Graphics
aligning text,
Manually Changing the Look of Paragraphs
,
Manually Changing the Look of Paragraphs
,
Manually Changing the Look of Paragraphs
,
Manually Changing the Look of Paragraphs
,
Presenting Information in Tables
,
Presenting Information in Tables
,
Formatting Tables
,
Inserting and Modifying Pictures
,
Changing the Alignment, Spacing, Size, and Look of Text
around pictures,
Inserting and Modifying Pictures
in tables,
Presenting Information in Tables
,
Presenting Information in Tables
,
Formatting Tables
with tab stops,
Manually Changing the Look of Paragraphs
aligning WordArt,
Working with WordArt
alignment, cell,
Defining Styles
alphabet bar,
Displaying Different Views of Contact Records
alphabetical sorting,
Sorting Information in Tables
,
Sorting Information in Tables
alt text in tables,
Presenting Information in Tables
And option in filters,
Limiting Data That Appears on Your Screen
angle of text in text boxes,
Adding Text Boxes
,
Manipulating Text Boxes
animation, turning off,
Setting Up Presentations for Delivery
application parts,
Create Databases and Simple Tables
,
Creating Databases from Templates
adding to databases,
Creating Databases from Templates
Application Parts button,
Creating Databases from Templates
Apply To All button (PowerPoint),
Adding Transitions
Apply To button (Publisher),
Working with Master Pages
Appointment button,
Scheduling Meetings
Appointment page,
Scheduling Meetings
Appointment Recurrence dialog box,
Scheduling and Changing Appointments
,
Scheduling and Changing Events
appointment windows,
Scheduling and Changing Appointments
–
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
appointments,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
availability during, marking,
Scheduling and Changing Appointments
creating from e-mail messages,
Scheduling and Changing Appointments
location, setting,
Scheduling and Changing Appointments
private,
Scheduling and Changing Appointments
recurring,
Scheduling and Changing Appointments
reminders for,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
scheduling,
Scheduling and Changing Appointments
arguments,
Creating Formulas to Calculate Values
,
Summarizing Data That Meets Specific Conditions
,
Finding and Correcting Errors in Calculations
defined,
Creating Formulas to Calculate Values
error codes for,
Finding and Correcting Errors in Calculations
Arrange All button,
Viewing Files in Different Ways
Arrange Windows dialog box (Excel),
Arranging Multiple Workbook Windows
,
Maximizing Usable Space in the Program Window
arranging slides,
Rearranging Slides and Sections
arranging workbook windows,
Arranging Multiple Workbook Windows
arrows,
Working in the Program Environment
,
Finding and Correcting Errors in Calculations
,
Formatting Cells
,
Limiting Data That Appears on Your Screen
,
Limiting Data That Appears on Your Screen
–
Limiting Data That Appears on Your Screen
,
Limiting Data That Appears on Your Screen
,
Limiting Data That Appears on Your Screen
,
Working in Access 2010
button,
Working in the Program Environment
,
Formatting Cells
,
Working in Access 2010
filter,
Limiting Data That Appears on Your Screen
,
Limiting Data That Appears on Your Screen
–
Limiting Data That Appears on Your Screen
,
Limiting Data That Appears on Your Screen
,
Limiting Data That Appears on Your Screen
tracer,
Finding and Correcting Errors in Calculations
Artistic Effects button (Word),
Inserting and Modifying Pictures
Ascending button,
Sorting Information in Tables
aspect ratio,
Working with Graphics
Assign Task button,
Tasks You Assign to Others
,
Tasks Other People Assign to You
assigning tasks,
Removing Tasks and Items from Task Lists
,
Tasks You Assign to Others
,
Tasks Other People Assign to You
asterisk as wildcard,
Filtering Information by Using Forms
,
Filtering Information by Using Forms
asterisk icon,
Creating Databases and Tables Manually
Attach File button (OneNote),
Referencing External Files
,
Page and Section Backgrounds
Attach File button (Outlook),
Attaching Files to Messages
attachments (OneNote),
Referencing External Files
,
Page and Section Backgrounds
–
Page and Section Backgrounds
,
Page and Section Backgrounds
inserting,
Page and Section Backgrounds
–
Page and Section Backgrounds
,
Page and Section Backgrounds
keyboard shortcut for,
Referencing External Files
attachments (Outlook),
Attaching Files to Messages
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Viewing Messages and Message Attachments
,
Responding to Messages
business cards as,
Viewing Messages and Message Attachments
contact records as,
Viewing Messages and Message Attachments
in replies,
Responding to Messages
opening,
Viewing Messages and Message Attachments
previewing in Reading Pane,
Viewing Messages and Message Attachments
saving to hard disk,
Viewing Messages and Message Attachments
ScreenTips for,
Viewing Messages and Message Attachments
viewing number of,
Viewing Messages and Message Attachments
warning before previewing,
Viewing Messages and Message Attachments
Word documents as,
Attaching Files to Messages
,
Viewing Messages and Message Attachments
Attachments tab,
Viewing Messages and Message Attachments
attributes (PowerPoint), applying,
Changing the Alignment, Spacing, Size, and Look of Text
Audio & Video Recording contextual tab (OneNote),
Capturing Audio and Video Notes
audio input devices,
Capturing Audio and Video Notes
audio notes (OneNote),
Capturing Audio and Video Notes
,
Capturing Audio and Video Notes
,
Capturing Audio and Video Notes
appearance of,
Capturing Audio and Video Notes
recording,
Capturing Audio and Video Notes
,
Capturing Audio and Video Notes
Audio Search (OneNote),
Capturing Audio and Video Notes
–
Capturing Audio and Video Notes
,
Capturing Audio and Video Notes
,
Capturing Audio and Video Notes
Audio Search dialog box (OneNote),
Capturing Audio and Video Notes
auditing errors,
Finding and Correcting Errors in Calculations
author name, viewing,
Preparing Documents for Electronic Distribution
authors (OneNote), hiding names,
Managing a Shared Notebook
AutoCalculate,
Summarizing Worksheets with Hidden and Filtered Rows
,
Finding Unique Values Within a Data Set
AutoComplete,
Entering and Revising Data
AutoCorrect,
Changing Program Settings
,
Correcting Spelling and Grammatical Errors
–
Correcting Spelling and Grammatical Errors
,
Correcting Spelling and Grammatical Errors
,
Correcting Spelling and Grammatical Errors
,
Correcting Spelling and Grammatical Errors
,
Correcting and Sizing Text While Typing
,
Checking Spelling and Choosing the Best Words
adding to,
Correcting Spelling and Grammatical Errors
fixing spelling errors with,
Correcting Spelling and Grammatical Errors
–
Correcting Spelling and Grammatical Errors
,
Correcting Spelling and Grammatical Errors
limitations of,
Correcting and Sizing Text While Typing
options, setting,
Changing Program Settings
,
Correcting Spelling and Grammatical Errors
synonyms,
Checking Spelling and Choosing the Best Words
AutoCorrect dialog box (Word),
Correcting Spelling and Grammatical Errors
,
Creating and Modifying Lists
AutoCorrect Options button (Excel),
Defining Excel Tables
AutoExpansion (Excel),
Defining Excel Tables
AutoFill Options button (Excel),
Entering and Revising Data
,
Entering and Revising Data
AutoFilter,
Limiting Data That Appears on Your Screen
AutoFit,
Correcting and Sizing Text While Typing
changing default settings,
Correcting and Sizing Text While Typing
AutoFit Options button (PowerPoint),
Correcting and Sizing Text While Typing
,
Correcting and Sizing Text While Typing
AutoFormatting options,
Creating and Modifying Lists
automatic slide shows,
Setting Up Presentations for Delivery
AutoRecover options (Word),
Changing Program Settings
,
Creating and Saving Files
AutoText,
Inserting Building Blocks
availability, marking,
Scheduling and Changing Appointments
,
Scheduling and Changing Appointments
AVERAGE function,
Creating Formulas to Calculate Values
,
Summarizing Worksheets with Hidden and Filtered Rows
AVERAGEIF function,
Summarizing Data That Meets Specific Conditions
,
Summarizing Data That Meets Specific Conditions
AVERAGEIFS function,
Summarizing Data That Meets Specific Conditions
,
Summarizing Data That Meets Specific Conditions
averages,
Summarizing Worksheets with Hidden and Filtered Rows
viewing with AutoCalculate,
Summarizing Worksheets with Hidden and Filtered Rows
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset