وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

The Complete Data Analytics Course in Excel

سرفصل های دوره

A complete data analysis course using the tools you already have.


1. Lectures
  • 1.1 01 - GOOG - Navigation.xlsx
  • 1. Navigation Part 1
  • 2. Navigation Part 2
  • 3.1 02 - Election results -Basic Functions.xlsx
  • 3. Basic Excel Formulas
  • 4.1 04 - SSN Internet - Data Structure.xlsx
  • 4. Structuring Data in Excel
  • 5.1 05 - Animals - Int. Functions.xlsx
  • 5. Intermediate Excel Functions
  • 6.1 06 - Orange Trees - Descriptive Stats.xlsx
  • 6. Descriptive Statistics Part 1
  • 7. Descriptive Statistics Part 2
  • 8.1 Product+Recall.xlsx
  • 8.2 Product+Recall+-+Solution.xlsx
  • 8. Module #1 Practice & Solutions

  • 2. Visualizations
  • 1.1 01 - MTcars - Charts.xlsx
  • 1. Introduction to Visualizations and Pie Charts
  • 2. Histograms
  • 3. Bar Charts
  • 4. Line Charts
  • 5. Box and Whisker
  • 6. Radial Charts
  • 7. Combo Charts
  • 8. Scatter Plots
  • 9.1 02 - Quakes - Conditional Formatting and Sparklines.xlsx
  • 9. Conditional Formatting Part 1
  • 10. Conditional Formatting Part 2
  • 11. Conditional Formatting Part 3
  • 12. Sparklines
  • 13.1 module 2 appendix.xlsx
  • 13. Appendix Control Charts
  • 14.1 OJ.xlsx
  • 14.2 OJ+-+Solution.xlsx
  • 14. Module #2 - Practice & Solutions

  • 3. Pivot Tables, Charts and Slicers
  • 1.1 01 - Pivot Table - Production Data.xlsx
  • 1. Introduction to Pivot Tables
  • 2. Root Cause Analysis
  • 3. Comparative Analysis
  • 4. Pivot Charts and Slicers
  • 5.1 Retail Sales - Solution.xlsx
  • 5.2 Retail Sales.xlsx
  • 5. Module #3 - Practice & Solutions

  • 4. Statistics Hypothesis Testing and Regression
  • 1.1 01 - Types of data.xlsx
  • 1. Types of Data
  • 2.1 02 - Sampling and Distributions.xlsx
  • 2. Fundamentals of Sampling
  • 3. Distributions Part 1
  • 4. Distributions Part 2
  • 5.1 03 - Hypothesis Tests.xlsx
  • 5. Introduction to Hypothesis Testing
  • 6.1 04 - T Tests.xlsx
  • 6. T-tests Part 1
  • 7. T-tests Part 2
  • 8. T-tests Part 3
  • 9.1 05 - Chi Square.xlsx
  • 9. Chi-Squared Test Part 1
  • 10. Chi-Squared Test Part 2
  • 11.1 06 - Normality Test.xlsx
  • 11. Test for Normality Part 1
  • 12. Test for Normality Part 2
  • 13.1 07 - ANOVA.xlsx
  • 13. ANOVA Part 1
  • 14. ANOVA Part 2
  • 15.1 08 - Simple Regression.xlsx
  • 15. Simple Regression Part 1
  • 16. Simple Regression Part 2
  • 17.1 09 - Multiple Regression.xlsx
  • 17. Multi-Variate Regression Part 1
  • 18. Multi-Variate Regression Part 2
  • 19. Multi-Variate Regression Part 3
  • 20.1 Police - Solution.xlsx
  • 20.2 Police.xlsx
  • 20. Module 4 - Practice & Solutions

  • 5. Forecasting
  • 1.1 01 - Intro to Forecasting.xlsx
  • 1. Introduction to Forecasting
  • 2.1 02 - Factor Forecasting - Regressions.xlsx
  • 2. Factor Forecasting - Regression Part 1
  • 3. Factor Forecasting - Regression Part 2
  • 4.1 03 - Monte Carlo.xlsx
  • 4. Factor Forecasting - Monte Carlo Simulation - Part 1
  • 5. Factor Forecasting - Monte Carlo Simulation - Part 2
  • 6. Factor Forecasting - Monte Carlo Simulation - Part 3
  • 7.1 04 - Time Series - SMA and Ex. Smoothing.xlsx
  • 7. Time Series Forecasting - The Simple Moving Average Part 1
  • 8. Time Series Forecasting - The Simple Moving Average Part 2
  • 9.1 05 - Time Series - Parameter Tuning.xlsx
  • 9. Time Series Forecasting - Parameter Tuning Part 1
  • 10. Time Series Forecasting - Parameter Tuning Part 2
  • 11. Time Series Forecasting - Parameter Tuning Part 3
  • 12.1 06 - Time Series - Auto Regressive Forecasting.xlsx
  • 12. Time Series Forecasting - Auto Regression
  • 13. Time Series Forecasting - Time Series ARMA
  • 14. Time Series Forecasting - Time Series ARIMA
  • 15.1 Problem Set #1 - Movies - Solution.xlsx
  • 15.2 Problem Set #1 - Movies.xlsx
  • 15. Module 5 - Practice Set #1 & Solutions
  • 16.1 Problem Set #2 - Hospital - Solution.xlsx
  • 16.2 Problem Set #2 - Hospital.xlsx
  • 16. Module 5 - Practice Set #2 & Solutions

  • 6. Miscellaneous Analytical Tools
  • 1.1 01 - Goal Seek.xlsx
  • 1. Intro and Goal Seek
  • 2.1 02 - Scenarios.xlsx
  • 2. Scenario Analysis
  • 3.1 03 - Data Table.xlsx
  • 3. Data Tables
  • 4.1 Solver_Suite.xlsx
  • 4. Introduction to Excel Solver Tool
  • 5. Excel Solver Tool - The Backpack Problem
  • 6. Excel Solver Tool - The Mixing Problem
  • 7. Excel Solver Tool - The Traveling Salesman Problem
  • 8.1 Coffee - Solution.xlsx
  • 8.2 Coffee.xlsx
  • 8. Module 6 - Practice & Solutions
  • 53,700 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 477
    حجم: 9294 مگابایت
    مدت زمان: 905 دقیقه
    تاریخ انتشار: 22 دی 1401
    طراحی سایت و خدمات سئو

    53,700 تومان
    افزودن به سبد خرید