Microsoft Excel 2002 : Complete Concepts and Techniques

Microsoft Excel 2002 : Complete Concepts and Techniques

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版
  • 言語 ENG,ENG
  • 商品コード 9780789562784
  • DDC分類 005

Full Description


Part of the highly successful Shelly Cashman Series, Microsoft Excel 2002 Complete Concepts and Techniques provides step-by-step instructions accompanied by full-color screen shots, helping students learn basic through advanced Excel 2002 skills quickly and easily.

Table of Contents

  Creating A Worksheet and Embedded Chart
Objectives 3 (3)
What is Microsoft Excel? 6 (1)
Project One - Dynamite Music Fourth Quarter 6 (1)
Sales
Starting and Customizing Excel 7 (3)
The Excel Worksheet 10(2)
The Worksheet 11(1)
Worksheet Window 12(4)
Menu Bar 12(1)
Standard Toolbar and Formatting Toolbar 13(2)
Formula Bar 15(1)
Status Bar 15(1)
Speech Recognition and Speech Playback 16(1)
Selecting a Cell 16(1)
Entering Text 16(5)
Entering the Worksheet Titles 17(2)
Correcting a Mistake While Typing 19(1)
AutoCorrect 19(1)
Entering Column Titles 19(1)
Entering Row Titles 20(1)
Entering Numbers 21(2)
Calculating a Sum 23(1)
Using the Fill Handle to Copy a Cell to 24(4)
Adjacent Cells
Determining Row Totals 26(2)
Formatting the Worksheet 28(7)
Fonts, Font Color, Font Size, and Font 29(1)
Style
Bolding a Cell 29(1)
Increasing the Font Size 29(1)
Changing the Font Color of a Cell 30(1)
Centering the Worksheet Title across 31(1)
Columns
Formatting the Worksheet Subtitle 32(1)
Using AutoFormat to Format the Body of a 33(2)
Worksheet
Using the Name Box to Select a Cell 35(2)
Adding a 3-D Column Chart to the Worksheet 37(3)
Saving a Workbook 40(4)
Printing a Worksheet 44(1)
Quitting Excel 45(1)
Starting Excel and Opening a Workbook 46(1)
AutoCalculate 47(2)
Correcting Errors 49(3)
Correcting Errors While You Are Typing 49(1)
Data into a Cell
In-Cell Editing 49(1)
Undoing the Last Entry 50(1)
Clearing a Cell or Range of Cells 51(1)
Clearing the Entire Worksheet 51(1)
Excel Help System 52(3)
Obtaining Help Using the Ask a Question 52(2)
Box on the Menu Bar
Quitting Excel 54(1)
Project Summary 55(1)
What You Should Know 55(1)
Learn It Online 56(1)
Apply Your Knowledge 57(1)
In the Lab 58(5)
Cases and Places 63
Formulas, Functions, Formatting, and Web
Queries
Objectives 1 (3)
Introduction 4 (1)
Project Two - Greenback Stock Club 4 (3)
Starting and Customizing Excel 6 (1)
Entering the Titles and Numbers into the 7 (2)
Worksheet
Entering Formulas 9 (7)
Order of Operations 10(1)
Entering Formulas Using Point Mode 11(2)
Copying the Formulas Using the Fill Handle 13(2)
Smart Tags 15(1)
Determining the Totals Using the AutoSum 15(1)
Button
Determining the Total Percent Gain/Loss 16(1)
Using the AVERAGE, MAX, and MIN Functions 16(9)
Determining the Average of a Range of 17(1)
Numbers
Determining the Highest Number in a Range 18(2)
of Numbers
Determining the Lowest Number in a Range 20(3)
of Numbers
Copying the AVERAGE, MAX, and MIN 23(1)
Functions
Saving the Workbook 24(1)
Verifying Formulas Using Range Finder 25(1)
Formatting the Worksheet 26(22)
Changing the Font and Centering the 27(3)
Worksheet Title
Changing the Worksheet Title Background 30(1)
and Font Colors and Applying an Outline
Border
Applying Formats to the Column Titles 31(1)
Centering the Stock Symbols and 32(1)
Formatting the Dates and Numbers in the
Worksheet
Formatting Numbers Using the Formatting 33(3)
Toolbar
Underlining the Row above the Title Row 36(1)
and Bolding the Total Row Titles
Formatting Numbers Using the Format Cells 36(3)
Command on the Shortcut Menu
Formatting Numbers Using the Percent 39(1)
Style Button and Increase Decimal Button
Conditional Formatting 40(3)
Changing the Widths of Columns and 43(1)
Heights of Rows
Changing the Widths of Columns 43(3)
Changing the Heights of Rows 46(2)
Checking Spelling 48(2)
Saving a Workbook a Second Time Using the 50(1)
Same File Name
Previewing and Printing the Worksheet 51(5)
Printing a Section of the Worksheet 54(2)
Displaying and Printing the Formulas 56(2)
Version of the Worksheet
Changing the Print Scaling Option Back to 57(1)
100%
Importing External Data from a Web Source 58(4)
Using a Web Query
Changing the Sheet Names 62(1)
E-Mailing a Workbook from within Excel 63(2)
Quitting Excel and Saving the Workbook 64(1)
Project Summary 65(1)
What You Should Know 65(1)
Learn It Online 66(1)
Apply Your Knowledge 67(2)
In the Lab 69(9)
Cases and Places 78
What-If Analysis, Charting, and Working With
Large Worksheets
Objectives 1 (3)
Introduction 4 (2)
Project Three-Awesome Intranets' Six-Month 6 (2)
Financial Projections
Starting and Customizing Excel 6 (1)
Changing the Font of the Entire Worksheet 7 (1)
to Bold
Entering the Worksheet Titles 7 (1)
Rotating Text and Using the Fill Handle to 8 (3)
Create a Series
Copying a Cell's Format Using the Format 11(2)
Painter Button
Increasing the Column Widths and Entering 12(1)
Row Titles
Copying a Range of Cells to a Nonadjacent 13(3)
Destination Area
Using Drag and Drop to Move or Copy Cells 16(1)
Inserting and Deleting Cells in a Worksheet 16(3)
Inserting Rows 16(2)
Inserting Columns 18(1)
Inserting Individual Cells or a Range of 18(1)
Cells
Deleting Columns and Rows 18(1)
Deleting Individual Cells or a Range of 18(1)
Cells
Entering Numbers with a Format Symbol 19(1)
Saving the Workbook 19(1)
Freezing Worksheet Titles 20(2)
Entering the Projected Revenue 21(1)
Displaying the System Date 22(3)
Absolute Versus Relative Addressing 25(2)
Entering a Formula Containing Absolute 26(1)
Cell References
Making Decisions - The If Function 27(5)
Entering the Remaining Projected Expense 29(1)
and Net Income Formulas for January
Copying the Projected January Expenses 30(1)
and Net Income Formulas to the Other
Months
Determining the Projected Total Expenses 31(1)
by Category and Total Net Income
Unfreezing Worksheet Titles and Saving 31(1)
the Workbook
Formatting the Worksheet 32(11)
Formatting the Numbers 33(2)
Formatting the Worksheet Titles 35(2)
Displaying the Drawing Toolbar 37(1)
Moving and Docking a Toolbar 38(1)
Adding a Drop Shadow to the Title Area 39(1)
Formatting the Category Row Titles and 40(2)
Net Income Row
Formatting the Assumptions Table 42(1)
Hiding the Drawing Toolbar and Saving the 43(1)
Workbook
Adding a 3-D Pie Chart to the Workbook 43(11)
Drawing a 3-D Pie Chart on a Separate 44(4)
Chart Sheet
Formatting the Chart Title and Data Labels 48(1)
Changing the Colors of the Slices 49(2)
Exploding the 3-D Pie Chart 51(1)
Rotating and Tilting the 3-D Pie Chart 51(2)
Adding Leader Lines to the Data Labels 53(1)
Renaming and Reordering the Sheets and 54(2)
Coloring Their Tabs
Checking Spelling, Saving, Previewing, and 56(2)
Printing the Workbook
Checking Spelling in Multiple Sheets 56(1)
Previewing and Printing the Workbook 56(2)
Changing the View of the Worksheet 58(3)
Shrinking and Magnifying the View of a 58(1)
Worksheet or Chart
Splitting the Window into Panes 59(2)
What-If Analysis 61(4)
Goal Seeking 63(2)
Quitting Excel 65(1)
Project Summary 65(1)
What You Should Know 66(1)
Learn It Online 67(1)
Apply Your Knowledge 68(1)
In the Lab 69(10)
Cases and Places 79
WEB FEATURE Creating Static and Dynamic Web
Pages Using Excel
Introduction 1 (3)
Using Web Page Preview and Saving an Excel 4 (6)
Workbook as a Static Web Page
Web Page Preview 4 (2)
Saving a Workbook as a Static Web Page to 6 (2)
a New Folder
Viewing the Static Web Page Using Your 8 (2)
Browser
Saving an Excel Chart as a Dynamic Web Page 10(5)
Viewing and Manipulating the Dynamic Web 12(1)
Page Using Your Browser
Modifying the Worksheet on a Dynamic Web 13(2)
Page
Web Feature Summary 15(1)
What You Should Know 15(1)
In the Lab 15
Financial Functions, Data Tables,
Amortization Schedules, and Hyperlinks
Objectives 1 (3)
Introduction 4 (2)
Project Four-Pay-Less Financial Services 6 (3)
Loan Analysis
Starting and Customizing Excel 6 (1)
Changing the Font Style of the Entire 7 (1)
Worksheet
Entering the Section Title, Row Titles, 7 (2)
and System Date
Adding Borders to a Range 9 (3)
Formatting Cells Before Entering Values 10(1)
Entering the Loan Data 11(1)
Creating Cell Names Based On Row Titles 12(6)
Determining the Loan Amount 14(1)
Determining the Monthly Payment 15(1)
Determining the Total Interest and Total 16(1)
Cost
Entering New Loan Data 17(1)
Using a Data Table to Analyze Worksheet Data 18(7)
Creating a Percent Series Using the Fill 20(1)
Handle
Entering the Formulas in the Data Table 21(1)
Defining the Data Table 22(2)
Formatting the Data Table 24(1)
Adding a Pointer to the Data Table Using 25(3)
Conditional Formatting
Creating an Amortization Schedule 28(11)
Changing Column Widths and Entering the 29(1)
Titles
Creating a Series of Integers Using the 30(1)
Fill Handle
Entering the Formulas in the Amortization 30(4)
Schedule
Entering the Total Formulas in the 34(2)
Amortization Schedule
Formatting New Loan Data 36(1)
Entering New Loan Data 37(2)
Adding a Hyperlink to the Worksheet 39(5)
Assigning a Hyperlink to an Embedded 40(3)
Graphic
Displaying and Printing a Hyperlinked File 43(1)
Printing Sections of the Worksheet 44(5)
Setting Up to Print 44(1)
Printing a Section of a Worksheet Using 45(2)
the Set Print Area Command
Naming Print Areas 47(2)
Protecting the Worksheet 49(3)
Formula Checking 52(2)
Background Formula Checking 52(1)
Quitting Excel 53(1)
Project Summary 54(1)
What You Should Know 54(1)
Learn It Online 55(1)
Apply Your Knowledge 56(1)
In the Lab 57(6)
Cases and Places 63
Creating, Sorting, and Querying a Worksheet
Database
Objectives 1 (3)
Introduction 4 (1)
Project Five - GPS Golf Cart 4 (3)
Distributorship Database
Starting and Customizing Excel 6 (1)
Creating a Database 7 (6)
Setting Up a Database 7 (2)
Naming a Database 9 (1)
Entering Records into the Database Using 9 (4)
a Data Form
Moving from Field to Field in a Data Form 13(1)
Adding Computational Fields to the Database 13(8)
Adding New Field Names and Determining 13(2)
the % of Quota
Using Excel's VLOOKUP Function to 15(3)
Determine Letter Grades
Redefining the Name Database 18(3)
Guidelines to Follow When Creating a 21(1)
Database
Using a Data Form to View Records and 21(1)
Change Data
Sorting a Database 22(5)
Sorting the Database in Ascending 22(1)
Sequence by Company Name
Sorting a Database in Descending Sequence 23(1)
by Company Name
Returning a Database to Its Original Order 24(1)
Sorting a Database on Multiple Fields 25(2)
Sorting a Database on More than Three 27(1)
Fields
Displaying Automatic Subtotals in a Database 27(5)
Zooming Out on a Worksheet and Hiding and 30(1)
Showing Detail Data in a Subtotaled
Database
Removing Subtotals from the Database 31(1)
Finding Records Using a Data Form 32(3)
Using Wildcard Characters in Comparison 34(1)
Criteria
Using Computed Criteria 35(1)
Filtering a Database Using AutoFilter 35(5)
Removing AutoFilter 37(1)
Entering Custom Criteria with AutoFilter 38(2)
Using a Criteria Range on the Worksheet 40(3)
Creating a Criteria Range on the Worksheet 40(1)
Filtering a Database Using the Advanced 41(2)
Filter Command
Extracting Records 43(2)
Creating an Extract Range and Extracting 43(2)
Records
More about Comparison Criteria 45(2)
A Blank Row in the Criteria Range 46(1)
Using Multiple Comparison Criteria with 46(1)
the Same Field
Comparison Criteria in Different Rows and 46(1)
Under Different Fields
Using Database Functions 47(1)
Printing the Worksheet and Saving the 48(2)
Workbook
Quitting Excel 49(1)
Project Summary 50(1)
What You Should Know 50(1)
Learn It Online 51(1)
Apply Your Knowledge 52(1)
In the Lab 53(9)
Cases and Places 62
Creating Templates and Working with Multiple
Worksheets and Workbooks
Objectives 1 (3)
Introduction 4 (2)
Project Six - Grand Enterprises 6 (1)
Incorporated Statement of Financial
Condition
Starting and Customizing Excel 6 (1)
Creating the Template 7 (4)
Changing the Font to Bold and Changing 7 (1)
the Column Widths of the Template
Entering the Template Title and Row Titles 8 (1)
Entering Dummy Data in the Template 9 (1)
Determining Totals 9 (2)
Saving the Template 11(1)
Formatting the Template 12(10)
Formatting the Template Titles 13(1)
Assigning a Comma Style Format to 14(1)
Nonadjacent Ranges
Creating and Assigning a Customized 15(3)
Format Code
Creating and Applying a Style 18(2)
Applying a Style 20(1)
Spell Checking, Saving, and Printing the 21(1)
Template
Alternative Uses of Templates 22(1)
Creating a Workbook from a Template 23(12)
Adding a Worksheet to a Workbook 24(1)
Copying the Contents of a Worksheet to 25(2)
Other Worksheets in a Workbook
Modifying the Western Division Sheet 27(1)
Modifying the Central Division Sheet 28(1)
Modifying the Eastern Division Sheet 29(1)
Referencing Cells in Other Sheets in a 30(1)
Workbook
Entering a Sheet Reference 31(1)
Modifying the Consolidated Sheet 31(4)
Drawing the 3-D Cylinder Chart 35(4)
Formatting the 3-D Cylinder Chart 38(1)
Adding a Chart Title Using the WordArt Tool 39(7)
Adding a Text Box and Arrow to the Chart 43(3)
Adding Comments to a Workbook 46(2)
Adding a Header, Changing the Margins, and 48(10)
Printing the Workbook
Printing All the Worksheets in the 53(1)
Workbook
Printing Nonadjacent Worksheets in a 53(2)
Workbook
Page Breaks 55(1)
Hiding Page Breaks 56(2)
The Find and Replace Commands 58(4)
The Find Command 58(2)
The Replace Command 60(1)
Closing the Workbook 61(1)
Consolidating Data by Linking Workbooks 62(6)
Searching for and Opening Workbooks 64(1)
Creating a Workspace File 64(2)
Consolidating the Data 66(1)
Updating Links 67(1)
Closing All Workbooks at One Time and 67(1)
Quitting Excel
Project Summary 68(1)
What You Should Know 68(1)
Learn in Online 69(1)
Apply Your Knowledge 70(1)
In the Lab 71(6)
Cases and Places 77
INTEGRATION FEATURE Linking an Excel Worksheet
to a Word Document and Web Discussions
Introduction 1 (2)
Opening a Word Document and an Excel 3 (1)
Workbook
Linking an Excel Worksheet to a Word 4 (3)
Document
Printing and Saving the Word Document with 7 (1)
the Linked Worksheet
Editing the Linked Worksheet 8 (2)
Quitting Word and Excel 9 (1)
Saving the Word Document as a Web Page and 10(4)
Using a Discussion Server
Replying to a Comment on a Discussion 12(2)
Server
Integration Feature Summary 14(1)
What You Should Know 14(1)
In the Lab 15
APPENDIX A Microsoft Excel Help System
Using the Excel Help System 1 (1)
Ask a Question Box 2 (1)
The Office Assistant 3 (3)
Showing and Hiding the Office Assistant 4 (1)
Turning the Office Assistant On and Off 4 (1)
Using the Office Assistant 5 (1)
The Microsoft Excel Help Window 6 (3)
Using the Contents Sheet 6 (1)
Using the Answer Wizard Sheet 7 (1)
Using the Index Sheet 8 (1)
What's This? Command and Question Mark 9 (2)
Button
What's This? Command 9 (1)
Question Mark Button 10(1)
Office on the Web Command 11(1)
Other Help Commands 11(1)
Activate Product Command 11(1)
Lotus 1-2-3 Help Command 11(1)
Detect and Repair Command 11(1)
About Microsoft Excel Command 11(1)
Use Help 12
APPENDIX B Speech and Handwriting Recognition
and Speech Playback
Introduction 1 (1)
The Language Bar 1 (4)
Buttons on the Language Bar 2 (1)
Customizing the Language Bar 2 (3)
Speech Recognition 5 (4)
Getting Started with Speech Recognition 6 (2)
Using Speech Recognition 8 (1)
Handwriting Recognition 9 (3)
Writing Pad 9 (2)
Write Anywhere 11(1)
On-Screen Keyboard 11(1)
Speech Playback 12
Customizing Speech Playback 13
APPENDIX C Publishing Office Web Pages to a Web
Server
Using Web Folders to Publish Office Web 1 (1)
Pages
Using FTP to Publish Office Web Pages 1 (1)
APPENDIX D Resetting the Excel Toolbars and 1 (1)
Menus
APPENDIX E Microsoft Office User Specialist
Certification Program
What is MOUS Certification? 1 (1)
Why Should You Get Certified? 1 (1)
The MOUS Exams 2 (1)
How Can You Prepare for the MOUS Exams? 2 (1)
How to Find an Authorized Testing Center 2 (1)
Shelly Cashman Series MOUS Web Page 2 (1)
Microsoft Excel 2002 User Specialist 3
Certification Core and Expert Maps
Index 1 (1)
Quick Reference Summary 1