Always Learning

Excel 2000 Essentials Basic
Marianne Fox
Lawrence C. Metzelaar

ISBN-10: 1580760937
ISBN-13:  9781580760935

Publisher:  Prentice Hall
Copyright:  2000
Format:  Spiral Bound; 240 pp
Published:  11/09/1999
Status: Out of Stock


We're sorry, this product is no longer available.
Please contact your Pearson rep if you are using this product and need instructor resources.


Print this content

In this section:


Description

For courses in Microsoft Office Professional for Windows and Excel for Windows.

Essentials courseware is anchored in the practical and professional needs of all types of students. The series has been completely revamped as the result of extensive usability testing conducted by students with multiple levels of computer knowledge.

The Essentials series is conceived as a “learning system” that combines graphics, instructions, experience, reinforcement, and problem solving. It consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. Explanatory material is interwoven before each lesson and between the steps.

Additional features, tips, pitfalls, and other related information are provided at exactly the right place. They are easily recognizable elements that stand out from the main flow of the tutorial. Icons are designed to match the Microsoft Office theme.

The end-of-chapter exercises have been carefully graded from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod students into extending what they've learned into areas beyond the explicit scope of the lessons proper.


Features

Substantial Focus On Learning and How To Learn.
  • Guided use of onscreen Help within lessons and end-of-project exercises.
    • Helps students “learn to learn” on their own to keep up with the ever-expanding feature set of Microsoft Office. Shows them how to discover the right procedures or answers by exploiting the many resources that are already within the application. Ex.___

Hands-On Exercises: Expanded into Three Levels.
  • Skill Drill exercises—Reinforce project skills. Each skill that is reinforced is the same, or nearly the same, as a skill presented in the project. Detailed instructions are provided in a step-by-step format.
    • Enables students to check their comprehension, evaluate their progress, and practice what they've learned. Ex.___

  • Challenge exercises—Expand upon or are related to skills presented in the lessons. Each exercise provides a brief narrative introduction, followed by instructions in a numbered step format that are not as detailed as those in the Skill Drill section. Some contain references for students to apply tips discussed in Nice to Know, Need to Know, or Help.
    • Helps students learn to think on their own and fosters the “near transfer” of learning. Ex.___

  • Discovery Zone exercises—Require advanced knowledge of topics presented in Essentials lessons, the application of skills from multiple lessons, or self-directed learning of new skills. Some contain references for students to apply tips discussed in Nice to Know, Need to Know, or Help.
    • Emulates real-world experience by encouraging self-directed learning of new skills. Ex.___

Beginning of the Project.
  • Objectives—Specific topics covered in the lessons.
    • Gives students short-term, attainable goals for each project. Ex.___

  • Key Terms—New terminology defined and discussed in the project.
    • Helps students to become familiar with the terminology used. Ex.___

  • Why Would I Do This?—Introductory section telling students why a project is useful to them.
    • Shows students why a project is useful to them and what they can do with the knowledge they obtain. Ex.___

  • Visual Summary—Screen shots and sample documents to illustrate what students will learn in the project.
    • Illustrates the concepts and features students will learn in the project and helps to keep them motivated. Ex.___

Lessons.
  • Lessons—Projects broken down into lessons that correspond with objectives.
    • Gives students the project broken down into lessons that correspond with objectives. Ex.___

  • Step-by-Step Instructions—Instructions, along with explanation, to guide students as they learn new features.
    • Guides students as they learn new features, and lets them “learn-by-doing.” Ex.___

  • If You Have Problems— Trouble-shooting tips that anticipate common pitfalls.
    • Helps students anticipate or solve common problems quickly and effectively. Ex.___

  • Need to Know—Essential notes and information necessary to apply features.
    • Provides students with essential tips for performing the task and using the application more effectively. Ex.___

  • Nice to Know—Additional tips to become more proficient in using the software.
    • Provide students with extra tips, shortcuts, alternative ways to complete a process, and special hints about using the software. Ex.___

Checking Concepts and Terms.
  • True/False Questions —With reference to lesson where topic is covered.
  • Multiple Choice Questions—With reference to lesson where topic is covered.
  • Screen ID—Where students identify elements of the screen and within documents.
  • Discussion Questions—That make students apply critical-thinking skills to further understand concepts and features.
    • Helps students check their comprehension and assess their retention. Ex.___


Table of Contents



Project 1: Getting Started with Excel 2000.

Lesson 1: Exploring the Excel Workspace. Lesson 2: Entering Text and Numbers. Lesson 3: Saving a Workbook. Lesson 4: Getting Help. Lesson 5: Entering a Formula. Lesson 6: Preparing a Worksheet for Printing. Lesson 7: Printing a Worksheet. Lesson 8: Closing a File and Exiting Excel.



Project 2: Modifying a Worksheet.

Lesson 1: Opening an Existing Worksheet. Lesson 2: Selecting Worksheet Items. Lesson 3: Using AutoFill. Lesson 4: Inserting and Deleting Rows and Columns. Lesson 5: Copying and Moving Cell Contents. Lesson 6: Using AutoSum. Lesson 7: Copying a Formula with Relative References.



Project 3: Improving the Appearance of a Worksheet.

Lesson 1: Exploring Formatting Options. Lesson 2: Formatting Numbers. Lesson 3: Aligning Cell Contents. Lesson 4: Changing Font and Font Size. Lesson 5: Applying Bold, Italic and Underline. Lesson 6: Adding Color. Lesson 7: Adding Borders. Lesson 8: Removing Formatting.



Project 4: Entering Formulas in Well-Designed Worksheets.

Lesson 1: Analyzing a Poorly-Designed Worksheet. Lesson 2: Adding User Instructions and Other Documentation. Lesson 3: Working with Operators and Order of Precedence. Lesson 4: Typing and Pointing Formulas. Lesson 5: Comparing Absolute and Relative Cell References. Lesson 6: Creating and Copying Formulas with Relative or Absolute Cell References. Lesson 7: Freezing and Splitting the Worksheet Display. Lesson 8: Displaying Formulas Instead of Formula Results.



Project 5: Working with Functions.

Lesson 1: Getting Help with Functions. Lesson 2: Analyzing Data with AVERAGE, MAX and MIN. Lesson 3: Calculating a Payment with PMT. Lesson 4: Creating a Loan Payment Table. Lesson 5: Using IF to Display Messages. Lesson 6: Using IF to Calculate. Lesson 7: Using NOW to Display the Current Date. Lesson 8: Hiding and Unhiding Rows and Columns.



Project 6: Sorting, Filtering, and Editing Lists.

Lesson 1: Using an Excel List as a Database. Lesson 2: Sorting Records on the Contents of One Field. Lesson 3: Sorting Records on the Contents of Two or More Fields. Lesson 4: Using AutoFilter with One Search Condition. Lesson 5: Using Custom AutoFilter with OR Search Criteria. Lesson 6: Using Custom AutoFilter with AND Search Criteria. Lesson 7: Adding and Deleting Records by Using a Form. Lesson 8: Editing Records by Using a Form.



Project 7: Working with Charts.

Lesson 1: Identifying Common Chart Types and Features. Lesson 2: Using Chart Wizard to Create an Embedded Pie Chart. Lesson 3: Using Chart Wizard to Create an Embedded Column Chart. Lesson 4: Changing the Chart Type. Lesson 5: Charting Non-Adjacent Data Series. Lesson 6: Formatting Charts. Lesson 7: Modifying Chart Formats. Lesson 8: Creating a Combination Chart.



Project 8: Developing a Multiple-Sheet Workbook

Lesson 1: Copying Data from Another Application. Lesson 2: Renaming Worksheets. Lesson 3: Editing Multiple Worksheets Simultaneously. Lesson 4: Subtotaling Data. Lesson 5: Linking Worksheets. Lesson 6: Applying Conditional Formatting. Lesson 7: Using a Worksheet to Solve a Problem. Lesson 8: Saving a Worksheet with Chart as a Web Page.



Task Guide.


Glossary.


Index.



Back to top

Print this content

In this section:


Websites and Online Courses

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
More Info

Back to top

Print this content

In this section:

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
More Info

Back to top


Websites and online courses

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
More Info


For the CIS: Office Applications Discipline

PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0131588346  |  ISBN-13: 9780131588349
More Info

PHIT Tips: File Management
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 2 pp  |  Instock
ISBN-10: 0131588354  |  ISBN-13: 9780131588356
More Info

Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0136128017  |  ISBN-13: 9780136128014
More Info

PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132332221  |  ISBN-13: 9780132332224
More Info

PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132050625  |  ISBN-13: 9780132050623
More Info

PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132332558  |  ISBN-13: 9780132332552
More Info

PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132050617  |  ISBN-13: 9780132050616
More Info

PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card  |  Instock
ISBN-10: 0131588311  |  ISBN-13: 9780131588318
More Info

Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 2 pp  |  Instock
ISBN-10: 0131588400  |  ISBN-13: 9780131588400
More Info

Windows Vista PHIT Tip
Prentice Hall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0136128025  |  ISBN-13: 9780136128021
More Info


Back to top


Websites and Online Courses

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
More Info

Log in to the Instructor Resource Center

Login name: 

  Password: 

Forgot login/password?  |  Need to redeem an access code?

        

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel     I accept, proceed with download

Print this content

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.

Package ISBN-10: 0130744883 | ISBN-13: 9780130744883
©2001 | Out of Stock
Suggested retail price: $107.20  Buy from myPearsonStore

This package contains:

Fox & Metzelaar | ©2000 | Prentice Hall | Spiral Bound; 240 pp
Beekman | ©2001 | Prentice Hall | Paper Package
Beekman | ©2001 | Prentice Hall | Paper
Infosource | ©2001 | Prentice Hall | Paper


Back to top