In this series, we look at tips and techniques that chemical engineers can use to get the most out of Excel spreadsheets.
Want more Excel tips for chemical engineers?
If you know you want to delve even deeper than this blog series – or if our Excel tips leave you hungry for more – be sure to check out AIChE’s virtual combo course on spreadsheet problem solving and VBA programming. It’s taught by David E. Clough, the author of this series, and combines two of AIChE’s most popular spreadsheet courses, Spreadsheet Problem-Solving for Chemical Engineers and Excel VBA Programming for Chemical Engineers.
Share your tips, on Engage!
Do you have some tips of your own about spreadsheets? If you're a member, share them on AIChE Engage.
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.
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.
We look at more pointers to manage units and explain why it's best to keep unit conversion factors outside of formulas.
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.
Forget copying and pasting calculation results to build a case study—there's a better way with Excel's Data Table tool.