Spreadsheets are the chemical engineer’s tool of choice for day-to-day problem-solving; yet most chemical engineers have little formal training in their application to typical scenarios. This two-day course provides a comprehensive, hands-on overview of spreadsheet applications, focused on the needs of chemical engineers. Join expert instructor David Clough, who has taught this course over 100 times, as he provides dozens of useful tips and techniques to fill gaps in your spreadsheet knowledge.
In two days, you will implement typical chemical engineering calculations using Excel, including material and energy balances, fluid flow and heat transfer, separations, chemical reactions and flowsheets. You will learn methods for solving algebraic and differential equations associated with these scenarios. You will analyze data with spreadsheet methods, including statistical methods and model-fitting. Optimization methods for process design, scheduling and economics are also included.
Save $795 or more when you take both this course and CH766: Excel VBA Programming for Chemical Engineers. by registering for CH768 Spreadsheet Problem Solving and VBA Programming Combo Course.
Improve your basic skills with Excel so that your work is more efficient and reliable.
Develop well-organized, well-documented spreadsheets for chemical engineering calculations that can be understood by other engineers (and ... by you a few months down the road).
Use Excel’s built-in functions for calculations and table-based operations.
Set up spreadsheet-based flowsheet calculations, including processes with recycle streams.
Carry out model-fitting calculations using regression techniques, both linear and nonlinear.
Learn targeting and case study techniques.
Set up cash flow tables for venture-guidance profitability analysis.
Chemical engineers with basic knowledge of Excel and common spreadsheet operations. Those involved in process engineering, design and economic evaluation, research and development, and chemical engineering education will find value in this course.
Course Outline
Day One
Basic Spreadsheet Skills
Process Calculations
Day Two
Dealing the Data
Numerical Problem-Solving
10:00 – 11:30 Session 1
Basic Spreadsheet Skills
12:00 – 1:30 Session 2
Basic Spreadsheet Skills
2:30 – 4:00 Session 3
Process Calculations
4:30 – 6:00 Session 4
Process Calculations
10:00 – 11:30 Session 1
Dealing with Data
12:00 – 1:30 Session 2
Dealing with Data
2:30 – 4:00 Session 3
Numerical Problem-Solving
4:30 – 6:00 Session 4
Numerical Problem-Solving
Course Outline
Day One
Basic Spreadsheet Skills
Process Calculations
Day Two
Dealing the Data
Numerical Problem-Solving
A laptop with Excel installed (preferably the latest version) is required for this course.
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.
AIChE Practice+ provides learners with opportunities to work on real-world challenges through industry internships and competitions.
With AIChE Career Discovery®, we'll help you to identify aptitudes and skills you’ll need in order to achieve your full potential at various career stages.
AIChE Credential validates your proficiency with potential employers in areas such as process intensification, safety, sustainability and others.