Get this product faster from our US warehouse
For students taking an introductory course using a project-based introduction to Microsoft Office 2007.
Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.
Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.
Robert L. Ferret recently retired as the director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty. He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher, WordPerfect, and Word. Before writing the GO! Series, Bob was a series editor and author for the Learn Series. He has a bachelor's degree in psychology, a master's degree in geography, and a master's degree in interdisciplinary technology from Eastern Michigan University. Bob's doctoral studies were in instructional technology at Wayne State University. For fun, Bob teaches a four-week computers and genealogy class and has written genealogy and local history books.
Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College. She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
Suzanne Marks is a faculty member in Business Technology Systems at Bellevue Community College, Bellevue, Washington. She holds a bachelor's degree in business education from Washington State University, and was project manager for the first IT Skills Standards in the United States.
Word Chapter 5: Creating Documents with Microsoft Word 2007
Objective 1 Create and Save a New Document
Objective 2 Edit Text
Objective 3 Select, Delete, and Format Text
Objective 4 Print a Document
Objective 5 Navigate the Word Window
Objective 6 Add a Graphic to a Document
Objective 7 Use the Spelling and Grammar Checker
Objective 8 Preview and Print Documents, Close a Document, and Close Word
Objective 9 Use the Microsoft Help System
Word Chapter 6 Formatting and Organizing Text
Objective 1 Change Document and Paragraph Layout
Objective 2 Change and Reorganize Text
Objective 3 Create and Modify Lists
Objective 4 Insert and Format Headers and Footers
Objective 5 Insert Frequently Used Text
Objective 6 Insert and Format References
Word Chapter 7 Using Graphics and Tables
Objective 1 Insert and Format Graphics
Objective 2 Set Tab Stops
Objective 3 Insert and Modify Text Boxes and Shapes
Objective 4 Create a Table
Objective 5 Format a Table
Word Chapter 8 Special Document Formats, Columns, and Mail Merge
Objective 1 Collect and Paste Text and Graphics
Objective 2 Create and Format Columns
Objective 3 Use Special Character and Paragraph Formatting
Objective 4 Create Mailing Labels Using Mail Merge
Objective 5 Insert Hyperlinks
Objective 6 Insert a SmartArt Graphic
Objective 7 Preview and Save a Document as a Web Page
Excel 2007
Excel Chapter 9 Creating a Worksheet and Charting Data
Objective 1 Create, Save, and Navigate an Excel Workbook
Objective 2 Enter and Edit Data in a Worksheet
Objective 3 Construct and Copy Formulas, Use the Sum Function, and Edit Cells
Objective 4 Format Data, Cells, and Worksheets
Objective 5 Close and Reopen a Workbook
Objective 6 Chart Data
Objective 7 Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel
Objective 8 Design a Worksheet
Objective 9 Construct Formulas for Mathematical Operations
Objective 10 Format Percentages and Move Formulas
Objective 11 Create a Pie Chart and a Chart Sheet
Objective 12 Use the Excel Help System
Excel Chapter 10 Managing Workbooks and Analyzing Data
Objective 1 Create and Save a Workbook from an Existing Workbook
Objective 2 Navigate a Workbook and Rename Worksheets
Objective 3 Enter Dates, Clear Contents, and Clear Formats
Objective 4 Move, Copy, and Paste Cell Contents
Objective 5 Edit and Format Multiple Worksheets at the Same Time
Objective 6 Create a Summary Sheet
Objective 7 Format and Print Multiple Worksheets in a Workbook
Objective 8 Design a Worksheet for What-If Analysis
Objective 9 Perform What-If Analysis
Objective 10 Compare Data with a Line Chart
Excel Chapter 11 Using Functions and Tables
Objective 1 Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
Objective 2 Use COUNTIF and IF Functions, and Apply Conditional Formatting
Objective 3 Use a Date Function
Objective 4 Freeze Panes and Create an Excel Table
Objective 5 Format and Print a Large Worksheet
Objective 6 Use Financial Functions
Objective 7 Use Goal Seek
Objective 8 Create a Data Table
Access 2007
Access Chapter 12 Getting Started with Access Databases and Tables
Objective 1 Start Access and Create a New Blank Database
Objective 2 Add Records to a Table
Objective 3 Rename Table Fields in Datasheet View
Objective 4 Modify the Design of a Table
Objective 5 Add a Second Table to a Database
Objective 6 Print a Table
Objective 7 Create and Use a Query
Objective 8 Create and Use a Form
Objective 9 Create and Print a Report
Objective 10 Close and Save a Database
Objective 11 Create a Database Using a Template
Objective 12 Organize Database Objects in the Navigation Pane
Objective 13 Create a New Table in a Database Created with a Template
Objective 14 View a Report and Print a Table in a Database Created with a Template
Objective 15 Use the Access Help System
Access Chapter 13 Sort and Query a Database
Objective 1 Open an Existing Database
Objective 2 Create Table Relationships
Objective 3 Sort Records in a Table
Objective 4 Create a Query in Design View
Objective 5 Create a New Query from an Existing Query
Objective 6 Sort Query Results
Objective 7 Specify Criteria in a Query
Objective 8 Create a New Table by Importing an Excel Spreadsheet
Objective 9 Specify Numeric Criteria in a Query
Objective 10 Use Compound Criteria
Objective 11 Create a Query Based on More Than One Table
Objective 12 Use Wildcards in a Query
Objective 13 Use Calculated Fields in a Query
Objective 14 Group Data and Calculate Statistics in a Query
Access Chapter 14 Forms, Filters, and Reports
Objective 1 Create a Form
Objective 2 Use a Form to Add and Delete Records
Objective 3 Create a Form by Using the Form Wizard
Objective 4 Modify a Form in Design View and in Layout View
Objective 5 Filter Records
Objective 6 Create a Report by Using the Report Tool
Objective 7 Create a Report by Using the Blank Report Tool
Objective 8 Create a Report by Using the Report Wizard
Objective 9 Modify the Design of a Report
Objective 10 Print a Report and Keep Data Together
PowerPoint 2007
PowerPoint Chapter 15 Getting Started with Microsoft PowerPoint 2007
Objective 1 Open, View, and Save a Presentation
Objective 2 Edit a Presentation
Objective 3 Format a Presentation
Objective 4 Create Headers and Footers and Print a Presentation
Objective 5 Create a New Presentation
Objective 6 Use Slide Sorter View
Objective 7 Add Pictures to a Presentation
Objective 8 Use the Microsoft Help System
PowerPoint Chapter 16 Designing a PowerPoint Presentation
Objective 1 Format Slide Elements
Objective 2 Insert and Format Pictures and Shapes
Objective 3 Apply Slide Transitions
Objective 4 Reorganize Presentation Text and Clear Formats
Objective 5 Create and Format a SmartArt Graphic
PowerPoint Chapter 17 Enhancing a Presentation with Animation, Tables, and Charts
Objective 1 Customize Slide Backgrounds and Themes
Objective 2 Animate a Slide Show
Objective 3 Create and Modify Tables
Objective 4 Create and Modify Charts
Integrated Projects
Chapter 18 Using Access Data with Other Office Programs
Objective 1 Export Access Data to Excel
Objective 2 Create a Formula in Excel
Objective 3 Create a Chart in Excel
Objective 4 Copy Access Data into a Word Document
Objective 5 Copy Excel Data into a Word Document
Objective 6 Insert an Excel Chart into a PowerPoint Presentation
Chapter 19 Using Tables in Word and Excel
Objective 1 Plan a Table in Word
Objective 2 Enter Data and Format a Table in Word
Objective 3 Create a Table in Word from Excel Data
Objective 4 Create an Excel Worksheet from a Word Table
Chapter 20 Using Excel as a Data Source in a Mail Merge
Objective 1 Prepare a Mail Merge Document for Mailing Labels
Objective 2 Choose an Excel Worksheet as a Data Source
Objective 3 Produce and Save Merged Mailing Labels
Objective 4 Open a Saved Main Document for Mail Merge
Chapter 21 Linking Data in Office Documents
Objective 1 Insert and Link an Excel Object in Word
Objective 2 Revise a Linked Excel Worksheet and Update Links in Word
Objective 3 Open a Word Document That Includes a Linked Object and Update Links
Chapter 22 Creating Presentation Content from Office Documents
Objective 1 Insert a Word Outline into PowerPoint
Objective 2 Import Excel Data into a PowerPoint Chart
Objective 3 Insert a Hyperlink into a PowerPoint Slide