Synopses & Reviews
Through previous editions, this practical text has found a permanent spot in many introductory engineering courses by successfully combining an introduction to Excel fundamentals with a clear presentation on how Excel can be used to solve common engineering problems. Updated to ensure compatability with all recent versions of Excel, this third edition of
Spreadsheet Tools for Engineers provides beginning engineering students with a strong foundation in problem solving using Excel as the modern day equivalent of the slide rule.
As part of McGraw-Hill's BEST series for freshman engineering curricula, this text is particularly geared toward introductory students. The author provides plenty of background information on technical terms, and numerous examples illustrating both traditional and spreadsheet solutions for a variety of engineering problems. The first three chapters introduce the basics of problem solving and Excel fundamentals. Beyond that, the chapters are largely independent of one another. Topics covered include graphing data, converting units, analyzing data, interpolation and curve fitting, solving equations, evaluating integrals, writing macros, and comparing economic alternatives.
About the Author
Byron S. Gottfried is a Professor of Industrial Engineering and Academic Director of the Freshman Engineering Program at the University of Pittsburgh. He has written eleven college textbooks, including Schaum's Outline of Programming with Basic.
Table of Contents
PART 1 EXCEL FUNDAMENTALS
CHAPTER 1 ENGINEERING ANALYSIS AND SPREADSHEETS
1.1 A SPREADSHEET OVERVIEW
1.2 GENERAL PROBLEM-SOLVING TECHNIQUES
1.3 APPLICABLE ENGINEERING FUNDAMENTALS
1.4 MATHEMATICAL SOLUTION PROCEDURES
CHAPTER 2 CREATING AN EXCEL WORKSHEET
2.1 ENTERING AND LEAVING EXCEL
2.2 GETTING HELP
2.3 MOVING AROUND THE WORKSHEET
2.4 ENTERING DATA
2.5 CORRECTING ERRORS
2.6 USING FORMULAS
2.7 USING FUNCTIONS
CHAPTER 3 EDITING AN EXCEL WORKSHEET
3.1 EDITING THE WORKSHEET
3.2 SAVING AND RETRIEVING THE WORKSHEET
3.3 PRINTING THE WORKSHEET
3.4 DISPLAYING CELL FORMULAS
3.5 CLOSING REMARKS
CHAPTER 4 GRAPHING DATA
4.1 CHARACTERISTICS OF A GOOD GRAPH
4.2 CREATING A GRAPH IN EXCEL
4.3 X-Y GRAPHS (EXCEL XY CHARTS, OR SCATTER CHARTS)
4.4 SEMI-LOG GRAPHS
4.5 LOG-LOG GRAPHS
4.6 LINE GRAPHS (EXCEL LINE CHARTS)
4.7 BAR GRAPHS (EXCEL COLUMN CHARTS)
4.8 PIE CHARTS
4.9 CLOSING REMARKS
CHAPTER 5 ORGANIZING DATA
5.1 CREATING A LIST IN EXCEL
5.2 SORTING DATA IN EXCEL
(and more...)