Introduction to Excel 2002
Published on 10. January 2003
Book
Paperback/Softback
177 pages
978-0-13-008175-9 (ISBN)
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.
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.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Width: 255 mm
Thickness: 10 mm
Weight
386 gr
ISBN-13
978-0-13-008175-9 (9780130081759)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Previous edition
David C. Kuncicky
Introduction to Excel
Book
08/2000
2nd Edition
Pearson
€18.56
Article exhausted; check for reprint
Person
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.
Content
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.
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.