25 Books to Read Before You Die
 
 

Recently Viewed clear list


Original Essays | Yesterday, 11:30am

Julie Schumacher: IMG Dear Professor Fitger



Saint Paul, August 2014 Dear Professor Fitger, I've been asked to say a few words about you for Powells.com. Having dreamed you up with a ball-point... Continue »
  1. $16.07 Sale Hardcover add to wish list

    Dear Committee Members

    Julie Schumacher 9780385538138

spacer
Qualifying orders ship free.
$56.67
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

More copies of this ISBN

Go! with Microsoft Excel 2007, Brief (Go!)

by

Go! with Microsoft Excel 2007, Brief (Go!) Cover

 

Synopses & Reviews

Publisher Comments:

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. 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. GO! with Microsoft Excel 2007, Brief, 1/e  covers the following topics: creating a worksheet and charting data; managing workbooks and analyzing data; using functions and tables. Ideal for students and individuals seeking a project-based introduction to Microsoft Excel 2007.

Synopsis:

Package consists of

0132448165 / 9780132448161 GO! with Microsoft Access 2007, Brief

0132672839 / 9780132672832 Microsoft Office 2007 180-day Trial CD Spring 2011

013509383X / 9780135093832 myitlab — Access Card — for Office 2007

0135129966 / 9780135129968 GO! with Microsoft Word 2007,

0135130034 / 9780135130032 GO! with Microsoft Excel 2007,

0135130417 / 9780135130414 GO! with Microsoft PowerPoint 2007, Brief

Synopsis:

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. GO!’s project-based approach clusters the learning objectives around the projects, rather than around software features. Overall, this approach teaches students to solve real problems as they practice and learn the features.

About the Author

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.

Table of Contents

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

Product Details

ISBN:
9780135130032
Author:
Gaskin, Shelley
Publisher:
Prentice Hall
Author:
Vargas, Alicia
Author:
Ferrett, Robert
Subject:
Business
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Spreadsheets - General
Subject:
Business -- Computer programs.
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Trade paper
Series:
GO! GO! for Office 2010 Go! Series
Publication Date:
April 2007
Binding:
Spiral, comb or coil bound book
Grade Level:
College/higher education:
Language:
English
Illustrations:
Y
Pages:
320
Dimensions:
11 x 9 x 2.1 in 2599 gr

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Go! with Microsoft Excel 2007, Brief (Go!) New Trade Paper
0 stars - 0 reviews
$56.67 In Stock
Product details 320 pages Prentice Hall - English 9780135130032 Reviews:
"Synopsis" by ,

Package consists of

0132448165 / 9780132448161 GO! with Microsoft Access 2007, Brief

0132672839 / 9780132672832 Microsoft Office 2007 180-day Trial CD Spring 2011

013509383X / 9780135093832 myitlab — Access Card — for Office 2007

0135129966 / 9780135129968 GO! with Microsoft Word 2007,

0135130034 / 9780135130032 GO! with Microsoft Excel 2007,

0135130417 / 9780135130414 GO! with Microsoft PowerPoint 2007, Brief

"Synopsis" by ,
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. GO!’s project-based approach clusters the learning objectives around the projects, rather than around software features. Overall, this approach teaches students to solve real problems as they practice and learn the features.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.