Microsoft Excel 2000 Comprehensive Course : Mastering and Using (w/ CD-ROM): Napier, H. Albert; Judd, Philip J.: 9780538426152: Book: : eCampus.com

Napier & Judd

Preface

OFFICE UNIT

(1)

Getting Started with Microsoft Office 2000

(18)

What is Microsoft Office 2000?

(1)

Hardware and Software Requirements

(1)

Identifying Common Office Elements

(3)

Starting Office Applications

(4)

Getting Help in Office Applications

(5)

Closing Office Applications

(4)

Working with Menus and Toolbars

(15)

Working with Personalized Menus and Toolbars

(4)

Viewing, Hiding, Docking, and Floating Toolbars

(2)

Customizing the Menu Bar and Toolbars

(1)

Viewing and Customizing the Office Shortcut Bar

(7)

Working With Others Using Online Collaboration Tools

(15)

Scheduling an Online Meeting

(6)

Participating in Web Discussions

(8)

Introduction to the Internet and the World Wide Web

What is the Internet?

(1)

Connecting to the Internet

(3)

Challenges to Using the Internet

(1)

Using Internet Explorer

(3)

Using Directories and Search Engines

EXCEL UNIT

(1)

Quick Start for Excel

(26)

Exploring the Excel Components

(2)

Locating and Opening an Existing Workbook

(1)

Navigating a Worksheet

(1)

Entering Text, Dates, and Numbers

(2)

Selecting Cells

(2)

Editing Cell Content

(2)

Clearing Contents and Formatting of Cells

(1)

Using Undo and Redo

(1)

Entering Formulas and Functions

(4)

Saving Workbooks

(2)

Closing Workbooks and Exiting Excel

(8)

Formatting Worksheets

(24)

Merging Cells to Create a Worksheet Title

(1)

Working with a Series to Add Labels

(2)

Modifying the Size of Columns and Rows

(1)

Changing Fonts and Font Styles

(2)

Modifying the Alignment of Cell Contents

(1)

Rotating Text and Changing Indents

(1)

Applying Number Formats

(3)

Applying Cell Borders and Shading

(12)

Organizing Worksheets Effectively

(28)

Performing Single and Multi-level Sorts

(1)

Copying and Moving Data Using Drag and Drop

(2)

Renaming a Worksheet

(1)

Inserting, Moving, Copying, and Deleting Worksheets

(2)

Copy and Move Data Using Cut, Copy, and Paste

(3)

Inserting and Deleting Cells, Rows, and Columns

(1)

Using Absolute, Relative, and Mixed References in Formulas

(3)

Creating and Using Named Ranges

(2)

Freezing and Unfreezing Rows and Columns

(1)

Using Grouping and Outlines

(3)

Check Spelling in a Worksheet

(9)

Previewing and Printing Worksheets

(18)

Previewing and Modifying Page Setup Options

(7)

Inserting and Removing Page Breaks

(2)

Printing an Entire Workbook

(8)

Creating Charts

Using Chart Wizard to Create a Chart

(3)

Formatting and Modifying a Chart

102

(3)

Previewing and Printing Charts

105

(1)

Working with Embedded Charts

106

Integrating Excel with Office Applications and the Internet

(1)

Integrating Excel with Word and PowerPoint

(7)

Integrating Excel with Access

(6)

Importing Data from Other Applications

(1)

Sending a Workbook via E-mail

(4)

Integrating Excel with the Internet

Drawing in Excel

(25)

Using Clip Art and AutoShapes

(7)

Adding and Modifying Text and Line Objects

(3)

Adding Shadow and 3-D Effects to Objects

(3)

Modifying Stack Order and Grouping Objects

(2)

Creating WordArt

(9)

Using Worksheet Functions

(44)

Using Worksheet Functions

(1)

Using Paste Function and the Formula Palette

(5)

Creating Natural Language Formulas

(1)

Using Date and Time Functions

(5)

Using Financial Functions

(6)

Using Logical Functions

(6)

Using Statistical Functions

(3)

Using Engineering Functions

(2)

Using Lookup and Reference Functions

(4)

Using Text Functions

(11)

Formatting Worksheets with Styles and Custom Formats

(30)

Creating Custom Number Formats

(8)

Using Conditional Formatting

(5)

Applying AutoFormats

(2)

Defining, Applying, and Removing Styles

(14)

Summarizing Data with Data Maps, PivotTables, and PivotCharts

100

(36)

Using Data Map

101

(8)

Using Data Analysis

109

(4)

Creating PivotTable Reports

113

(6)

Modifying a PivotTable Report

119

(4)

Formatting a PivotTable Report

123

(3)

Creating PivotChart Reports

126

(10)

Linking Multiple Worksheets and Workbooks

136

(26)

Grouping Worksheets to Share Data, Formatting, and Formulas

137

(3)

Linking Worksheets and Using 3-D References

140

(3)

Printing Multiple Worksheets

143

(1)

Working with Multiple Workbooks

144

(3)

Linking Workbooks

147

(3)

Inserting Hyperlinks

150

(12)

Customizing Excel Templates, Toolbars, and Menus

162

Using and Editing Templates to Create a New Workbook

163

(8)

Creating Custom Templates

171

(4)

Viewing, Hiding, and Docking Toolbars

175

(3)

Customizing Toolbars

178

(4)

Creating a Custom Menu

182

Sharing Workbooks with Others

(19)

Protecting Worksheets and Workbooks and Using Passwords

(2)

Sharing a Workbook

(1)

Tracking Changes

(3)

Changing Workbook Properties

(1)

Merging Workbooks

(2)

Creating, Editing, and Removing Comments

(9)

Using Lists in Excel

(30)

Identifying Components of a List

(1)

Using Data Validation

(10)

Using the Data Form

(2)

Applying Data Filters

(16)

Auditing a Worksheet

(16)

Using Range Finder to Check and Review Data

(2)

Identifying Relationships Between Precedent and Dependent Cells

(5)

Tracing Errors

(1)

Identifying Invalid Data

(7)

Automating Excel with Macros

(23)

Recording a Macro

(2)

Running a Macro

(1)

Editing a Macro

(4)

Using Workbooks Containing Macros

(2)

Adding Visual Basic Functions to a Macro

(13)

Using What-If Analysis

Creating Data Tables

(4)

Using Goal Seek and Solver

(7)

Creating Scenarios

101

Appendix

A Working with Windows 98

a. Reviewing the Windows 98 Desktop

b. Accessing Your Computer System Resources

c. Using Menu Commands and Toolbar Buttons

d. Using the Start Menu

e. Reviewing Dialog Box Options

f. Using Windows 98 Shortcuts

g. Understanding the Recycle Bin

h. Shutting Down Windows 98

B Managing Your Folders and Files Using Windows Explorer

a. Opening Windows Explorer

b. Reviewing Windows Explorer Options

c. Creating a New Folder

d. Moving and Copying Folders and Files

e. Renaming Folders and Files

f. Creating Desktop Shortcuts

g. Deleting Folders and Files

C Formatting Tips for Business Documents

a. Formatting Letters

b. Inserting Mailing Notations

c. Formatting Envelopes

d. Formatting Interoffice Memorandums

e. Formatting Formal Outlines

f. Using Proofreader's Marks

g. Using Style Guides


	Buy Textbooks Sell Textbooks College Apparel Shop by School Virtual Bookstores	Order Status Shipping Rates Return Policy Marketplace Info F.A.S.T.	Contact Us Privacy Policy Legal Notices Site Security Employment	Help Desk eCampus Blog Affiliate Program Bulk Orders College Marketing

Need Help? bookstore@ecampus.com Copyright© 1999-2008
.