Udemy - Data Analysis Using Excel

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Introduction.mp4 (8.4 MB)
2 - Module1 Using Formulae
• 1 - Formula Introduction - StudentDataMaster.xlsx (31.7 KB)
• 1 - Formula Introduction.mp4 (2.9 MB)
• 10 - Finding the right Function.mp4 (36.6 MB)
• 11 - Conditional Counting in Excel.mp4 (138.5 MB)
• 12 - Using Name Manager in Formulae.mp4 (31.7 MB)
• 13 - Calculation Options in Formulae.mp4 (26.9 MB)
• 14 - Debugging Formulae - FormulaAuditingMaster.xlsx (11.5 KB)
• 14 - Debugging Formulae.mp4 (28.7 MB)
• 15 - Using Watch Window for Debugging.mp4 (16.6 MB)
• 2 - Creating first formula Summation Formula.mp4 (25.8 MB)
• 3 - Creating Mathematical Formulae and Using Named References.mp4 (28.5 MB)
• 4 - Creating Functions that work with text input.mp4 (42.0 MB)
• 5 - Creating Nested Functions.mp4 (25.9 MB)
• 6 - Creating Formula that use logical operators.mp4 (39.5 MB)
• 7 - Creating Nested Logical Functions.mp4 (30.2 MB)
• 8 - Using the lookup function.mp4 (59.3 MB)
• 9 - Functions that work with dates.mp4 (27.1 MB)
3 - Module2 Data Visualization Using Charts
• 1 - Charts Introduction - CreatingChartsMaster.xlsx (10.8 KB)
• 1 - Charts Introduction.mp4 (1.6 MB)
• 2 - Creating a simple chart.mp4 (20.3 MB)
• 3 - Options for Formatting Charts.mp4 (31.5 MB)
• 4 - Formatting Axis on Charts.mp4 (33.1 MB)
• 5 - Formatting Data on Charts.mp4 (22.7 MB)
• 6 - Formatting Legends And Gridlines on Charts.mp4 (10.9 MB)
• 7 - Changing Chart Styles, Chart Data and Chart Type.mp4 (40.9 MB)
• 8 - Adding Error Lines, Trend Lines Drop Lines in Charts.mp4 (36.6 MB)
• 9 - Selecting the most appropriate Chart.mp4 (21.2 MB)
4 - Module 3 Pivot Tables and Pivot Charts
• 1 - Pivot Table Introduction - PivotTablesMaster.xlsx (8.8 MB)
• 1 - Pivot Table Introduction.mp4 (3.6 MB)
• 10 - Formatting Pivot Tables.mp4 (71.7 MB)
• 11 - Creating Pivot Charts.mp4 (56.9 MB)
• 2 - Creating a Pivot Table.mp4 (34.6 MB)
• 3 - Creating Hierarchies In Pivot Table.mp4 (50.0 MB)
• 4 - Applying Filters In Pivot Table.mp4 (11.6 MB)
• 5 - Formulae In Pivot Tables.mp4 (16.2 MB)
• 6 - Data Comparison In Pivot Tables.mp4 (179.0 MB)
• 7 - Analyzing Individual Data Points in Pivot Table.mp4 (39.1 MB)
• 8 - Working with Slicers.mp4 (46.2 MB)
• 9 - Working with Timelines.mp4 (59.3 MB)
5 - Module 4 Adding Sparklines, Headers and Footers
• 1 - Introduction to Sparklines, Headers and Footers.mp4 (3.3 MB)
• 2 - Creating Sparklines.mp4 (24.5 MB)
• 3 - Features of a Sparklines.mp4 (25.6 MB)
• 4 - Types of Sparklines.mp4 (30.1 MB)
• 5 - Sparklines In Pivot Tables.mp4 (18.8 MB)
• 6 - Creating Headers and Footers.mp4 (24.1 MB)
• 7 - Header and Footer Features.mp4 (18.0 MB)
• 8 - Printing Headers and Footers.mp4 (12.2 MB)
6 - Module 5 Problem Solving Using Excel
• 1 - Introduction to Forecasting In Excel - ForecastingMaster.xlsx (8.8 MB)
• 1 - Introduction to Forecasting In Excel.mp4 (2.1 MB)
• 2 - Creating a Forecast.mp4 (8.2 MB)
• 3 - Forecasting Options.mp4 (40.6 MB)
• 4 - Forecasting Multiple Data Points.mp4 (9.7 MB)
• 5 - What If Analysis Goal Seek.mp4 (12.3 MB)
• 6 - What If Analysis Data Table.mp4 (13.9 MB)
• 7 - What If Analysis Scenario Manager.mp4 (17.7 MB)
• 8 - Using Solver Add-In.mp4 (34.4 MB)
7 - Module 6 Interactive Dashboard using Excel
• 1 - Introduction to Dashboards - DashboardMaster.xlsx (338.9 KB)
• 1 - Introduction to Dashboards.mp4 (1.6 MB)
• 2 - Dashboard Explained.mp4 (19.3 MB)
• 3 - Creating Pivot Tables.mp4 (9.6 MB)
• 4 - Creating Dashboard Slicers.mp4 (21.9 MB)
• 5 - Tying together Dashboard Elements.mp4 (42.3 MB)
8 - Recap
• 1 - Recap.mp4 (6.5 MB)
• Bonus Resources.txt (0.1 KB)