FREE SHIPPING BOTH WAYS
ON EVERY ORDER!
LIST PRICE:
$26.60

Sorry, this item is currently unavailable.

Introduction to Excel 2002

ISBN: 9780130081759 | 0130081752
Edition: 1st
Format: Paperback
Publisher: PRENTICE HALL
Pub. Date: 1/1/2003

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help
SummaryTable of Contents
Part of Esource?Prentice Hall's Engineering Source, this book provides a flexible introduction to the use of Excel in engineering. Featuring over 25 modules and growing, the ESource series provides a comprehensive resource of essential engineering topics. Covers topics such as formatting data, formulas and functions, data analysis, database management, collaborating, and the World Wide Web. For any Engineer or Computer Scientist interested in a brief introduction to Excel.

For Freshman or Introduct... MORE
Microsoft Excel Basics
1(34)
Introduction to Worksheets
1(1)
How to Use This Book
... MORE2(1)
Typographic Conventions Used in This Book
2(1)
Selection with the Mouse
2(1)
Multiple Selections
3(1)
Multiple Keystrokes
3(1)
Literal Expressions
3(1)
Key Terms
3(1)
Understanding the Excel 2002 Screen
3(9)
Title Bar
4(1)
Menu Bar
5(1)
Toolbars
5(1)
Customizing Toolbars
6(1)
Formula Bar
7(2)
Task Pane
9(1)
Workbook Window
10(1)
Sheet Tabs
10(1)
Scrollbars
11(1)
Status Bar
11(1)
Getting Help
12(3)
Choosing from the Table of Contents
12(1)
Using the Answer Wizard
13(1)
Using the Help Index
13(1)
Using the Question Panel on the Standard Toolbar
14(1)
Using the Office Assistant
14(1)
Using the What's This Feature
15(1)
Learning from the Tip of the Day
15(1)
Accessing Help From the World Wide Web
15(1)
Manipulating Windows
15(2)
Minimize Control Button
16(1)
Restore/Maximize
16(1)
Close Control Button
16(1)
Creating and Saving Worksheets and Workbooks
17(4)
Creating a New Workbook
17(1)
Opening an Existing Workbook
17(1)
Creating New Worksheet
18(1)
Introduction to Templates
18(1)
Opening Workbooks with Macros
18(1)
Saving Documents
18(2)
The AutoRecover Feature
20(1)
Naming Documents
21(1)
Moving Around a Worksheet
21(3)
Movement by Using the Keyboard
22(1)
Movement by Using the Mouse
22(1)
Movement by Using the Go to Dialog Box
22(2)
Selecting a Region
24(1)
Selection by Using Cell References
24(1)
Selection by Using the Mouse
24(1)
Selection by Using the Keyboard
25(1)
Cutting, Moving, Copying, and Pasting
25(3)
Cutting a Region
26(1)
Moving a Region
26(1)
Copying a Region
27(1)
Inserting and Deleting Cells
28(1)
Shortcut Keys
28(1)
Finding and Correcting Mistakes
29(2)
Undoing Mistakes
29(1)
Checking Spelling
29(1)
The AutoCorrect Feature
29(2)
Printing
31(4)
Setting the Print Area
31(1)
Previewing a Worksheet
31(1)
Printing a Worksheet
32(3)
Entering and Formatting Data
35(20)
Entering Numeric Data
35(3)
Entering Text Data
38(1)
Entering Data and Time Data
38(1)
Using Fill Handles
39(2)
Formatting Cells
41(1)
Formatting Columns and Rows
42(1)
Table AutoFormats
43(1)
Conditional Formatting
43(2)
Sorting
45(3)
Formatting Entire Worksheets
48(7)
Formulas and Functions
55(24)
Introduction
55(1)
Creating and Using Formulas
56(1)
Formula Syntax
56(3)
Arithmetic Operators
56(1)
Predefined Functions
57(1)
Cell References
57(2)
Cell and Range Names
59(2)
Absolute and Relative References
61(3)
Error Messages
64(1)
Debugging Errors by Using Cell Selection
64(3)
Formulas
64(1)
Precedents
65(1)
Dependents
65(1)
Column (or Row) Differences
66(1)
Debugging Errors by Using Tracing
67(1)
Using Excel's Built-in Functions
67(4)
Examples of Statistical Functions
67(2)
Example of Matrix Operations
69(2)
Using Macros to Automate Computations
71(8)
Recording a Macro
71(2)
Executing a Macro
73(1)
Editing a Macro
73(6)
Working with Charts
79(24)
Using the Chart Wizard to Create an XY Scatter Chart
79(4)
Creating a Chart by Using Shortcut Keys
83(2)
Previewing and Printing Charts
85(2)
Adding and Editing Chart Data
87(4)
Adding Data Points
87(1)
Multiple Data Series
88(3)
Formatting Charts
91(4)
Creating Chart Objects
91(1)
Formatting Individual Chart Objects
91(3)
Annotating a Chart
94(1)
Changing Chart Types
95(1)
Charting Features Useful to Engineers
95(8)
Scaling an Axis
95(1)
Error Bars
96(7)
Performing Data Analysis
103(27)
Using the Analysis ToolPak
103(1)
Creating a Histogram
104(2)
Providing Descriptive Statistics
106(2)
Computing a Correlation
108(2)
Performing a Linear Regression
110(2)
Trend Analysis
112(7)
Trend Analysis with Data Series
112(2)
Trend-Analysis Functions
114(1)
Trend Analysis for Charts
115(4)
Using the Goal Seeker
119(1)
Using Solver for Optimization Problems
120(10)
Introduction to Microsoft Excel Solver
121(1)
Setting Up an Optimization Problem in Excel
121(1)
Linear Optimization Example
121(4)
Nonlinear Optimization Example
125(5)
Database Management Within Excel
130(12)
Introduction
130(1)
Database Terminology
131(1)
Creating Databases
131(1)
Entering Data
132(1)
Sorting a Database
133(1)
Searching and Filtering
134(8)
Filtering with the Data Entry Form
134(1)
Using the AutoFilter Function
135(1)
Using the Custom AutoFilter
135(2)
Using Wild-Card Characters
137(1)
Using the Advanced Filter Function
137(1)
Logic Within Rows
138(1)
Logic Between Rows
138(4)
Collaborating with Other Engineers
142(22)
The Collaborative Design Process
142(1)
Microsoft Excel and Collaboration
143(1)
Tracking Changes
143(3)
Highlighting Changes
143(1)
Creating an Identity
144(1)
Incorporating or Rejecting Revisions
145(1)
Adding Comments to a Document
146(1)
Maintaining Shared Workbooks
147(3)
Sharing a Workbook
147(1)
Keeping a Change History
147(2)
Timed Updates
149(1)
Managing Conflicts
149(1)
Personal Views
149(1)
Merging Workbooks
149(1)
Viewing the History of Changes
149(1)
Restrictions for Shared Workbooks
150(1)
Password Protection
150(4)
Open Protection
150(1)
Write Protection
151(1)
Sheet Protection
151(3)
Importing and Exporting Data from External File Formats
154(10)
Import Using the File Open Option
154(1)
Importing Text Data by Using the Text Import Wizard
154(10)
Excel and the World Wide Web
164(10)
Engineering and the Internet
164(1)
Accessing the World Wide Web from Within Excel
165(2)
Web Sites Related to Microsoft Excel
167(1)
Retrieving Data by Using a Web Query
167(3)
Accessing Excel Files on the Web
170(1)
Creating Hyperlinks Within a Worksheet
170(2)
Converting a Worksheet to a Web Page
172(2)
Appendix A174(2)
Index176

Related Products


  • Introduction to Excel
    Introduction to Excel
  • Introduction to Excel
    Introduction to Excel
  • Introduction to Excel
    Introduction to Excel
  • Introduction to Excel 2004
    Introduction to Excel 2004
  • Introductory Excel for Engineers and Scientists
    Introductory Excel for Enginee...


Please wait while this item is added to your cart...