New Perspectives on Microsoft... | Buy

Preface

iii

Microsoft Windows 98---Level I Tutorials

1.1

(1)

Read This Before You Begin

1.2

(1)

Exploring the Basics Investigating the Windows 98 Operating System

1.3

(1)

Session 1.1

1.4

(1)

Starting Windows 98

1.4

(1)

The Windows 98 Desktop

1.4

(1)

Using a Pointing Device

1.5

(1)

Pointing

1.6

(1)

Clicking

1.7

(1)

Selecting

1.8

(1)

Right-Clicking

1.9

(1)

Starting and Closing a Program

1.11

(1)

Running Multiple Programs

1.12

(1)

Switching Between Programs

1.13

(1)

Accessing the Desktop from the Quick Launch Toolbar

1.14

(1)

Closing Inactive Programs from the Taskbar

1.14

(1)

Shutting Down Windows 98

1.15

(1)

Quick Check

1.16

(1)

Session 1.2

1.17

(1)

Anatomy of a Window

1.17

(1)

Manipulating a Window

1.18

(1)

Minimizing a Window

1.18

(1)

Redisplaying a Window

1.20

(1)

Maximizing a Window

1.20

(1)

Restoring a Window

1.20

(1)

Moving a Window

1.20

(1)

Changing the Size of a Window

1.21

(1)

Using Program Menus

1.21

(1)

Selecting Commands from a Menu

1.21

(1)

Using Toolbars

1.23

(1)

Using List Boxes and Scroll Bars

1.24

(1)

Using Dialog Box Controls

1.25

(1)

Using Help

1.27

(1)

Viewing Topics from the Contents Tab

1.27

(1)

Selecting a Topic from the Index

1.28

(1)

Returning to a Previous Help Topic

1.30

(1)

Quick Check

1.30

(1)

Tutorial Assignments

1.31

(1)

Projects

1.32

(1)

Lab Assignments

1.33

(1)

Quick Check Answers

1.34

(1)

Working with Files Creating, Saving, and Managing Files

2.1

(1)

Session 2.1

2.2

(1)

Formatting a Disk

2.2

(1)

Working with Text

2.4

(1)

The Insertion Point Versus the Pointer

2.4

(1)

Selecting Text

2.5

(1)

Inserting a Character

2.6

(1)

Saving a File

2.7

(1)

Opening a File

2.8

(1)

Printing a File

2.10

(1)

Quick Check

2.11

(1)

Session 2.2

2.12

(1)

Changing Desktop Style Settings

2.12

(1)

Switching to Web Style

2.12

(1)

Selecting on Icon in Web Style

2.13

(1)

Opening a File in Web Style

2.14

(1)

Creating Your Student Disk

2.15

(1)

My Computer

2.15

(1)

Changing My Computer View Options

2.17

(1)

Controlling the Toolbar Display

2.17

(1)

Web View

2.18

(1)

Changing the Icon Display

2.19

(1)

Hiding File Extensions

2.20

(1)

Folders and Directories

2.20

(1)

Moving and Copying a File

2.21

(1)

Navigating Explorer Windows

2.23

(1)

Deleting a File

2.24

(1)

Renaming a File

2.24

(1)

Copying on Entire Floppy Disk

2.25

(1)

Quick Check

2.26

(1)

Tutorial Assignments

2.26

(1)

Projects

2.28

(1)

Lab Assignments

2.29

(1)

Quick Check Answers

2.30

(1)

Microsoft Excel 2000---Level I Tutorials

1.01

(1)

Read This Before You Begin

1.02

(1)

Using Worksheets to Make Business Decisions Evaluating Sites for an Inwood Design Group Golf Course

1.03

(1)

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)

Session 1.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)

Session 1.2 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 Producing a Sales Comparison Report for MSI

2.01

(1)

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)

Session 2.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 Row 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)

Session 2.2 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 Producing a Projected Sales Report for the Pronto Salsa Company

3.01

(1)

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 Painter 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)

Session 3.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)

Session 3.2 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 Charts Charting Sales Information for Cast Iron Concepts

4.01

(1)

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)

Session 4.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)

Session 4.2 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 Managing Faculty Data at North State University

5.03

(1)

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 From

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)

Session 5.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)

Session 5.2 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)

Session 5.3 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 Creating Integrated Documents for Basket Weavers

6.01

(1)

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 an 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 an Excel Chart in a Word Document

6.16

(1)

Modifying an Embedded Object

6.19

(1)

Session 6.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)

Session 6.2 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)

Session 6.3 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 Employee 401(k) Planning at CableScan

7.01

(1)

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)

Session 7.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)

Session 7.2 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)

Session 7.3 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 Creating Grading Sheets at MidWest University

8.01

(1)

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)

Session 8.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)

Session 8.2 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)

Session 8.3 Quick Check

8.48

(1)

Review Assignments

8.48

(1)

Case Problems

8.49

(1)

Quick Check Answers

8.53

(1)

Microsoft Excel 2000--- Level III Tutorials

9.01

(1)

Read This Before You Begin

9.02

(1)

Data Tables and Scenario Management Perform Cost-Volume-Profit Analysis for Davis Blades

9.03

(1)

Session 9.1

9.04

(1)

Principle of Cost-Volume-Profit Relationship

9.04

(1)

Types of Expenses

9.04

(1)

The Break-Even Point

9.05

(1)

Planning Income and Expenses at Davis Blades

9.07

(1)

One-Variable Data Tables

9.08

(1)

Creating a One-Variable Data Table

9.10

(1)

Charting a One-Variable Data Table

9.14

(1)

Two-Variable Data Tables

9.16

(1)

Creating a Two-Variable Table

9.18

(1)

Charting a Two-Variable Data Table

9.22

(1)

Session 9.1 Quick Check

9.25

(1)

Session 9.2

9.26

(1)

Using Scenario Manager

9.26

(1)

Naming Input and Result Cells

9.27

(1)

Defining Scenarios

9.28

(1)

Viewing Scenarios

9.32

(1)

Editing Scenarios

9.33

(1)

Creating a Scenario Summary Report

9.35

(1)

Using the Report Manager

9.36

(1)

Adding Report Sections

9.37

(1)

Printing a Report

9.38

(1)

Session 9.2 Quick Check

9.39

(1)

Review Assignments

9.39

(1)

Case Problems

9.40

(1)

Quick Check Answers

9.45

(1)

Using Solver for Complex Problems Determining the Most Profitable Product Mix for Appliance Mart Superstore, Inc.

10.01

(1)

Session 10.1

10.02

(1)

Planning the Worksheet

10.02

(1)

Creating the Order Worksheet

10.03

(1)

Finding a Solution

10.07

(1)

Finding Solutions by Trial and Error

10.08

(1)

Finding Solutions with Goal Seek

10.10

(1)

Session 10.1 Quick Check

10.14

(1)

Session 10.2

10.14

(1)

Exploring More Complex Problems

10.14

(1)

Formulating the Problem

10.16

(1)

Solving Complex Problems Using Solver

10.16

(1)

Solving Complex Problems Using Solver

10.18

(1)

Setting Up Solver to Find a Solution

10.18

(1)

Inserting Additional Constraints

10.22

(1)

Inserting an Integer Constraint

10.24

(1)

Creating an Answer Report

10.25

(1)

Session 10.2 Quick Check

10.30

(1)

Review Assignments

10.30

(1)

Case Problems

10.31

(1)

Quick Check Answers

10.34

(1)

Importing Data into Excel Working with a Stock Portfolio for Davis & Larson

11.01

(1)

Session 11.1

11.02

(1)

Planning Data Needs at Davis & Larson

11.02

(1)

Working with Text Files

11.03

(1)

Text File Formats

11.03

(1)

Starting the Text Import Wizard

11.05

(1)

Specifying the Starting Row

11.06

(1)

Editing Column Breaks

11.07

(1)

Formatting and Trimming Incoming Data

11.09

(1)

Databases and Queries

11.12

(1)

Using the Query Wizard

11.15

(1)

Defining a Data Source

11.16

(1)

Choosing Tables and Columns

11.17

(1)

Filtering and Sorting Data

11.21

(1)

Saving Your Queries

11.23

(1)

Session 11.1 Quick Check

11.26

(1)

Session 11.2

11.27

(1)

Working with External Data and Queries

11.27

(1)

Refreshing External Data

11.27

(1)

Setting External Data Properties

11.28

(1)

Editing a Query

11.30

(1)

Creating a Pivot Table and Chart from External Data

11.32

(1)

Session 11.2 Quick Check

11.39

(1)

Session 11.3

11.39

(1)

Web Queries

11.39

(1)

Retrieving Multiple Stock Quotes

11.40

(1)

Refreshing a Web Query

11.42

(1)

Using Hyperlinks

11.43

(1)

Creating a Web Query

11.45

(1)

Session 11.3 Quick Check

11.49

(1)

Review Assignments

11.49

(1)

Case Problems

11.50

(1)

Quick Check Answers

11.53

(1)

Enhancing Excel with Visual Basic Creating a Customized Application for the Imageon Shareholders' Convention

12.01

(1)

Session 12.1

12.02

(1)

Planning Your Macros

12.02

(1)

Creating and Running a Simple Macro

12.05

(1)

Using the Macro Recorder

12.05

(1)

Assigning a Macro to a Button

12.06

(1)

Starting the Visual Basic Editor

12.08

(1)

Elements of the Visual Basic Editor

12.10

(1)

The Project Explorer

12.10

(1)

The Properties Window

12.13

(1)

Modules

12.16

(1)

The Code Window

12.17

(1)

Working with Visual Basic Sub Procedures

12.18

(1)

Introducing Sub Procedures

12.18

(1)

Creating a Sub Procedure Using Copy and Paste

12.19

(1)

Session 12.1 Quick Check

12.25

(1)

Session 12.2

12.25

(1)

Introducing Visual Basic

12.25

(1)

Objects

12.26

(1)

Properties

12.27

(1)

Methods

12.28

(1)

Variables

12.30

(1)

Retrieving Information from the User

12.31

(1)

Entering the InputBox Function

12.33

(1)

Using the Input Box

12.37

(1)

Session 12.2 Quick Check

12.39

(1)

Session 12.3

12.40

(1)

Introducing Control Structures

12.40

(1)

Using the If-Then-Else Control Structure

12.41

(1)

Comparison and Logical Operators

12.43

(1)

Writing on If-Then-Elself Control Structure

12.45

(1)

Creating a Message Box

12.47

(1)

Finishing Your Customized Application

12.51

(1)

Viewing Your Workbook's Properties List

12.51

(1)

Protecting your Workbook and Worksheet

12.52

(1)

Hiding Screen Elements

12.53

(1)

Customizing Excel Menus

12.55

(1)

Removing Menu Items

12.56

(1)

Inserting Menu Commands

12.57

(1)

Resetting Menu Options

12.61

(1)

Session 12.3 Quick Check

12.62

(1)

Review Assignments

12.62

(1)

Case Problems

12.63

(1)

Quick Check Answers

12.67

(1)

Additional Case 1 Sales Invoicing for Island Dreamz Shoppe

AC1.01

Additional Case 2 Performance Reporting for Boston Scientific

AC2.01

Additional Case 3 Negotiating Salaries for the National Basketball Association

AC3.01

Additional Case 4 Managing Tours for Executive Travel Services

AC4.01

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

Appendix 2 Using Data Maps Creating a Data Map for a Presentation

A2.01

Session A2.1

A2.02

Introducing Data Mapping

A2.02

Creating a Data Map

A2.02

Organizing a Worksheet for a Data Map

A2.02

Selecting the Data Map Range and Sizing the Frame

A2.04

Customizing the Data Map

A2.07

Modifying Map Legends

A2.08

Resizing the Data Map

A2.09

Modifying the Value Shading Data Map

A2.09

Changing the Format of a Data Map

A2.11

Session A2.1 Quick Check

A2.14

Session A2.2

A2.15

Overlaying Maps

A2.15

Magnifying an Area of the Data Map

A2.16

Displaying Labels on the Data Map

A2.17

Identifying Special Points Using a Custom Pin Map

A2.18

Removing Map Features

A2.21

Session A2.2 Quick Check

A2.23

Review Assignments

A2.23

Case Problems

A2.24

Quick Check Answers

A2.26

Appendix 3 Auditing, Custom Formatting, and Sharing Workbooks

A3.01

Session A3.1

A3.02

Auditing a Worksheet

A3.02

Dependent and Precedent Cells

A3.03

Tracing Dependent Cells

A3.04

Tracing Precedent Cells

A3.07

Modifying the Worksheet

A3.08

Tracing Errors

A3.09

Using Styles

A3.10

Creating Styles

A3.11

Applying Styles

A3.12

Creating Custom Formats

A3.13

Custom Formatting Data with Color

A3.16

Custom Formatting Dates

A3.16

Applying Custom Formats

A3.18

Inserting a Worksheet Template

A3.19

Editing a Custom Template

A3.20

Session A3.1 Quick Check

A3.21

Session A3.2

A3.21

Sharing Workbooks

A3.21

Setting Up a Shared Workbook

A3.21

Working with a Shared Workbook

A3.23

Monitoring a Shared Workbook

A3.23

Adding Comments to a Shared Workbook

A3.24

Tracking Changes to a Shared Workbook

A3.25

Resolving Conflicts in a Shared Workbook

A3.25

Merging Shared Workbooks

A3.26

Session A3.2 Quick Check

A3.27

Review Assignments

A3.28

Case Problems

A3.28

Quick Check Answers

A3.31

Appendix 4 Saving Pivot Tables in HTML Format Creating Interactive PivotTables for the Web

A4.01

Session A4.1

A4.02

Saving Workbook as Web Pages

A4.02

Web Pages with Spreadsheet Functionality

A4.02

Web Pages with PivotTable Lists

A4.05

Web Pages with Interactive Charts

A4.06

System Requirements for Interactive Web Pages

A4.08

Creating an Interactive PivotTable

A4.08

Working with an Interactive PivotTable

A4.12

Modifying PivotTable Fields

A4.12

Formatting PivotTable Elements

A4.15

Exporting a Pivot Table to Excel

A4.18

Session A4.1 Quick Check

A4.20

Review Assignments

A4.20

Case Problems

A4.21

Quick Check Answers

A4.22

Index

(16)

Task Reference

(10)

MOUS Certification Grid

(10)

File Finder

Rent More, Save More! Use code: ECRENTAL

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

New Perspectives on Microsoft Excel 2000

Summary

Table of Contents

Supplemental Materials

Rewards Program