Synopses & Reviews
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 pacebuilding and practicing the skills you need, just when you need them!
- Take control of your dayorganize 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 books lessons
- Fully searchable eBook
- Bonus quick reference to the Ribbon, the new Microsoft Office interface
- Windows Vista Product Guide eBookplus other resources on CD
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
Synopsis
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 books 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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Synopsis
Combining self-paced lessons and hands-on exercises, this practical tutorial furnishes detailed instruction in the fundamental features and functions of Access, Excel, FrontPage, Outlook, PowerPoint, Publisher, and Word, as well as InfoPath, SharePoint, LiveMeeting, and Groove--and the new integration features of the new version of the Office suite. Original. (Beginning/Intermediate)
About the Author
Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.
Joyce Cox has more than 30 years' experience in the development of training materials about technical subjects for non-technical audiences and is the author of dozens of books about Office and Windows technologies. Joyce is vice president of Online Training Solutions, Inc. (OTSI). Previously, she was president of and principal author for Online Press, where she developed the Quick Course 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.
Katherine Murray has written more than 60 computer books, including Microsoft Office 2010 Plain & Simple, Microsoft Word 2010 Plain & Simple, and Microsoft Word 2010 Inside Out. She specializes in teaching people and businesses how to improve their productivity using Microsoft technologies, and she loves the freedom that comes along with the “work virtually anywhere” approach Office 365 offers.
Table of Contents
A Tour of the Office 2007 User Interface; Using the "Ribbon"; The New File Menu; Quick Access Toolbar; New View Controls; Key Points; Information for Readers Running Windows XP; Managing the Practice Files; Using the Start Menu; Navigating Dialog Boxes; Getting Help; Getting Help with This Book and Its Companion CD; Getting Help with an Office Program; More Information; Using the Books CD; Whats on the CD?; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Removing and Uninstalling the Practice Files; Features and Conventions of This Book; About the Authors; Joyce Cox; Curtis Frye; Steve Lambert; M. Dow Lambert III; Katherine Murray; Joan Lambert Preppernau; Online Training Solutions, Inc. (OTSI); 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 Document Appearance; 9 Creating a Database; 10 Simplifying Data Entry by Using Forms; 11 Locating Specific Information; 12 Keeping Your Information Accurate; 13 Starting a New Presentation; 14 Working with Slide Text; 15 Adjusting the Layout, Order, and Look of Slides; 16 Delivering a Presentation Electronically; 17 Getting Started with Outlook 2007; 18 Sending E-Mail Messages; 19 Managing Your Inbox; 20 Managing Appointments, Events, and Meetings; 21 Managing Your Calendar; Part I: 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; Part II: 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; Part III: 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; Part IV: 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; Part V: 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;