Introduction to Excel 2002

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.

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.