The goal of the training is to gain skills in using the Excel tool - Solver. It is a powerful Excel tool used for optimization. Solver is immensely useful in the decision making process on the optimization of such issues as: determining the volume of production, procurement plans and optimal use of materials, lowering the production waste, reducing the costs of transport and supply, etc.
The first step in using Solver is to determine the issue that has to be optimized, therefore a significant part of the training is dedicated to the methods of describing optimized issues, in particular the techniques of saving them in Excel.
A strong emphasis is put on the formulation of constraints, namely saving such parameters as the volume of available materials, machine capacity, number of people in a department.
Solver allows you to solve problems quickly, which cannot be solved with other Excel tools. The full use of this tool involves the interpretation of its results, therefore some part of the course is focused on interpreting and using the results obtained with the help of Solver.
All stages of the Solver use are discussed on the basis of various examples.
The training is dedicated primarily to people involved in the optimization process, especially regarding: production, material transportation, reduction of waste materials, reduction of working time with higher performance.
The training is 8 didactic hours long, from 8:30 am to 2:30 pm.
The training participants receive training materials in the form of:
- A script which consists of the full description of the tool and practical examples on the use of Solver.
- A CD where you can find interactive exercises.
As a part of the training, each participant is guaranteed 3-month, free of charge, after-training care. Within the after-training care, the participants can contact the trainer by e-mail, phone or during meetings at AkKom office.
Formulating optimization issues
Saving an issue, which is to be solved with the Solver tool, in Excel using tables and functions
- Defining and saving a function, the value of which is to be optimized
- Defining parameters, the optimization function depends on, and which can be changed
- Saving the conditions and constraints, that have to be met
Using the Solver tool
Entering data previously saved in the spreadsheet cells to Solver tool
- Defining the cell, goal and the operation that has to be done (minimization, maximization or finding a particular solution)
- Determining the area of changing cells
- Inserting constraints, including those that cannot be saved in the spreadsheet
Solver tool options
The description of options and the ways to choose between them, depending on whether the computation time is more important than their accuracy, what is important for issues with a large number of conditions and parameters
- Options influencing the calculation accuracy
- Options influencing the computing speed
- Deciding on the choice of a specific optimization method
Reports and their use
Discussing the reports created by Solver tool and the ways of using them for decision making and predicting
- Result Report
- Sensitivity Report
- Border Report
Exporting and importing Models
Methods of saving, editing and importing models in order to accelerate the work with Solver
- Exporting models created by Solver
- Editing the exported model
- Importing the created model
- Errors associated with importing some conditions and how to cope with them
Zapisz się na interesujący Cię termin szkolenia
There are currently no training dates
