Introduction to Excel 2002 / Edition 3

Introduction to Excel 2002 / Edition 3

by David C. Kuncicky
     
 

ISBN-10: 0130081752

ISBN-13: 9780130081759

Pub. Date: 08/09/2002

Publisher: Prentice Hall

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

Overview

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.

Product Details

ISBN-13:
9780130081759
Publisher:
Prentice Hall
Publication date:
08/09/2002
Series:
ESource: The Prentice Hall Engineering Source Series
Edition description:
Older Edition
Pages:
208
Product dimensions:
7.98(w) x 10.12(h) x 0.38(d)

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 DesignProcess. 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >