David E. Clough Professor, Department of Chemical and Biological EngineeringUniversity of ColoradoDavid 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. Professor Clough’s research is in applied process control. He also served as Associate Dean of Engineering at Colorado for seven years from 1986 through 1992 and currently represents Colorado to the NCAA as the campus’ Faculty Athletics Representative. Connect on AIChE Engage ChEnected contributions 7/7 in the series Excel Tips for Chemical Engineers Excel Tip #6: Use Excel’s Iterative Solver to Close Recycles and Other Circular Calculations Mar 16, 2017 . by David E. Clough Take advantage of Excel's Iterative Solver to make your spreadsheet more useful and reliable. 6/7 in the series Excel Tips for Chemical Engineers Excel Tip #5: Take Advantage of Data Tables for Case Studies Feb 28, 2017 . by David E. Clough Forget copying and pasting calculation results to build a case study—there's a better way with Excel's Data Table tool. 5/7 in the series Excel Tips for Chemical Engineers Excel Tip #4: Set Up Calculations in Natural Sequence and Employ Targeting Methods Feb 15, 2017 . by David E. Clough Many problems have a natural sequence, but for some, you may need to find one or more starting values that yield a desired final result. 4/7 in the series Excel Tips for Chemical Engineers Excel Tip #3: Manage Units and Avoid “Magic Numbers” Feb 1, 2017 . by David E. Clough We look at more pointers to manage units and explain why it's best to keep unit conversion factors outside of formulas. 3/7 in the series Excel Tips for Chemical Engineers Excel Tip #2: Master Selection, Copy, and Move Jan 18, 2017 . by David E. Clough In the second installment of this series, we look at the frequently used Excel techniques of selecting, copying, and moving. Simple slip-ups in these common Excel operations can... 2/7 in the series Excel Tips for Chemical Engineers Excel Tip #1: Avoid Mistakes with User-Friendly Cells Jan 4, 2017 . by David E. Clough In this first tip of the series, we look at how you can make your life easier with smartly named cells. As spreadsheets grow in size, so do the benefits of using this tip.