Excel VBA Programming for Chemical Engineers

Source: AIChE
  • Course ID:
    CH766
  • Type:
    Face-to-Face Course
  • Language:
    English
  • Skill Level:
    Intermediate
  • Duration:
    1 day
  • CEUs:
    0.75
  • PDHs:
    7.50

Share This Post:

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. Join chemical engineer and VBA expert David Clough for an intensive, hands-on introduction to 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.

The basics of Excel VBA programming 

In one day, you’ll learn how to improve your efficiency and enhance your spreadsheets by incorporating VBA. You’ll discover how to create time-saving shortcuts via VBA macros and to develop user-defined functions to package custom chemical engineering calculations. You’ll also learn how to manage information between the spreadsheet and VBA environments. And, you’ll see how to design and implement interfaces including user forms and communication with other software packages, such as process simulators. Throughout the day, you’ll cover dozens of topics – everything from creating Excel add-ins to user interfaces – that will improve your Excel problem-solving skills immediately.

Be sure to bring your own computer with Excel installed – preferably the latest version –and get ready to roll up your sleeves to learn by doing. 

Mac users please note: A good portion of the afternoon of the course covers Excel VBA ‘userforms’ which are not currently functional in Excel for Macs. Please take the course on a PC.

Save $795 or more when you take both this course and CH764 Spreadsheet Problem-Solving for Chemical Engineers by registering for CH768 Spreadsheet Problem Solving and VBA Programming Combo Course.

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

Register

Venue: To be announced
Houston, TX
United States

October 17, 2019

Pricing

Teams (10 or more)

Minimize cost and maximize learning with Train-A-Team.

Learn more

Individuals

...
AIChE Members $1,195.00
AIChE Grad Student Members $547.50
AIChE Undergrad Student Members $547.50
Accrediting Agencies: 

Horizontal Tabs