Optimization with Excel: Operations Research without Coding

Unlock the power of optimization algorithms for better business decisions! This course provides a practical, no-code approach to tackling complex operational planning and long-term planning challenges. Learn to find optimal solutions using powerful techniques, even if you have no coding experience.

What you'll learn:

• Linear Programming (LP): Master the fundamentals of LP to optimize resource allocation and decision-making.
• Mixed-Integer Linear Programming (MILP): Solve problems with both continuous and discrete variables.
• NonLinear Programming (NLP): Apply NLP techniques to complex, non-linear optimization scenarios.
• Mixed-Integer NonLinear Programming (MINLP): Handle problems with both integer and non-linear constraints.
• Genetic Algorithm (GA): Explore GA for finding near-optimal solutions to complex optimization problems.
• Vehicle Routing Problems with Time Windows (VRPTW): Learn to optimize delivery routes considering time constraints.

Tools & Solvers:

This course explores a range of powerful solvers, including:

• Gurobi: A leading commercial optimization solver.
• CBC: A robust open-source solver.
• IPOPT: An open-source solver for nonlinear optimization.
• Bonmin: A powerful open-source solver.
• Couenne: A high-performance open-source solver.
• CPLEX: A leading commercial solver (limited version via NEOS server).

Hands-on Learning:

• Excel-Based Solutions: Solve optimization problems effectively using Excel, leveraging built-in formulas and functions.
• Workbooks Included: Practical workbooks provide step-by-step guidance for solving problems using GA and VRPTW.
• Mathematical Modeling: Gain a solid foundation in mathematical modeling and essential Excel formulas.
• Real-World Examples: Apply your knowledge to solve practical problems such as:
  • Route Optimization: Improve efficiency in logistics and transportation.
  • Maintenance Planning: Optimize maintenance schedules to minimize downtime.
  • Optimal Power Flow: Enhance efficiency in electrical systems.
  • And many more, including complex scenarios with summations and constraints.

Important Considerations:

• This course is designed for problems that can be solved effectively with Excel and optimization solvers. It is not suitable for:
  • Extremely complex problems requiring decomposition and iterations (e.g., Benders decomposition).
  • Real-time operational problems.
  • Very large problems requiring extremely fast solutions.
  • Multi-objective optimization problems.
• No Coding Required: This course focuses on using optimization solvers without programming.
• Software Requirements: You will need Excel installed on your computer. The tools are tested on Windows and Mac.
• No Excel Installation Instructions: The course teaches how to install the required tools, but does not provide instructions for installing Excel itself.

This course is perfect for professionals seeking to enhance their skills in operations research, mathematical optimization, and decision-making. Receive a certificate of completion from Udemy upon finishing the course!