Tutorialsplanet NET Udemy - Financial Analysis and Financial Modeling using MS Excel

1. 1. Introduction/1. Welcome to the course.mp421.78MB
2. 10. Case Study - Finance Dashboard/1. Financial Dashboard - Introduction.mp423.96MB
3. 10. Case Study - Finance Dashboard/2. Financial Dashboard - Time Series of Profit & Profit Margin.mp428.65MB
4. 10. Case Study - Finance Dashboard/3. Financial Dashboard - Trend of Revenue and Projection.mp418.44MB
5. 10. Case Study - Finance Dashboard/4. Financial Dashboard - Expense Analysis using Pie Chart.mp419.06MB
6. 10. Case Study - Finance Dashboard/5. Financial Dashboard - Target monitoring using Column chart.mp425.96MB
7. 10. Case Study - Finance Dashboard/6. Financial Dashboard - Collating and Formatting to create a Dashboard.mp441.49MB
8. 11. Pivot Tables/1. Pivot Tables.mp473.09MB
9. 11. Pivot Tables/2. Pivot Charts.mp469.35MB
10. 12. Predictive Analytics - Introduction/1. Linear Regression - Introduction.mp45.32MB
11. 13. Basics of Statistics/1. Types of Data.mp422.71MB
12. 13. Basics of Statistics/2. Types of Statistics.mp411.36MB
13. 13. Basics of Statistics/3. Describing data Graphically.mp469.27MB
14. 13. Basics of Statistics/4. Measures of Centers.mp440.79MB
15. 13. Basics of Statistics/5. Measures of Dispersion.mp424.68MB
16. 14. Machine Learning -Introduction/1. Introduction to Machine Learning.mp4109.12MB
17. 14. Machine Learning -Introduction/2. Building a Machine Learning Model.mp439.46MB
18. 15. Getting Data Ready for Regression Model/1. Gathering Business Knowledge.mp419.24MB
19. 15. Getting Data Ready for Regression Model/10. Variable Transformation in Excel.mp452.44MB
20. 15. Getting Data Ready for Regression Model/11. Dummy variable creation Handling qualitative data.mp436.82MB
21. 15. Getting Data Ready for Regression Model/12. Dummy Variable Creation in Excel.mp4101.61MB
22. 15. Getting Data Ready for Regression Model/13. Correlation Analysis.mp469.86MB
23. 15. Getting Data Ready for Regression Model/14. Creating Correlation Matrix in Excel.mp488.84MB
24. 15. Getting Data Ready for Regression Model/2. Data Exploration.mp420.52MB
25. 15. Getting Data Ready for Regression Model/3. The Data and the Data Dictionary.mp469.34MB
26. 15. Getting Data Ready for Regression Model/4. Univariate analysis and EDD.mp424.2MB
27. 15. Getting Data Ready for Regression Model/5. Discriptive Data Analytics in Excel.mp4146.05MB
28. 15. Getting Data Ready for Regression Model/6. Outlier Treatment.mp424.48MB
29. 15. Getting Data Ready for Regression Model/7. Identifying and Treating Outliers in Excel.mp451.44MB
30. 15. Getting Data Ready for Regression Model/8. Missing Value Imputation.mp424.98MB
31. 15. Getting Data Ready for Regression Model/9. Identifying and Treating missing values in Excel.mp449.58MB
32. 16. Creating Regression Model/1. The Problem Statement.mp49.34MB
33. 16. Creating Regression Model/2. Basic Equations and Ordinary Least Squares (OLS) method.mp443.37MB
34. 16. Creating Regression Model/3. Assessing accuracy of predicted coefficients.mp492.14MB
35. 16. Creating Regression Model/4. Assessing Model Accuracy RSE and R squared.mp443.63MB
36. 16. Creating Regression Model/5. Creating Simple Linear Regression model.mp427.05MB
37. 16. Creating Regression Model/6. Multiple Linear Regression.mp434.32MB
38. 16. Creating Regression Model/7. The F - statistic.mp456.01MB
39. 16. Creating Regression Model/8. Interpreting results of Categorical variables.mp422.5MB
40. 16. Creating Regression Model/9. Creating Multiple Linear Regression model.mp484.2MB
41. 17. Finance Case Study - Linear Regression/1. Case Study Linear Regression - Introduction.mp47.87MB
42. 17. Finance Case Study - Linear Regression/2. Case study Linear Regression - Data.mp449.09MB
43. 17. Finance Case Study - Linear Regression/3. Case study Linear Regression - Preprocessing.mp480.81MB
44. 17. Finance Case Study - Linear Regression/4. Case study Linear Regression - Results.mp478.29MB
45. 17. Finance Case Study - Linear Regression/5. Case study Linear Regression - Prediction.mp483.17MB
46. 2. Prerequisites Excel formulas and functions/1. Basic Formula Operations.mp473.84MB
47. 2. Prerequisites Excel formulas and functions/2. Mathematical Formulas.mp4109.51MB
48. 2. Prerequisites Excel formulas and functions/3. Textual Formulas.mp4109.06MB
49. 2. Prerequisites Excel formulas and functions/4. Logical Formulas.mp477.76MB
50. 2. Prerequisites Excel formulas and functions/5. Date-Time Formulas.mp448.85MB
51. 2. Prerequisites Excel formulas and functions/6. Lookup Formulas_(V Lookup, Hlookup, Index-Match).mp464.37MB
52. 3. Time Value of Money/1. Future Value.mp434.69MB
53. 3. Time Value of Money/2. Excel Simple Interest and Compound Interest.mp440.9MB
54. 3. Time Value of Money/3. Net Present Value.mp435.7MB
55. 3. Time Value of Money/4. Internal Rate of Return.mp432.6MB
56. 3. Time Value of Money/5. EXCEL NPV and PV for calculating Present Value.mp450.42MB
57. 3. Time Value of Money/6. Excel Internal Rate of Return.mp441.46MB
58. 3. Time Value of Money/7. Excel NPV and IRR for particular dates.mp416.86MB
59. 4. Analysis of Profit and Loss Statement/1. Horizontal and Vertical Analysis.mp418.56MB
60. 4. Analysis of Profit and Loss Statement/2. Excel Vertical Analysis.mp430.93MB
61. 4. Analysis of Profit and Loss Statement/3. Excel Horizontal Analysis.mp421.78MB
62. 5. Loan Repayment Calculations/1. Loan Repayment concepts.mp420.79MB
63. 5. Loan Repayment Calculations/2. Excel Calculating Payments.mp433.11MB
64. 5. Loan Repayment Calculations/3. Excel Calculating Rate or Term.mp411.56MB
65. 6. Methods of calculating Depreciation/1. Depreciation Methods and Straight Line Method.mp418.62MB
66. 6. Methods of calculating Depreciation/2. Double Declining Balance Depreciation.mp425.78MB
67. 6. Methods of calculating Depreciation/3. Sum of Years Digits Method.mp421.51MB
68. 6. Methods of calculating Depreciation/4. Excel Calculating Depreciation.mp432.39MB
69. 7. Financial Ratio Analysis/1. Theory Financial Ratios.mp458.08MB
70. 7. Financial Ratio Analysis/2. Excel Building a Template for Financial Ratio Analysis.mp470.62MB
71. 8. Financial Charts and Dashboards - Introduction/1. Financial Charts - Introduction.mp416.34MB
72. 9. Charts and Dashboards using Excel/1. Excel Charts - Categories of messages that can be conveyed.mp419.98MB
73. 9. Charts and Dashboards using Excel/10. Scatter plot or XY chart.mp4121.09MB
74. 9. Charts and Dashboards using Excel/11. Frequency Distribution and Histograms.mp481.32MB
75. 9. Charts and Dashboards using Excel/12. Stock Charts.mp481.24MB
76. 9. Charts and Dashboards using Excel/13. Sparklines.mp442.38MB
77. 9. Charts and Dashboards using Excel/14. Waterfall Chart.mp476.21MB
78. 9. Charts and Dashboards using Excel/15. Heat Maps.mp438.88MB
79. 9. Charts and Dashboards using Excel/2. Elements of charts.mp429.34MB
80. 9. Charts and Dashboards using Excel/3. The Easy way of creating charts.mp421.7MB
81. 9. Charts and Dashboards using Excel/4. Bar and column charts.mp487.15MB
82. 9. Charts and Dashboards using Excel/5. Formating charts.mp496.27MB
83. 9. Charts and Dashboards using Excel/6. Line Charts.mp481.1MB
84. 9. Charts and Dashboards using Excel/7. Area Charts.mp441.58MB
85. 9. Charts and Dashboards using Excel/8. Pie and Doughnut Charts.mp493.89MB
86. 9. Charts and Dashboards using Excel/9. Why we should avoid Pie charts.mp417.01MB