Introduction to Excel 2002 / Edition 3by David C. Kuncicky
Pub. Date: 08/09/2002
Publisher: Prentice Hall
Part of EsourcePrentice 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.
- Prentice Hall
- Publication date:
- ESource: The Prentice Hall Engineering Source Series
- Edition description:
- Older Edition
- Product dimensions:
- 7.98(w) x 10.12(h) x 0.38(d)
Table of Contents1. 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.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >