Udemy - Excel Data Analysis for Professionals and Analysts

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Excel for Data Analysis
• 1. What is Data Analysis.mp4 (64.1 MB)
• 2. Why Use Excel for Data Analysis.mp4 (99.3 MB)
2 - Excel Basics Refresher
• 3. Workbook Structure and Navigation.mp4 (105.1 MB)
• 4. Data Types and Formatting Essentials.mp4 (92.6 MB)
• 5. Working with Tables and Named Ranges.mp4 (52.8 MB)
• 6. Keyboard Shortcuts for Productivity.mp4 (120.4 MB)
3 - Data Cleaning and Preparation
• 7. Identifying and Handling Missing Data.mp4 (43.6 MB)
• 8. Text-To-Columns, Flash Fill, and Find & Replace.mp4 (42.0 MB)
• 9. Data Validation and Drop-Down Lists.mp4 (23.7 MB)
4 - Essential Formulas for Analysis
• 10. Logical Formulas IF, AND, OR, IFERROR.mp4 (67.2 MB)
• 11. Lookup Formulas VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP.mp4 (60.9 MB)
• 12. Text Functions LEFT, RIGHT, MID, TRIM, LEN, CONCATENATE.mp4 (51.3 MB)
• 13. Date and Time Functions.mp4 (84.3 MB)
• 14. Nested and Dynamic Formulas.mp4 (83.4 MB)
5 - Data Aggregation and Summarization
• 15. Using SUMIF, COUNTIF, AVERAGEIF.mp4 (51.5 MB)
• 16. Dynamic Ranges with OFFSET and INDIRECT.mp4 (54.0 MB)
• 17. Conditional Formatting for Data Insights.mp4 (32.2 MB)
• 18. Subtotals and Grouping.mp4 (35.5 MB)
6 - Pivot Tables & Pivot Charts
• 19. Creating and Customizing Pivot Tables.mp4 (45.9 MB)
• 20. Filtering, Sorting and Grouping Data.mp4 (46.6 MB)
• 21. Calculated Fields and Custom Summaries.mp4 (45.0 MB)
• 22. Building Pivot Charts for Interactive Reports.mp4 (31.5 MB)
• Bonus Resources.txt (0.1 KB)