Engineering Economy and Excel Spreadsheet Modeling

Every engineering decision has a financial impact, yet many professionals struggle to build the clean, efficient spreadsheet models needed to justify their designs. This text-based course bridges the gap between engineering theory and practical economic analysis. You will move past basic spreadsheet usage to build robust, structured models that support complex project evaluations. Starting with foundational economic concepts, you will learn to structure data logically, perform rigorous financial calculations, and conduct dynamic sensitivity analyses. What you will learn: Understand core engineering economy principles, including the time value of money, cash flows, and interest formulas; Build structured spreadsheet models using best practices for layout, documentation, and error prevention; Apply advanced Excel analysis tools such as Goal Seek and Data Tables to evaluate design trade-offs; Perform sensitivity and scenario analysis to assess project risks under uncertainty; Calculate key financial metrics including Net Present Value (NPV), Internal Rate of Return (IRR), and payback periods. You will begin by mastering essential terminology and financial formulas before progressing to hands-on modeling scenarios where you will construct and analyze your own engineering project evaluations. This course is designed specifically for beginners, engineering students, and technical professionals who want to build strong spreadsheet modeling skills from scratch with no prior financial experience required. Start building cleaner, more powerful engineering economy models today.