Spreadsheet Problem-Solving for Chemical Engineers Source: AIChE Course ID: ELS101 Type: eLearning (online) CourseLanguage: English Skill Level: Intermediate Duration: 30 hours CEUs: 3.00 PDHs: 30.00 Share This Post: Many chemical engineers are self-taught in the use of spreadsheets for day-to-day problem-solving, which is testimony to the inherent usefulness of this tool. The goal of this course is to provide you with a more comprehensive background in spreadsheet techniques and improve the quality, reliability and efficiency of your work. Dr. Clough will provide instruction using Microsoft Excel to illustrate a wide range of spreadsheet applications and skills that are relevant to the calculations and problem-solving encountered by practicing chemical engineers. Lectures include frequent live spreadsheet demonstrations. There is ample opportunity for you to practice and perfect the sound techniques and the methods taught. Topics include: Excel basic skills – improving your efficiency Working with tables of data and information Process calculations including flowsheeting and economic analysis Applied statistics including regression analysis Solving equations – algebraic and differential Instructor(s): David E. Clough Dr. David Clough has taught applied statistics at the undergraduate and graduate levels to chemical engineering students for the past 20 years. At the graduate level, his students have included practicing professionals. Dr. Clough recently retired after a 43-year career on the faculty of Chemical and Biological Engineering at the University of Colorado’s Boulder Campus. He is still active in the Department in the Emeritus role, including the supervision of research in applied process control. He teaches several AIChE Academy courses, both in-person and eLearning...Read more Checkout Checkout Do you already own this? Log In for instructions on accessing this content. Pricing Teams (10 or more) Minimize cost and maximize learning with Train-A-Team. Learn more Individuals AIChE Members $1095.00 AIChE Graduate Student Members $547.50 AIChE Undergraduate Student Members $547.50 Non-Members $1395.00 Accrediting Agencies: Florida New Jersey New York RCEP Horizontal TabsOutline Unit One: Excel Setup and Basic Skills Lecture One: Preview of the Course Lecture Two: Entry and Formatting of Data and Information Lecture Three: Selection, Copying and Moving Efficiently Lecture Four: Cell Addressing and Names Lecture Five: Creating Excel Formulas with Built-in Functions Unit One Quiz: 16 Questions Unit Two – Working with Tables of Data Lecture One: Tables and Lists Lecture Two: Lookup Functions Lecture Three: Case Studies with the TABLE Function Lecture Four: Array Formulas and Functions Lecture Five: Pivot Tables and Scenarios Unit Two Quiz: 15 Questions Unit Three – Process Calculations Lecture One: Material Flowsheeting Lecture Two: Closing recycles with the Iterative Solver Lecture Three: Property Estimation and Equations of State Lecture Four: Solving Differential Balances Lecture Five: Cost Estimation and Cash Flow Analysis Unit Three Quiz: 10 Questions Unit Four – Applied Statistics Lecture One: Characterizing Data Sets Lecture Two: Creating Excel Graphs Lecture Three: Regression Analysis Lecture Four: Design of Experiments Lecture Five: Statistical Quality Control Unit Four Quiz: 12 Questions Unit Five – Solving Equations Lecture One: Algebraic Equations and Equation Sets Lecture Two: Differential Equations Lecture Three: Use of Solver and Goal Seek Lecture Four: Unit Operation Modeling Lecture Five: Process Control Calculations Unit Five Quiz: 12 Questions Download Course Outline (PDF) What You'll Learn Learning Outcomes: Develop efficiently well-organized Excel spreadsheets for typical chemical engineering calculations Organize and access tables of data and information using Excel’s built-in features and functions Carry out typical chemical process calculations, including flowsheet material balances with recycle Analyze chemical engineering data using Excel’s statistical tools, including regression analysis Carry out targeting and optimization calculations in Excel using the Solver, Goal Seek, and other methods. Who Should Attend Who Should Attend: Chemical engineers who already have some level of proficiency with Excel and use, or desire to use, spreadsheeting as a common software tool for problem solving and daily work. The course is also ideal for those engineers who believe they are very proficient Excel users, as a common comment on evaluations from those who have attended Dr. Clough’s short courses in the past is “I thought I knew a lot about Excel before I attended this course.” Knowledge of programming in VBA is not required nor expected. FAQs Find answers to questions about registration and refunds, tuition and fees, travel and lodging (for location-based courses), how eLearning courses work, how credits work, and more. Go to FAQs Page
David E. Clough Dr. David Clough has taught applied statistics at the undergraduate and graduate levels to chemical engineering students for the past 20 years. At the graduate level, his students have included practicing professionals. Dr. Clough recently retired after a 43-year career on the faculty of Chemical and Biological Engineering at the University of Colorado’s Boulder Campus. He is still active in the Department in the Emeritus role, including the supervision of research in applied process control. He teaches several AIChE Academy courses, both in-person and eLearning...Read more