Advanced Excel VBA for Engineers and Scientists Short Course

June 26, 2017 - June 27, 2017
Vancouver, Canada


Key Learning Outcome

Most engineers use Excel daily yet thay are not taught how to use Excel efficiently.  In practice this means that engineers may develop spreadsheets in a manner that is:

  • Inefficient
  • Error-prone, and 
  • Incomprehensible.

This course provides engineers with a logical and structured framework so that the multitude of funchions (both directly in Excel and also avaiable in third party add-ins) can be utilized to enhance Excel productiviity in the workplace.

Topics include:

  • The basics of Excel
  • What is VBA?
  • How to call VBA modules?
  • Creating an add-in
  • Customiizing the Ribbon
  • Using color Styles in Excel
  • Using Named Ranges
  • Templates
  • Constrution a flowsheet to present dataflow
  • Visio flowsheets vs. Excel flowsheets
  • Linking a flowsheet with named ranges
  • Database - how to integrate with Excel
  • Automated table creation
  • A flowsheet simulation system.

Visit Event Website

Contact Information

OreVenture Training and Technical Services

Mary, Client Relations Officer

PO Box 79356

North Vancouver


Phone: 6047827501