MS Office Excel Training - MS Excel Analysis Toolpack Add-in

Loading

MS Office Excel Training - MS Excel Analysis Toolpack Add-in 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.


425.-/d
ID : 929

Goal : Discover trough examples of real case studies in detail all options available in the MS Excel analysis tool add-in for business or statistics analysis.

Audience : Engineers, financial analysts, accountants, executives and analysts/forecasters that whish to make more advanced analysis than it is possible using the spreadsheet-basic tools.

Prerequisites : Have at least a university degree or equivalent level in a scientific field (economics, physics, mathematics, chemistry, etc.) and be comfortable with statistics. One must also have the ability to mentally represent simple or complex mechanisms and processes.

Goals :
  • Introduction
  • Histogram
  • Descriptive statistics
  • Rank and Percentile
  • Moving Average
  • Correlation Analysis
  • Covariance Analysis
  • Linear regression
  • Exponential Smoothing
  • Random Number Generation
  • Z-Test two sample for Means
  • t-Test Paired tow sample for means
  • t-Test Two-Sample assuming equal variances
  • t-Test two Sample assuming unequal variances
  • F-test two-Sample for Variances
  • ANOVA single Factor
  • ANOVA double Factor without replication
  • Fourier Analysis
  • Random and periodic Sampling
  • Training Conclusion
Suggested duration for presentiel training (days) : 2
Suggested duration for on-line training (days) : 2.4

Daily price in face-to-face : 425 CHF
Daily price in remote : 204 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 2125 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).


Tags : ms excel business training, ms excel statistics training, ms excel business cours, analysis tool, anova , fourier transform, statistical test , business.