This AIChE course presents common problem-solving strategies using spreadsheets. Topics include table-based operations, flowsheeting, introduction to macros and Visual Basic for Applications (VBA), solving algebraic and differential equations, preparing spreadsheets for others to use, applied statistics including regression analysis, and optimization.
This well-proven course has been taught over 100 times. Frequent comments from engineers, after taking the course have been, “I thought I knew how to use spreadsheets before I took this course.” and “Why didn’t I take this course a year ago?”
You will learn:
- How to solve many engineering problems faster and more accurately using spreadsheets
- How to solve algebraic and differential equations and to analyze data using methods of applied statistics
- How to prepare flowsheets and material balances on spreadsheets
- How to optimize flowsheets and equipment design
Please click HERE for the course outline.
Who Should Attend
Engineers involved in process engineering, plant technical support, design and economic evaluation, R&D, or education. Participants should have a rudimentary knowledge of spreadsheets
Course attendees must bring their own computers with Excel installed. The latest version of Excel is preferred.
Excel Programming/Spreadsheet Combo CH203 - This course is a combination of "Spreadsheet Power" (CH201) and "Excel Programming with VBA" (CH200). Take these courses as a combo and save up to $445.00
For venue information, please click HERE.
-
Course Type: Public Course
-
Course Number: CH201
-
Language: English
Search, view abstracts and purchase individual papers from this journal in the ASME Digital Library.
- Find papers from this and other journals
- Sign up for content alerts
- Subscribe to RSS feeds
- View calls for papers
Instructors
David E. Clough, Ph.D., is Professor of Chemical Engineering at the University of Colorado, Boulder. His interests are applied computing in chemical engineering, process control, and applied statistics. Dr. Clough has taught the use of spreadsheets in chemical engineering applications since 1985, and he has won a number of teaching awards.
Miles Julian is retired after 41 years with DuPont and is a consultant in engineering evaluations and methanol technology, both in the United States and in Europe. He has taught AIChE’s course Spreadsheet Power! with David Clough since 1989.