CARVIEW |
2007 Microsoft® Office System Step by Step
- By
- Joyce Cox, Curtis Frye, Steve Lambert, Joan Preppernau, Katherine Murray, et al.
- Publisher:
- Microsoft Press
- Released:
- January 2007
- Pages:
- 752
The smart way to learn the latest version of Microsoft Office—one step at a time! Build exactly the skills you need by working at your own pace through easy-to-follow lessons and hands-on practice files on CD.
Quickly teach yourself how to use Microsoft Office Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Word 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!
- Take control of your day—organize your e-mail, calendar, and meetings
- Learn the essentials for creating effective documents
- Build spreadsheets and perform calculations on your data
- Design database applications to help manage information
- Produce and deliver compelling slide show presentations
- Organize and format text to craft professional-quality documents
Your all-in-one learning experience includes:
- Files for building skills and practicing the book’s lessons
- Fully searchable eBook
- Bonus quick reference to the Ribbon, the new Microsoft Office interface
- Windows Vista Product Guide eBook—plus other resources on CD
-
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
-
-
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
-
-
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
-
-
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
-
-
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
-
Appendix Choose the Right Book for You
-
Published and Upcoming Titles
-

- Title:
- 2007 Microsoft® Office System Step by Step
- By:
- Joyce Cox, Curtis Frye, Steve Lambert, Joan Preppernau, Katherine Murray
- Publisher:
- Microsoft Press
- Formats:
-
- Ebook
- Safari Books Online
- Print Release:
- January 2007
- Ebook Release:
- November 2009
- Pages:
- 752
- Print ISBN:
- 978-0-7356-2278-4
- | ISBN 10:
- 0-7356-2278-7
- Ebook ISBN:
- 978-0-7356-9031-8
- | ISBN 10:
- 0-7356-9031-6
Joyce Cox,
Joyce has 25 years' experience in writing about and editing technical subjects for non-technical audiences. For 12 of those years she was the principal author for Online Press, where she developed of a series of computer training books for beginning and intermediate adult learners. She was also the first managing editor of Microsoft Press, an editor for Sybex, and an editor for the University of California. She is a master gardener with a passion for culinary and medicinal herbs.
Curtis Frye,
Curtis Frye is a freelance writer and Microsoft Most Valuable Professional for Microsoft Office Excel. He is the author of eight books from Microsoft Press, including Excel 2007 Step by Step, Microsoft Office Access 2007 Plain & Simple, Microsoft Office Excel 2007 Plain & Simple, and Microsoft Office Accounting 2006 Step by Step. He has also written numerous articles for the Microsoft Work Essentials Web site.
Steve Lambert,
Steve started messing around with computers in the mid 1970's, before they became personal and migrated to the desktop. As computers evolved from wire-wrap and solder to consumer products, he evolved from hardware geek to programmer and writer. Steve has written 14 books and a wide variety of technical documentation, and has produced training tools and help systems. He wrote this book aboard his trimaran while anchored off the coast of Florida.
Joan Preppernau,
Joan is the primary author of Windows XP Step by Step and FrontPage 2002 Step by Step published by Microsoft Press, and is a contributing author to Quick Course® in Windows XP and Quick Course® in Windows 2000, both books in OTSI's Practical Business Skills™ series. Currently residing in Sweden with her family, Joan is taking part in an extended mobile computing experiment, and enjoying the benefits of the time difference between her home office and OTSI's corporate headquarters. Prior to becoming involved as an author, Joan wore a variety of hats for OTSI including data preparation manager, operations manager, web master, technical editor, and copy editor, all of which contribute to her passion for producing interesting, useful, and understandable training materials.
Katherine Murray,
Katherine Murray has authored and coauthored more than 40 computer books with several Microsoft Office titles to her credit, including Faster Smarter Microsoft Office 2003, First Look Microsoft Office 2003, Faster Smarter Microsoft Office XP, and Microsoft Word Version 2002 Inside Out. She is also a columnist on the Microsoft Office Community site on www.microsoft.com. Katherine specializes in teaching people and businesses how to communicate effectively by using print and electronic media.
![]() ©2010, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly
Academic Solutions Authors Contacts Customer Service Jobs Newsletters O'Reilly Labs Press Room Privacy Policy RSS Feeds Terms of Service User Groups Writing for O'Reilly |
Content Archive Business Technology Computer Technology Microsoft Mobile Network Operating System Digital Photography Programming Software Web Web Design |
More O'Reilly Sites
O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone makezine.com craftzine.com hackszine.com perl.com xml.com Partner Sites InsideRIA java.net O'Reilly Insights on Forbes.com |