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

 1,155 total views,  2 views today

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

Pedagogical method : A certificate will be awarded to each participant who has attended at least 80% of the training.

Suggested duration (days) : 2

Daily price : 425 CHF
Price per day per trainee without course material, without certificate, without evaluation, without training room or computer


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