David E. Clough Professor, Department of Chemical and Biological EngineeringUniversity of ColoradoDr. 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 versions. 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 open your work up to major errors, but master them, and you can gain speed, efficiency, and more dependable spreadsheet calculations. 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.