Excel VBA Programming for Chemical Engineers
- Course ID: ELA118
- Type: eLearning (online) Course
- Language: English
- Skill Level: Intermediate
- Duration: 12 hours
- CEUs: 1.20
- PDHs: 12.00
- Accrediting Agencies:
If you know your way around Microsoft Excel and you’re ready to learn Visual Basic for Applications (VBA) Programming this course is for you. In this online course, chemical engineer and VBA expert David Clough will introduce the built-in programming capabilities of Microsoft Excel, and its companion VBA programming language. Learn how to take your spreadsheet problem-solving skills to the next level.
Mac users please note: Lectures 10 and 11 use Excel VBA ‘userforms’ which are not currently functional in Excel for Macs. Please take the course on a PC.
Topics will include:
- 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
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
Teams (10 or more)
Minimize cost and maximize learning with Train-A-Team.Learn more
|AIChE Graduate Student Members||$397.50|
|AIChE Undergraduate Student Members||$397.50|