What the book covers: Windows 7: Introducing the OS and basic interface navigation, managing applications, files and data, printing documents, getting connected to the Internet, establishing an e-mail account, preventing common security/safety issues, using Windows to edit and manage audio, video, and photo files, creating CDs, DVDs, and playlists with Media Center, troubleshooting, and more. Office 2010: Typing and formatting text in Word, spicing up your documents, navigating an Excel spreadsheet, editing a spreadsheet, creating a PowerPoint presentation, adding color, sound, and pictures to a presentation, configuring e-mail with Outlook, storing contacts and organizing tasks, scheduling your time and setting appointments, designing an Access database, sorting and querying a database, and more. What's on the DVDs: 4 ½ hours of step-by-step instructions for completing the most essential Windows 7 and Office 2010 tasks. Windows 7: launching Windows 7 for the first time; touring the Windows 7 interface; working with programs and files; setting up a printer; creating and using shortcuts; connecting to the internet; sending and receiving e-mail; setting up parental controls; customizing Windows 7; adding and removing programs; configuring a wireless home network; getting started with Windows Media Player; burning CDs and DVDs; importing pictures from a digital camera; and more. Office 2010: creating, opening, and saving a document; previewing and printing a document; starting new paragraphs, sections, and pages; formatting with styles and templates; setting margins and other layout options; getting data into a worksheet; managing cells, rows, and columns; reading, organizing, and deleting e-mail; saving and viewing e-mail attachments; storing and updating contact information; creating and populating slides; applying and modifying themes and masters; adding audio and video; designing a database; creating and editing a data form; searching and filtering a database; and more.