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. Although spreadsheet software was developed for financial calculations, engineers and scientists in all fields have found spreadsheets to be their tool of choice. In this course, Dr. Clough will provide instruction using Excel 2010 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 will include frequent live spreadsheet demonstrations. There will be ample opportunity for participants to practice and perfect the sound techniques and the methods taught.
Topics will 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
- Programming in Excel using VBA
Although the spreadsheet version used by Dr. Clough in the course is Excel 2010, participants using Excel 2007 and earlier versions will be able to extract full benefit from the course.
What You’ll Learn
Most Excel courses are not attuned to the needs of engineers rather are more general, often focusing on business applications, and often not presenting the level of challenge that chemical engineers are known to expect. This course is designed for and dedicated to the needs of ChEs. You will learn how to bring the myriad of features and capabilities of Excel to the challenge of solving problems that you encounter in your work. Units in the course will focus on setting up Excel for engineering work and building efficient spreadsheet skills and techniques, working with tables of information and data, carrying out process calculations, characterizing data including statistical methods and regression analysis, solving equations relevant to chemical engineering scenarios, and programming in Excel using Visual Basic for Applications. This course will open doors in spreadsheet use that will greatly improve your productivity and work quality.
Who Should Attend
This course is designed for 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.
|AIChE Grad Student Members||$447.50|
|AIChE Undergrad Student Members||$447.50|
(Membership is just $199 a year. For more information on becoming an AIChE member click here.)