For questions related to the use of Excel and the Excel solver. The Excel solver is an add-in that allows the solution of linear programming problems, such as product mix problems (whether maximization or minimization), transportation problems and problems for the allocation of scarce resources. The spreadsheet is easy to use and fast to raise the model. It can obtain the reports of the optimal solution and the sensitivity analysis in a matter of seconds.
These are some introductory tutorials on using Excel to solve various linear optimization problems:
Lecture 5P1: IE 3340 Operations Research - Solving LP problems using Excel
Solving linear equations using Excel
