Using Pivot Tables and Slicers to Describe Data

Pivot tables are useful to describe data, it is a Excel tool which allows to grup data, classifying, filtering and arranging data acording with different approaches.


Click here

Summarizing data by Using Histograms

Hi,

The histograms tool allow us to get how a set of measures take shape broke into bin ranges, so that it renders us how a set of figures will be symmetric or skewed, as a result managers will know how to performance.


To see the file: Click here

Solving problems of warehouse location by using GRG Multistart SOLVER tool

Hi everybody,

GRG Multistar is an engine of Solver, which allows solve functions that it has several peaks, so that this engine find the upper and lower bounds as regards function of range peak function.

This kind of problems could be useful to find the best location of service or product warehouse between two points (customers, suppliers, crib tools...), and it renders the best problem election, when we face a multi choice problem.



Click here

Using Solver for Financial Planing

I can use Solver to verify the accuracy of the Excel PMT function or to determina mortgage payments for a variable interest rate, including we could determinate how much money it is needed to save for our retirement.

You could look up downloading file.

Using Solver for Capital Budgeting

Hi,

Solver tool is useful to determine which project it should undertake a company, sometimes a company have to face election problems, because of theirs Capital budget constraints; so election could be performed in the right way if managers use this Solver in other to solve this kind of problems.

You could download the file by clicking here

Using Solver to Schedule Your Workforce

Hi again

Here you are a new Excel file, where I have learnt, in this lesson I learnt to perfomance optimizise work force schedule, applying constraints as full's days work with no breaks, working week, labor requirements shifts...

You could look at the file by clicking here.

Optimization: determi the optimal product using SOLVER

Hi again,

Solver is a tool that you can use to determine de maximum profit or minimum cost, by considering constrains as total labor hour, capacity of the plant, work time machine, available raw materials...

The tool can help performance managers to find the optimal production by solving this can of problems.

If like to look at how to solve this kind of problems

Clic here

Best regards,