30-days Money-Back Guarantee
An practical introduction to mathematical programming in Excel and Python
Updated on Sep, 2026
Office Productivity, Microsoft, Excel
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
This course provides a practical introduction to mathematical modeling and optimization in Excel and Python, using
Excel Solver in Excel
PuLP and default free solvers through PuLP in Python
A concrete use case serves as an application example: Mathematical optimization of machine setup and changeover sequences.
There are many versions of this problem, but in the course, we will focus on two single-machine setup and changeover sequencing problems:
Optimal setup and changeover sequence for a one-time production program
Optimal changeover sequence for a repeated production cycle, i.e. repetitive cyclic production program
As part of this course, you will see and learn:
How to formally define a changeover sequencing problem mathematically
Get an overview of modeling frameworks and solvers in Excel and Python
How to set up Excel Solver and how to implement mathematical models with Excel Solver
How to implement and solve mathematical optimization models with PuLP in Python
As part of the course, you will have access to case study data, case study descriptions, mathematical model definitions, Excel files, and Python scripts. You can use these as templates for your specific problem.
How to use Excel Solver in Excel for mathematical programming.
How to use Python for mathematical programming.
Define a changeover matrix for a machine.
Define the changeover sequencing problem as mathematical optimization problem.
Implement a single machine changeover sequence optimization problem in Excel Solver.
Implement a single machine changeover sequence optimization problem in Python.
Basic knowledge of linear programming required.
Basic knowledge of mathematical programming required.
Basic Python knowledge required.
Basic Excel knowledge required.
Check out the detailed breakdown of what’s inside the course
Industrial engineer with a M.Sc. from ETH Zürich and many years of industrial optimization and simulation experience for business process, logistics system, and manufacturing process improvement. Founder fo SCDA - a supply chain analytics service .
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.