LIMITED TIME OFFER: Use promo code SUMMERSALE20 to take 20% off on eLearning courses.
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鈥檒l review key Excel principles and then, through the use of three example models鈥攂udget, project decision-making and financial statement鈥攜ou鈥檒l learn how to apply these principles. This course also highlights the features of Excel that best apply to these models.
In addition, you鈥檒l review key evaluation principles鈥攖ime value of money, present value and rate of return鈥攁nd how to use Excel to generate these values. You鈥檒l identify spreadsheet errors chemical engineers commonly make and how to avoid them. Throughout the course, you鈥檒l 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.
- The organization of a spreadsheet and what it consists of
- How to best develop an evaluation model in Excel
- What Excel functions are available to project evaluation
- The meaning of net present value and rate of return
- Pitfalls of using spreadsheets and how to avoid them What financial statements are
Any engineer who is involved in project development, evaluation and decision-making and who needs to use Excel spreadsheets for financial and evaluation analyses.
Lecture 1: Concept of Modeling
- Introduction
- Types of Models
- Excel Principles
- Evaluation Concepts
- Avoiding Errors
Lecture 2: Various Models
- Model Guidelines
- A Budget Model
- A Project Evaluation Model
- Financial Statement Modeling
Find answers to questions about registration and refunds, tuition and fees, travel and lodging (for location-based courses), how eLearning courses work, how credits work, and more.
Instructor
Explore More Areas of Advancement
AIChE Practice+ provides learners with opportunities to work on real-world challenges through industry internships and competitions.
With AIChE Career Discovery庐, we'll help you to identify aptitudes and skills you鈥檒l need in order to achieve your full potential at various career stages.
AIChE Credential validates your proficiency with potential employers in areas such as process intensification, safety, sustainability and others.