IMPORTANT COVID-19 UPDATES

9780760070871

New Perspectives on Microsoft Excel 2000

by ; ; ;
  • ISBN13:

    9780760070871

  • ISBN10:

    0760070873

  • Format: Paperback
  • Copyright: 1999-08-01
  • Publisher: Course Technology Ptr
  • 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: $66.95 Save up to $16.74
  • Buy Used
    $50.21
    Add to Cart Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

Provides realistic cases and step-by-step guidance and screen shots that are designed to teach you everything you need to know to use Microsoft Excel 2000 software. Softcover.

Table of Contents

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 1(16)
Task Reference 17(10)
MOUS Certification Grid 27(10)
File Finder 37

Rewards Program

Write a Review