1. Welcome to the course.mp4 (21.78 MB)
10. Lookup Formulas (V Lookup, Hlookup, Index Match).mp4 (64.37 MB)
11. Future Value.mp4 (34.69 MB)
12. Excel Simple Interest and Compound Interest.mp4 (40.9 MB)
13. Net Present Value.mp4 (35.7 MB)
14. Internal Rate of Return.mp4 (32.6 MB)
15. EXCEL NPV and PV for calculating Present Value.mp4 (50.42 MB)
16. Excel Internal Rate of Return.mp4 (41.46 MB)
17. Excel NPV and IRR for particular dates.mp4 (16.86 MB)
18. Horizontal and Vertical Analysis.mp4 (18.56 MB)
19. Excel Vertical Analysis.mp4 (30.93 MB)
20. Excel Horizontal Analysis.mp4 (21.78 MB)
21. Loan Repayment concepts.mp4 (20.79 MB)
22. Excel Calculating Payments.mp4 (33.11 MB)
23. Excel Calculating Rate or Term.mp4 (11.56 MB)
24. Depreciation Methods and Straight Line Method.mp4 (18.62 MB)
25. Double Declining Balance Depreciation.mp4 (25.78 MB)
26. Sum of Years Digits Method.mp4 (21.51 MB)
27. Excel Calculating Depreciation.mp4 (32.39 MB)
28. Theory Financial Ratios.mp4 (58.08 MB)
29. Excel Building a Template for Financial Ratio Analysis.mp4 (70.62 MB)
3. Basic Formula Operations.mp4 (73.84 MB)
30. Financial Charts Introduction.mp4 (16.34 MB)
31. Excel Charts Categories of messages that can be conveyed.mp4 (19.98 MB)
32. Elements of charts.mp4 (29.34 MB)
33. The Easy way of creating charts.mp4 (21.7 MB)
34. Bar and column charts.mp4 (87.15 MB)
35. Formating charts.mp4 (96.27 MB)
36. Line Charts.mp4 (81.1 MB)
37. Area Charts.mp4 (41.57 MB)
38. Pie and Doughnut Charts.mp4 (93.89 MB)
39. Why we should avoid Pie charts.mp4 (17.01 MB)
4. This is a milestone!.mp4 (20.65 MB)
40. Scatter plot or XY chart.mp4 (121.09 MB)
41. Frequency Distribution and Histograms.mp4 (81.32 MB)
42. Stock Charts.mp4 (81.24 MB)
43. Sparklines.mp4 (42.38 MB)
44. Waterfall Chart.mp4 (76.2 MB)
45. Heat Maps.mp4 (38.88 MB)
46. Financial Dashboard Introduction.mp4 (23.96 MB)
47. Financial Dashboard Time Series of Profit & Profit Margin.mp4 (28.65 MB)
48. Financial Dashboard Trend of Revenue and Projection.mp4 (18.44 MB)
49. Financial Dashboard Expense Analysis using Pie Chart.mp4 (19.05 MB)
5. Mathematical Functions Part 1.mp4 (67.94 MB)
50. Financial Dashboard Target monitoring using Column chart.mp4 (25.96 MB)
51. Financial Dashboard Collating and Formatting to create a Dashboard.mp4 (41.49 MB)
52. Pivot Tables.mp4 (73.09 MB)
53. Pivot Charts.mp4 (69.34 MB)
54. Linear Regression Introduction.mp4 (5.32 MB)
55. Types of Data.mp4 (21.74 MB)
56. Types of Statistics.mp4 (10.93 MB)
57. Describing data Graphically.mp4 (65.41 MB)
58. Measures of Centers.mp4 (38.54 MB)
59. Measures of Dispersion.mp4 (22.86 MB)
6. Mathematical Functions Part 2.mp4 (56.16 MB)
60. Introduction to Machine Learning.mp4 (109.12 MB)
61. Building a Machine Learning Model.mp4 (39.46 MB)
62. Gathering Business Knowledge.mp4 (19.24 MB)
63. Data Exploration.mp4 (20.52 MB)
64. The Data and the Data Dictionary.mp4 (69.34 MB)
65. Univariate analysis and EDD.mp4 (24.2 MB)
66. Discriptive Data Analytics in Excel.mp4 (146.04 MB)
67. Outlier Treatment.mp4 (24.48 MB)
68. Identifying and Treating Outliers in Excel.mp4 (51.44 MB)
69. Missing Value Imputation.mp4 (24.98 MB)
7. Textual Formulas.mp4 (109.05 MB)
70. Identifying and Treating missing values in Excel.mp4 (49.58 MB)
71. Variable Transformation in Excel.mp4 (52.44 MB)
72. Dummy variable creation Handling qualitative data.mp4 (36.82 MB)
73. Dummy Variable Creation in Excel.mp4 (101.61 MB)
74. Correlation Analysis.mp4 (69.86 MB)
75. Creating Correlation Matrix in Excel.mp4 (88.84 MB)
76. The Problem Statement.mp4 (9.34 MB)
77. Basic Equations and Ordinary Least Squares (OLS) method.mp4 (43.37 MB)
78. Assessing accuracy of predicted coefficients.mp4 (92.14 MB)
79. Assessing Model Accuracy RSE and R squared.mp4 (43.63 MB)
8. Logical Formulas.mp4 (77.76 MB)
80. Creating Simple Linear Regression model.mp4 (27.05 MB)
81. Multiple Linear Regression.mp4 (34.32 MB)
82. The F statistic.mp4 (56.01 MB)
83. Interpreting results of Categorical variables.mp4 (22.5 MB)
84. Creating Multiple Linear Regression model.mp4 (84.2 MB)
85. Case Study Linear Regression Introduction.mp4 (7.87 MB)
86. Case study Linear Regression Data.mp4 (49.09 MB)
87. Case study Linear Regression Preprocessing.mp4 (80.81 MB)
88. Case study Linear Regression Results.mp4 (78.29 MB)
89. Case study Linear Regression Prediction.mp4 (83.16 MB)
9. Date Time Formulas.mp4 (48.85 MB)
91. The final milestone!.mp4 (11.86 MB)