Spreadsheet Problem-Solving for Chemical Engineers - Virtual - December-2023

  • Course ID:
  • Type:
    Instructor-led Virtual Course
  • Language:
  • Skill Level:
  • Duration:
    2 days
  • CEUs:
  • PDHs:
  • Accrediting Agencies:

Share This Post:

To take your basic knowledge and skills in spreadsheet problem solving to a new level, you need useful techniques and hands-on practice. In this time-tested course, you’ll master new skills that will improve your spreadsheet effectiveness and efficiency and you’ll have expert instructor David Clough there to help you when you need it.

Focus on the spreadsheet scenarios chemical engineers face every day

Arrive ready to participate as you learn how to develop well-organized, well-documented spreadsheets for chemical engineering calculations that can be understood by other engineers (and by you down the road). You’ll learn how to use Excel to implement typical chemical engineering calculations involving material and energy balances, fluid flow and heat transfer, separations and thermodynamics, chemical reactors and reaction kinetics, and flowsheets. You’ll also deepen your understanding of how to analyze data and apply statistical methods including model fitting and you’ll learn optimization methods for process design, scheduling, and economics.

Even if you think you know all about Excel, this course will open your eyes to new and better ways to problem solve with spreadsheets—whether you’re responsible for performance and trouble-shooting calculations with process data, process development and improvement, optimizing equipment specifications and economic profitability or incorporating spreadsheets in your teaching and research.

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,644.50
AIChE Grad Student Members $822.25
AIChE Undergrad Student Members $822.25

Horizontal Tabs