Take advantage of a three-day immersion into Spreadsheet Problem Solving and Excel VBA Programming specifically covering chemical engineering applications.
This course is a combination of two popular AIChE courses: CH764: Spreadsheet Problem Solving for Chemical Engineers and CH766: Excel VBA Programming for Chemical Engineers.
Here’s a preview of what you’ll learn:
Spreadsheet Problem Solving for Chemical Engineers (CH764):
- 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.
Excel VBA Programming for Chemical Engineers (CH766):
- How to work back and forth between Excel and VBA
- Recording and editing macros
- Debugging VBA code
- Developing Excel add-ins
- VBA programming fundamentals and techniques
- Excel user interfaces: message and input boxes and user forms
Who Should Attend:
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.
Day One
8:00 – 8:30
Registration
8:30 – 9:45
Spreadsheet Basics
- Spreadsheet manipulations
- Cell addressing and naming
- Engineering formulas
9:45 – 10:15
Morning Break
10:15 – Noon
Table-based Operations
- Lookup functions – discrete tables
- Interpolation – continuous tables
- Quadrature and smoothing
Noon – 1:00
Lunch Break
1:00 – 2:45
Case Studies and Targeting
- Development of the base example
- Targeting, Goal Seek and Solver
- Case Studies, Data Tables
2:45 – 3:15
Afternoon Break
3:15 – 5:00
Numerical Methods
- Live solution methods
- Array formulas and functions
- Iterative solver
- Solving differential equations
Day Two
8:30 – 9:45
Working with Data
- Common statistical calculations
- Histograms and control charts
- Experimental design/ANOVA
9:45 – 10:15
Morning Break
10:15 – Noon
Model-fitting
- Linear regression
- Live solution methods
- Nonlinear regression
Noon – 1:00
Lunch Break
1:00 – 2:45
Optimization and Economics
- Design optimization
- Optimal scheduling
- Profitability analysis
2:45 – 3:15
Afternoon Break
3:15 – 5:00
Interfacing with Other Software
- Process simulators
- Math/statistics software
- Data acquisition
Day Three
7:30 – 8:00
Registration
8:00 – 9:45
Getting Started with VBA
- Configuring Excel for VBA programming
- The Visual Basic Editor environment
- Recording and editing macros
- Debugging tools
9:45 – 10:15
Morning Break
10:15 – Noon
User-defined Functions
- Programming user-defined functions (UDFs) for engineering formulas
- Including programming structure in UDFs
- Developing array functions and borrowing Excel functions
- Packaging collections of functions in an Excel Add-in
Noon – 1:00 Lunch Break
1:00 – 2:45
Delving into VBA Programming
- Communicating with Excel – object-oriented concepts
- Data types and scope
- VBA programming structures
- Modular programming organization
2:45 – 3:15
Afternoon Break
3:15 – 5:00
User Interfaces and VBA Applications
- Message boxes, input boxes and user forms
- Programming event handlers
- Integrating course concepts into an Excel/VBA application
- Interfacing with outside programs – process simulator example
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.
Explore More Areas of Advancement
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.