Academy Offers

Get a 20% discount on eLearning course purchases made through July 31. Use code ACADEMY20 at check out.

AIChE members receive complimentary, unlimited access to live and on-demand AIChE webinars by purchasing them with their newly increased number of credits. See more resources.

Spreadsheet Problem-Solving for Chemical Engineers - Virtual

Source: AIChE
  • Course ID:
  • Type:
    Instructor-led Virtual Course
  • Language:
  • Skill Level:
  • Duration:
    18 hours
  • CEUs:
  • PDHs:

Share This Post:

This four-session course provides a comprehensive, hands-on experience in solving numerical problems often encountered by chemical engineers using Microsoft Excel.  Scenarios include material and energy balances, fluid flow, heat transfer, separations, chemical reactions, and process flowsheets.  Methods included are equation-solving, data analysis, optimization, and process economics. Typical chemical engineering examples are used throughout.

The course is organized in four, half-day sessions with hourly breaks during the sessions.  Participants alternate watching the instructor’s screen while he demonstrates spreadsheet techniques and working with spreadsheets on their own computer.  There is ample opportunity for questions and interaction between the participants and the instructor.  Participants are provided with a comprehensive notebook and a set of computer files.

Save $795 or more when you take both this course and  CH766VTL: Excel VBA Programming for Chemical Engineers. by registering for CH768VTL Spreadsheet Problem Solving and VBA Programming Combo Course.

Session 1

Basic Spreadsheet Skills

  • Configuring Excel for engineering calculations
  • Efficient spreadsheet manipulations
  • Formulas, cell addressing, and range names
  • Creating engineering graphs

Session 2

Process Calculations

  • Dealing with engineering formulas and units
  • Debugging spreadsheet calculations
  • Flowsheet calculations including recycle streams
  • Targeting calculations
  • Case studies

Session 3

Dealing with Data

  • Table look-up and interpolation
    • Incorporating discrete table-lookup in engineering calculations
    • Continuous tables with linear interpolation
  • Quadrature and smoothing
  • Excel’s Data Analysis Toolpak
  • Histograms and distributions
  • Model building through curve-fitting

Session 4

Numerical Problem-Solving

  • Solving algebraic equations and systems
    • Single nonlinear equations
    • Sets of linear equations
    • Sets of nonlinear equations
  • Numerical solution of differential equations
  • Optimization calculations
  • Capstone design calculations
  • Process economic evaluation
    • Cash flow and profitability

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


Teams (10 or more)

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

Learn more


AIChE Members $1,495.00
AIChE Grad Student Members $747.50
AIChE Undergrad Student Members $747.50
Accrediting Agencies: 

Horizontal Tabs