Numerical Methods for Chemical Engineering in Excel

Chemical engineers often face complex problems that require quantitative solutions. This course provides a practical, hands-on approach to tackling these challenges using readily available spreadsheet tools. By the end of this course, you will be able to confidently implement various numerical methods directly within Excel, enabling you to model systems, analyze experimental data, and make informed engineering decisions. What you'll learn: Understand fundamental numerical methods for chemical engineering applications. Apply Excel's built-in tools like Solver and Goal Seek to find roots and optimize systems. Implement numerical integration and differentiation techniques within spreadsheets. Solve systems of linear and non-linear equations using Excel functions and iterative methods. Perform data regression and interpolation to model experimental data. Analyze solution stability and perform basic sensitivity analysis on your models. Learn to structure your Excel workbooks for clarity, reproducibility, and basic error checking. The course begins with foundational concepts of numerical analysis, then progresses through practical, step-by-step implementations of each method in Excel, culminating in real-world chemical engineering problem-solving scenarios. This course is designed for aspiring chemical engineers, students, and professionals who are new to numerical methods or wish to learn how to apply them effectively using Excel. No prior experience with advanced numerical software or programming is required. Begin your journey to mastering numerical problem-solving in chemical engineering with Excel today.