By Douglas Clark on
In this series, we look at tips and techniques that chemical engineers can use to get the most out of Excel spreadsheets.
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.
Over the last few years, one of our most popular series has been Excelling With Excel , which takes a look at some incredibly useful Excel tips for chemical engineers. Given the...
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...
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.