MS Office Excel Training - Analytical Tools and Decisioneering (Business Analysis)


MS Office Excel Training - 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.

ID : 1157

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).

  • 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.