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.
Topics include:
- Excel basic skills – improving your efficiency
- Working with tables of data and information
- Process calculations including flowsheeting and economic analysis
- Applied statistics including regression analysis
- Solving equations – algebraic and differential
Learning Outcomes:
- Develop efficiently well-organized Excel spreadsheets for typical chemical engineering calculations
- Organize and access tables of data and information using Excel’s built-in features and functions
- Carry out typical chemical process calculations, including flowsheet material balances with recycle
- Analyze chemical engineering data using Excel’s statistical tools, including regression analysis
- Carry out targeting and optimization calculations in Excel using the Solver, Goal Seek, and other methods.
Who Should Attend:
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
- Lecture One: Preview of the Course
- Lecture Two: Entry and Formatting of Data and Information
- Lecture Three: Selection, Copying and Moving Efficiently
- Lecture Four: Cell Addressing and Names
- Lecture Five: Creating Excel Formulas with Built-in Functions
- Unit One Quiz: 16 Questions
Unit Two – Working with Tables of Data
- Lecture One: Tables and Lists
- Lecture Two: Lookup Functions
- Lecture Three: Case Studies with the TABLE Function
- Lecture Four: Array Formulas and Functions
- Lecture Five: Pivot Tables and Scenarios
- Unit Two Quiz: 15 Questions
Unit Three – Process Calculations
- Lecture One: Material Flowsheeting
- Lecture Two: Closing recycles with the Iterative Solver
- Lecture Three: Property Estimation and Equations of State
- Lecture Four: Solving Differential Balances
- Lecture Five: Cost Estimation and Cash Flow Analysis
- Unit Three Quiz: 10 Questions
Unit Four – Applied Statistics
- Lecture One: Characterizing Data Sets
- Lecture Two: Creating Excel Graphs
- Lecture Three: Regression Analysis
- Lecture Four: Design of Experiments
- Lecture Five: Statistical Quality Control
- Unit Four Quiz: 12 Questions
Unit Five – Solving Equations
- Lecture One: Algebraic Equations and Equation Sets
- Lecture Two: Differential Equations
- Lecture Three: Use of Solver and Goal Seek
- Lecture Four: Unit Operation Modeling
- Lecture Five: Process Control Calculations
- Unit Five Quiz: 12 Questions
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.
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’ll 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.