Prentice Hall

Information Technology



GO! with Microsoft Excel 2007, Brief
Shelley Gaskin
Alicia Vargas, Pasadena City College

ISBN-10: 0135130034
ISBN-13: 9780135130032

Publisher: Prentice Hall
Copyright: 2008
Format: Spiral Bound; 320 pp
Published: 05/15/2007

Suggested retail price: $43.33
Buy from myPearsonStore



For Introductory Computer courses in Microsoft Office 2007 or courses in Computer Concepts with a lab component for Microsoft Office 2007 applications.

 

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.

Sequential chapter numbering: In addition to sequential page numbering GO! chapters are now numbered 1 through 22 instead of Word Chapter 1, Excel Chapter 1, etc. This makes the text even easier to navigate.

 

Project-Based Approach: GO!’s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features.

  • Texts are now organized by objectives and student learning outcomes and there are always two instructional projects per chapter

“There’s More You Can Do” feature

 

·        Try It! exercises teach students additional skills or new office features that are not  included within the instructional portion of the chapter.

 

Workshop feature for Excel and PowerPoint chapters help students better understand the uses of these applications.

 

·        The Excel Workshop teaches formulas and other basic math skills and a separate PowerPoint Workshop teaches essential presentation skills

 

End-of-Chapter organized into two sections: Content–Based Assessments and Outcomes-Based Assessments.

  • Now your content-based or defined-solution assessments that can be graded with a solution file or GO! Highlighted Overlays are separated from your non-defined solution assessments that can be graded with the GO! Rubric. 

End-of-Chapter assessments provide even more options for quizzing and review.

 

·        GO! with Help teaches the student to work with the Help feature in Office as a project.

·        Group Business Running Case is a project that runs through entire textbook and designed to be assigned to group of students.

 

Audio/Video Expert Demonstration Documents (A/V-EDDs) are multimedia versions of the GO! Expert Demonstration Documents that provide an alternative scripted lecture scenario of each chapter project in the text.

 

·        Provided in Flash file format for easy delivery, these are ideal for online, lecture reinforcement, and lecture replacement.

 

Assignment Tags for Problem Solving assessments provide task-specific scoring checklists that save time in grading open-ended assessments (assessments without defined solutions).

 

GO!-Specific instructional content in the new myitlab assessment and training software for Office 2007!

 

  • New MyITLab training scenarios deliver the exact same step-by-step content as the projects in the GO! textbook while the assessment provides two additional scenarios of each GO! project.  

GO! with Excel 2007 Brief 1e

Chapter 1–Creating a Worksheet and Charting Data

    Project 1A–Create a Worksheet and Chart Data

        Objective 1: Create, Save, and Navigate an Excel Workbook

            Activity 1.1 Starting Excel and Naming and Saving a Workbook

            Activity 1.2 Navigating a Worksheet and a Workbook

            Activity 1.3 Selecting Parts of a Worksheet

        Objective 2: Enter and Edit Date in a Worksheet

            Activity 1.4 Entering Text, Using AutoComplete, Filling a Series with AutoFill,

            and Using Spelling Checker and Undo to Correct Typing Errors

            Activity 1.5 Aligning Text and Adjusting the Size of Columns and Rows

            Activity 1.6 Entering Numbers

            Activity 1.7 Inserting and Deleting Rows and Columns and Using the Insert

            Options Button

        Objective 3: Construct and Copy Formulas, Use the Sum Function, and Edit Cells

            Activity 1.8 Constructing a Formula, Using the Sum Function and Editing

            Numbers in Cells

            Activity 1.9 Copying a Formula by Using the Fill Handle

        Objective 4: Format Data, Cells, and Worksheets

            Activity 1.10 Formatting Financial Numbers, Using Column AutoFit, and Using

            Format Painter

            Activity 1.11 Formatting Text and Using Merge and Center

        Objective 5: Close and Reopen a Workbook

            Activity 1.12 Closing and Reopening an Existing Workbook

        Objective 6: Chart Data

            Activity 1.13 Charting Data

        Objective 7: Use Page Layout View, Prepare a Worksheet for Printing and Close Excel

            Activity 1.14 Changing Views, Creating a Footer and Using Print Preview

            Activity 1.15 Deleting Unused Sheets in a Workbook

            Activity 1.16 Printing a Worksheet

            Activity 1.17 Displaying, Printing, and Hiding Formulas

    Project 1B–Perform Calculations and Make Comparisons by Using a Pie Chart

        Objective 8: Design a Worksheet

            Activity 1.18 Setting Column Widths and Creating Row and Column Titles

            Activity 1.19 Entering Data by Range

        Objective 9: Construct Formulas for Mathematical Operations

            Activity 1.20 Using Arithmetic Operators

            Activity 1.21 Copying Formulas Containing Absolute Cell References

        Objective 10: Format Percentages and Move Formulas

            Activity 1.22 Formatting Cells with the Percent Style Button

            Activity 1.23 Inserting Rows in a Worksheet Containing Formulas and Wrapping

            Text in a Cell

        Objective 11: Create a Pie Chart and Chart Sheet

            Activity 1.24 Creating a Pie Chart and a Chart Sheet

    Objective 12: Use the Excel Help System

            Activity 1.25 Using the Excel Help System

 

Chapter 2–Managing Workbooks and Analyzing Data

    Project 2A Create a Summary Sheet from Multiple Worksheets

        Objective 1: Create and Save a Workbook from an Existing Workbook

            Activity 2.1 Creating and Saving a Workbook from an Existing Workbook

        Objective 2: Navigate a Workbook and Rename Worksheets

            Activity 2.2 Navigating Among Worksheets, Renaming Worksheets, and

            Changing the Tab Color of a Worksheet

        Objective 3: Enter Dates, Clear Contents, and Clear Formats

            Activity 2.3 Entering and Formatting Dates

            Activity 2.4 Clearing Cell Contents and Formats

        Objective 4: Move, Copy, and Paste Cell Contents

            Activity 2.5 Copying, Pasting, and Moving Cell Contents

        Objective 5: Edit and Format Multiple Worksheets at the Same Time

            Activity 2.6 Wrapping Text in a Cell in Several Worksheets at the Same Time

            Activity 2.7 Entering Data and Constructing Formulas on Multiple Worksheets

        Objective 6: Create a Summary Sheet

            Activity 2.8 Constructing Formulas that Refer to Cells in Another Worksheet

        Objective 7: Format and Print Multiple Worksheets in a Workbook

            Activity 2.9 Moving and Formatting Worksheets in a Workbook

            Activity 2.10 Printing All the Worksheets in a Workbook

    Project 2 B Growth Projection

        Objective 8: Design a Worksheet for What-If Analysis

            Activity 2.11 Using Parentheses in a Formula

            Activity 2.12 Formatting as You Type

            Activity 2.13 Calculating a Value After an Increase

        Objective 9: Perform What-If Analysis

            Activity 2.14 Performing What-If Analysis and Using Paste Special

        Objective 10: Compare Data with a Line Chart

            Activity 2.15 Creating a Line Chart

 

Chapter 3–Using Functions and Tables

    Project 3A–Track Inventory by Using Math, Logical, and Statistical Functions and

    by Creating an Excel Table

        Objective 1: Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

            Activity 3.1 Using the SUM, AVERAGE, and MEDIAN Functions

            Activity 3.2 Using the MIN and MAX Functions

            Activity 3.3 Moving Data, Adding Borders, and Rotating Text

        Objective 2: Use COUNTIF and IF Functions, and Apply Conditional Formatting

            Activity 3.4 Using the COUNTIF Functions

            Activity 3.5 Using the IF Function and Applying Conditional Formatting

            Activity 3.6 Applying Conditional Formatting Using Custom Formats and Data

            Bars

            Activity 3.7 Using Find and Replace

        Objective 3: Use a Date Function

            Activity 3.8 Using the NOW Function

        Objective 4: Freeze Panes and Create an Excel Table

            Activity 3.9 Freezing and Unfreezing Panes

            Activity 3.10 Sorting and Filtering in an Excel Table

            Activity 3.11 Inserting a Second Table in a Worksheet

            Activity 3.12 Converting a Table to a Range of Data

        Objective 5: Format and Print a Large Worksheet

            Activity 3.13 Printing Large Worksheets

    Project 3B–Make Financial Decisions by Using Financial Functions and What-If

    Analysis

        Objective 6: Use Financial Functions

            Activity 3.14 Designing a Loan Worksheet

            Activity 3.15 Inserting the PMT Financial Function

        Objective 7: Use Goal Seek

            Activity 3.16 Using Goal Seek to Produce the Desired Result

            Activity 3.17 Using Goal Seek to Find an Increase Period

        Objective 8: Create a Data Table

            Activity 3.18 Designing a Two-Variable Data Table

            Activity 3.19 Using a Data Table to Calculate Options

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.

View a Sample Chapter PDF:

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson Higher Education representative for pricing and ordering information.

This title is a member of the Go! Series, which also contains the titles below . You can also visit the Go! Series page.

  • 0132437988GO with Microsoft Office PowerPoint Comprehensive and Student CD Package
    Gaskin & Vargas
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132437988 | ISBN-13: 9780132437981
    Brief Description | Buy from myPearsonStore

  • 0132327627GO! with Access 2007 Comprehensive
    Gaskin, McLellan, Dozier & Townsend
    © 2008 | Prentice Hall | Paper; 912 pages | Instock
    ISBN-10: 0132327627 | ISBN-13: 9780132327626
    Brief Description | Buy from myPearsonStore

  • 0132327937GO! with Computer Concepts Getting Started
    Gaskin & Coyle
    © 2008 | Prentice Hall | Paper; 96 pages | Instock
    ISBN-10: 0132327937 | ISBN-13: 9780132327930
    Brief Description | Buy from myPearsonStore

  • 0132255596GO! with Excel 2007 Comprehensive
    Gaskin & Jolly
    © 2008 | Prentice Hall | Paper; 1232 pages | Instock
    ISBN-10: 0132255596 | ISBN-13: 9780132255592
    Brief Description | Buy from myPearsonStore

  • 013157244XGO! with Internet Explorer 2007 Getting Started
    Gaskin & Fry
    © 2008 | Prentice Hall | Paper; 96 pages | Instock
    ISBN-10: 013157244X | ISBN-13: 9780131572447
    Brief Description | Buy from myPearsonStore

  • 0132437686GO! with Microsoft Access 2003, Vol. 1 and Student CD Package
    Gaskin & Foster-Turpen
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132437686 | ISBN-13: 9780132437684
    Brief Description | Buy from myPearsonStore

  • 0131791486GO! with Microsoft Access 2003, Vol. 2 and Student CD Package
    Gaskin & Howard
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0131791486 | ISBN-13: 9780131791480
    Brief Description | Buy from myPearsonStore

  • 0135130409GO! with Microsoft Access 2007, Volume 1
    Gaskin, Marks & Townsend
    © 2008 | Prentice Hall | Spiralbound with CD-ROM; 576 pages | Instock
    ISBN-10: 0135130409 | ISBN-13: 9780135130407
    Brief Description | Buy from myPearsonStore

  • 0131791478GO! with Microsoft Excel 2003, Vol 2 and Student CD Package
    Gaskin, Preston & Preston
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0131791478 | ISBN-13: 9780131791473
    Brief Description | Buy from myPearsonStore

  • 0135130034GO! with Microsoft Excel 2007, Brief
    Gaskin & Vargas
    © 2008 | Prentice Hall | Spiral Bound; 320 pages | Instock
    ISBN-10: 0135130034 | ISBN-13: 9780135130032
    Brief Description | Buy from myPearsonStore

  • 0135129869GO! with Microsoft Excel 2007, Volume 1
    Gaskin, Vargas & Preston
    © 2008 | Prentice Hall | Spiralbound with CD-ROM; 608 pages | Instock
    ISBN-10: 0135129869 | ISBN-13: 9780135129869
    Brief Description | Buy from myPearsonStore

  • 0131679996GO! with Microsoft Office 2007 Introductory
    Gaskin, Ferrett, Vargas & Marks
    © 2008 | Prentice Hall | Paper; 1504 pages | Instock
    ISBN-10: 0131679996 | ISBN-13: 9780131679993
    Brief Description | Buy from myPearsonStore

  • 0132446642GO! with Microsoft Office 2007, Intermediate
    Gaskin, Ferrett, Vargas, Marks & Preston
    © 2008 | Prentice Hall | Paper; 928 pages | Instock
    ISBN-10: 0132446642 | ISBN-13: 9780132446648
    Brief Description | Buy from myPearsonStore

  • 0132438011GO! with Microsoft Office Access 2003 Comprehensive and Student CD Package
    Gaskin & Howard
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132438011 | ISBN-13: 9780132438018
    Brief Description | Buy from myPearsonStore

  • 0132437708GO! with Microsoft Office Excel 2003 Brief and Student CD Package
    Gaskin, Preston, Preston & Ferrett
    © 2004 | Prentice Hall | Paper | Instock
    ISBN-10: 0132437708 | ISBN-13: 9780132437707
    Brief Description | Buy from myPearsonStore

  • 0132437716GO! with Microsoft Office Excel 2003 Comprehensive and Student CD Package
    Gaskin, Ferrett, Preston & Preston
    © 2004 | Prentice Hall | Paper | Instock
    ISBN-10: 0132437716 | ISBN-13: 9780132437714
    Brief Description | Buy from myPearsonStore

  • 0132437732GO! with Microsoft Office PowerPoint 2003 Brief and Student CD Package
    Gaskin & Vargas
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132437732 | ISBN-13: 9780132437738
    Brief Description | Buy from myPearsonStore

  • 0132242370GO! with Microsoft Office PowerPoint 2003 Vol. 1 and Student CD Package
    Gaskin & Vargas
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132242370 | ISBN-13: 9780132242370
    Brief Description | Buy from myPearsonStore

  • 013179146XGO! with Microsoft Office PowerPoint Vol. 2 and Student CD Package
    Gaskin & Vargas
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Out of Stock
    ISBN-10: 013179146X | ISBN-13: 9780131791466
    Brief Description

  • 0132242419GO! with Microsoft Office Word 2003 Comprehensive and Go! Student CD Package
    Gaskin, Preston, Preston & Ferrett
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132242419 | ISBN-13: 9780132242417
    Brief Description | Buy from myPearsonStore

  • 0131791451GO! with Microsoft Office Word, Vol. 2 and Student CD Package
    Gaskin, Preston, Preston & Ferrett
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0131791451 | ISBN-13: 9780131791459
    Brief Description | Buy from myPearsonStore

  • 0132447983GO! with Microsoft PowerPoint 2007 Volume 1
    Gaskin & Vargas
    © 2008 | Prentice Hall | Spiralbound with CD-ROM; 512 pages | Instock
    ISBN-10: 0132447983 | ISBN-13: 9780132447980
    Brief Description | Buy from myPearsonStore

  • 0135130417GO! with Microsoft PowerPoint 2007, Brief
    Gaskin & Vargas
    © 2008 | Prentice Hall | Spiralbound with CD-ROM; 272 pages | Instock
    ISBN-10: 0135130417 | ISBN-13: 9780135130414
    Brief Description | Buy from myPearsonStore

  • 0132318393GO! with Microsoft Windows XP Getting Started
    Gaskin, Ferrett, Preston & Preston
    © 2008 | Prentice Hall | Paper; 96 pages | Instock
    ISBN-10: 0132318393 | ISBN-13: 9780132318396
    Brief Description | Buy from myPearsonStore

  • 0135129966GO! with Microsoft Word 2007, Brief
    Gaskin & Ferrett
    © 2008 | Prentice Hall | Spiralbound with CD-ROM; 384 pages | Instock
    ISBN-10: 0135129966 | ISBN-13: 9780135129968
    Brief Description | Buy from myPearsonStore

  • 0135129524GO! with Microsoft Word 2007, Volume 1
    Gaskin & Ferrett
    © 2008 | Prentice Hall | Spiralbound with CD-ROM; 512 pages | Instock
    ISBN-10: 0135129524 | ISBN-13: 9780135129524
    Brief Description | Buy from myPearsonStore

  • 0131572504GO! with Office 2007 Getting Started
    Vargas, Marks, Preston, Ferrett & Gaskin
    © 2008 | Prentice Hall | Paper; 416 pages | Instock
    ISBN-10: 0131572504 | ISBN-13: 9780131572508
    Brief Description | Buy from myPearsonStore

  • 0136158714GO! with Office 2007 Integrated Projects
    Gaskin & Hain
    © 2008 | Prentice Hall | Spiral Bound; 800 pages | Instock
    ISBN-10: 0136158714 | ISBN-13: 9780136158714
    Brief Description | Buy from myPearsonStore

  • 0132418878GO! with Office 2007, Introductory, 2/E
    Gaskin, Ferrett, Vargas & Marks
    © 2009 | Prentice Hall | Spiral Bound; 1280 pages | Instock
    ISBN-10: 0132418878 | ISBN-13: 9780132418874
    Brief Description | Buy from myPearsonStore

  • 0132256177GO! with Outlook 2007 Getting Started
    Gaskin & Townsend
    © 2008 | Prentice Hall | Paper; 96 pages | Instock
    ISBN-10: 0132256177 | ISBN-13: 9780132256179
    Brief Description | Buy from myPearsonStore

  • 0132327678GO! with PowerPoint 2007 Comprehensive
    Gaskin & Roselli
    © 2008 | Prentice Hall | Paper; 720 pages | Instock
    ISBN-10: 0132327678 | ISBN-13: 9780132327671
    Brief Description | Buy from myPearsonStore

  • 0131466267GO! with XHTML Comprehensive
    Duvall
    © 2007 | Prentice Hall | Paper; 928 pages | Instock
    ISBN-10: 0131466267 | ISBN-13: 9780131466265
    Brief Description | Buy from myPearsonStore

  • 0131573586Go! with Microsoft Office 2003 Brief 2e and Student CD, 2/E
    Gaskin
    © 2007 | Prentice Hall | Kit/Package/ShrinkWrap; 1400 pages | Instock
    ISBN-10: 0131573586 | ISBN-13: 9780131573581
    Brief Description | Buy from myPearsonStore

  • 0132242427Go! with Microsoft Word 2003, Volume 1 and Go! Student CD
    Preston, Preston, Ferrett & Gaskin
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132242427 | ISBN-13: 9780132242424
    Brief Description | Buy from myPearsonStore

  • 013159253XInstructor Reference Cards PowerPoint Comprehensive
    Grauer
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 013159253X | ISBN-13: 9780131592537


  • 0131588346PHIT TIPS Microsoft Access 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0131588346 | ISBN-13: 9780131588349
    Buy from myPearsonStore

  • 0131588354PHIT Tips: File Management
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 2 pages | Instock
    ISBN-10: 0131588354 | ISBN-13: 9780131588356
    Buy from myPearsonStore

  • 0132332221PHIT Tips: Microsoft Office 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0132332221 | ISBN-13: 9780132332224
    Buy from myPearsonStore

  • 0132050625PHIT Tips: Microsoft Outlook 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0132050625 | ISBN-13: 9780132050623
    Buy from myPearsonStore

  • 0132332558PHIT Tips: Microsoft PowerPoint 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0132332558 | ISBN-13: 9780132332552
    Buy from myPearsonStore

  • 0132050617PHIT Tips: Microsoft Word 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0132050617 | ISBN-13: 9780132050616
    Buy from myPearsonStore

  • 0131588311PHIT Tips: WinZip for Microsoft Office 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card | Instock
    ISBN-10: 0131588311 | ISBN-13: 9780131588318
    Buy from myPearsonStore

  • 0136128017Phit TIPS: Microsoft Excel 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0136128017 | ISBN-13: 9780136128014
    Buy from myPearsonStore

  • 0132050609Shortcut Key Card: Microsoft Access 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card | Instock
    ISBN-10: 0132050609 | ISBN-13: 9780132050609
    Buy from myPearsonStore

  • 0132332531Shortcut Key Card: Microsoft Excel 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0132332531 | ISBN-13: 9780132332538
    Buy from myPearsonStore

  • 0131588400Shortcut Key Card: Microsoft Office 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 2 pages | Instock
    ISBN-10: 0131588400 | ISBN-13: 9780131588400
    Buy from myPearsonStore

  • 013158832XShortcut Key Card: Microsoft PowerPoint 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card | Out of Stock
    ISBN-10: 013158832X | ISBN-13: 9780131588325


  • 0136128009Shortcut Key Card: Microsoft Word 2007
    PrenticeHall
    © 2008 | Prentice Hall | Study Card; 2 pages | Instock
    ISBN-10: 0136128009 | ISBN-13: 9780136128007
    Buy from myPearsonStore

  • 0136128025Windows Vista PHIT Tip
    CIS Prentice Hall
    © 2008 | Prentice Hall | Study Card; 4 pages | Instock
    ISBN-10: 0136128025 | ISBN-13: 9780136128021
    Buy from myPearsonStore

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.