Spreadsheet Problem-Solving for Chemical Engineers | AIChE

Spreadsheet Problem-Solving for Chemical Engineers

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. The goal of this course is to provide you with a more comprehensive background in spreadsheet techniques and improve the quality, reliability and efficiency of your work. Dr. Clough will provide instruction using Microsoft Excel 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 include frequent live spreadsheet demonstrations. There is ample opportunity for you to practice and perfect the sound techniques and the methods taught.

Topics 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

Learning Outcomes:

  • Develop efficiently well-organized Excel spreadsheets for typical chemical engineering calculations
  • Organize and access tables of data and information using Excel’s built-in features and functions
  • Carry out typical chemical process calculations, including flowsheet material balances with recycle
  • Analyze chemical engineering data using Excel’s statistical tools, including regression analysis
  • Carry out targeting and optimization calculations in Excel using the Solver, Goal Seek, and other methods.

Who Should Attend:

Chemical engineers who already have some level of proficiency with Excel and use, or desire to use, spreadsheeting as a common software tool for problem solving and daily work. The course is also ideal for those engineers who believe they are very proficient Excel users, as a common comment on evaluations from those who have attended Dr. Clough’s short courses in the past is “I thought I knew a lot about Excel before I attended this course.” Knowledge of programming in VBA is not required nor expected.

  • Unit One: Excel Setup and Basic Skills

    • Lecture One: Preview of the Course
    • Lecture Two: Entry and Formatting of Data and Information
    • Lecture Three: Selection, Copying and Moving Efficiently
    • Lecture Four: Cell Addressing and Names
    • Lecture Five: Creating Excel Formulas with Built-in Functions
    • Unit One Quiz: 16 Questions

    Unit Two – Working with Tables of Data

    • Lecture One: Tables and Lists
    • Lecture Two: Lookup Functions
    • Lecture Three: Case Studies with the TABLE Function
    • Lecture Four: Array Formulas and Functions
    • Lecture Five: Pivot Tables and Scenarios
    • Unit Two Quiz: 15 Questions

    Unit Three – Process Calculations

    • Lecture One: Material Flowsheeting
    • Lecture Two: Closing recycles with the Iterative Solver
    • Lecture Three: Property Estimation and Equations of State
    • Lecture Four: Solving Differential Balances
    • Lecture Five: Cost Estimation and Cash Flow Analysis
    • Unit Three Quiz: 10 Questions

    Unit Four – Applied Statistics

    • Lecture One: Characterizing Data Sets
    • Lecture Two: Creating Excel Graphs
    • Lecture Three: Regression Analysis
    • Lecture Four: Design of Experiments
    • Lecture Five: Statistical Quality Control
    • Unit Four Quiz: 12 Questions

    Unit Five – Solving Equations

    • Lecture One: Algebraic Equations and Equation Sets
    • Lecture Two: Differential Equations
    • Lecture Three: Use of Solver and Goal Seek
    • Lecture Four: Unit Operation Modeling
    • Lecture Five: Process Control Calculations
    • Unit Five Quiz: 12 Questions

Find answers to questions about registration and refunds, tuition and fees, travel and lodging (for location-based courses), how eLearning courses work, how credits work, and more. 

Go to FAQs Page

  • Course ID:
  • Source:
  • Language:
  • Skill Level:
  • Duration:
    30 hours
  • CEUs:
  • PDHs:
  • Accrediting Agencies:
    New Jersey
    New York