Udemy - Excel Data Analysis - Build Professional Dashboards and R...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Data Analysis with Excel
• 1 - Introduction to Data Analysis Concepts.mp4 (79.6 MB)
• 2 - Data Entry and Validation.mp4 (39.0 MB)
• 3 - Data Cleaning and Transformation Techniques Removing Duplicates Handling Missi.mp4 (47.6 MB)
2 - Excel Functions and Formulas for Data Analysis
• 4 - Essential Excel Functions SUM AVERAGE COUNT IF VLOOKUP INDEXMATCH.mp4 (32.6 MB)
• 5 - Array Formulas and Their Applications.mp4 (39.4 MB)
• 6 - Building Complex Formulas for Specific Analysis Needs.mp4 (35.8 MB)
3 - Pivot Tables and Charts
• 10 - Creating Interactive Charts Column Bar Line Pie Scatter.mp4 (109.4 MB)
• 7 - Creating and Customizing Pivot Tables.mp4 (71.0 MB)
• 8 - Summarizing Data Using Different Aggregation Methods.mp4 (68.9 MB)
• 9 - Filtering and Sorting Data in Pivot Tables.mp4 (74.6 MB)
4 - Dashboard Development
• 11 - Using Excels Charting Tools for Dashboard Creation.mp4 (87.7 MB)
• 12 - Adding Conditional Formatting for Visual Insights.mp4 (53.8 MB)
5 - Data Analysis Techniques
• 13 - Trend Analysis and Forecasting.mp4 (40.2 MB)
• 14 - Whatif Analysis Using Scenarios and Goal Seek.mp4 (51.6 MB)
• 15 - Statistical Analysis Using Excels Builtin Tools.mp4 (84.2 MB)
• 16 - Data Mining Techniques Basic Concepts.mp4 (70.1 MB)
• 17 - Correlation and Regression Analysis.mp4 (148.0 MB)
6 - Advanced Excel Features
• 18 - Introduction to Macros and VBA for Automation.mp4 (99.6 MB)
• 19 - Recording and Editing Macros.mp4 (73.9 MB)
• 20 - Creating Custom Functions Using VBA.mp4 (83.8 MB)
• 21 - Working with Power Query for Advanced Data Transformation.mp4 (58.0 MB)
7 - Data Visualization and Reporting
• 22 - Creating Compelling Charts and Graphs.mp4 (74.7 MB)
• 23 - Communicating Data Insights Clearly and Concisely.mp4 (102.1 MB)
• Bonus Resources.txt (0.1 KB)