Introduction to Excel

by Kuncicky, David C.

• ISBN13: 9780130168818
• ISBN10: 0130168815
• Edition: 2nd
• Format: Paperback
• Copyright: 2000-07-01
• Publisher: Pearson College Div

Summary

For Freshman or Introductory courses in Engineering and Computer Science. ESourcePrentice Hall's Engineering Sourceprovides a complete, flexible introductory engineering and computing program. Featuring over 15 modules and growing, ESource allows professors to fully customize their textbooks through the ESource website. Professors are not only able to pick and choose modules, but also sections of modules, incorporate their own materials, and re-paginate and re-index the complete project. http://emissary.prenhall.com/esource or http://www.prenhall.com/esource

Table of Contents

About ESource	iii
About the Authors	vii
Engineering and Electronic Worksheets	1	(6)
Introduction to Worksheets	1	(1)
Engineering Methods	2	(2)
Problem Definition	2	(1)
Information Gathering	3	(1)
Selection of the Appropriate Theory or Methodology	3	(1)
Collection of Simplifying Assumptions	3	(1)
Solution and Refinement	3	(1)
Testing and Verification	3	(1)
Issues in Engineering and Data Analysis	4	(1)
Group Problem Solving	4	(1)
Document Transfer	4	(1)
Standardized Units	4	(1)
How to Use this Book	4	(3)
Typographic Conventions Used in This Book	5	(2)
Microsoft Excel Basics	7	(24)
Understanding the Excel 97 Screen	7	(5)
Title Bar	7	(1)
Menu Bar	8	(1)
Toolbars	9	(1)
Formula Bar	10	(1)
Workbook Window	11	(1)
Sheet Tabs	11	(1)
Scrollbars	12	(1)
Status Bar	12	(1)
Getting Help	12	(3)
Choosing from the Table of Contents	13	(1)
Searching the Help Index	13	(1)
Searching for Keywords in the Help Text	14	(1)
Using the Office Assistant	15	(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)
Accessing Special Help for Lotus 1-2-3 Users	15	(1)
Manipulating Windows	15	(2)
Minimize Control Button	16	(1)
Full Screen Control Button	16	(1)
Close Control Button	17	(1)
Creating and Saving Worksheets and Workbooks	17	(3)
Introduction to Templates	17	(1)
Creating and Opening Documents	17	(1)
Naming Documents	18	(1)
Opening Workbooks with Macros	18	(1)
Saving Documents	19	(1)
Editing a Worksheet	20	(8)
Moving around a Worksheet	20	(3)
Selecting a Region	23	(1)
Cutting, Moving, Copying, and Pasting	24	(1)
Inserting and Deleting Cells	25	(1)
Shortcut Keys	26	(1)
Undoing Mistakes	27	(1)
Spell Checking	27	(1)
The AutoCorrect Feature	27	(1)
Previewing and Printing a Worksheet	28	(3)
Previewing a Worksheet	28	(1)
Printing a Worksheet	29	(2)
Entering and Formatting Data	31	(18)
Entering Data	31	(4)
Numerical Data	31	(2)
Text Data	33	(1)
Date and Time Data	33	(1)
Fill Handles	34	(1)
Formatting Worksheets	35	(14)
Formatting Cells	35	(1)
Formatting Columns and Rows	35	(1)
Table AutoFormats	36	(1)
Conditional Formatting	37	(1)
Sorting	37	(2)
Formatting Entire Worksheets	39	(10)
Engineering Computation	49	(24)
Introduction	49	(1)
Creating and Using Formulas	49	(11)
Formula Syntax	50	(1)
Selecting Ranges	51	(1)
Cell and Range Names	52	(1)
Absolute and Relative References	53	(4)
Error Messages	57	(1)
Debugging Errors Using Cell Selection	58	(1)
Debugging Errors Using Tracing	59	(1)
Mathematical Functions	60	(1)
Matrix Operations	61	(2)
Using Macros to Automate Computations	63	(10)
Recording a Macro	63	(2)
Executing a Macro	65	(1)
Editing a Macro	65	(8)
Working with Charts	73	(24)
Creating Charts	73	(7)
Using the Chart Wizard to Create an XY Scatter Chart	73	(3)
Creating a Chart Using Shortcut Keys	76	(3)
Previewing and Printing Charts	79	(1)
Adding and Editing Chart Data	80	(4)
Adding Data Points	80	(2)
Multiple Data Series	82	(2)
Formatting Charts	84	(4)
Creating Chart Objects	84	(1)
Formatting Chart Objects	84	(2)
Changing Chart Types	86	(1)
Inserting Text	87	(1)
Charting Features Useful to Engineers	88	(9)
Scaling an Axis	88	(1)
Error Bars	88	(9)
Performing Data Analysis and Optimization	97	(28)
Using the Analysis ToolPak	97	(2)
Descriptive Statistics	99	(3)
Correlation	102	(1)
Linear Regression	102	(2)
Trend Analysis	104	(6)
Trend Analysis with Data Series	104	(1)
Trend Analysis Functions	105	(2)
Trend Analysis for Charts	107	(3)
Pivot Tables for Interactive Analysis	110	(2)
Using the Goal Seeker for What-If Analysis	112	(1)
Using Solver for Optimization Problems	113	(12)
Introduction to Microsoft Excel Solver	113	(1)
Setting Up an Optimization Problem in Excel	114	(1)
Linear Optimization Example	114	(3)
Non-Linear Optimization Example	117	(8)
Database Management within Excel	125	(18)
Introduction	125	(1)
Creating Databases	125	(3)
Database Terminology	125	(1)
Database Creation Tips	126	(1)
Entering Data	126	(2)
Sorting, Searching, and Filtering	128	(15)
Sorting a Database	128	(1)
Searching and Filtering	128	(3)
External Data Retrieval Using Microsoft Query	131	(12)
Collaborating with Other Engineers	143	(18)
The Collaborative Design Process	143	(1)
Microsoft Excel and Collaboration	143	(1)
Tracking Changes	144	(2)
Incorporating or Rejecting Revisions	145	(1)
Adding Comments to a Document	146	(1)
Maintaining Shared Workbooks	147	(3)
Keeping a Change History	147	(1)
Timed Updates	148	(1)
Managing Conflicts	148	(1)
Personal Views	149	(1)
Merging Workbooks	149	(1)
Viewing the History of Changes	149	(1)
Restrictions for Shared Workbooks	149	(1)
Password Protection	150	(2)
Open Protection	150	(1)
Write Protection	151	(1)
Sheet Protection	151	(1)
Workbook Protection	152	(1)
Importing and Exporting Data from External File Formats	152	(3)
Import Using the File Open Option	152	(1)
Importing Text Data Using the Text Import Wizard	153	(2)
Conducting a Team Meeting	155	(6)
Excel and the World Wide Web	161	(12)
Engineering and the Internet	161	(1)
Accessing the World Wide Web from within Excel	162	(2)
Web Sites Related to Microsoft Excel	164	(1)
Retrieving Data from a Web Page	164	(2)
Accessing FTP Sites from within Excel	166	(1)
Creating Hyperlinks within a Worksheet	167	(2)
Converting a Worksheet to a Web Page	169	(4)
Appendix A: Commonly Used Functions	173	(2)
Index	175