Udemy Excel Masterclass 15 Day Data Analytics Bootcamp in Excel

Files Included :

43 - PivotTables for group data analysis PART 1.mp4 (123.96 MB)
MP4
44 - PivotTables for crosstab data analysis PART 2.mp4 (28.55 MB)
MP4
45 - PivotCharts and Slicers for interactivity.mp4 (77.21 MB)
MP4
46 - Descriptive statistics and analysis.mp4 (65.14 MB)
MP4
47 - Independent sample ttest.mp4 (55.18 MB)
MP4
48 - Paired sample ttest.mp4 (53.97 MB)
MP4
49 - Analysis of variance One way.mp4 (93.3 MB)
MP4
50 - Correlation test relationship measure.mp4 (90 MB)
MP4
51 - Regression analysis influence measure.mp4 (132.43 MB)
MP4
52 - Integrating analysis and graphs for dashboard.mp4 (112.46 MB)
MP4
53 - Building a canvas for implementing dashboard.mp4 (53.83 MB)
MP4
54 - Creating dashboard with drag and drops.mp4 (92.39 MB)
MP4
55 - Final adjustment of dashboard elements.mp4 (72.07 MB)
MP4
3 - What is data analysis.mp4 (46.72 MB)
MP4
4 - Key components of data analysis.mp4 (60.97 MB)
MP4
5 - Methods of exploratory data analysis Part 1.mp4 (124.67 MB)
MP4
6 - Methods of exploratory data analysis Part 2.mp4 (129.55 MB)
MP4
7 - Methods of exploratory data analysis Part 3.mp4 (67.39 MB)
MP4
10 - Types of statistical data analysis.mp4 (32.01 MB)
MP4
11 - Inferential statistics Part 1 Ttests and ANOVA.mp4 (29.93 MB)
MP4
12 - Inferential statistics Part 2 Relationships measures.mp4 (16.63 MB)
MP4
13 - Inferential statistics Part 3 Linear regression.mp4 (142.67 MB)
MP4
8 - What is statistical data analysis.mp4 (46.61 MB)
MP4
9 - Population vs sample and its methods.mp4 (87.71 MB)
MP4
14 - Hypothesis testing for inferential statistics.mp4 (27.22 MB)
MP4
15 - Selecting statistical test and assumption testing.mp4 (59.68 MB)
MP4
16 - Confidence level significance level pvalue.mp4 (10.5 MB)
MP4
17 - Making decision and conclusion on findings.mp4 (9.8 MB)
MP4
18 - Complete statistical analysis and hypothesis testing.mp4 (32.63 MB)
MP4
19 - Identify and remove duplicates.mp4 (57.8 MB)
MP4
20 - Dealing with missing values.mp4 (143.79 MB)
MP4
21 - Defining and removing outliers.mp4 (117.38 MB)
MP4
22 - Dealing with inconsistent values.mp4 (79.7 MB)
MP4
23 - Texttocolumns for data separation.mp4 (39.29 MB)
MP4
24 - Sorting and filtering for data precision.mp4 (98.89 MB)
MP4
25 - Advanced filtering with criteria.mp4 (69.21 MB)
MP4
26 - Highlighting cells based on conditions.mp4 (116.28 MB)
MP4
27 - Findings top and bottom insights.mp4 (63.98 MB)
MP4
28 - Creating color scales and color bars.mp4 (107.08 MB)
MP4
29 - SUM AVERAGE MIN and MAX functions.mp4 (176.25 MB)
MP4
30 - SUMIF and AVERAGEIF functions.mp4 (112.1 MB)
MP4
31 - COUNT COUNTA and COUNTIF functions.mp4 (108.07 MB)
MP4
32 - YEAR MONTH and DAY for date manipulation.mp4 (70.27 MB)
MP4
33 - IF STATEMENTs for conditional operation.mp4 (166.43 MB)
MP4
34 - VLOOKUP for columnwise insight search.mp4 (77.9 MB)
MP4
35 - HLOOKUP for rowwise insight search.mp4 (64.21 MB)
MP4
36 - XLOOKUP for robust complex insight search.mp4 (89.86 MB)
MP4
37 - Data analysis with Stacked and cluster bar charts.mp4 (192.94 MB)
MP4
38 - Data analysis with Pie chart and line chart.mp4 (82.08 MB)
MP4
39 - Data analysis with Area chart and TreeMap.mp4 (100.33 MB)
MP4
40 - Data analysis with Boxplot and Histogram.mp4 (42.55 MB)
MP4
41 - Data analysis with Scatterplot and Combo chart.mp4 (49.19 MB)
MP4
42 - Adjusting and decorating graphs and charts.mp4 (59.45 MB)
MP4