Excel 2000 Essentials Basic / Edition 1

Excel 2000 Essentials Basic / Edition 1

ISBN-10:
1580760937
ISBN-13:
9781580760935
Pub. Date:
11/08/1999
Publisher:
Prentice Hall

Other Format

Current price is , Original price is $26.67. You
Select a Purchase Option (Spiral Bound - BK&CD-ROM)
  • purchase options

Overview

Excel 2000 Essentials Basic / Edition 1

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. For anyone interested in learning Microsoft Office 2000.

Product Details

ISBN-13: 9781580760935
Publisher: Prentice Hall
Publication date: 11/08/1999
Series: Essentials Series for Office 2000
Edition description: BK&CD-ROM
Pages: 240
Product dimensions: 8.63(w) x 10.83(h) x 0.59(d)

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 CellReferences. 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.

Introduction

Essentials courseware from Prentice Hall is anchored in the practical and professional needs of all types of students. This edition of the Office 2000 Essentials has been completely revamped as the result of painstaking usability research by the publisher, authors, editors, and students. Practically every detail-by way of pedagogy, content, presentation, and design was the object of continuous online (and offline) discussion among the entire team.

The Essentials series has been conceived around a "learning-by-doing" approach that encourages you to grasp application-related concepts as you expand your skills through hands-on tutorials. As such, 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. Explicatory 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 where you would most expect them. They are easily recognizable elements that stand out from the main flow of the tutorial. We have even designed our icons to match the Microsoft Office theme. The end-of-chapter exercises have likewise been carefully graded from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod you into extending what you've learned into areas beyond the explicit scope of the lessons proper. Following, you'll find out more about the rationale behind each book element and how to use each to your maximum benefit.

How to Use This Book

Typically, each Essentials book is divided into seven to eight projects, concerning topics such as enteringformulas in a well-designed worksheet, working with functions, and sorting, filtering, and editing lists. A project covers one area (or a few closely related areas) of application functionality. Each project is then divided into seven to nine lessons that are related to that topic. For example, a project on lists is divided into lessons explaining how to sort on the contents of one or more fields, filter based on one condition, filter based on multiple criteria (all met or only one met), and add, edit or delete records using a form. Each lesson presents a specific task or closely related set of tasks in a manageable chunk that is easy to assimilate and retain.

Each element in Excel 2000 Essentials Basic is designed to maximize your learning experience. Following is a list of the Essentials project elements and a description of how each element can help you:

  • Project Objectives. Starting with an objective gives you short-term, attainable goals. Using project objectives that closely match the titles of the step-by-step tutorials breaks down the possibly overwhelming prospect of learning several new features of Excel into small, attainable, bite-sized tasks. Look over the objectives on the opening page of the project before you begin, and review them after completing the project to identify the main goals for each project.

  • Key Terms. This book includes a limited number of useful vocabulary words and definitions, such as chart, filter, function, and sort. Key terms introduced in each project are listed in alphabetical order immediately after the objectives on the opening page of the project. These key terms are shown in bold italic and are defined during their first use within the text. Definitions of key terms are also included in the Glossary.

  • Why Would I Do This? You are studying Excel so you can accomplish useful tasks in the real world. This brief section tells you why these tasks or procedures are important. What can you do with the knowledge? How can these application features be applied to everyday tasks?

  • Visual Summary. This opening section graphically illustrates the concepts and features that you will learn in the project. Several figures, with ample callouts, show the final result of completing the project. This road map to your destination keeps you motivated as you work through the individual steps of each task.

  • Lessons. Each lesson contains one or more tasks that correspond to an objective on the opening page of the project. A lesson consists of step-by-step tutorials, their associated data files, screen shots, and the special notes described as follows. Although each lesson often builds on the previous one, the lessons (and the exercises) have been made as modular as possible. For example, you can skip tasks that you have already mastered, and begin a later lesson using a data file provided specifically for its task(s).

  • Step-by-Step Tutorial. The lessons consist of numbered, bold, step-by-step instructions that show you how to perform the procedures in a clear, concise and direct manner. These hands-on tutorials, which are the "essentials" of each project, let you "learn by doing." Regular paragraphs between the steps clarify the results of each step. Also, screen shots are introduced after key steps for you to check against the results on your monitor. To review the lesson, you can easily scan the bold numbered steps. Quick (or impatient!) learners may likewise ignore the intervening paragraphs.

  • Need to Know. These sidebars provide essential tips for performing the task and using the application more effectively. You can easily recognize them by their distinctive icon and bold headings. It is well worth the effort to review these crucial notes again after completing the project.

  • Nice to Know. Nice to Know comments provide extra tips, shortcuts, alternative ways to complete a process, and special hints about using the software. You may safely ignore these for the moment to focus on the main task at hand, or you may pause to learn and appreciate these tidbits. Here, you find neat tricks and special insights to impress your friends and coworkers!

  • If You Have Problems... These short troubleshooting notes help you anticipate or solve common problems quickly and effectively. Even if you do not encounter the problem at this time, make a mental note of it so that you know where to look when you find yourself (or others) in difficulty.

  • Summary. This section provides a brief recap of the tasks learned in the project. The summary guides you to places where you can expand your knowledge, which may include references to specific Help topics or the Prentice Hall Essentials Web site (http://www.prenhall.com/essentials).

  • Checking Concepts and Terms. This section offers optional True/False, Multiple Choice, Screen ID, and Discussion questions that are designed to check your comprehension and assess retention. If you need to refresh your memory, the relevant lesson number is provided after each True/False and Multiple Choice question. For example, [L5] directs you to review Lesson 5 for the answer. Lesson numbers may be provided-where relevant-for other types of exercises as well.

  • Skill Drill Exercises. This section enables you to check your comprehension, evaluate your progress, and practice what you learn. The exercises in this section build on and reinforce what was learned in each project. Generally, the Skill Drill exercises include step-by-step instructions.

  • Challenge Exercises. This section provides exercises that expand on or relate to the skills practiced in the project. Each exercise provides a brief narrative introduction followed by instructions. Although the instructions are written in a step-by-step format, the steps are not as detailed as those in the Skill Drill section. Providing less specific steps helps you learn to think on your own. These exercises foster the "near transfer" of learning.

  • Discovery Zone Exercises. These exercises require advanced knowledge of project topics or the application of skills from multiple lessons. Additionally, these exercises may require you to research topics in Help or on the Web to complete them. This self-directed method of learning new skills emulates real-world experience. We provide the cues, and you do the exploring!

  • Learning to Learn. Throughout this book, you will find lessons, exercises, and other elements highlighted by this icon. For the most part, they involve using or exploring the built-in Help system or Web-based Help, which is also accessible from the application. However, their significance is much greater. Microsoft Office has become so rich with features that cater to so many diverse needs that it is no longer possible to anticipate and teach you everything that you might need to know. It is becoming increasingly important that, as you learn from this book, you also "learn to learn" on your own. These elements help you identify related-perhaps more specialized-tasks or questions, and show you how to discover the right procedures or answers by exploiting the many resources that are already within the application.

  • Task Guide. The Task Guide that follows the last project lists all the procedures and shortcuts you have learned in this book. It can be used in two complementary ways to enhance your learning experience. You can refer to it, while progressing through the book, to refresh your memory on procedures learned in a previous lesson. Or, you can keep it as a handy real-world reference while using the application for your daily work

  • Glossary. Here, you find the definitions-collected in one place--of all the key terms defined throughout the book and listed in the opening page of each project. Use it to refresh your memory.

Typeface Conventions Used in This Book

We have used the following conventions throughout this book to make it easier for you to understand the material:

  • Key terms appear in italic and bold the first time that they are defined in a project.

  • Text that you type, as well as text that appears on your computer screen as warning confirmation, or general information, appears in a special monospace typeface.

  • Hotkeys, the underlined keys onscreen that activate commands and options, are also underlined in this book Hotkeys offer a quick way to bring up frequently used commands.

How to Use the CD-ROM

The CD-ROM that accompanies this book contains all the data files for you to use as you work through the step-by-step tutorials, Skill Drill, Challenge, and Discovery Zone exercises provided at the end of each project. The CD contains separate parallel folders for each project. The filenames correspond to the filenames called for in this book The files are named in the following manner. The first three characters represent the software and the book level (such as XL1 for the Excel 2000 Essentials Basic). The last four digits indicate the project number and the file number within the project. For example, the first file used in Project I is 0101. Therefore, the complete name for the first file in the Excel 2000 Essentials Basic book is XL1-0101.

Files on a CD-ROM are read-only; they cannot be modified in any way. To use the provided data files while working through this book, you must first transfer the files to a readwrite medium, where you can modify them. Because classroom and lab rules governing the use of storage media vary from school to school, this book assumes the standard procedure of working with the file(s) on a 3.5-inch floppy disk.

A word of caution about using floppy disks: As you use a data file, it increases in size or automatically generates temporary work files. Ensure that your disk remains at least one-third empty to provide the needed extra space. Moreover, using a floppy for your work disk is slower than working from a hard drive. You will also need several floppy disks to hold all the files on the CID.

  • Copying to a 3.5-inch floppy disk. For security or space reasons, many labs do not allow you to transfer files to the hard drive at all. The only way you can transfer Microsoft Excel workbooks to a floppy disk is to copy the files manually.

    First, select the files on the CID that you want to copy, and ensure that their combined size (shown on the status bar of the Explorer window) will fit on a 1.44MB floppy disk. Right-click on the selection with your mouse, choose Send To on the context menu that appears, and then choose 3 1/2 Floppy on the submenu. After copying, select the copied files on the floppy disk and right-click the selection with the mouse again. This time, choose Properties, choose the General tab on the

    Properties dialog box that appears, and then uncheck the read-only attribute at the bottom of this page. Because the original files on the CD-ROM were read-only, the files were copied with this attribute turned on. You can rename files copied in this manner only after you have turned of the read-only attribute.

    Although you can use the same method to copy the entire CID contents to a large capacity drive, it is much simpler to use the installation routine in the CD-ROM for this purpose. This automatically removes the read-only attribute while transferring the files.

  • Installing to a hard drive or Zip drive. The CD-ROM contains an installation routine that automatically copies all the contents to a local or networked hard drive, or to a removable large-capacity drive (for example, an Iomega Zip drive). If you are working in the classroom, your instructor has probably already installed the files to the hard drive and can tell you where the files are located. You will be asked to save or copy the file(s) you need to your personal work area on the hard drive or to a floppy work disk.

    Otherwise, run the installation routine yourself to transfer all the files to the hard drive (for example, if you are working at home) or to your personal Zip drive. You may then work directly and more efficiently from these high-capacity drives.

CD-ROM Installation Routine

If you were instructed to install the files on a lab computer or if you are installing them on your home computer, simply insert the CD-ROM into the CD-ROM drive. When the installation screen appears, follow these steps:

1. From the installation screen, click the Install button.

2. The Welcome dialog box displays. Click the Next-button.

3. The Readme.txt appears. The Readme.txt gives you important information regarding the installation. Make sure that you use the scrollbar to view the entire Readme.txt file. When you finish reading the Readme.txt, click the Next button.

4. The Select Destination Directory displays. Unless you are told otherwise by your instructor, the default location is recommended. Click -Next.

5. The Ready to Install screen appears. Click Next to begin the installation.

A directory is created on your hard drive where the student files will be installed.

6. A dialog box appears, confirming that the installation is complete.

The installation of the student data files allows you to access the data files from the Start menu programs. To access the student data files from the Start menu, click Start, click Programs, and then click the Essentials title you installed from the list of programs. The student data files are in subfolders, arranged by project.

Uninstalling the Student Data Files

After you complete the course, you may decide that you do not need the student data files any more. If that is the case, you have the capability to uninstall them. The following steps walk you through the process:

1. Click on the Start menu, and then click Programs.

2. Click the Essentials title that you installed.

3. Click Uninstall.

4. Click one of the Uninstall methods listed:

  • Automatic-This method deletes all files in the directory and all shortcuts created.

  • Custom-This method enables you to select the files that you want to delete.

5. Click Next.

6. The Perform Uninstall dialog box appears. Click Finish. The Student data files and their folders are deleted.

The Annotated Instructor's Manual

The Annotated Instructor's Manual (AIM) is a printed copy of the student book-complete with marginal annotations and detailed guidelines, including a curriculum guide-that helps the instructor use this book and teach the software more effectively. The AIM also includes a Resource CD-ROM with additional support files for the instructor, suggested solution files that show how the students' files should look at the end of a tutorial; answers to test questions; PowerPoint presentations to augment your instruction; additional test questions and answers; and additional Skill Drill, Challenge, and Discovery Zone exercises. Instructors should contact Prentice Hall for their complimentary AIM. Prentice Hall can be reached via phone at 1-800-333-7945 or via the Internet at http://www.prenhall.com.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews