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

Excel Masterclass: A-Z Data Analysis Statistics & Dashboard

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

Learn Excel with Important Formulas-Functions, PivotTables, Analysis Tools, Graphs and Dashboard for A-Z Data Analysis.


1 - Dont Ignore It Start From Here
  • 1 - Instructions you MUST follow.html
  • 2 - Excel functions and shortcuts cheatsheet.html
  • 2 - Microsoft-Excel-Data-Analysis-Cheat-Sheet.pdf

  • 2 - Necessary Foundation of Data Analysis
  • 1 - Necessary foundation on data analysis.html
  • 3 - 1.Un-DA.pdf
  • 3 - What is data analysis
  • 4 - 2.Key-COMP.pdf
  • 4 - Key components of data analysis
  • 5 - 12.13.14.Methods-of-EDA.pdf
  • 5 - Methods of exploratory data analysis Part 1
  • 6 - Methods of exploratory data analysis Part 2
  • 7 - Methods of exploratory data analysis Part 3

  • 3 - Necessary Foundation of Statistical Analysis
  • 2 - Necessary foundation on statistical analysis.html
  • 8 - 22.Statistical-Data-Analysis.pdf
  • 8 - What is statistical data analysis
  • 9 - 6.Sampling-methods.pdf
  • 9 - Population vs sample and its methods
  • 10 - 23.Types-of-Statistics.pdf
  • 10 - Types of statistical data analysis
  • 11 - Inferential statistics Part 1 Ttests and ANOVA
  • 12 - 25.26.27.methods-of-ds-and-is.pdf
  • 12 - Inferential statistics Part 2 Relationships measures
  • 13 - 28.Lin-reg.pdf
  • 13 - Inferential statistics Part 3 Linear regression

  • 4 - Necessary Foundation on Hypothesis Testing
  • 1 - Necessary foundation on hypothesis testing.html
  • 14 - 36.Hypothesis-Testing.pdf
  • 14 - Hypothesis testing for inferential statistics
  • 15 - 37.Selecting-Appropriate-Statistical-Test.pdf
  • 15 - Selecting statistical test and assumption testing
  • 16 - 38.CSP.pdf
  • 16 - Confidence level significance level pvalue
  • 17 - 39.Making-Decision-and-Conclusion.pdf
  • 17 - Making decision and conclusion on findings
  • 18 - 40.Example-HT.pdf
  • 18 - Complete statistical analysis and hypothesis testing

  • 5 - Data Cleaning and Formatting in Excel
  • 19 - Identify and remove duplicates
  • 19 - employee-dataset.xlsx
  • 20 - Dealing with missing values
  • 20 - missing-mployee-dataset.xlsx
  • 21 - Defining and removing outliers
  • 21 - outliers-sales-data.xlsx
  • 22 - Dealing with inconsistent values
  • 22 - Incon-sales-data.xlsx
  • 23 - Texttocolumns for data separation
  • 23 - practice-text-to-column.xlsx

  • 6 - Sorting and Filtering Datasets
  • 24 - Sorting and filtering for data precision
  • 24 - filtering-data.xlsx
  • 25 - Advanced filtering with criteria
  • 25 - advanced-filtering-data.xlsx

  • 7 - Conditional Formatting for Tabular Analysis
  • 26 - Highlighting cells based on conditions
  • 26 - highlight-cells.xlsx
  • 27 - Findings top and bottom insights
  • 27 - topbottom.xlsx
  • 28 - Creating color scales and color bars
  • 28 - colorbar.xlsx

  • 8 - Formulas and Functions for Analyzing data
  • 29 - SUM AVERAGE MIN and MAX functions
  • 29 - business-growth-data.xlsx
  • 30 - SUMIF and AVERAGEIF functions
  • 30 - business-growth-data.xlsx
  • 31 - COUNT COUNTA and COUNTIF functions
  • 31 - business-growth-data.xlsx
  • 32 - YEAR MONTH and DAY for date manipulation
  • 32 - business-growth-data.xlsx
  • 33 - IF STATEMENTs for conditional operation
  • 33 - business-growth-data.xlsx
  • 34 - VLOOKUP for columnwise insight search
  • 34 - employeeInfo.xlsx
  • 35 - HLOOKUP for rowwise insight search
  • 35 - sales-crosstab.xlsx
  • 36 - XLOOKUP for robust complex insight search
  • 36 - xlookup.xlsx

  • 9 - Graphs and Charts for Data Visualization
  • 37 - Data analysis with Stacked and cluster bar charts
  • 37 - sales-data.xlsx
  • 38 - Data analysis with Pie chart and line chart
  • 38 - sales-data.xlsx
  • 39 - Data analysis with Area chart and TreeMap
  • 39 - sales-data.xlsx
  • 40 - Data analysis with Boxplot and Histogram
  • 40 - sales-data.xlsx
  • 41 - Data analysis with Scatterplot and Combo chart
  • 41 - sale-data.xlsx
  • 42 - Adjusting and decorating graphs and charts
  • 42 - sale-data.xlsx

  • 10 - Advanced Analysis in PivotTables and PivotCharts
  • 43 - PivotTables for group data analysis PART 1
  • 43 - Pivot-data-p1.xlsx
  • 44 - PivotTables for crosstab data analysis PART 2
  • 44 - Pivot-data-p2.xlsx
  • 45 - PivotCharts and Slicers for interactivity
  • 45 - Pivot-data-p3.xlsx

  • 11 - Data Analysis Tools for Statistical Analysis
  • 46 - Descriptive statistics and analysis
  • 46 - data-for-statistics.xlsx
  • 47 - Independent sample ttest
  • 47 - data-for-ind-t-tests.xlsx
  • 48 - Paired sample ttest
  • 48 - data-for-paired-t-tests.xlsx
  • 49 - Analysis of variance One way
  • 49 - data-for-anova.xlsx
  • 50 - Correlation test relationship measure
  • 50 - data-for-corr.xlsx
  • 51 - Regression analysis influence measure
  • 51 - data-for-reg.xlsx

  • 12 - Building Dashboard in Excel
  • 52 - 1.acc-inf.xlsx
  • 52 - Integrating analysis and graphs for dashboard
  • 53 - 2.canvas.xlsx
  • 53 - Building a canvas for implementing dashboard
  • 54 - 3.dashboard.xlsx
  • 54 - Creating dashboard with drag and drops
  • 55 - 4.decor-dash.xlsx
  • 55 - Final adjustment of dashboard elements

  • 13 - Final Project Data Analysis AZ in Excel
  • 56 - Final remark for you.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 37196
    حجم: 4274 مگابایت
    مدت زمان: 412 دقیقه
    تاریخ انتشار: ۱۶ خرداد ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید