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.
Save when you take both this course and CH765 Spreadsheet Problem-Solving for Chemical Engineers by registering for CH767 Spreadsheet Problem Solving and VBA Programming Combo Course.
Here’s a preview of what you’ll learn:
- 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:
Engineers or scientist who have been working with Excel for some time, have basic spreadsheet skills and basic knowledge of computer programming or have attended AIChE’s Spreadsheet Problem-Solving for Chemical Engineers (CH765).
|AIChE Grad Student Members||$447.50|
|AIChE Undergrad Student Members||$447.50|
|Training 10 or More?||Volume Pricing is available. Send an e-mail to
firstname.lastname@example.org for more information.
* AIChE Membership is just $199 a year. For more information on becoming an AIChE member click here.
Note: Registered attendees will receive an email 4 weeks before the course start date (6 weeks if course is outside the U.S.) notifying them of the status of the course. Please do not book airline tickets before you receive notification as we cannot reimburse tickets or airline change fees if the class is not held. If you have any questions, please call Customer Service (800.242.4363 or 203.702.7660 outside US).
June 16, 2015
October 14, 2015