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 تومان

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

خرید دانلودی فوری

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

تولید کننده: Udemy