Advance Excel

Excel Session 5: Data Analysis

  • Explain Analysis ToolPak
  • Explain single factor and two factor tool with and without replication
  • Describe Correlation and Covariance
  • Explain F-Test two-sample for variances
  • Describe Histogram and moving average
  • Explain Random number generation
  • Describe Goal seek and Solver for what-if analysis
  • Explain one-input and two input data table and scenario
  • Describe Regression, Sampling, Rank, and Percentile
  • Describe Exponential Smoothing
Excel Session 4: Presenting Data Visually (Prev Lesson)
(Next Lesson) Excel Session 6: Macros and Forms
Back to Advance Excel

No Comments

Give a comment

×