Master Visually®: Microsoft® Office 2007

Master Visually®: Microsoft® Office 2007

by Tom Bunzel
Released September 2007
Publisher(s): Visual
ISBN: 9780470135471

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Within this comprehensive, visual reference, succinctly captioned, step-by-step screen shots show you how to accomplish more than 300 Office tasks. You’ll learn how to format text and apply styles in Word, work with Excel formulas and functions, add animation to PowerPoint slides, create an Access database, manage contacts with Outlook, collaborate with OneNote and Live Meeting, and create publications with Publisher. A bonus CD-ROM includes demo software, add-ins, sample files, and additional chapters.

Table of contents

  1. Copyright
  2. Praise for Visual Books...
  3. Credits
  4. About the Author
  5. Author's Acknowledgments
  6. HOW TO USE THIS BOOK
    1. How to Use this Master VISUALLY Book
    2. Who Needs This Book
    3. Book Organization
    4. Chapter Organization
    5. What You Need to Use This Book
    6. Using the mouse
    7. The Conventions in this Book
  7. I. USING OFFICE 2007 PROGRAMS AND FEATURES
    1. 1. Getting Started with Office 2007
      1. 1.1. An Introduction to Microsoft Office 2007
      2. 1.2. Install Office 2007
        1. 1.2.1. Using Install Now
        2. 1.2.2. Customize your Office installation
      3. 1.3. Add or Remove Office 2007 Features
      4. 1.4. Run Office Diagnostics
      5. 1.5. Start and Exit a Program
      6. 1.6. Using the Office Button
    2. 2. Working with Office Documents
      1. 2.1. Create a New Document
        1. 2.1.1. Using the default template
      2. 2.2. Open a Document
      3. 2.3. Work with Multiple Windows
      4. 2.4. Save and Close a Document
        1. 2.4.1. Save a document
      5. 2.5. Save in Different Versions
        1. 2.5.1. Save in Office 97-2003 format
        2. 2.5.2. Save in Office 2007 format
      6. 2.6. Using Vista Search Features
        1. 2.6.1. Add a metatag search parameter to a document
        2. 2.6.2. Perform a metatag search
      7. 2.7. Explore the Contextual Ribbon
        1. 2.7.1. Word
        2. 2.7.2. PowerPoint
      8. 2.8. Preview Galleries and Themes
        1. 2.8.1. Apply a style from a gallery
        2. 2.8.2. Apply a theme from a gallery
      9. 2.9. Get Help
  8. II. USING WORD
    1. 3. Getting Started with Word
      1. 3.1. An Introduction to Word
        1. 3.1.1. Enter and Edit Text
        2. 3.1.2. View and Print Documents
      2. 3.2. Explore the Contextual Ribbon
        1. 3.2.1. Home
        2. 3.2.2. Page Layout
      3. 3.3. Type and Select Text
        1. 3.3.1. Type your text and review errors
      4. 3.4. Insert and Delete Text
        1. 3.4.1. Insert text
        2. 3.4.2. Delete text
      5. 3.5. Move or Copy Text
        1. 3.5.1. Move Text
      6. 3.6. Move through a Document
        1. 3.6.1. Display previous and next pages
      7. 3.7. Undo Changes
        1. 3.7.1. Undo one change
      8. 3.8. Insert a Page Break
      9. 3.9. Find Text
        1. 3.9.1. Using the Reading Highlight
      10. 3.10. Replace Text
      11. 3.11. Using AutoCorrect
        1. 3.11.1. Type an AutoCorrect entry
      12. 3.12. Using Contextual Spell Check
        1. 3.12.1. View errors as you type
        2. 3.12.2. Check the entire document
      13. 3.13. Check Grammar
      14. 3.14. Using the Thesaurus
      15. 3.15. Count Words
      16. 3.16. Create and Insert a Quick Parts Entry
        1. 3.16.1. Create a Quick Parts entry
        2. 3.16.2. Insert a Quick Parts entry
      17. 3.17. Insert Date and Time
      18. 3.18. Insert Symbols or Special Characters
    2. 4. Formatting Text
      1. 4.1. Bold, Italicize, and Underline Text
      2. 4.2. Change the Font Style
      3. 4.3. Change the Font Size
      4. 4.4. Highlight Text
      5. 4.5. Align Text
        1. 4.5.1. Using the Ribbon
        2. 4.5.2. Using Click and Type
      6. 4.6. Indent Paragraphs
        1. 4.6.1. Using the Ribbon
      7. 4.7. Set Tabs
      8. 4.8. Change Line and Paragraph Spacing
        1. 4.8.1. Change paragraph spacing
        2. 4.8.2. Change indents and spacing options
      9. 4.9. Add Bullets
        1. 4.9.1. Using the Ribbon
        2. 4.9.2. Change bullets
      10. 4.10. Create a Numbered List
        1. 4.10.1. Using the Ribbon
        2. 4.10.2. Change number style
      11. 4.11. Apply a Quick Style
      12. 4.12. Create a Quick Style
      13. 4.13. Modify a Quick Style
      14. 4.14. Copy Formatting
      15. 4.15. Show or Hide Formatting
      16. 4.16. Change AutoFormat Options
    3. 5. Changing Document Appearance
      1. 5.1. Change the Document View
        1. 5.1.1. Print Layout view
        2. 5.1.2. Web Layout view
      2. 5.2. Using Outline View
        1. 5.2.1. Show a document outline
        2. 5.2.2. Show specific heading levels
      3. 5.3. Change Margins
      4. 5.4. Align Text on a Page
      5. 5.5. Change Page Orientation
      6. 5.6. Add Page Numbers
      7. 5.7. Add a Header or Footer
      8. 5.8. Add Footnotes or Endnotes
      9. 5.9. Add and View Comments
        1. 5.9.1. Add a comment in Print Layout view
      10. 5.10. Create Columns
      11. 5.11. Create New Documents from Templates
      12. 5.12. Apply a Theme to a Document
      13. 5.13. Using the Building Blocks Organizer
        1. 5.13.1. Modify a Building Block
    4. 6. Creating Tables
      1. 6.1. Create a Table
        1. 6.1.1. Draw table lines
      2. 6.2. Type Text in a Table
      3. 6.3. Sort Text
      4. 6.4. Change Column Width
      5. 6.5. Erase Lines
      6. 6.6. Add or Delete a Row or Column
        1. 6.6.1. Add a row or column
        2. 6.6.2. Delete a row or column
      7. 6.7. Move or Resize a Table
        1. 6.7.1. Move a table
        2. 6.7.2. Resize a table
      8. 6.8. Change Table Borders
        1. 6.8.1. Change the line style
        2. 6.8.2. Change the border color
      9. 6.9. Add Shading or Color to Cells
      10. 6.10. Change Text Position in Cells
      11. 6.11. Using Table Styles with Galleries
      12. 6.12. Using Quick Tables
    5. 7. Working with Graphics
      1. 7.1. Insert a Picture
      2. 7.2. Add a Clip Art Image
      3. 7.3. Add Shapes
      4. 7.4. Add a SmartArt Graphic
      5. 7.5. Move, Copy, or Resize a Graphic
        1. 7.5.1. Move a graphic
        2. 7.5.2. Resize a graphic
      6. 7.6. Change the Position of a Graphic
      7. 7.7. Change Graphic Colors and Add Effects
    6. 8. Completing Documents
      1. 8.1. Work with Reviewers
        1. 8.1.1. Review a document
        2. 8.1.2. Accept or reject changes
      2. 8.2. Compare Multiple Versions
      3. 8.3. Using the Document Inspector
      4. 8.4. Preview a Document
        1. 8.4.1. Using Print Preview
        2. 8.4.2. Display multiple pages
      5. 8.5. Print a Document
      6. 8.6. An Introduction to Mail Merge
      7. 8.7. Create a Letter with Mail Merge
        1. 8.7.1. Create a main document
      8. 8.8. Print Mailing Labels
      9. 8.9. Print an Envelope
      10. 8.10. Output to PDF and XPS Formats
  9. III. USING EXCEL
    1. 9. Getting Started with Excel
      1. 9.1. An Introduction to Excel
      2. 9.2. Start Excel
      3. 9.3. Parts of the Excel Screen
      4. 9.4. Explore the Excel Ribbon
      5. 9.5. Type Text
      6. 9.6. Type Numbers
      7. 9.7. Edit or Delete Data
      8. 9.8. Move or Copy Data
      9. 9.9. Bold, Italicize, or Underline Text
      10. 9.10. Apply a Number Style to Cells
      11. 9.11. Format Numbers
      12. 9.12. Change Font or Font Size
      13. 9.13. Change Font or Fill Color
      14. 9.14. Apply Special Font Effects
      15. 9.15. Change Data Alignment
      16. 9.16. Add Borders
      17. 9.17. Copy Formatting
      18. 9.18. Clear Formatting
      19. 9.19. Apply Cell Styles
      20. 9.20. Check Spelling
      21. 9.21. Share a Workbook
    2. 10. Working with Worksheets
      1. 10.1. Insert a Row or Column
      2. 10.2. Delete a Row or Column
      3. 10.3. Hide or Unhide a Column
      4. 10.4. Change Column Width or Row Height
      5. 10.5. Add or Delete a Worksheet
      6. 10.6. Rename a Worksheet
      7. 10.7. Move or Copy a Worksheet
    3. 11. Working with Data, Formulas, and Functions
      1. 11.1. Find Data
      2. 11.2. Fill a Series
      3. 11.3. Enter Dates and Times
      4. 11.4. Using AutoComplete
      5. 11.5. Using Cell and Range Names
      6. 11.6. Select a Range of Cells
      7. 11.7. Protect Cells
      8. 11.8. Using a Data Table
      9. 11.9. Sort Data in a Table
      10. 11.10. Filter Data in a Table
      11. 11.11. Add Subtotals to a Range
      12. 11.12. An Introduction to Formulas and Functions
      13. 11.13. Sum Numbers
      14. 11.14. Enter and Edit Formulas
      15. 11.15. Copy a Formula
      16. 11.16. Enter a Function
      17. 11.17. Using the Function Library
      18. 11.18. Audit Formulas
      19. 11.19. Using the Watch Window
    4. 12. Creating Charts and PivotTables
      1. 12.1. An Introduction to Charts
      2. 12.2. Create a Chart
      3. 12.3. Change the Chart Type
      4. 12.4. Format Chart Elements
      5. 12.5. Move or Resize a Chart
      6. 12.6. Delete a Chart
      7. 12.7. Add Data to a Chart
      8. 12.8. Print a Chart
      9. 12.9. Change Chart Shapes
      10. 12.10. Apply Chart Shape Effects
      11. 12.11. An Introduction to PivotTables
      12. 12.12. Create and Use a PivotTable
      13. 12.13. Create a PivotTable Chart
    5. 13. Working with Graphics
      1. 13.1. Add Shapes
      2. 13.2. Add a SmartArt Graphic
      3. 13.3. Move or Resize a Graphic
      4. 13.4. Add a Text Box
      5. 13.5. Add a Clip Art Image
      6. 13.6. Work with Graphics and Special Effects
      7. 13.7. An Introduction to Conditional Formats
      8. 13.8. Using Conditional Formats with Rules
      9. 13.9. Using Conditional Formats with Graphics
    6. 14. Printing Worksheets
      1. 14.1. Preview a Worksheet
      2. 14.2. Change Margins
      3. 14.3. Using Page Break Preview
      4. 14.4. Fit a Worksheet to a Page or Pages
      5. 14.5. Repeat Row or Column Headings
      6. 14.6. Add a Header or Footer
      7. 14.7. Create a Custom Header or Footer
      8. 14.8. Change Page Orientation
      9. 14.9. Change Print Options
      10. 14.10. Print a Worksheet
  10. IV. USING POWERPOINT
    1. 15. Getting Started with PowerPoint
      1. 15.1. An Introduction to PowerPoint
      2. 15.2. Create a Blank Presentation
      3. 15.3. Parts of the PowerPoint Screen
      4. 15.4. Explore the PowerPoint Ribbon
      5. 15.5. Using Online Content Presentations
      6. 15.6. Add a Slide
      7. 15.7. Select Text
      8. 15.8. Add and Edit Text
      9. 15.9. Move or Copy Text
      10. 15.10. Resize, Add, or Delete Text Boxes
      11. 15.11. Using Slide Layouts
    2. 16. Formatting a Presentation
      1. 16.1. Change Font Style or Font Size
      2. 16.2. Bold, Italicize, or Underline Text
      3. 16.3. Change Text Alignment
      4. 16.4. Change Text Color
      5. 16.5. Copy Formatting
      6. 16.6. Format Bulleted and Numbered Lists
      7. 16.7. Change the Background Style
      8. 16.8. Using a Design Template
      9. 16.9. Format a Presentation with Themes
      10. 16.10. Save a Custom Theme
      11. 16.11. Move Slides between Presentations
    3. 17. Adding Objects to Slides
      1. 17.1. Add a Table with Text
      2. 17.2. Format a Table
      3. 17.3. Add a Chart
      4. 17.4. Edit or Format a Chart
      5. 17.5. Add a Clip Art Image
      6. 17.6. Add a Picture
      7. 17.7. Add a Shape
      8. 17.8. Add WordArt Styles
      9. 17.9. Add or Edit a Header or Footer
      10. 17.10. Convert Bullets to SmartArt Graphics
      11. 17.11. Add Special Effects to Graphics
      12. 17.12. Animate Slide Objects
      13. 17.13. Using Custom Animation
    4. 18. Fine-Tuning a Presentation
      1. 18.1. Change Views
      2. 18.2. Browse a Presentation
      3. 18.3. Using the Slide Master
      4. 18.4. Rearrange Slides
      5. 18.5. Delete a Slide
      6. 18.6. Hide a Slide
      7. 18.7. Using the Selection Pane
      8. 18.8. Add Slide Transitions
      9. 18.9. Rehearse a Slide Show
      10. 18.10. Set Up a Slide Show
      11. 18.11. Preview a Slide Show
      12. 18.12. Create Speaker Notes
      13. 18.13. Check Spelling
      14. 18.14. Set Up a Presentation for Printing
      15. 18.15. Print a Presentation
      16. 18.16. Present with a Projector
  11. V. USING ACCESS
    1. 19. Getting Started with Access
      1. 19.1. An Introduction to Access
      2. 19.2. Parts of a Database
      3. 19.3. Plan a Database
      4. 19.4. Start Access
      5. 19.5. Create a Blank Database
      6. 19.6. Create a Database Using a Template
      7. 19.7. Explore the Contextual Ribbon
      8. 19.8. Using the Navigation Pane
      9. 19.9. Parts of the Database Window
      10. 19.10. Rename or Delete an Object
      11. 19.11. Open and Save a Database
    2. 20. Creating and Editing Data
      1. 20.1. Create a Table
      2. 20.2. Create a Table Using Templates
      3. 20.3. Add Fields from Templates
      4. 20.4. Enter Data in a Table
      5. 20.5. Understanding Data Types
      6. 20.6. Open a Table
      7. 20.7. Add or Delete Records
      8. 20.8. Move through Records
      9. 20.9. Select Data
      10. 20.10. Edit Data
      11. 20.11. Zoom Into a Cell
      12. 20.12. Change Column Width
      13. 20.13. Hide a Field
      14. 20.14. Freeze a Field
      15. 20.15. Embed Attachment Files in Fields
    3. 21. Changing Table Design
      1. 21.1. Switch between Datasheet and Design Views
      2. 21.2. Rearrange Fields
      3. 21.3. Display Field Properties
      4. 21.4. Add a Field Description
      5. 21.5. Change the Data Type
      6. 21.6. Rename a Field
      7. 21.7. Change the Field Size
      8. 21.8. Select a Data Format
      9. 21.9. Change the Number of Decimal Places
      10. 21.10. Add or Delete a Field
      11. 21.11. Add a Caption
      12. 21.12. Add a Default Value
      13. 21.13. Require an Entry
      14. 21.14. Add a Validation Rule
      15. 21.15. Create a Yes/No Field
      16. 21.16. Create a Lookup Column
      17. 21.17. Using a Lookup Column to Enter Data
      18. 21.18. Create an Index
      19. 21.19. Set the Primary Key
      20. 21.20. Display a Subdatasheet
      21. 21.21. Define Relationships between Tables
    4. 22. Creating Forms
      1. 22.1. Create a Form Using a Wizard
      2. 22.2. Open a Form
      3. 22.3. Move through Records with a Form
      4. 22.4. Edit Data Using a Form
      5. 22.5. Add a Record
      6. 22.6. Add a Field to a Form
      7. 22.7. AutoFormat a Form
      8. 22.8. Change a Form Control
      9. 22.9. Change the Appearance of Form Controls
      10. 22.10. Change Form Control Colors and Gridlines
      11. 22.11. Using Conditional Formats
    5. 23. Finding and Querying Data
      1. 23.1. Find Data
      2. 23.2. Sort Records
      3. 23.3. Filter Data
      4. 23.4. Filter Data by Form
      5. 23.5. Create a Query Using the Simple Query Wizard
      6. 23.6. Create a Query in Design View
      7. 23.7. Open a Query
      8. 23.8. Change the Query View
      9. 23.9. Set Criteria
      10. 23.10. Examples of Criteria
      11. 23.11. Sort Query Results
      12. 23.12. Perform Calculations
      13. 23.13. Summarize Data
      14. 23.14. Connect an InfoPath Web Form
    6. 24. Creating Reports
      1. 24.1. Create a Report Using the Report Wizard
      2. 24.2. Open a Report
      3. 24.3. Change the Report View
      4. 24.4. Preview a Report
      5. 24.5. Print Data from a Database
      6. 24.6. An Introduction to Interactive Design Modes
      7. 24.7. Create Mailing Labels Using the Label Wizard
  12. VI. USING OUTLOOK
    1. 25. Getting Started with Outlook
      1. 25.1. An Introduction to Outlook
      2. 25.2. Start Outlook
      3. 25.3. Using the Outlook To-Do Bar
      4. 25.4. Using the Navigation Pane
      5. 25.5. Read Messages
      6. 25.6. Create a New Message
      7. 25.7. Select a Name from the Address Book
      8. 25.8. Attach a File to a Message
      9. 25.9. Open and Save Attachments
      10. 25.10. Reply to or Forward a Message
      11. 25.11. Preview Messages and Attachments
    2. 26. Organizing E-Mail
      1. 26.1. Open E-mail Folders
      2. 26.2. Print a Previewed Message
      3. 26.3. Delete a Message
      4. 26.4. Create a New Mail Folder
      5. 26.5. Move a Message
      6. 26.6. Archive Messages
      7. 26.7. Format a Message
      8. 26.8. Sort or Find Messages
      9. 26.9. Sort Messages Using Rules
      10. 26.10. Using the Spam Filter
      11. 26.11. Using RSS Feeds in Outlook
    3. 27. Managing Personal Information
      1. 27.1. View the Calendar
      2. 27.2. Create New Appointments
      3. 27.3. Print a Calendar
      4. 27.4. Share a Calendar
      5. 27.5. Add Contacts
      6. 27.6. Organize Contacts with Categories
      7. 27.7. Create a Task List
      8. 27.8. Manage a Task List
      9. 27.9. Keep Personal Notes
  13. VII. USING ONENOTE AND OTHER OFFICE COLLABORATION TOOLS
    1. 28. Getting Started with OneNote
      1. 28.1. An Introduction to OneNote
      2. 28.2. Start OneNote
      3. 28.3. Create a New Section
      4. 28.4. Add a New Page
      5. 28.5. Work with Pages
      6. 28.6. Note a Web Page
      7. 28.7. Find Text
      8. 28.8. Change Font Style or Font Size
      9. 28.9. Bold, Italicize, or Underline Text
      10. 28.10. Change Text Color
      11. 28.11. Indent Text
      12. 28.12. Add Numbers or Bullets
      13. 28.13. Using Tags for Organization
      14. 28.14. Add an Outlook Task
      15. 28.15. Add a Picture
      16. 28.16. Using the All Notebooks Window
      17. 28.17. Protect and Back Up Your Notebook
      18. 28.18. Share Notes
      19. 28.19. Start a OneNote Shared Session
    2. 29. Collaborating with Office System 2007
      1. 29.1. An Introduction to Live Meeting
      2. 29.2. Start a Live Meeting Conference
      3. 29.3. Present PowerPoint in Live Meeting
      4. 29.4. Poll in Live Meeting
      5. 29.5. An Introduction to SharePoint Workspaces
      6. 29.6. Using Files in SharePoint
      7. 29.7. Using a PowerPoint Slide Library
      8. 29.8. Using a Team Discussion
      9. 29.9. An Introduction to Groove Workspaces
      10. 29.10. Explore Vista Meeting Space
    3. A. What's on the CD-ROM
    4. Wiley Publishing, Inc. End-User License Agreement
  14. VIII. USING PUBLISHER
    1. Bonus Chapter 1. Getting Started with Publisher
      1. BC1.1. Start Publisher
      2. BC1.2. Parts of the Publisher Screen
      3. BC1.3. Create a New Publication
      4. BC1.4. Insert a New Page
      5. BC1.5. Move through a Publication
      6. BC1.6. Insert Text in a Text Box
      7. BC1.7. Using the Zoom Tools
      8. BC1.8. Insert or Delete Text
      9. BC1.9. Arrange Text Using AutoFlow
    2. Bonus Chapter 2. Working with Graphics
      1. BC2.1. Add a Clip Art Image
      2. BC2.2. Insert a Picture
      3. BC2.3. Move or Resize a Graphic
      4. BC2.4. Wrap Text Around a Graphic
      5. BC2.5. Create a Table
      6. BC2.6. Using the Design Gallery
      7. BC2.7. Using the Content Library
    3. Bonus Chapter 3. Reviewing and Printing Your Publication
      1. BC3.1. Using the Design Checker
      2. BC3.2. Add a Header or Footer
      3. BC3.3. Preview a Publication
      4. BC3.4. Print a Publication

Product information

  • Title: Master Visually®: Microsoft® Office 2007
  • Author(s): Tom Bunzel
  • Release date: September 2007
  • Publisher(s): Visual
  • ISBN: 9780470135471