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.1 Microsoft Excel Data Analysis Cheat Sheet.pdf

2. Excel functions and shortcuts cheatsheet.html

2. Necessary Foundation of Data Analysis

1.1 1. Un DA.pdf

1. What is data analysis

2.1 2. Key COMP.pdf

2. Key components of data analysis

3.1 11. EDA.pdf

3. Understanding exploratory data analysis

4. Methods of exploratory data analysis Part 1

5. Methods of exploratory data analysis Part 2

6.1 12. 13. 14. Methods of EDA.pdf

6. Methods of exploratory data analysis Part 3

7. Necessary foundation on data analysis.html

3. Necessary Foundation of Statistical Analysis

1.1 22. Statistical Data Analysis.pdf

1. What is statistical data analysis

2.1 24. stat v s eda.pdf

2. Statistical data analysis vs EDA

3.1 6. Sampling methods.pdf

3. Population vs sample and its methods

4.1 23. Types of Statistics.pdf

4. Types of statistical data analysis

5. A recap on descriptive analysis

6. Inferential statistics Part 1 T-tests and ANOVA

7.1 25. 26. 27. methods of ds and is.pdf

7. Inferential statistics Part 2 Relationships measures

8.1 28. Lin reg.pdf

8. Inferential statistics Part 3 Linear regression

9. Necessary foundation on statistical analysis.html

4. Necessary Foundation on Hypothesis Testing

1.1 36. Hypothesis Testing.pdf

1. Hypothesis testing for inferential statistics

2.1 37. Selecting Appropriate Statistical Test.pdf

2. Selecting statistical test and assumption testing

3.1 38. CSP.pdf

3. Confidence level, significance level, p-value

4.1 39. Making Decision and Conclusion.pdf

4. Making decision and conclusion on findings

5.1 40. Example HT.pdf

5. Complete statistical analysis and hypothesis testing

6. Necessary foundation on hypothesis testing.html

5. Necessary Foundation on Data Visualizations

1.1 44. Data Visualization.pdf

1. Visualizing data for the best insight delivery

2. Several methods of data visualization Part 1

3. Several methods of data visualization Part 2

4.1 45. 46. 47. Data Visualization Methods.pdf

4. Several methods of data visualization Part 3

5. Data visualization and methods.html

6. Data Cleaning and Formatting in Excel

1.1 employee dataset.xlsx

1. Identify and remove duplicates

2. Removing duplicated values.html

3.1 missing mployee dataset.xlsx

3. Dealing with missing values

4. Imputing missing values.html

5.1 outliers sales data.xlsx

5. Defining and removing outliers

6. Dealing with outliers.html

7.1 Incon sales data.xlsx

7. Dealing with inconsistent values

8. Replacing inconsistent value.html

9.1 text to column.xlsx

9. Text-to-columns for data separation

10. Text-to-columns.html

7. Sorting and Filtering for Data Precision

1.1 filtering data.xlsx

1. Sorting and filtering data

2. Sorting and filtering in Excel.html

3.1 advanced filtering data.xlsx

3. Advanced filtering with criteria

4. Advanced filtering method.html

8. Conditional Formatting for Tabular Analysis

1.1 highlight cells.xlsx

1. Highlighting cells based on conditions

2. Cells highlighting in criteria.html

3.1 topbottom.xlsx

3. Findings top and bottom insights

4. Findings top and bottom insights.html

5.1 colorbar.xlsx

5. Creating color scales and color bars

6. Creating color scales and color bars.html

9. Formulas and Functions for Analyzing data

1.1 SAMM business growth data.xlsx

1. SUM, AVERAGE, MIN, and MAX functions

2. Perform SUM and AVERAGE operation.html

3.1 SA business growth data.xlsx

3. SUMIF, and AVERAGEIF functions

4. Using SUMIF and AVERAGEIF functions.html

5.1 CCC business growth data.xlsx

5. COUNT, COUNTA, and COUNTIF functions

6. Utilizing COUNTIF functions.html

7.1 YMD business growth data.xlsx

7. YEAR, MONTH and DAY for date manipulation

8. Extracting year, month and day.html

10. Advanced Formulas and Functions for Analyzing data

1.1 IF business growth data.xlsx

1. IF STATEMENTs for conditional operation

2. Applying NESTED IF operation.html

3.1 VLOOK employeeInfo.xlsx

3. VLOOKUP for column-wise insight search

4. Utilizing VLOOKUP function.html

5.1 HLOOK sales crosstab.xlsx

5. HLOOKUP for row-wise insight search

6. Utilizing HLOOKUP function.html

7.1 XLOOK sales data.xlsx

7. XLOOKUP for robust & complex insight search

8. Utilizing XLOOKUP function.html

11. Graphs and Charts for Data Visualization

1.1 Bar sales data.xlsx

1. Data analysis with Stacked and cluster bar charts

2. Insight generation using Stacked bar charts.html

3.1 Pie-Line sales data.xlsx

3. Data analysis with Pie chart and line chart

4. Insight generation using Pie chart.html

5.1 Area-Tree sales data.xlsx

5. Data analysis with Area chart and TreeMap

6. Insight generation using Area chart.html

7.1 Hist-Box sales data.xlsx

7. Data analysis with Boxplot and Histogram

8. Insight generation using Boxplot.html

9.1 Scatter-Combo sale data.xlsx

9. Data analysis with Scatterplot and Combo chart

10. Insight generation using Scatter plot.html

11.1 Decor sale data.xlsx

11. Adjusting and decorating graphs and charts

12. Data Analysis in PivotTables and PivotCharts

1.1 Pivot data p1.xlsx

1. PivotTables for group data analysis PART 1

2. Group data analysis in PivotTable.html

3.1 Pivot data p2.xlsx

3. PivotTables for crosstab data analysis PART 2

4. Crosstab data analysis in PivotTable.html

5.1 Pivot data p3.xlsx

5. PivotCharts and Slicers for interactivity

6. PivotCharts and Slicers for analysis.html

13. Data Analysis Tools for Statistical Analysis

1.1 data for statistics.xlsx

1. Descriptive statistics and analysis

2. Descriptive statistics.html

3.1 data for ind t-tests.xlsx

3. Independent sample t-test

4. Finding the difference between genders.html

5.1 data for paired t-tests.xlsx

5. Paired sample t-test

6. Finding the difference between time frames.html

7.1 data for anova.xlsx

7. Analysis of variance One way

8. Finding the difference among regions.html

9.1 data for corr.xlsx

9. Correlation test - relationship measure

10. Finding the relationship between numeric data.html

11.1 data for reg.xlsx

11. Regression analysis - influence measure

12. Measuring the influence of IV on DV.html

14. Building Dashboard in Excel

1.1 1. acc inf.xlsx

1. Integrating analysis and graphs for dashboard

2.1 2. canvas.xlsx

2. Building a canvas for implementing dashboard

3.1 3. dashboard.xlsx

3. Creating dashboard with drag and drops

4.1 4. decor dash.xlsx

4. Final adjustment of dashboard elements

5. Creating a complete dashboard.html

15. Final Project - Data Analysis A-Z in Excel

1. Bank churn data analysis in Microsoft Excel.html

2. Final remark for you.html

139,000 تومان

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

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

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

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