This course, Excel for Chemical Engineers, provides a complete guide to leveraging Microsoft Excel for chemical engineering applications. It starts with the basics, including navigating Excel, tables, plotting data, iterations, least square methods, statistical functions, and matrix operations. Students then explore material and energy balances, applying Excel to solve non-reactive and reactive systems, including recycle streams.

The course introduces thermodynamics applications, including bubble and dew point calculations, flash calculations, and energy balances for reactive systems. It covers distillation (McCabe-Thiele method), liquid-liquid extraction (multi-stage and graphical solutions), and gas absorption and stripping, all modeled in Excel. Advanced topics include numerical methods, such as bisection, false position, Newton-Raphson, and fixed-point methods, as well as differential equations, iterative solutions, and optimization techniques.

Students also learn to use Excel macros, conditional statements, lookup functions, pivot tables, charts, and templates for efficient engineering calculations. Additional practical applications include pipe sizing, absorption in packed columns, and data extraction from PDFs and graphs. By the end, learners gain hands-on proficiency in Excel for chemical engineering, enabling them to analyze processes, perform simulations, and solve complex engineering problems in a professional and efficient manner.