Udemy - The Complete Microsoft Excel Data Analysis Bootcamp
- Type:
- Other > Other
- Files:
- 29
- Size:
- 2.35 GiB (2518522494 Bytes)
- Uploaded:
- 2024-09-23 12:27:12 GMT
- By:
- abdenna
- Seeders:
- 51
- Leechers:
- 1
- Comments
- 0
- Info Hash: 2D6B687E66D20462431375063B9F0DDB366B61EC
(Problems with magnets links are fixed by upgrading your torrent client!)
Description: Unlock the full potential of Microsoft Excel with "The Complete Microsoft Excel Data Analysis Bootcamp." This comprehensive course is designed to take you from a beginner to an advanced user, equipping you with the skills to perform powerful data analysis and make data-driven decisions confidently. Whether you’re a professional looking to enhance your data analysis skills, a student eager to learn one of the most valuable tools in the job market, or a business owner wanting to make more informed decisions, this bootcamp covers everything you need. You’ll learn to use Excel's robust features for data cleaning, analysis, visualization, and automation, mastering tools such as PivotTables, VLOOKUP, Power Query, and advanced charting techniques. Through step-by-step tutorials, real-world examples, and hands-on exercises, you’ll gain the knowledge to analyze large datasets, create insightful reports, and automate repetitive tasks, saving you time and effort. By the end of this course, you’ll be proficient in using Excel for data analysis, making you an invaluable asset in any data-driven role
Chapter_1-Module_1_Excel_Basics/1. Navigating the Excel Interface.mp4 | 71.9 MiB |
Chapter_1-Module_1_Excel_Basics/2. Basic Excel Functions and Formulas.mp4 | 67.75 MiB |
Chapter_1-Module_1_Excel_Basics/3. Entering and Editing Data.mp4 | 67.63 MiB |
Chapter_1-Module_1_Excel_Basics/4. Sorting and Filtering Data.mp4 | 74.04 MiB |
Chapter_1-Module_1_Excel_Basics/5. Data Validation.mp4 | 72.34 MiB |
Chapter_2-Module_2_Data_Cleaning_and_Preperation/10. Using Text Functions.mp4 | 97.79 MiB |
Chapter_2-Module_2_Data_Cleaning_and_Preperation/6. Removing Duplicates.mp4 | 52.37 MiB |
Chapter_2-Module_2_Data_Cleaning_and_Preperation/7. Handling Missing Values.mp4 | 86.65 MiB |
Chapter_2-Module_2_Data_Cleaning_and_Preperation/8. Data Transformation Techniques.mp4 | 83.74 MiB |
Chapter_2-Module_2_Data_Cleaning_and_Preperation/9. Structuring Data.mp4 | 79.72 MiB |
Chapter_3-Module_3_Data_Analysis_Techniques/11. Mean, Median, Mode.mp4 | 49.76 MiB |
Chapter_3-Module_3_Data_Analysis_Techniques/12. Standard Deviation and Variance.mp4 | 54.36 MiB |
Chapter_3-Module_3_Data_Analysis_Techniques/13. Data Visualization with Charts.mp4 | 104.12 MiB |
Chapter_3-Module_3_Data_Analysis_Techniques/14. Creating Pivot Tables.mp4 | 84.16 MiB |
Chapter_3-Module_3_Data_Analysis_Techniques/15. Analyzing Data with Pivot Tables.mp4 | 78.69 MiB |
Chapter_3-Module_3_Data_Analysis_Techniques/16. Using Pivot Charts for Visualization.mp4 | 103.78 MiB |
Chapter_4-Module_4_Advanced_Excel_Functions/17. IF, AND, OR Functions.mp4 | 74.58 MiB |
Chapter_4-Module_4_Advanced_Excel_Functions/18. Conditional Formatting.mp4 | 72.24 MiB |
Chapter_4-Module_4_Advanced_Excel_Functions/19. VLOOKUP, HLOOKUP, INDEX, MATCH.mp4 | 107.4 MiB |
Chapter_4-Module_4_Advanced_Excel_Functions/20. Using Dynamic Ranges.mp4 | 97.44 MiB |
Chapter_4-Module_4_Advanced_Excel_Functions/21. Install Data Analysis Toolpak.mp4 | 32.48 MiB |
Chapter_4-Module_4_Advanced_Excel_Functions/22. Using Analysis Tools (e.g., regression, correlation).mp4 | 101.52 MiB |
Chapter_5-Module_5_Data_Visualization/23. Types of Charts and their Uses.mp4 | 109.41 MiB |
Chapter_5-Module_5_Data_Visualization/24. Customizing Chart Elements.mp4 | 66.61 MiB |
Chapter_5-Module_5_Data_Visualization/25. Using Sparklines.mp4 | 66.2 MiB |
Chapter_5-Module_5_Data_Visualization/26. Creating Interactive Dashboards.mp4 | 97.66 MiB |
Chapter_6-Module_6_Case_Studies_and_Real_World_Applications/27. Analyzing Sales Data.mp4 | 111.9 MiB |
Chapter_6-Module_6_Case_Studies_and_Real_World_Applications/28. Monthly Budget Analysis.mp4 | 118.58 MiB |
Chapter_6-Module_6_Case_Studies_and_Real_World_Applications/29. Sales Projection and Forecast Calculation.mp4 | 117.04 MiB |