This intensive, hands-on AIChE course introduces the built-in programming capabilities of Microsoft Excel and its companion Visual Basic for Applications (VBA) programming language. Course topics include recording and editing macros, user-defined functions and Excel add-ins, programming fundamentals, spreadsheet- VBA communications, user interfaces, debugging, algorithm structure including decisions, loops and modular programming. The purpose of this one-day course is to bring you up to speed quickly in VBA programming and provide you with VBA program examples. If you want to step your use of spreadsheets to a higher level, this course is for you.
You Will Learn:
- How to apply VBA programming to many different engineering and technical applications
- How to use the Visual Basic Editor to examine and debug VBA code
- How to communicate between the Excel spreadsheet and VBA
- How to interconnect Excel with other software using VBA
Please click HERE for the course outline.
Course attendees must bring their own computers with Excel installed. The latest version of Excel is preferred.
Who Should Attend
This course is intended for engineers and scientists who have good spreadsheet skills and basic knowledge of computer programming. Those who have previously attended the Institute’s Spreadsheet Power course, or who are already familiar with the expansive capabilities of spreadsheets, will find this course to be an excellent reinforcement.
Excel Programming/Spreadsheet Combo CH203 - This course is a combination of "Spreadsheet Power" (CH201) and "Excel Programming with VBA" (CH200). Take these courses as a combo and save up to $445.00
For venue information, please click HERE.
-
Course Type: Public Course
-
Course Number: CH200
-
Language: English
Search, view abstracts and purchase individual papers from this journal in the ASME Digital Library.
- Find papers from this and other journals
- Sign up for content alerts
- Subscribe to RSS feeds
- View calls for papers
Instructors
David E. Clough, PhD, is Professor of Chemical Engineering at the University of Colorado, Boulder. His interests are applied computing in chemical engineering, process control, and applied statistics. Dr. Clough has taught the use of spreadsheets in chemical engineering applications since 1985, and he has won a number of teaching awards.
Miles Julian is retired after 41 years with DuPont and is a consultant in engineering evaluations and methanol technology, both in the United States and in Europe. He has taught AIChE’s course Spreadsheet Power! with David Clough since 1989.