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. The goal of this course is to provide you with a more comprehensive background in spreadsheet techniques and improve the quality, reliability and efficiency of your work. Dr. Clough will provide instruction using Microsoft Excel 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 include frequent live spreadsheet demonstrations. There is ample opportunity for you to practice and perfect the sound techniques and the methods taught.
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.
Unit One: Excel Setup and Basic Skills
Unit Two – Working with Tables of Data
Unit Three – Process Calculations
Unit Four – Applied Statistics
Unit Five – Solving Equations