Udemy - Microsoft Excel for Data Analytics Statistics and Dashboa...
- Category Other
- Type Tutorials
- Language English
- Total size 1.3 GB
- Uploaded By freecoursewb
- Downloads 612
- Last checked 5 days ago
- Date uploaded 1 year ago
- Seeders 17
- Leechers 1
Microsoft Excel for Data Analytics Statistics and Dashboard
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
Files:
[ DevCourseWeb.com ] Udemy - Microsoft Excel for Data Analytics Statistics and Dashboard- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1. What Is Data Analysis
- 1. Introduction to data analysis.mp4 (10.6 MB)
- 2. Steps in data analysis workflow.mp4 (9.9 MB)
- 1. Understanding statistical analysis.mp4 (30.4 MB)
- 2. Various elements of hypothesis testing.mp4 (27.4 MB)
- 3. Steps in hypothesis testing.mp4 (19.8 MB)
- 1. Dealing with missing values.mp4 (127.1 MB)
- 2. Practice data - Missing values.html (0.1 KB)
- 2.1 PD - missing value.xlsx (16.4 KB)
- 3. Dealing with inconsistent values.mp4 (69.5 MB)
- 4. Practice data - Inconsistent values.html (0.1 KB)
- 4.1 PD - Inconsistent value.xlsx (16.5 KB)
- 5. Dealing with outliers.mp4 (62.8 MB)
- 6. Practice data - Outliers.html (0.1 KB)
- 6.1 PD - outliers.xlsx (14.8 KB)
- 7. Dealing with duplicated values.mp4 (22.9 MB)
- 8. Practice data - Duplicated values.html (0.1 KB)
- 8.1 PD - duplicates.xlsx (9.7 KB)
- 1. Install Excel Data Analysis Tool pack (If Necessary).html (0.3 KB)
- 2. Frequency and percentage analysis.mp4 (87.4 MB)
- 3. Practice data - Frequency and percentage analysis.html (0.1 KB)
- 3.1 PD - FP analysis.xlsx (24.7 KB)
- 4. Descriptive analysis (mean, std. dev., skewness, etc.).mp4 (107.7 MB)
- 5. Practice data - Descriptive analysis.html (0.1 KB)
- 5.1 PD - DA analysis.xlsx (19.3 KB)
- 6. Group by analysis in excel pivot table.mp4 (110.2 MB)
- 7. Practice data - Group by analysis.html (0.1 KB)
- 7.1 PD - PVT analysis.xlsx (49.8 KB)
- 8. Crosstabulation analysis in excel pivot table.mp4 (45.1 MB)
- 9. Practice data - Crosstabulation analysis.html (0.1 KB)
- 9.1 PD - PVT analysis.xlsx (49.8 KB)
- 1. Independent sample t-test.mp4 (107.5 MB)
- 10. Practice data - Regression analysis.html (0.1 KB)
- 10.1 PD - REG analysis.xlsx (21.0 KB)
- 2. Practice data - Independent sample t-test.html (0.1 KB)
- 2.1 PD - INDSTT analysis.xlsx (21.4 KB)
- 3. Paired sample t-test.mp4 (63.6 MB)
- 4. Practice data - Paired sample t-test.html (0.1 KB)
- 4.1 PD - PRDSTT analysis.xlsx (16.9 KB)
- 5. Analysis of variance (ANOVA).mp4 (76.9 MB)
- 6. Practice data - ANOVA.html (0.1 KB)
- 6.1 PD - ONANVA analysis.xlsx (15.3 KB)
- 7. Pearson correlation analysis.mp4 (102.0 MB)
- 8. Practice data - Correlation analysis.html (0.1 KB)
- 8.1 PD - CORR analysis.xlsx (16.5 KB)
- 9. Multiple linear regression analysis.mp4 (141.0 MB)
- 1. Creating canvas for dashboard.mp4 (58.8 MB)
- 2. Creating the final dashboard.mp4 (87.3 MB)
- 3. Practice data - Dashboard.html (0.1 KB)
- 3.1 Dashboard.xlsx (103.8 KB)
- Bonus Resources.txt (0.4 KB)
There are currently no comments. Feel free to leave one :)
Code:
- udp://tracker.torrent.eu.org:451/announce
- udp://tracker.tiny-vps.com:6969/announce
- http://tracker.foreverpirates.co:80/announce
- udp://tracker.cyberia.is:6969/announce
- udp://exodus.desync.com:6969/announce
- udp://explodie.org:6969/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://9.rarbg.to:2780/announce
- udp://tracker.internetwarriors.net:1337/announce
- udp://ipv4.tracker.harry.lu:80/announce
- udp://open.stealth.si:80/announce
- udp://9.rarbg.to:2900/announce
- udp://9.rarbg.me:2720/announce
- udp://opentor.org:2710/announce