Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - Microsoft Excel for Data Analytics Statistics and Dashboard

Size
1.3 GB
Seeders
0
Leechers
1
Files
50
Category
Added
at 7:01pm GMT+1
Infohash
3be31fe7c9d3010ea637a6fc42109ef11df262bf
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] Microsoft Excel for Data Analytics Statistics and Dashboard



If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com







Published 1/2024

Created by Md Shahriar

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English | Duration: 35 Lectures ( 3h 3m ) | Size: 1.33 GB



Unleash Excel for Data Cleaning, Data Analytics, Statistical Analysis, Hypothesis Testing and Interactive Dashboard.



What you'll learn:

Understand and apply techniques for cleaning and preparing raw data in Excel.

Learn to identify and handle missing data, outliers, and inconsistencies.

Utilize Excel functions and tools for data validation and transformation.

Explore fundamental statistical concepts and their application in Excel.

Learn to perform descriptive statistics, inferential statistics, and hypothesis testing using Excel functions and tools.

Understand how to interpret and communicate statistical results effectively.

Design and build interactive dashboards in Excel for effective data visualization.

Learn to use PivotTables, PivotCharts, and slicers to create dynamic and user-friendly dashboards.

Explore various data visualization techniques available in Excel, including charts, graphs.



Requirements:

Microsoft Excel

Desire to learn



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

File list
  • Udemy - Microsoft Excel for Data Analytics Statistics and Dashboard
  • ~Get Your Files Here !/1. What Is Data Analysis/1. Introduction to data analysis.mp4 10.6 MB
  • ~Get Your Files Here !/1. What Is Data Analysis/2. Steps in data analysis workflow.mp4 9.9 MB
  • ~Get Your Files Here !/2. What Is Hypothesis Testing/1. Understanding statistical analysis.mp4 30.4 MB
  • ~Get Your Files Here !/2. What Is Hypothesis Testing/2. Various elements of hypothesis testing.mp4 27.4 MB
  • ~Get Your Files Here !/2. What Is Hypothesis Testing/3. Steps in hypothesis testing.mp4 19.8 MB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/1. Dealing with missing values.mp4 127.1 MB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/2. Practice data - Missing values.html 115 B
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/2.1 PD - missing value.xlsx 16.4 KB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/3. Dealing with inconsistent values.mp4 69.5 MB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/4. Practice data - Inconsistent values.html 120 B
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/4.1 PD - Inconsistent value.xlsx 16.5 KB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/5. Dealing with outliers.mp4 62.8 MB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/6. Practice data - Outliers.html 109 B
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/6.1 PD - outliers.xlsx 14.8 KB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/7. Dealing with duplicated values.mp4 22.9 MB
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/8. Practice data - Duplicated values.html 118 B
  • ~Get Your Files Here !/3. Step 1 - Data Cleaning and Manipulation in Excel/8.1 PD - duplicates.xlsx 9.7 KB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/1. Install Excel Data Analysis Tool pack (If Necessary).html 316 B
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/2. Frequency and percentage analysis.mp4 87.4 MB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/3. Practice data - Frequency and percentage analysis.html 121 B
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/3.1 PD - FP analysis.xlsx 24.7 KB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/4. Descriptive analysis (mean, std. dev., skewness, etc.).mp4 107.7 MB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/5. Practice data - Descriptive analysis.html 108 B
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/5.1 PD - DA analysis.xlsx 19.3 KB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/6. Group by analysis in excel pivot table.mp4 110.2 MB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/7. Practice data - Group by analysis.html 149 B
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/7.1 PD - PVT analysis.xlsx 49.8 KB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/8. Crosstabulation analysis in excel pivot table.mp4 45.1 MB
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/9. Practice data - Crosstabulation analysis.html 149 B
  • ~Get Your Files Here !/4. Step 2 - Exploratory Data Analysis in Excel/9.1 PD - PVT analysis.xlsx 49.8 KB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/1. Independent sample t-test.mp4 107.5 MB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/10. Practice data - Regression analysis.html 107 B
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/10.1 PD - REG analysis.xlsx 21 KB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/2. Practice data - Independent sample t-test.html 113 B
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/2.1 PD - INDSTT analysis.xlsx 21.4 KB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/3. Paired sample t-test.mp4 63.6 MB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/4. Practice data - Paired sample t-test.html 108 B
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/4.1 PD - PRDSTT analysis.xlsx 16.9 KB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/5. Analysis of variance (ANOVA).mp4 76.9 MB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/6. Practice data - ANOVA.html 93 B
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/6.1 PD - ONANVA analysis.xlsx 15.3 KB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/7. Pearson correlation analysis.mp4 102 MB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/8. Practice data - Correlation analysis.html 108 B
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/8.1 PD - CORR analysis.xlsx 16.5 KB
  • ~Get Your Files Here !/5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel/9. Multiple linear regression analysis.mp4 141 MB
  • ~Get Your Files Here !/6. Final step - Putting All Together in Dashboard/1. Creating canvas for dashboard.mp4 58.8 MB
  • ~Get Your Files Here !/6. Final step - Putting All Together in Dashboard/2. Creating the final dashboard.mp4 87.3 MB
  • ~Get Your Files Here !/6. Final step - Putting All Together in Dashboard/3. Practice data - Dashboard.html 110 B
  • ~Get Your Files Here !/6. Final step - Putting All Together in Dashboard/3.1 Dashboard.xlsx 103.8 KB
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.