Udemy - Microsoft Excel - Master Data Analysis, Cleaning and Dash...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Excel for Data Analysis
• 1 - Understanding the Excel Interface.mp4 (58.0 MB)
• 2 - Importing Data into Excel.mp4 (55.6 MB)
• 3 - Formatting Data for Analysis.mp4 (73.9 MB)
2 - Data Cleaning and Preparation
• 1 - Removing Duplicates.mp4 (37.3 MB)
• 2 - Handling Missing Data.mp4 (55.2 MB)
• 3 - Standardizing Data Formats.mp4 (80.3 MB)
• 4 - Using CONCATENATE, LEFT, RIGHT, and MID.mp4 (57.7 MB)
• 5 - TRIM, CLEAN, and SUBSTITUTE Functions.mp4 (59.2 MB)
• 6 - Sorting and Filtering Data.mp4 (61.4 MB)
• 7 - Using Conditional Formatting.mp4 (70.5 MB)
3 - Data Analysis Fundamentals
• 1 - SUM, AVERAGE, COUNT, and COUNTA.mp4 (52.3 MB)
• 2 - Logical Functions IF, AND, OR.mp4 (82.8 MB)
• 3 - Lookup Functions VLOOKUP, HLOOKUP, XLOOKUP.mp4 (73.8 MB)
• 4 - Creating and Formatting Pivot Tables.mp4 (62.3 MB)
• 5 - Grouping Data and Summarizing Values.mp4 (48.9 MB)
• 6 - Using Calculated Fields and Items.mp4 (58.9 MB)
• 7 - Exploring What-If Analysis Goal Seek, Data Tables, Scenario Manager.mp4 (73.4 MB)
4 - Data Visualization
• 1 - Creating Bar, Line, and Pie Charts.mp4 (42.9 MB)
• 2 - Customizing Chart Styles and Layouts.mp4 (59.3 MB)
• 3 - Choosing The Right Chart for Your Data.mp4 (64.9 MB)
• 4 - Creating Combo Charts.mp4 (48.5 MB)
• 5 - Linking Charts to Dynamic Data.mp4 (59.5 MB)
5 - Advanced Data Analysis Techniques
• 1 - Descriptive statistics (mean, median, mode).mp4 (32.3 MB)
• 2 - Variance and standard deviation.mp4 (51.9 MB)
• 3 - Using Analysis ToolPak for statistical function.mp4 (59.0 MB)
• 4 - Introduction to Power Query.mp4 (32.6 MB)
• 5 - Transforming and Shaping Dat.mp4 (59.0 MB)
• 6 - Merging and Appending Data.mp4 (77.9 MB)
• 7 - Creating Data Models.mp4 (54.6 MB)
• 8 - Relationships Between Tables.mp4 (56.3 MB)
• Bonus Resources.txt (0.1 KB)