Analytical Tools and Decisioneering (Business Analysis)

Goal : Being able to set up and use common business mathematical models and tools in relation to business decision support (in various fields such as finance, quality, R&D, Marketing, etc.) using specialized functions, the solver and the MS Excel analysis toolpack.

Audience : This training is aimed at departments or company managers who already have an excellent level of education (minimum University Master).

Prerequisites : The learner must have at least a knowledge of basic statistical mathematics (undergraduate level).

Goals :

Introduction
Explanation of the limits of MS Excel compared to specialized software (@Risk, Statistica, TreeAge, etc.)
Calculation of the mode, max, min, mean, geometric mean, harmonic mean, median and ranks
Frequency analysis of data
Using the Table Tool to create double entry tables
Calculation of the rate of return (NPV, IRR) in certain future
Use of scenarios and scenario reports for deterministic simulation
Solving linear problems using the target tool
Solving multilinear problem using the solver (operational research)
Trend curves (linear, log, exponential, binomial, etc.) and forecast function (FORECAST())
Functions for linear regressions (LINEST(), FORECAST(), SLOPE())
Calculation of variance and standard deviation (estimators with or without bias / BUS)
Confidence intervals and average deviations
Univariate statistics (binomial law, beta law, Weibull law, exponential law, gamma law, reduced centered normal law, etc.)
Multivariate statistics (covariance, correlation coefficient, correlation / covariance matrix, etc.)
ANOVA (analyse de la variance)
ANOVA (analysis of variance)
Risk management with probabilistic PERT according to beta, normal or triangular laws
Monte Carlo simulations (if available time)
Analysis of time series and forecasting techniques
...

Pedagogical method : This training is based on practical exercises imposed by the trainer.

Suggested duration for presentiel training (days) : 3

Suggested duration for on-line training (days) : 3.6

Daily price in face-to-face : 675 CHF

Daily price in remote : 324 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 3375 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Book

Title : Microsoft Excel Data Analysis and Business Modeling
Author(s) : Wayne Winston
Pages : 823
ISBN : 9781509305889

Tags : monte-carlo, decisioneering, excel expert, business analysis, excel training, excel business analysis course, quality, scenarios modelisation, statistics, return, yield, temporal series, forecasting.

Formation MS Office Excel - Analytical Tools and Decisioneering (Business Analysis) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.