IMPORTANT COVID-19 UPDATES

9780760070864

New Perspectives on Microsoft Excel 200

by
  • ISBN13:

    9780760070864

  • ISBN10:

    0760070865

  • Format: Paperback
  • Copyright: 1999-08-13
  • Publisher: Cengage Learning
  • View Upgraded Edition

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $101.95 Save up to $25.49
  • Buy Used
    $76.46
    Add to Cart Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach for learning the basic to intermediate features of Microsoft Excel 2000.

Table of Contents

Preface iii
Microsoft Excel 2000---Level I Tutorials 1.01(1)
Read This Before You Begin
1.02(1)
Using Worksheets to Make Business Decisions
1.03(1)
Evaluating Sites for an Inwood Design Group Golf Course
Session 1.1
1.04(1)
What is Excel?
1.04(1)
Starting Excel
1.04(1)
The Excel Window
1.06(1)
Toolbars
1.06(1)
Formula Bar
1.06(1)
Workbook Window
1.07(1)
Pointer
1.07(1)
Sheet Tabs
1.07(1)
Moving Around a Worksheet
1.07(1)
Using the Mouse
1.07(1)
Using the Keyboard
1.07(1)
Navigating in a Workbook
1.10(1)
Opening a Workbook
1.10(1)
Layout of the Inwood Workbook
1.12(1)
Quick Check
1.14(1)
Session 1.2
1.14(1)
Text, Values, Formulas, and Functions
1.14(1)
Text
1.14(1)
Values
1.15(1)
Formulas
1.16(1)
Functions
1.18(1)
Saving the Workbook
1.21(1)
What-if Analysis
1.23(1)
Correcting Mistakes
1.25(1)
Getting Help
1.26(1)
Clearing Cell Contents
1.29(1)
Printing the Worksheet
1.31(1)
Closing the Workbook
1.33(1)
Exiting Excel
1.34(1)
Quick Check
1.34(1)
Review Assignments
1.35(1)
Case Problems
1.35(1)
Lab Assignments
1.38(1)
Internet Assignments
1.40(1)
Quick Check Answers
1.40(1)
Creating a Worksheet
2.01(1)
Producing a Sales Comparison Report for MSI
Session 2.1
2.01(1)
Developing Worksheets
2.02(1)
Planning the Worksheet
2.02(1)
Building the Worksheet
2.03(1)
Entering Labels
2.03(1)
Entering Data
2.05(1)
Using the AutoSum Button
2.06(1)
Entering Formulas
2.07(1)
Copying a Formula Using the Fill Handle
2.08(1)
Copying a Formula Using Relative References
2.10(1)
Copying a Formula Using an Absolute Reference
2.13(1)
Absolute Versus Relative References
2.12(1)
Copying Cell Contents Using the Copy-and-Paste Method
2.13(1)
Renaming the Worksheet
2.14(1)
Saving the New Workbook
2.14(1)
Quick Check
2.15(1)
Session 2.2
2.15(1)
Excel Functions
2.15(1)
Average Function
2.16(1)
Max Function
2.19(1)
Min Function
2.19(1)
Building Formulas by Pointing
2.19(1)
Testing the Worksheet
2.20(1)
Spell Checking the Worksheet
2.20(1)
Improving the Worksheet Layout
2.21(1)
Changing Column Width
2.21(1)
Inserting a Raw into a Worksheet
2.22(1)
Using the Undo Button
2.24(1)
Moving a Range Using the Mouse
2.25(1)
Using AutoFormat
2.26(1)
Previewing the Worksheet Using Print Preview
2.28(1)
Centering the Printout
2.29(1)
Adding Headers and Footers
2.30(1)
Setting the Print Area
2.33(1)
Documenting the Workbook
2.33(1)
Adding Cell Comments
2.34(1)
Displaying and Printing Worksheet Formulas
2.35(1)
Quick Check
2.37(1)
Review Assignments
2.37(1)
Case Problems
2.39(1)
Internet Assignments
2.43(1)
Quick Check Answers
2.44(1)
Developing a Professional-Looking Worksheet
3.01(1)
Producing a Projected Sales Report for the Pronto Salsa Company
Session 3.1
3.02(1)
Opening the Workbook
3.02(1)
Formatting Worksheet Data
3.04(1)
Changing the Appearance of Numbers
3.05(1)
Currency and Accounting Formats
3.05(1)
The Format Pointer Button
3.08(1)
Number Symbol (###) Replacement
3.08(1)
Number Formats
3.09(1)
Percentage Format
3.10(1)
Aligning Cell Contents
3.11(1)
Wrapping Text in a Cell
3.11(1)
Centering Text Across Cells
3.12(1)
Indenting Text Within a Cell
3.13(1)
Changing the Font, Font Style, and Font Size
3.14(1)
Using Styles
3.17(1)
Clearing Formats from Cells
3.17(1)
Deleting Cells from a Worksheet
3.18(1)
Quick Check
3.19(1)
Session 3.2
3.19(1)
Adding and Removing Borders
3.19(1)
Using Color for Emphasis
3.22(1)
Using the Drawing Toolbar for Emphasis
3.24(1)
Activating the Drawing Toolbar
3.24(1)
Adding a Text Box
3.25(1)
Adding an Arrow
3.28(1)
Controlling the Display of Gridlines
3.30(1)
Printing the Worksheet
3.31(1)
Portrait and Landscape Orientations
3.32(1)
Hiding and Unhiding Rows and Columns
3.34(1)
Quick Check
3.36(1)
Review Assignments
3.36(1)
Case Problems
3.37(1)
Internet Assignments
3.41(1)
Quick Check Answers
3.42(1)
Creating Chars 4.01(1)
Charting Sales Information for Cast Iron Concepts
Session 4.1
4.02(1)
Excel Charts
4.02(1)
Placement of Charts
4.04(1)
Planning a Chart
4.05(1)
Creating a Column Chart
4.06(1)
Moving and Resizing a Chart
4.11(1)
Updating a Chart
4.13(1)
Modifying an Excel Chart
4.14(1)
Revising the Chart Data Series
4.14(1)
Editing Chart Text
4.16(1)
Adding Data Labels
4.17(1)
Enhancing the Appearance of the Chart
4.19(1)
Emphasizing the Title with Border and Color
4.19(1)
Changing Colors and Patterns
4.20(1)
Previewing and Printing the Chart
4.23(1)
Quick Check
4.24(1)
Session 4.2
4.24(1)
Creating a Chart in a Chart Sheet
4.24(1)
Creating a Pie Chart
4.24(1)
Selecting Nonadjacent Ranges
4.25(1)
Changing the Chart Type from Two-Dimensional to Three-Dimensional
4.27(1)
Exploding a Slice of a Pie Chart
4.29(1)
Rotating a Three-Dimensional Chart
4.30(1)
Formatting Chart Labels
4.31(1)
Applying a Texture Fill Effect to the Chart Background
4.32(1)
Printing the Chart from the Chart Sheet
4.33(1)
Creating a Bar Chart
4.34(1)
Using Pictures in a Bar Chart
4.36(1)
Stretching and Stacking Pictures
4.37(1)
Quick Check
4.38(1)
Review Assignments
4.39(1)
Case Problems
4.39(1)
Internet Assignments
4.42(1)
Quick Check Answers
4.42(1)
Microsoft Excel 2000---Level II Tutorials 5.01(1)
Read This Before You Begin
5.02(1)
Working with Excel Lists 5.03(1)
Managing Faculty Data at North State University
Session 5.1
5.04(1)
Introduction to Lists
5.04(1)
Planning and Creating a List
5.05(1)
Freezing Rows and Columns
5.06(1)
Changing the Zoom Setting of a Worksheet
5.08(1)
Using Find and Replace
5.09(1)
Sorting Data
5.10(1)
Sorting a List Using One Sort Field
5.10(1)
Sorting a List Using More than One Sort Field
5.11(1)
Maintaining a List Using a Data Form
5.13(1)
Using the Data Form to Search for Records
5.15(1)
Using the Data Form to Delete a Record
5.16(1)
Quick Check
5.18(1)
Session 5.2
5.19(1)
Filtering a List Using AutoFilters
5.19(1)
Using Custom AutoFilters to Specify More Complex Criteria
5.22(1)
Using Conditional Formatting
5.24(1)
Using Worksheet Labels in Formulas
5.26(1)
Inserting Subtotals into a List
5.28(1)
Using the Subtotals Outline View
5.30(1)
Printing the List Using Page Breaks
5.31(1)
Printing Row and Column Titles on Every Page
5.32(1)
Removing Page Breaks
5.33(1)
Quick Check
5.33(1)
Session 5.3
5.34(1)
Creating and Using Pivot Tables to Summarize a List
5.34(1)
Creating a Pivot Table
5.35(1)
Laying Out the Pivot Table Directly on the Worksheet
5.38(1)
Changing the Layout of a Pivot Table
5.41(1)
Formatting Numbers in the Pivot Table
5.41(1)
Repositioning a Field in the Pivot Table
5.42(1)
Sorting Items Within the Pivot Table
5.43(1)
Adding a Field to a Pivot Table
5.44(1)
Removing a Field from the Pivot Table
5.45(1)
Hiding Field Items on a Pivot Table
5.46(1)
Refreshing a Pivot Table
5.47(1)
Making a Chart from a Pivot Table
5.48(1)
Quick Check
5.50(1)
Review Assignments
5.50(1)
Case Problems
5.51(1)
Quick Check Answers
5.55(1)
Integrating Excel with Other Windows Programs and the World Wide Web
6.01(1)
Creating Integrated Documents for Basket Weavers
Session 6.1
6.02(1)
Methods of Integration
6.02(1)
Pasting Data
6.02(1)
Object Linking and Embedding
6.03(1)
Planning the Integration
6.04(1)
Creating the New Products Flyer
6.05(1)
Inserting WordArt into on Excel Worksheet
6.07(1)
Mail a Workbook as an Attachment
6.11(1)
Linking an Excel Worksheet to a Word Document
6.11(1)
Updating Linked Objects
6.15(1)
Embedding on Excel Chart in a Word Document
6.16(1)
Modifying an Embedded Object
6.19(1)
Quick Check
6.21(1)
Session 6.2
6.22(1)
Customizing a Form Letter Using an Excel List
6.22(1)
Planning the Form Letter
6.22(1)
Specifying a Main Document and a Data Source
6.23(1)
Inserting the Merge Fields
6.25(1)
Performing the Mail Merge
6.28(1)
Viewing Merged Documents
6.30(1)
Previewing and Printing a Merged Document
6.31(1)
Quick Check
6.33(1)
Session 6.3
6.33(1)
Creating Hyperlinks to Connect Files
6.33(1)
Inserting a Hyperlink
6.34(1)
Testing Hyperlinks
6.36(1)
Navigating Between the Hyperlink Documents
6.36(1)
Publishing Excel Data on a Web Page
6.37(1)
Saving Excel Data as a Web Page
6.37(1)
Quick Check
6.41(1)
Review Assignments
6.41(1)
Case Problems
6.43(1)
Quick Check Answers
6.46(1)
Developing an Excel Application
7.01(1)
Employee 401 (k) Planning at CableScan
Session 7.1
7.02(1)
Planning the 401 (k) Workbook Application
7.02(1)
Arranging a Worksheet in Sections
7.04(1)
Entering Initial Values
7.04(1)
Validating Data Entry
7.05(1)
Specifying Data Type and Acceptable Values
7.06(1)
Specifying an Input Message
7.07(1)
Specifying an Error Alert Style and Message
7.07(1)
Using Range Names
7.10(1)
Defining a Range Name
7.10(1)
Using the Name Box to Define a Range Name
7.11(1)
Using a Range Name in a Formula
7.12(1)
Building a Conditional Formula Using the IF Function
7.13(1)
Quick Check
7.17(1)
Session 7.2
7.17(1)
Computing the Retirement Fund
7.17(1)
Creating a Series Using AutoFill
7.17(1)
Inserting the FV Function
7.19(1)
Protecting Cells in a Worksheet
7.24(1)
Unlocking Individual Cells
7.25(1)
Protecting the Worksheet
7.27(1)
Testing Cell Protection
7.28(1)
Deleting Unnecessary Worksheets
7.29(1)
Quick Check
7.29(1)
Session 7.3
7.29(1)
Automating Tasks Using Macros
7.29(1)
Creating Macros
7.30(1)
Planning Macros
7.30(1)
Recording the ClearInputs Macro
7.31(1)
Running the ClearInputs Macro from the Tools Menu
7.34(1)
Creating a Macro Shortcut Key
7.36(1)
Viewing the ClearInputs Macro Code
7.37(1)
Visual Basic for Applications Code
7.38(1)
Recording the Print401k Macro
7.39(1)
Assigning the Print401k Macro to a Button on the Worksheet
7.42(1)
Quick Check
7.45(1)
Review Assignments
7.45(1)
Case Problems
7.47(1)
Quick Check Answers
7.55(1)
Working with Multiple Worksheets and Workbooks
8.01(1)
Creating Grading Sheets at MidWest University
Session 8.1
8.02(1)
Why Use Multiple Worksheets?
8.02(1)
Planning a Multiple-Sheet Workbook
8.02(1)
Inserting a Worksheet
8.03(1)
Moving Worksheets
8.06(1)
Working with Worksheet Groups
8.07(1)
Copying Information Across Worksheets
8.08(1)
Entering Text and Formulas into a Worksheet Group
8.10(1)
Formatting a Worksheet Group
8.14(1)
Creating a Summary Worksheet
8.15(1)
Consolidating Data with 3-D References
8.16(1)
Printing Worksheet Groups
8.22(1)
Quick Check
8.24(1)
Session 8.2
8.24(1)
Using Templates
8.24(1)
Opening a Workbook Based on a Template
8.25(1)
Creating and Storing a Workbook Template
8.27(1)
Using the Templates Folder
8.28(1)
Quick Check
8.31(1)
Session 8.3
8.32(1)
Summarizing Data from Several Workbooks
8.32(1)
Creating 3-D Cell References to Other Workbooks
8.32(1)
Working with Linked Workbooks
8.37(1)
Using Lookup Tables
8.40(1)
Using Lookup Functions
8.43(1)
Creating an Excel Workspace
8.46(1)
Quick Check
8.48(1)
Review Assignments
8.48(1)
Case Problems
8.49(1)
Quick Check Answers
8.53(1)
APPENDIX 1 Excel Functions A1.01
Session A1.1
A1.01
Financial Functions
A1.01
Introduction to Financial Functions
A1.01
Calculating a Loan Payment Using the PMT Function
A1.02
Developing the Loan Amortization Schedule
A1.03
Calculating the Principal Paid in Each Period Using the PPMT Function
A1.04
Calculating the Interest Paid in Each Period Using the IPMT Function
A1.05
Completing the Amortization Schedule
A1.06
Session A1.2
A1.07
AND, OR, NOT, and Nesting IF Functions
A1.07
Introduction to Logical Functions
A1.08
Using the AND Function to Compute the 401(k) Costs
A1.09
Nesting IF Functions to Compute Health Insurance Costs
A1.11
Session A1.3
A1.13
Date and Time Functions
A1.13
Introduction to Date and Time Values
A1.13
Using the YEAR Function to Calculate Years Employed
A1.14
Text and Statistical Functions
A1.14
Review Assignments
A1.15
Case Problems
A1.17
Index 1(7)
Task Reference 8(7)
MOUS Certification Grid 15(6)
File Finder 21

Rewards Program

Write a Review