Modeling Techniques in Excel
- Course ID: ELA181
- Type: eLearning (online) Course
- Language: English
- Skill Level: Intermediate
- Duration: 2 hours
- CEUs: 0.20
- PDHs: 2.00
Develop the deeper knowledge of spreadsheets, especially Excel, which you need to improve your financial and evaluation modeling and analysis. This online course will bring you up-to-speed on the features of Excel that best apply to the specific evaluations chemical engineers get involved with and how to use them to develop your own models.
Modeling expert Robert Salvin will begin by introducing the concept of modeling and different types of models. You’ll review key Excel principles and then, through the use of three example models—budget, project decision-making and financial statement—you’ll learn how to apply these principles. This course also highlights the features of Excel that best apply to these models.
In addition, you’ll review key evaluation principles—time value of money, present value and rate of return—and how to use Excel to generate these values. You’ll identify spreadsheet errors chemical engineers commonly make and how to avoid them. Throughout the course, you’ll learn practical skills to improve your day-to-day modeling efforts, such as how to best organize a spreadsheet, develop an evaluation model in Excel and apply model guidelines to your own work.
Robert Salvin is a chemical engineer with over 40 years of experience in the chemical industry. He has been associated 35 of those years with LyondellBasell and its predecessor companies, Lyondell and ARCO Chemical. Throughout his career, Salvin has focused primarily on corporate development with responsibility for economic evaluation guidelines and methodology for the company worldwide. He has an MBA in finance with degrees from Drexel University and is the instructor of AIChE’s eLearning course “Economic Evaluation for Chemical Engineers” as well as several...Read more
Teams (10 or more)
Minimize cost and maximize learning with Train-A-Team.Learn more
|AIChE Graduate Student Members||$197.50|
|AIChE Undergraduate Student Members||$197.50|