GO! with Microsoft Excel 2007, Brief
Autor Shelley Gaskin, Alicia Vargasen Limba Engleză Mixed media product – 14 mai 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.
Preț: 450.31 lei
Nou
Puncte Express: 675
Preț estimativ în valută:
86.18€ • 89.74$ • 72.83£
86.18€ • 89.74$ • 72.83£
Carte indisponibilă temporar
Doresc să fiu notificat când acest titlu va fi disponibil:
Se trimite...
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9780135130032
ISBN-10: 0135130034
Pagini: 320
Dimensiuni: 210 x 276 mm
Greutate: 0.68 kg
Ediția:1
Editura: Pearson Education
Colecția Prentice Hall
Locul publicării:Upper Saddle River, United States
ISBN-10: 0135130034
Pagini: 320
Dimensiuni: 210 x 276 mm
Greutate: 0.68 kg
Ediția:1
Editura: Pearson Education
Colecția Prentice Hall
Locul publicării:Upper Saddle River, United States
Cuprins
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
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
Notă biografică
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.
Caracteristici noi
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.
· 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.
· 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!
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
· 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.
· 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.