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)

https://rapidgator.net/file/7df297af7aca4c7ff1704c1cf9e3e9e3/
https://rapidgator.net/file/1d1e1629e515e40bcf608a32917dcd22/
https://rapidgator.net/file/5fec4b32b7ee4fcfccf3fcc49635d7f9/