Home Page Icon
Home Page
Table of Contents for
II. Microsoft Office Excel 2007
Close
II. Microsoft Office Excel 2007
by Joan Lambert, Curtis Frye, Joyce Cox
Microsoft® Office Home and Student 2007 Step by Step
Microsoft Office Home and Student 2007 Step by Step
SPECIAL OFFER: Upgrade this ebook with O’Reilly
A Note Regarding Supplemental Files
Introducing the 2007 Microsoft Office System
Microsoft Office Home and Student 2007
The Microsoft Office Fluent User Interface
Certification
Information for Readers Running Windows XP
Managing the Practice Files
Using the Start Menu
Navigating Dialog Boxes
Features and Conventions of This Book
Using the Book's CD
What's on the CD?
Minimum System Requirements
Installing the Practice Files
Using the Practice Files
Removing and Uninstalling the Practice Files
Getting Help
Getting Help with This Book and Its Companion CD
Getting Help with an Office Program
More Information
Quick Reference
1 Exploring Word 2007
2 Editing and Proofreading Documents
3 Changing the Look of Text
4 Presenting Information in Columns and Tables
5 Setting Up a Workbook
6 Working with Data and Data Tables
7 Performing Calculations on Data
8 Changing Workbook Appearance
9 Starting a New Presentation
10 Working with Slide Text
11 Adjusting the Layout, Order, and Look of Slides
12 Delivering a Presentation Electronically
13 Getting Started with OneNote
14 Creating and Configuring Notebooks
15 Collecting Information in a Notebook
16 Organizing and Locating Information
I. Microsoft Office Word 2007
1. Exploring Word 2007
Chapter at a Glance
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
2. Editing and Proofreading Documents
Chapter at a Glance
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
3. Changing the Look of Text
Chapter at a Glance
Quickly Formatting Text and Paragraphs
Manually Changing the Look of Characters
Manually Changing the Look of Paragraphs
Creating and Modifying Lists
Key Points
4. Presenting Information in Columns and Tables
Chapter at a Glance
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
II. Microsoft Office Excel 2007
5. Setting Up a Workbook
Chapter at a Glance
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
Zooming In on a Worksheet
Arranging Multiple Workbook Windows
Adding Buttons to the Quick Access Toolbar
Key Points
6. Working with Data and Data Tables
Chapter at a Glance
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining a Table
Key Points
7. Performing Calculations on Data
Chapter at a Glance
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
Key Points
8. Changing Workbook Appearance
Chapter at a Glance
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 Documents
Key Points
III. Microsoft Office PowerPoint 2007
9. Starting a New Presentation
Chapter at a Glance
Quickly Creating a Presentation
Creating a Presentation Based on a Ready-Made Design
Converting an Outline to a Presentation
Reusing Existing Slides
Key Points
10. Working with Slide Text
Chapter at a Glance
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
11. Adjusting the Layout, Order, and Look of Slides
Chapter at a Glance
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
12. Delivering a Presentation Electronically
Chapter at a Glance
Adapting a Presentation for Different Audiences
Rehearsing a Presentation
Preparing Speaker Notes and Handouts
Preparing a Presentation for Travel
Showing a Presentation
Key Points
IV. Microsoft Office One Note 2007
13. Getting Started with OneNote
Chapter at a Glance
Installing or Upgrading to OneNote 2007
Working in the OneNote Program Window
Giving Commands
Using Built-In Resources
Customizing OneNote
Key Points
14. Creating and Configuring Notebooks
Chapter at a Glance
Creating a Notebook for Use on One Computer
Creating a Notebook for Use on Multiple Computers
Creating Pages and Sections
Creating Pages and Subpages
Naming Pages
Creating Sections and Section Groups
Key Points
15. Collecting Information in a Notebook
Chapter at a Glance
Understanding Note Containers
Entering Content Directly onto a Page
Referencing External Files
Creating Handwritten Notes
Sending Content to OneNote
Collecting Screen Clippings
Collecting Web Notes
Capturing Audio and Video Notes
Recording Audio
Recording Video
Playing Back a Recording
Quickly Capturing Notes
Key Points
16. Organizing and Locating Information
Chapter at a Glance
Moving and Removing Information
Manipulating Objects on a Page
Moving Pages, Sections, and Notebooks
Accessing Information from Multiple Locations
Tagging Notes
Searching for Information
Key Points
A. Your All-in-One Resource
Glossary
SPECIAL OFFER: Upgrade this ebook with O’Reilly
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
Key Points
Next
Next Chapter
5. Setting Up a Workbook
Part II. Microsoft Office Excel 2007
Chapter 5
Chapter 6
Chapter 7
Chapter 8
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