Spreadsheet Problem-Solving for Chemical Engineers

Developed by: AIChE
  • Course ID:
  • Type:
    eLearning (online) Course
  • Language:
  • Skill Level:
  • Duration:
    30 hours
  • CEUs:
  • PDHs:

Share This Post:

Many chemical engineers are self-taught in the use of spreadsheets for day-to-day problem-solving, which is testimony to the inherent usefulness of this tool. Although spreadsheet software was developed for financial calculations, engineers and scientists in all fields have found spreadsheets to be their tool of choice. In this online course, Dr. Clough will provide instruction using Excel 2010 to illustrate a wide range of spreadsheet applications and skills that are relevant to the calculations and problem solving encountered by practicing chemical engineers. Lectures will include frequent live spreadsheet demonstrations. There will be ample opportunity for participants to practice and perfect the sound techniques and the methods taught.

Topics will include:

  • Excel basic skills – improving your efficiency
  • Working with tables of data and information
  • Process calculations including flowsheeting and economic analysis
  • Applied statistics including regression analysis
  • Solving equations – algebraic and differential
  • Programming in Excel using VBA

Although the spreadsheet version used by Dr. Clough in the course is Excel 2010, participants using Excel 2007 and earlier versions will be able to extract full benefit from the course.


David E. Clough

David Clough is a professor in the Department of Chemical and Biological Engineering at the University of Colorado. He has been on the faculty there for 40 years. Professor Clough has been teaching spreadsheets to undergraduate chemical engineers for 30 years. He has also taught, in collaboration with Miles Julian, more than 100 spreadsheets courses for AIChE in the last 25 years. Professor Clough continues to teach in-person AIChE courses and also offers two popular on-line spreadsheet courses via AIChE eLearning.

...Read more



Do you already own this?

Log In for instructions on accessing this content.


AIChE Members $995.00
AIChE Undergraduate Student Members $497.50
AIChE Graduate Student Members $497.50
Non-Members $1295.00


Training 10 or more?

In-company training and volume pricing are available. Learn more.

Horizontal Tabs