book

Microsoft® Office 2007 Simplified®

Name: Microsoft® Office 2007 Simplified®
Author: Sherry Willard Kinkoph
ISBN: 9780470045893

by Sherry Willard Kinkoph

February 2007

Beginner

416 pages

10h 35m

English

Visual

Read now

Unlock full access

Copyright
Praise for Visual Books
Credits
About the Author
Author's Acknowledgments
I. Office Features
1. Office Basics
1.1. Start and Exit Office Applications1.2. Navigate the Program Windows1.3. Work with the Ribbon1.4. Customize the Quick Access Toolbar1.5. Find Customizing Options1.6. Turn Off Live Preview1.7. Find Help with Office1.8. Diagnose Office Programs
2. Working with Files
2.1. Start a New File2.2. Save a File2.3. Open an Existing File2.4. Close a File2.5. Print a File2.6. Cut, Copy, and Paste Data2.7. View Multiple Files
3. Office Internet and Graphics Tools
3.1. Create an HTML File3.2. Add a Hyperlink3.3. Draw AutoShapes3.4. Insert Clip Art3.5. View Clip Art with the Clip Organizer3.6. Insert a Picture3.7. Insert a WordArt Object3.8. Move and Resize an Object3.9. Rotate and Flip Objects3.10. Crop a Picture3.11. Arrange Objects3.12. Control Text Wrapping3.13. Recolor a Picture3.14. Add SmartArt
II. Word

4. Adding Text
4.1. Change Word's Views4.2. Type and Edit Text4.3. Select Text4.4. Move and Copy Text4.5. Insert Quick Parts4.6. Apply a Template4.7. Insert Symbols
5. Formatting Text
5.1. Add Basic Formatting5.2. Use the Mini Toolbar5.3. Changethe Font5.4. Change the Font Size5.5. Add Color to Text5.6. AlignText5.7. Set Line Spacing5.8. Set Character Spacing5.9. Apply Color Shading5.10. Highlight Text5.11. Copy Formatting5.12. Clear Formatting5.13. Indent Text5.14. Set Tabs5.15. Create Bulleted or Numbered Lists5.16. Set Margins5.17. Format with Styles
6. Working with Tables
6.1. Insert a Table6.2. Insert a Quick Table6.3. Draw a Table6.4. Insert an Excel Spreadsheet6.5. Select Table Cells6.6. Adjust the Column Width or Row Height6.7. Add Columns and Rows6.8. Delete Columns or Rows6.9. Merge Table Cells6.10. Split Table Cells6.11. Apply Table Styles6.12. Change Cell Alignment6.13. Reposition a Table6.14. Resize a Table
7. Adding Extra Touches
7.1. Assign a Theme7.2. Add Borders7.3. Create Columns7.4. Add Headers and Footers7.5. Insert Comments7.6. Insert Footnotes and Endnotes7.7. Insert Page Numbers and Page Breaks
8. Reviewing and Printing Documents
8.1. Find and Replace Text8.2. Check Spelling and Grammar8.3. Work with AutoCorrect8.4. Use the Thesaurus8.5. Check Your Document for Hidden or Personal Data8.6. Track and Review Document Changes8.7. E-mail a Document8.8. Change Paper Size8.9. Print an Envelope
III. Excel
9. Building Spreadsheets
9.1. Enter Cell Data9.2. Select Cells9.3. Faster Data Entry with AutoFill9.4. Add Columns and Rows9.5. Delete Columns and Rows9.6. Resize Columns and Rows9.7. Turn On Text Wrapping9.8. Center Data Across Columns9.9. Freeze a Column or Row9.10. Remove Data or Cells
10. Worksheet Basics
10.1. Assign Worksheet Names10.2. Delete a Worksheet10.3. Add a Worksheet10.4. Move a Worksheet10.5. Copy a Worksheet10.6. Format the Worksheet Tab Color10.7. Find and Replace Data10.8. Sort Data10.9. Filter Data with AutoFilter10.10. Insert a Comment10.11. Track and Review Workbook Changes10.12. Change Page Setup Options
11. working with formulas and functions
11.1. Understanding Formulas11.2. Create Formulas11.3. Define a Range Name11.4. Reference Ranges in Formulas11.5. Reference Cells from Other Worksheets11.6. Apply Absolute and Relative Cell References11.7. Understanding Functions11.8. Apply a Function11.9. Total Cells with AutoSum11.10. Audit a Worksheet for Errors
12. Formatting Worksheets
12.1. Change Number Formats12.2. Change the Font and Size12.3. Increase or Decrease Decimals12.4. Change Data Color12.5. Adjust the Cell Alignment12.6. Control Data Orientation12.7. Copy Cell Formatting12.8. Add Borders12.9. Format Data with Styles12.10. Assign Conditional Formatting
13. working with charts
13.1. Create a Chart13.2. Move and Resize Charts13.3. Change the Chart Type13.4. Change the Chart Style13.5. Change the Chart Layout13.6. Add Axis Titles13.7. Format Chart Objects13.8. Add Gridlines13.9. Change the Chart Data
IV. PowerPoint
14. Presentation Basics
14.1. Create a Presentation with a Template14.2. Build a Blank Presentation14.3. Change PowerPoint Views
15. Creating Slides
15.1. Add and Edit Slide Text15.2. Change the Font and Size15.3. Change the Text Color15.4. Change the Text Style15.5. Change the Text Alignment15.6. Set Line Spacing15.7. Assign a Theme15.8. Change the Slide Layout15.9. Add a New Text Object15.10. Add Clip Art to a Slide15.11. Add a Chart to a Slide15.12. Add a Table to a Slide15.13. Move a Slide Object15.14. Resize a Slide Object
16. Assembling a Slide Show
16.1. Insert and Delete Slides16.2. Reorganize Slides16.3. Define Slide Transitions16.4. Add Animation Effects16.5. Insert a Media Clip16.6. Record Narration16.7. Set Up a Slide Show
17. Presenting a Slide Show
17.1. Rehearse a Slide Show17.2. Run a Slide Show17.3. Create Speaker Notes17.4. Package Your Presentation on a CD
V. Access
18. Database Basics
18.1. Understanding Database Basics18.2. Create a Blank Database18.3. Create a Database Based on a Template
19. Adding Data Using Tables
19.1. Create a New Table19.2. Create a Table with a Table Template19.3. Change Table Views19.4. Add a Field19.5. Delete a Field19.6. Hide a Field19.7. Move a Field19.8. Add a Record19.9. Delete a Record
20. Adding Data Using Forms
20.1. Create a Form Using a Wizard20.2. Create a Quick Form20.3. Add a Record20.4. Navigate Records20.5. Delete a Record20.6. Change Form Views20.7. Move a Field20.8. Delete a Field20.9. Add a Field20.10. Change the Field Formatting20.11. Apply a Quick Format
21. Finding and Querying Data
21.1. Sort Records21.2. Filter Records21.3. Perform a Simple Query21.4. Create a Report
VI. Outlook
22. Organizing with Outlook
22.1. View Outlook Components22.2. Schedule an Appointment22.3. Schedule a Recurring Appointment22.4. Schedule an Event22.5. Plan a Meeting22.6. Create a New Contact22.7. Create a New Task22.8. Add a Note22.9. Organize Outlook Items22.10. Perform an Instant Search22.11. Customize the To-Do Bar
23. Emailing with Outlook
23.1. Compose and Send a Message23.2. Read an Incoming Message23.3. Control the Reading Pane23.4. Reply to or Forward a Message23.5. Add a Sender to Your Address Book23.6. Delete a Message23.7. Attach a File to a Message23.8. Clean Up the Mailbox23.9. Screen Junk E-mail23.10. Create a Message Rule
VII. Publisher
24. Publisher Basics
24.1. Create a Publication24.2. Create a Blank Publication24.3. Zoom In and Out24.4. Add Text24.5. Add a New Text Box24.6. Add a Picture to a Publication24.7. Add Clip Art to a Publication24.8. Change the Text Font and Size
25. Organizing with Outlook
25.1. Change the Text Style25.2. Change Text Alignment25.3. Change Text Color25.4. Control Text Wrap25.5. Add a Border25.6. Move a Publication Object25.7. Resize a Publication Object25.8. Connect Text Boxes25.9. Edit the Background Page25.10. Add a Design Gallery Object25.11. Use the Content Library

Overview

Are you new to computers? Does new technology make you nervous? Relax! You're holding in your hands the easiest guide ever to Office 2007 -- a book that skips the long-winded explanations and shows you how things work. All you have to do is open the book, follow Chip, your friendly guide -- and discover just how easy it is to get up to speed.

The Simplified series is very accessible to beginners and provides useful information for more experienced users. For visual learners (like myself), the illustrations are a great help. It's challenging to take a complex subject and express it simply, clearly, concisely, and comprehensively. This book meets the challenge.

--John Kelly (Anchorage, AK)

Simplify It" sidebars offer real-world advice
A friendly character called Chip introduces each task
Full-color screen shots walk you through step by step
Self-contained, two-page lessons make learning a snap

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Microsoft® SharePoint® 2007 for Office 2007 Users

Publisher Resources

ISBN: 9780470045893Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills