Microsoft Excel for A-Z Data Analysis Statistics & Dashboard

Files Included :

1 IF STATEMENTs for conditional operation.mp4 (110.35 MB)
MP4
3 VLOOKUP for column-wise insight search.mp4 (56.21 MB)
MP4
5 HLOOKUP for row-wise insight search.mp4 (60.74 MB)
MP4
7 XLOOKUP for robust & complex insight search.mp4 (62.87 MB)
MP4
1 Data analysis with Stacked and cluster bar charts.mp4 (128.84 MB)
MP4
11 Adjusting and decorating graphs and charts.mp4 (40.91 MB)
MP4
3 Data analysis with Pie chart and line chart.mp4 (64.01 MB)
MP4
5 Data analysis with Area chart and TreeMap.mp4 (69.48 MB)
MP4
7 Data analysis with Boxplot and Histogram.mp4 (35.54 MB)
MP4
9 Data analysis with Scatterplot and Combo chart.mp4 (34.98 MB)
MP4
1 PivotTables for group data analysis PART 1.mp4 (84.63 MB)
MP4
3 PivotTables for crosstab data analysis PART 2.mp4 (40.56 MB)
MP4
5 PivotCharts and Slicers for interactivity.mp4 (54.52 MB)
MP4
1 Descriptive statistics and analysis.mp4 (51.5 MB)
MP4
11 Regression analysis - influence measure.mp4 (102.72 MB)
MP4
3 Independent sample t-test.mp4 (68.71 MB)
MP4
5 Paired sample t-test.mp4 (39.31 MB)
MP4
7 Analysis of variance – One way.mp4 (64.31 MB)
MP4
9 Correlation test - relationship measure.mp4 (72.46 MB)
MP4
1 Integrating analysis and graphs for dashboard.mp4 (79.67 MB)
MP4
2 Building a canvas for implementing dashboard.mp4 (40.15 MB)
MP4
3 Creating dashboard with drag and drops.mp4 (64.9 MB)
MP4
4 Final adjustment of dashboard elements.mp4 (50.19 MB)
MP4
1 What is data analysis.mp4 (55.02 MB)
MP4
2 Key components of data analysis.mp4 (81.34 MB)
MP4
3 Understanding exploratory data analysis.mp4 (38.87 MB)
MP4
4 Methods of exploratory data analysis Part 1.mp4 (81.31 MB)
MP4
5 Methods of exploratory data analysis Part 2.mp4 (84.21 MB)
MP4
6 Methods of exploratory data analysis Part 3.mp4 (79.58 MB)
MP4
1 What is statistical data analysis.mp4 (56.64 MB)
MP4
2 Statistical data analysis vs EDA.mp4 (20.3 MB)
MP4
3 Population vs sample and its methods.mp4 (74.51 MB)
MP4
4 Types of statistical data analysis.mp4 (36.41 MB)
MP4
5 A recap on descriptive analysis.mp4 (18.8 MB)
MP4
6 Inferential statistics Part 1 – T-tests and ANOVA.mp4 (39.61 MB)
MP4
7 Inferential statistics Part 2 – Relationships measures.mp4 (22.67 MB)
MP4
8 Inferential statistics Part 3 – Linear regression.mp4 (91.62 MB)
MP4
1 Hypothesis testing for inferential statistics.mp4 (52.51 MB)
MP4
2 Selecting statistical test and assumption testing.mp4 (59.9 MB)
MP4
3 Confidence level, significance level, p-value.mp4 (17.28 MB)
MP4
4 Making decision and conclusion on findings.mp4 (14.72 MB)
MP4
5 Complete statistical analysis and hypothesis testing.mp4 (49.95 MB)
MP4
1 Visualizing data for the best insight delivery.mp4 (29.58 MB)
MP4
2 Several methods of data visualization Part 1.mp4 (24.39 MB)
MP4
3 Several methods of data visualization Part 2.mp4 (35.66 MB)
MP4
4 Several methods of data visualization Part 3.mp4 (32.75 MB)
MP4
1 Identify and remove duplicates.mp4 (43.17 MB)
MP4
3 Dealing with missing values.mp4 (102.95 MB)
MP4
5 Defining and removing outliers.mp4 (81.25 MB)
MP4
7 Dealing with inconsistent values.mp4 (56.73 MB)
MP4
9 Text-to-columns for data separation.mp4 (29.84 MB)
MP4
1 Sorting and filtering data.mp4 (65.74 MB)
MP4
3 Advanced filtering with criteria.mp4 (54.07 MB)
MP4
1 Highlighting cells based on conditions.mp4 (77 MB)
MP4
3 Findings top and bottom insights.mp4 (42.61 MB)
MP4
5 Creating color scales and color bars.mp4 (72.13 MB)
MP4
1 SUM, AVERAGE, MIN, and MAX functions.mp4 (115.18 MB)
MP4
3 SUMIF, and AVERAGEIF functions.mp4 (77.75 MB)
MP4
5 COUNT, COUNTA, and COUNTIF functions.mp4 (75.39 MB)
MP4
7 YEAR, MONTH and DAY for date manipulation.mp4 (44.32 MB)
MP4