PACKAGE ISBN-13: 9780132743778

By Shelley Gaskin, Alicia Vargas

Published by Prentice Hall

Published Date: Mar 16, 2011

Components of the Package:

Student Videos for GO! with Microsoft Excel Brief
By Shelley Gaskin

GO! with Microsoft Excel Brief
By Shelley Gaskin, Alicia Vargas

Description

For introductory computer courses on Microsoft Excel 2010 or courses in computer concepts with a lab component on Excel.

 

Teach the course YOU want in LESS TIME! 

 

The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.

Table of Contents

 

GO! with Excel 2010 Brief Table of Contents

Common Features Chapter 1 Using the Common Features of Office 2010 Scenario: Oceana Palm Grill Project 1A: Menu Plan

Objective 1 Use Windows Explorer to Locate Files and Folder Activity 1.01 Using Windows Explorer to Locate Files and Folders

Objective 2 Locate and Start a Microsoft Office 2010 Program Activity 1.02 Locating and Starting a Microsoft Office 2010 Program

Objective 3 Enter and Edit Text in an Office Program Activity 1.03 Entering and Editing Text in an Office Program

Objective 4 Perform Commands From a Dialog Box Activity 1.04 Performing Commands From a Dialog Box

Objective 5 Create a Folder, Save a File, and Close a Program Activity 1.05 Creating a Folder, Saving a File, and Closing a Program

Objective 6 Print a File Activity 1.06 Printing a File

Project 1B: Memo

Objective 7 Open an Existing File and Save it With a New Name Activity 1.07 Opening an Existing File and Saving it With a New Name

Objective 8 Explore Application Options Activity 1.08 Viewing Application Options

Objective 9 Perform Commands from the Ribbon Activity 1.09 Performing Commands from the Ribbon Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon

Objective 10 Apply Formatting in Office Programs Activity 1.11 Formatting and Viewing Pages Activity 1.12 Formatting Text Activity 1.13 Using the Office Clipboard to Cut, Copy, and Paste

Objective 11 Use the Microsoft Office 2010 Help System Activity 1.14 Using the Microsoft Office 2010 Help System in Excel

Objective 12 Compress Files Activity 1.15 Compressing Files

Chapter 1 Creating a Worksheet and Charting Data Scenario: Texas Spectrum Wireless Project 1A: Quarterly Sales Report with Embedded Column Chart

Objective 1 Create, Save, and Navigate an Excel Workbook Activity 1.01 Starting Excel and Naming and Saving a Workbook Activity 1.02 Navigating a Worksheet and a Workbook

Objective 2 Enter Data in a Worksheet Activity 1.03 Entering Text and Using AutoComplete Activity 1.04 Filling a Series with Auto Fill and Using Excel Keyboard Shortcuts Activity 1.05 Aligning Text and Adjusting the Size of Columns Activity 1.06 Entering Numbers

Objective 3 Construct and Copy Formulas and Use the Sum Function Activity 1.07 Constructing a Formula and Using the Sum Function Activity 1.08 Copying a Formula by Using the Fill Handle

Objective 4 Format Cells with Merge & Center and Cell Styles Activity 1.09 Using Merge & Center and Applying Cell Styles Activity 1.10 Formatting Financial Numbers

Objective 5 Chart Data in a Column Chart Activity 1.11 Charting Data in a Column Chart

Objective 6 Prepare a Worksheet for Printing and Close Excel Activity 1.12 Changing Views, Creating a Footer, and Using Print Preview Activity 1.13 Deleting Unused Sheets in a Workbook Activity 1.14 Printing a Worksheet Activity 1.15 Displaying, Printing, and Hiding Formulas

Project 1B: Inventory Valuation

Objective 7 Check Spelling in a Worksheet Activity 1.16 Checking Spelling in a Worksheet

Objective 8 Enter Data by Range Activity 1.17 Entering Data by Range

Objective 9 Construct Formulas for Mathematical Operations Activity 1.18 Using Arithmetic Operators Activity 1.19 Copying Formulas Containing Absolute Cell References

Objective 10 Edit Values in a Worksheet Activity 1.20 Editing Values in a Worksheet Activity 1.21 Formatting Cells with the Percent Style

Objective 11 Format a Worksheet Activity 1.22 Inserting and Deleting Rows and Columns Activity 1.23 Adjusting Column Widths and Wrapping Text

Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks Scenario: Laurales Herbs and Spices

Project 2A: Inventory Status Report

Objective 1 Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions Activity 2.01 Using the SUM and AVERAGE Functions Activity 2.02 Using the MEDIAN Function Activity 2.03 Using the MIN and MAX Functions

Objective 2 Move Data, Resolve Error Messages, and Rotate Text Activity 2.04 Moving Data and Resolving a # # # # Error Message Activity 2.05 Rotating Text

Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting Activity 2.06 Using the COUNTIF Function Activity 2.07 Using the IF Function Activity 2.08 Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars Activity 2.09 Using Find and Replace

Objective 4 Use Date & Time Functions and Freeze Panes Activity 2.10 Using the NOW Function to Display a System Date Activity 2.11 Freezing and Unvreezing Panes

Objective 5 Create, Sort, and Filter an Excel Table Activity 2.12 Creating an Excel Table Activity 2.13 Sorting and Filtering an Excel Table Activity 2.14 Converting a Table to a Range of Data

Objective 6 Format and Print a Large Worksheet Activity 2.15 Printing Titles and Scaling to Fit

Project 2B: Weekly Sales Summary

Objective 7 Navigate a Workbook and Rename Worksheets Activity 2.16 Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color Worksheets

Objective 8 Enter Dates, Clear Contents, and Clear Formats Activity 2.17 Entering and Formatting Dates Activity 2.18 Clearing Cell Contents and Formats

Objective 9 Copy and Paste Cell Contents Activity 2.19 Copying and Pasting Cell Contents

Objective 10 Edit and Format Multiple Worksheets at the Same Time Activity 2.20 Grouping Worksheets for Editing Activity 2.21 Formatting and Constructing Formulas on Grouped Worksheets

Objective 11 Create a Summary Sheet Activity 2.22 Constructing Formulas that Refer to Cells in Another Worksheet Activity 2.23 Changing Values in a Detail Worksheet to Update a Summary Worksheet

Objective 12 Format and Print Multiple Worksheets in a Workbook Activity 2.24 Moving and Formatting Worksheets in a Workbook Activity 2.25 Printing All the Worksheets in a Workbook

Chapter 3 Charting Data Scenario: City of Orange Blossom Beach Project 3A: Pie Chart Objective 1 Create a Pie Chart and a Chart Sheet Activity 3.01 Calculating Percentages Activity 3.02 Using Formula AutoComplete Activity 3.03 Creating a Pie Chart with a Chart Sheet

Objective 2 Format a Pie Chart Activity 3.04 Applying 3-D to a Pie Chart Activity 3.05 Rotating Slices in a Pie Chart Activity 3.06 Exploding and Coloring a Pie Chart Activity 3.07 Formatting the Chart Area of a Pie Chart Activity 3.08 Inserting a Text Box in a Chart

Objective 3 Update a Chart and Insert WordArt Activity 3.09 Updating a Chart Activity 3.10 Inserting WordArt in a Worksheet

Objective 4 Preparing a Chart Sheet for Printing Activity 3.11 Preparing and Printing a Chart Sheet

Project 3B: Line Chart

Objective 5 Design a Worksheet for What-If Analysis Activity 3.12 Using Parentheses in a Formula Activity 3.13 Calculating a Value After an Increase

Objective 6 Perform What-If Analysis Activity 3.14 Performing What-If Analysis Activity 3.15 Using Paste Special

Objective 7 Compare Data with a Line Chart Activity 3.16 Creating a Line Chart to Compare Data

This title is also sold in the various packages listed below. Before purchasing one of these packages, speak with your professor about which one will help you be successful in your course.

Package ISBN-13: 9780133511321

Includes this title packaged with:

  • myitlab with Pearson eText -- Access Code -- for GO! Office 2010
    . Pearson Education

$167.20 | Add to Cart

Package ISBN-13: 9780132977807

Includes this title packaged with:

  • myitlab -- Access Card -- for GO! Office 2010 Vol. 1
    Mike Pearson Education

$174.73 | Add to Cart

Package ISBN-13: 9780133777581

Includes this title packaged with:

  • Interpretive Simulations Access Code Card Group A
    INTERPRETIVE
  • myitlab -- Access Code -- for GO! Office 2010
    . Pearson Education

$205.93 | Add to Cart

Package ISBN-13: 9780133012002

Includes this title packaged with:

  • Interpretive Simulations Access Code Card Group A
    INTERPRETIVE
  • myitlab -- Access Card -- for GO! Office 2010 Vol. 1
    Mike Pearson Education

$205.93 | Add to Cart

Package ISBN-13: 9780133487114

Includes this title packaged with:

  • myitlab with Pearson eText -- Access Code -- for GO! Office 2010
    . Pearson Education
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$217.33 | Add to Cart

Package ISBN-13: 9780132928274

Includes this title packaged with:

  • GO! with Windows 7 Getting Started with Student CD
    Shelley Gaskin, Robert Ferrett
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$133.60 | Add to Cart

Package ISBN-13: 9780133514810

Includes this title packaged with:

  • GO WITH MICROSF OFC WORD BRF & STDNT VIDEOS
    Shelley Gaskin, Robert Ferrett
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$165.80 | Add to Cart

Package ISBN-13: 9780132836265

Includes this title packaged with:

  • GO WITH MICROSF PPT 2010 BRF & STDNT VIDEOS
    Shelley Gaskin, Alicia Vargas
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$165.80 | Add to Cart

Package ISBN-13: 9780133006278

Includes this title packaged with:

  • GO! with Concepts Getting Started
    Shelley Gaskin, Victor Giol
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$159.40 | Add to Cart

Package ISBN-13: 9780133353198

Includes this title packaged with:

  • GO WITH MICROSF PPT 2010 BRF & STDNT VIDEOS
    Shelley Gaskin, Alicia Vargas
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan
  • myitlab with Pearson eText -- Access Card -- for Office 2010
    Mike Pearson Education

$272.60 | Add to Cart

Package ISBN-13: 9780133017724

Includes this title packaged with:

  • GO! with Windows 7 Getting Started with Student CD
    Shelley Gaskin, Robert Ferrett
  • myitlab -- Access Card -- for GO! Office 2010 Vol. 1
    Mike Pearson Education
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$203.53 | Add to Cart

Package ISBN-13: 9780133747287

Includes this title packaged with:

  • myitlab with Pearson eText -- Access Code -- for GO! Office 2010
    . Pearson Education
  • GO WITH MICROSF PPT 2010 BRF & STDNT VIDEOS
    Shelley Gaskin, Alicia Vargas
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$272.60 | Add to Cart

Package ISBN-13: 9780132823739

Includes this title packaged with:

  • Technology In Action, Introductory, 8th Edition
    Alan Evans, Kendall Martin, Mary Anne Poatsy
  • GO WITH MICROSF OFC WORD BRF & STDNT VIDEOS
    Shelley Gaskin, Robert Ferrett
  • myitlab -- Access Card -- for Office 2010
    -- Prentice Hall

$234.73 | Add to Cart

Package ISBN-13: 9780132878111

Includes this title packaged with:

  • GO WITH MICROSF PPT 2010 BRF & STDNT VIDEOS
    Shelley Gaskin, Alicia Vargas
  • myitlab -- Access Card -- for GO! Office 2010 Vol. 1
    Mike Pearson Education
  • GO WITH MICROSF OFC WORD BRF & STDNT VIDEOS
    Shelley Gaskin, Robert Ferrett
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$358.93 | Add to Cart

Package ISBN-13: 9780132823722

Includes this title packaged with:

  • Technology In Action, Introductory, 8th Edition
    Alan Evans, Kendall Martin, Mary Anne Poatsy
  • Microsoft Office 180-day trial Spring 2011 (Component), 2nd Edition
    Corporation Microsoft
  • GO WITH MICROSF OFC WORD BRF & STDNT VIDEOS
    Shelley Gaskin, Robert Ferrett
  • myitlab -- Access Card -- for Office 2010
    -- Prentice Hall

$248.33 | Add to Cart

Package ISBN-13: 9780132886536

Includes this title packaged with:

  • Digital Planet: Tomorrow's Technology and You, Complete, 10th Edition
    George Beekman, Ben Beekman
  • GO WITH MICROSF PPT 2010 BRF & STDNT VIDEOS
    Shelley Gaskin, Alicia Vargas
  • GO WITH MICROSF OFC WORD BRF & STDNT VIDEOS
    Shelley Gaskin, Robert Ferrett
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$412.60 | Add to Cart

Package ISBN-13: 9780132823654

Includes this title packaged with:

  • GO WITH MICROSF PPT 2010 BRF & STDNT VIDEOS
    Shelley Gaskin, Alicia Vargas
  • Microsoft Office 180-day trial Spring 2011 (Component), 2nd Edition
    Corporation Microsoft
  • myitlab -- Access Card -- for GO! Office 2010 Vol. 1
    Mike Pearson Education
  • GO WITH MICROSF OFC WORD BRF & STDNT VIDEOS
    Shelley Gaskin, Robert Ferrett
  • GO WITH MICROSF ACCESS 2010 BRF& STDNT VIDS
    Shelley Gaskin, Carolyn McLellan

$375.27 | Add to Cart

Purchase Info

ISBN-10: 0-13-274377-9

ISBN-13: 978-0-13-274377-8

Format: ValuePack

$61.40 | Free Ground Shipping.

Add to Cart