Introduction to Excel 2002

Introduction to Excel 2002

By (author) 

List price: US$26.60

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

For Freshman or Introductory courses in Engineering and Computer Science. ESource-Prentice Hall's Engineering Source-provides a comprehensive, customizable introductory engineering and computing library. Featuring over 25 modules and growing, ESource allows professors to fully customize their textbooks through the ESource website. Professors are not only able to pick and choose complete modules, but also custom-build a freshman engineering text that matches their content needs and course organization exactly! Using the ESource online BookBuild system at www.prenhall.com/esource, they can view and select book chapters, change the sequence, instantly calculate the book's net (bookstore) price, request a free examination copy, and generate an ISBN for placing a bookstore order. They can also add your own course notes, syllabi, reference charts, or other favorite materials, including material from third-party publishers. ESource Access Card: 0-13-090400-7. Include this ISBN when setting up an ESource Bundle.show more

Product details

  • Paperback | 177 pages
  • 202.7 x 257 x 9.7mm | 385.56g
  • Pearson Education Limited
  • Prentice-Hall
  • Harlow, United Kingdom
  • English
  • 0130081752
  • 9780130081759

Table of contents

1. Microsoft Excel Basics. Introduction to Worksheets. How to Use This Book. Typographic Conventions Used in This Book. Understanding the Excel 2002 Screen. Getting Help. Manipulating Windows. Creating and Saving Worksheets and Workbooks. Moving around a Worksheet. Selecting a Region. Cutting, Moving, Copying, and Pasting. Inserting and Deleting Cells. Shortcut Keys. Finding and Correcting Mistakes. Printing. 2. Entering and Formatting Data. Entering Numerical Data. Entering Text Data. Entering Date and Time Data. Using Fill Handles. Formatting Cells. Formatting Columns and Rows. Table AutoFormats. Conditional Formatting. Sorting. Formatting Entire Worksheets. 3. Formulas and Functions. Introduction. Creating and Using Formulas. Formula Syntax. Cell and Range Names. Absolute and Relative References. Error Messages. Debugging Errors Using Cell Selection. Debugging Errors Using Tracing. Using Excel's Built-in Functions. Using Macros to Automate Computations. 4. Working with Charts. Using the Chart Wizard to Create and XY Scatter Chart. Creating a Chart Using Shortcut Keys. Previewing and Printing Charts. Adding and Editing Chart Data. Formatting Charts. Charting Features Useful to Engineers. 5. Performing Data Analysis. Using the Analysis ToolPak. Creating a Histogram. Providing Descriptive Statistics. Computing a Correlation. Performing a Linear Regression. Trend Analysis. Using the Goal Seeker. Using Solver for Optimization Problems. 6. Database Management within Excel. Introduction. Creating Databases. Entering Data. Sorting a Database. Searching and Filtering. 7. Collaborating with Other Engineers. The Collaborative Design Process. Tracking Changes. Adding Comments to a Document. Maintaining Shared Workbooks. Password Protection. Importing and Exporting Data from External File Formats. 8. Excel and the World Wide Web. Engineering and the Internet. Accessing the World Wide Web from within Excel. Web Sites Related to Microsoft Excel. Retrieving Data Using a Web Query. Accessing Excel Files on the Web. Creating Hyperlinks within a Worksheet. Converting a Worksheet to a Web Page.show more

About David Kuncicky

David C. Kuncicky is a native Floridian. He earned his Baccalaureate in psychology, Master's in computer science, and Ph.D. in computer science from Florida State University. He has served as a faculty member in the Department of Electrical Engineering at the FAMU-FSU College of Engineering and the Department of Computer Science at Florida State University. He has taught computer science and computer engineering courses for over 15 years. He has published research in the areas of intelligent hybrid systems and neural networks. He is currently the Director of Engineering at Bioreason, Inc. in Sante Fe, New Mexico.show more