Spreadsheet Problem-Solving and VBA Programming Combo Course

Source: AIChE

Course ID:

CH768
Type:
Face-to-Face Course
Language:

English
Skill Level:

Intermediate
Duration:

3 days
CEUs:

2.25
PDHs:

22.50
Accrediting Agencies:

Florida
New Jersey
New York
RCEP

Good news! This course is being offered as an instructor-led virtual course.

Go to Virtual Course

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.

Instructor(s):

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

Horizontal Tabs

What You'll Learn

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

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.

Outline

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

Download Course Outline (PDF)

FAQs

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.

Go to FAQs Page

Translate this page

Technical Groups

AIChE ENGAGE

IDEAL COMMUNITIES

4th Engineering Cosmetics and Consumer Products Conference

Global Polymers and Textiles Summit

Upcoming Conferences & Events

AIChE/ACS Frontiers of Chemistry, Materials Science & Chemical Engineering for Circular Economy

CCPS Latin America Regional Meeting

2023 North Central Student Regional Conference

2023 Southwest Student Regional Conference

2023 Eckhardt Northeast Student Regional Conference

15th AIChE Midwest Regional Conference

Effectively Managing Reactive Chemistry Risks—Part 3

2023 Pacific Northwest Student Regional Conference

2023 Mid-America Student Regional Conference

CEP: March 2023

CEP: February 2023

Explore Areas of Advancement:

Learning Center:

Gaseous Hydrogen: Safety Considerations

Search form

Limited Time Offer

Spreadsheet Problem-Solving and VBA Programming Combo Course

Share This Post:

Good news! This course is being offered as an instructor-led virtual course.

Go to Virtual Course

David E. Clough

Horizontal Tabs

Here’s a preview of what you’ll learn:

Spreadsheet Problem Solving for Chemical Engineers (CH764):

Excel VBA Programming for Chemical Engineers (CH766):

Who Should Attend:

Day One

8:00 – 8:30

8:30 – 9:45

9:45 – 10:15

10:15 – Noon

Noon – 1:00

1:00 – 2:45

2:45 – 3:15

3:15 – 5:00

Day Two

9:45 – 10:15

10:15 – Noon

Noon – 1:00

1:00 – 2:45

2:45 – 3:15

3:15 – 5:00

Day Three

7:30 – 8:00

8:00 – 9:45

9:45 – 10:15

10:15 – Noon

Noon – 1:00 Lunch Break

1:00 – 2:45

2:45 – 3:15

3:15 – 5:00

Explore More Areas of ILI