FreeAllCourse Com Udemy- The Complete Financial Analyst Course 2020

1. 1. Welcome! Course Introduction/1. What Does the Course Cover.mp478.16MB
2. 1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.mp425.7MB
3. 1. Welcome! Course Introduction/3. The Best Way to Take This Course.mp431.91MB
4. 10. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp415.07MB
5. 10. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.mp438.94MB
6. 10. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.mp421.51MB
7. 10. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp445.96MB
8. 10. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.mp436.27MB
9. 10. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.mp445.22MB
10. 10. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.mp413.18MB
11. 10. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.mp414.38MB
12. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/1. Introduction to the Case Study.mp426.74MB
13. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/10. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp436.4MB
14. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/11. Getting Fancy with Excel Slicers.mp435.81MB
15. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/12. This is How the Report Can be Used in Practice by High-level Executives.mp440.84MB
16. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/2. Working with an SAP Data Extraction.mp439.19MB
17. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/3. Preliminary Mapping of the Data Extraction.mp431.17MB
18. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/4. Creating an Output Structure of the FMCG Model.mp422.17MB
19. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/5. Improving the Layout and Appearance of the FMCG Report.mp427.13MB
20. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/6. Inserting Formulas and Automating Calculations.mp418.09MB
21. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp421.78MB
22. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp454.16MB
23. 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/9. GETPIVOTDATA fix.mp413.62MB
24. 12. Modeling in Excel - Building a Complete 3-statement Model/1. Introduction to the Exercise.mp436.65MB
25. 12. Modeling in Excel - Building a Complete 3-statement Model/2. Let's Create a Mapping of Financials.mp430.73MB
26. 12. Modeling in Excel - Building a Complete 3-statement Model/3. Building an Output P&L Sheet.mp430.55MB
27. 12. Modeling in Excel - Building a Complete 3-statement Model/4. Filling in the Output P&L Sheet with Historical Financials.mp423.9MB
28. 12. Modeling in Excel - Building a Complete 3-statement Model/5. Calculating Percentage Variances and Applying Conditional Formatting.mp427.21MB
29. 12. Modeling in Excel - Building a Complete 3-statement Model/6. Building an Output Balance Sheet.mp429.48MB
30. 12. Modeling in Excel - Building a Complete 3-statement Model/7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.mp443.48MB
31. 12. Modeling in Excel - Building a Complete 3-statement Model/8. Adding the Forecast Period.mp432.16MB
32. 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/1. Calculating Historical Percentage Ratios and Use INDEX and MATCH for Scenarios.mp449.35MB
33. 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/2. Building a Flexible Model with CHOOSE & MATCH.mp416.06MB
34. 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/3. Building a Flexible Model with VLOOKUP & COLUMNS.mp436.26MB
35. 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp444.49MB
36. 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp430.53MB
37. 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/1. Building a Fixed Asset Roll Forward.mp440.93MB
38. 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/2. Building a Financial Liabilities Schedule.mp447.54MB
39. 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/3. Building an Equity Schedule.mp436.56MB
40. 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/4. Preparing a Cash Flow Structure.mp415.19MB
41. 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/5. Calculating Cash Flows and Completing the Model.mp457.47MB
42. 15. Accounting - Introduction to Accounting & Bookkeeping/1. Accounting The Science Behind Financial Figures.mp432.88MB
43. 15. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.mp464.04MB
44. 15. Accounting - Introduction to Accounting & Bookkeeping/3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp426.68MB
45. 15. Accounting - Introduction to Accounting & Bookkeeping/4. An Introduction to Financial Accounting.mp431.94MB
46. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/1. The Different Types of Accounting Standards.mp421.66MB
47. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/10. Types of Liabilities.mp427.49MB
48. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/11. Liability Categories - Practical Example.mp423.84MB
49. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/12. Equity.mp415.01MB
50. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/2. The Three Financial Statements.mp411.81MB
51. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/3. Types of Revenues.mp426.53MB
52. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/4. Types of Revenues - Exercise.mp418.61MB
53. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/5. Types of Expenses.mp445.17MB
54. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/6. Income Taxes.mp417.9MB
55. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/7. Depreciation & Amortization.mp440.12MB
56. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/8. Types of Assets.mp431.77MB
57. 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/9. Asset Categories - Practical Example.mp429.13MB
58. 17. Accounting - Revenue Recognition/1. Accrual Accounting.mp413.65MB
59. 17. Accounting - Revenue Recognition/2. Revenue Recognition Criteria - Technical.mp432.24MB
60. 17. Accounting - Revenue Recognition/3. Potential Conflicts of Interest When Recognizing Revenue.mp418.78MB
61. 17. Accounting - Revenue Recognition/4. A Practical Example.mp439.52MB
62. 18. Accounting - Cost Recognition/1. Technical Aspects of Cost Recognition.mp427.66MB
63. 18. Accounting - Cost Recognition/2. The Two Types of Income Statement Formats.mp47.28MB
64. 19. Accounting - Understanding the Big Picture Why, What, When, and How Much/1. The Revenue Recognition Principle - Why Is It So Important.mp424.37MB
65. 19. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.mp425.24MB
66. 2. Microsoft Excel - Quick Introduction/1. Microsoft Excel The World's #1 Office Software.mp422.03MB
67. 2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.mp421.93MB
68. 2. Microsoft Excel - Quick Introduction/11. Work Efficiently by Using Cut, Copy, and Paste.mp414.47MB
69. 2. Microsoft Excel - Quick Introduction/13. Pasting Values, Formulas and Formats with Paste Special.mp410.97MB
70. 2. Microsoft Excel - Quick Introduction/2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp422.75MB
71. 2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.mp417.35MB
72. 2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.mp444.83MB
73. 2. Microsoft Excel - Quick Introduction/6. Inserting, Deleting, and Modifying Rows & Columns.mp412.35MB
74. 2. Microsoft Excel - Quick Introduction/8. Excel Formulas for Beginners.mp414.45MB
75. 20. Accounting - The Core Principles of Accounting/1. The Accounting Equation and Its Importance.mp424.48MB
76. 20. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.mp416.1MB
77. 20. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.mp421.38MB
78. 20. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.mp413.32MB
79. 20. Accounting - The Core Principles of Accounting/5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp424.09MB
80. 21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp468.36MB
81. 21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp446.41MB
82. 21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp453.35MB
83. 21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp458.94MB
84. 22. Accounting - The Importance of Timing/1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp413.23MB
85. 22. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.mp426.87MB
86. 22. Accounting - The Importance of Timing/3. Timing of Expenses Principles of Cost Recognition.mp415.8MB
87. 22. Accounting - The Importance of Timing/4. The Four Type of Accruals Arising in Accounting Transactions.mp449.58MB
88. 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp427.65MB
89. 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The Three Parts of Cash Flow Statements Explained.mp419.99MB
90. 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/3. Cash Flow Computations - The Direct Method.mp419.72MB
91. 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/4. Cash Flow Computations - The Indirect Method.mp431.38MB
92. 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5. Calculating Cash Flow in Practice A Complete Example.mp450.62MB
93. 24. Advanced Accounting - Trade Receivables/1. Why a Company Needs to Pay Attention to Trade Receivables.mp425.22MB
94. 24. Advanced Accounting - Trade Receivables/2. What If Clients Do Not Pay on Time.mp426.47MB
95. 24. Advanced Accounting - Trade Receivables/3. How to Handle Non-paying Customers A Case-study.mp424.94MB
96. 24. Advanced Accounting - Trade Receivables/4. A Technique to Collect Trade Receivables Sooner.mp415.44MB
97. 25. Advanced Accounting - Inventory/1. The Different Types of Inventory We Can Have.mp426.66MB
98. 25. Advanced Accounting - Inventory/2. The Connection Between Cost of Goods Sold and Inventory.mp417.24MB
99. 25. Advanced Accounting - Inventory/3. Cost Flow Methods.mp428.71MB
100. 25. Advanced Accounting - Inventory/4. Cost Flow Methods - a Practical Exercise.mp46.75MB
101. 26. Advanced Accounting - Fixed Assets/1. The Different Types of Fixed Assets.mp420.72MB
102. 26. Advanced Accounting - Fixed Assets/2. Capitalizing Interest Expenses.mp47.66MB
103. 26. Advanced Accounting - Fixed Assets/3. Fair Value Accounting.mp424.26MB
104. 26. Advanced Accounting - Fixed Assets/4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp435.29MB
105. 26. Advanced Accounting - Fixed Assets/5. The Revaluation Model.mp439.05MB
106. 26. Advanced Accounting - Fixed Assets/6. The Revaluation Model - Practical Exercise.mp437.99MB
107. 26. Advanced Accounting - Fixed Assets/7. Intangible Assets Created Internally.mp417.7MB
108. 27. Advanced Accounting - Trade Payables/1. How We Account for Trade Payables.mp422.53MB
109. 27. Advanced Accounting - Trade Payables/2. What Is the Difference Between Accounts Payable and Notes Payable.mp410.89MB
110. 27. Advanced Accounting - Trade Payables/3. Why Use E-invoicing.mp425.92MB
111. 28. Advanced Accounting - Financial Liabilities/1. The Difference Between Debt and Equity.mp414.8MB
112. 28. Advanced Accounting - Financial Liabilities/2. Amortizing a Loan.mp420.65MB
113. 28. Advanced Accounting - Financial Liabilities/3. Debt Covenants.mp425.78MB
114. 28. Advanced Accounting - Financial Liabilities/4. Debt Covenants - A Practical Example.mp413.67MB
115. 29. Advanced Accounting - Leasing Liabilties/1. The Reason Companies Lease Assets.mp411.11MB
116. 29. Advanced Accounting - Leasing Liabilties/2. Solving a Complete Leasing Exercise.mp438.17MB
117. 3. Microsoft Excel - Useful Tools/1. Inserting a Line Break with Alt + Enter.mp46.17MB
118. 3. Microsoft Excel - Useful Tools/2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp413.87MB
119. 3. Microsoft Excel - Useful Tools/4. Create Easily Printable Excel Documents.mp49.2MB
120. 3. Microsoft Excel - Useful Tools/5. How to Wrap Text in Excel and Adjust a Cell's Size.mp43.79MB
121. 3. Microsoft Excel - Useful Tools/6. Insert Hyperlinks into Excel Spreadsheets.mp48.25MB
122. 3. Microsoft Excel - Useful Tools/7. Using Excel's Freeze Panes to Handle Large Datasets.mp415.25MB
123. 3. Microsoft Excel - Useful Tools/8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp49.18MB
124. 3. Microsoft Excel - Useful Tools/9. A Quick Introduction to Excel's Pivot Tables.mp425.37MB
125. 30. Advanced Accounting - Using Leverage/1. What is Leverage and Why Companies Use Financial Leverage.mp457.42MB
126. 30. Advanced Accounting - Using Leverage/2. The Implications of Using Excessive Leverage.mp434.49MB
127. 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/1. The Different Types of Equity.mp455.22MB
128. 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/2. Raising Equity in Different Stages of a Company's Lifecycle.mp471.95MB
129. 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/3. The Types of Dividends Companies Pay to Shareholders.mp444.87MB
130. 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/4. Dividend Payments - a Timeline.mp436.18MB
131. 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/5. What Are Share Repurchases and Why Companies Do Them.mp443.91MB
132. 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/6. The Idea Behind Stock Splits.mp436.05MB
133. 32. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.mp427.34MB
134. 32. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.mp474.9MB
135. 32. Financial Statement Analysis - An Introduction/3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp425.84MB
136. 32. Financial Statement Analysis - An Introduction/4. Indispensable Tools for Financial Statement Analysis.mp415.32MB
137. 33. Financial Statement Analysis - Subtleties/1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp418.45MB
138. 33. Financial Statement Analysis - Subtleties/2. First Steps in Financial Statement Analysis.mp432.03MB
139. 33. Financial Statement Analysis - Subtleties/3. Horizontal vs. Vertical Financial Statement Analysis.mp428.21MB
140. 33. Financial Statement Analysis - Subtleties/4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp411.85MB
141. 33. Financial Statement Analysis - Subtleties/5. Using Accounting Ratios to Assess Business Performance.mp436.8MB
142. 34. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp455.77MB
143. 34. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp436.92MB
144. 34. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.mp418.74MB
145. 35. Financial Statement Analysis - Tesla Exercise/1. What You Will See Next In This Section.mp418.33MB
146. 35. Financial Statement Analysis - Tesla Exercise/2. How to Download Tesla's Historical Financials.mp414.4MB
147. 35. Financial Statement Analysis - Tesla Exercise/3. Calculating and Analyzing Growth and Profitability Ratios.mp496.5MB
148. 35. Financial Statement Analysis - Tesla Exercise/4. Calculating and Analyzing Liquidity Ratios.mp474.95MB
149. 35. Financial Statement Analysis - Tesla Exercise/5. Calculating and Analyzing Solvency Ratios.mp420.03MB
150. 36. Working Capital Management/1. Introduction.mp423.42MB
151. 36. Working Capital Management/10. Symptoms of Inefficient Working Capital - Trade Payables.mp417.94MB
152. 36. Working Capital Management/2. The Importance of Working Capital Optimization Case Study.mp489.97MB
153. 36. Working Capital Management/3. Overtrading vs. Excessive Investment.mp433.11MB
154. 36. Working Capital Management/4. Trade Receivables Management.mp476.14MB
155. 36. Working Capital Management/5. Re-order Level.mp431.3MB
156. 36. Working Capital Management/6. Economic Order Quantity (EOQ).mp431.85MB
157. 36. Working Capital Management/7. Inventory Optimization Techniques.mp450.48MB
158. 36. Working Capital Management/8. Trade Payables Management.mp419.27MB
159. 36. Working Capital Management/9. Working Capital Optimization - a Roadmap.mp448.18MB
160. 38. Finance 101 - The Time Value of Money and Interest Rate Components/1. Finance 101 Important Financial Principles That You Will Need.mp416.09MB
161. 38. Finance 101 - The Time Value of Money and Interest Rate Components/2. Understanding the Time Value of Money.mp46.22MB
162. 38. Finance 101 - The Time Value of Money and Interest Rate Components/3. How Interest Rates Play an Important Role in the Economy.mp413.75MB
163. 38. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.mp416.63MB
164. 38. Finance 101 - The Time Value of Money and Interest Rate Components/5. What Is Libor and What Purpose Does It Serve.mp417.13MB
165. 38. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.mp417.02MB
166. 38. Finance 101 - The Time Value of Money and Interest Rate Components/7. What Is Default Risk and How Does a Bank Account For It.mp431.16MB
167. 38. Finance 101 - The Time Value of Money and Interest Rate Components/8. Corporate Loan Specifics.mp425.76MB
168. 39. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.mp429.79MB
169. 39. Finance 101 - The Value of Cash Flows with Different Timing/2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp429.11MB
170. 4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp413.84MB
171. 4. Microsoft Excel - Best Practices That Will Make a Difference/10. Find and Select Cells That Meet Specific Conditions.mp413.45MB
172. 4. Microsoft Excel - Best Practices That Will Make a Difference/12. How to Create Dynamic Names in Excel Spreadsheets.mp415.15MB
173. 4. Microsoft Excel - Best Practices That Will Make a Difference/14. Using Named Ranges to Make Formulas More Readable.mp49.11MB
174. 4. Microsoft Excel - Best Practices That Will Make a Difference/15. Custom Number Formatting.mp49.89MB
175. 4. Microsoft Excel - Best Practices That Will Make a Difference/16. How to Add a Drop-down List in Excel.mp416.29MB
176. 4. Microsoft Excel - Best Practices That Will Make a Difference/17. Using Custom-sort to Sort Multiple Columns Within a Table.mp413.57MB
177. 4. Microsoft Excel - Best Practices That Will Make a Difference/18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp445.95MB
178. 4. Microsoft Excel - Best Practices That Will Make a Difference/19. Multiply by 1.mp414.84MB
179. 4. Microsoft Excel - Best Practices That Will Make a Difference/2. Macros Are a Great Timesaver! Here's Why..mp421.41MB
180. 4. Microsoft Excel - Best Practices That Will Make a Difference/20. Find and Replace - References.mp424.05MB
181. 4. Microsoft Excel - Best Practices That Will Make a Difference/21. Find and Replace - Formatting.mp413.78MB
182. 4. Microsoft Excel - Best Practices That Will Make a Difference/22. Green References.mp412.6MB
183. 4. Microsoft Excel - Best Practices That Will Make a Difference/23. Beauty Saving - The Professional Way of Saving Files.mp414.03MB
184. 4. Microsoft Excel - Best Practices That Will Make a Difference/24. The Power of F2.mp417.73MB
185. 4. Microsoft Excel - Best Practices That Will Make a Difference/25. Conditional Formatting.mp458.7MB
186. 4. Microsoft Excel - Best Practices That Will Make a Difference/3. How to Use the Same Macro On Multiple Workbooks.mp412.76MB
187. 4. Microsoft Excel - Best Practices That Will Make a Difference/5. The Secret to Faster Scrolling in Excel.mp420.84MB
188. 4. Microsoft Excel - Best Practices That Will Make a Difference/6. Be even quicker F5 + Enter.mp419.78MB
189. 4. Microsoft Excel - Best Practices That Will Make a Difference/8. Using Absolute and Relative Cell References.mp427.03MB
190. 40. Finance 101 - Loan Calculations/1. Using Annuities.mp424.24MB
191. 40. Finance 101 - Loan Calculations/2. Calculating a Complete Loan Schedule.mp449.62MB
192. 40. Finance 101 - Loan Calculations/3. COURSE CHALLENGE - Part 3.mp413.88MB
193. 41. Capital Budgeting - Basic Notions/1. What is Capital Budgeting.mp413.24MB
194. 41. Capital Budgeting - Basic Notions/2. When Do We Use Capital Budgeting.mp420.52MB
195. 41. Capital Budgeting - Basic Notions/3. The Time Value of Money in a Capital Budgeting Setting.mp418.9MB
196. 41. Capital Budgeting - Basic Notions/4. Calculating Present and Future Value.mp437.5MB
197. 41. Capital Budgeting - Basic Notions/5. Cost of Equity.mp455.84MB
198. 41. Capital Budgeting - Basic Notions/6. Project-specific Beta.mp427.2MB
199. 41. Capital Budgeting - Basic Notions/7. The Weighted Average Cost of Capital (WACC).mp415.71MB
200. 41. Capital Budgeting - Basic Notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp424.31MB
201. 41. Capital Budgeting - Basic Notions/9. Modeling Future Cash Flows.mp454.39MB
202. 42. Capital Budgeting - A Complete Case Study/1. An Introduction to the Case Study.mp425.3MB
203. 42. Capital Budgeting - A Complete Case Study/10. Estimating Cost of Equity.mp440.38MB
204. 42. Capital Budgeting - A Complete Case Study/11. Discounting Project Cash Flows.mp425.9MB
205. 42. Capital Budgeting - A Complete Case Study/12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp443.05MB
206. 42. Capital Budgeting - A Complete Case Study/2. Organizing Inputs In the Drivers Sheet.mp438.16MB
207. 42. Capital Budgeting - A Complete Case Study/3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp434.74MB
208. 42. Capital Budgeting - A Complete Case Study/4. Preparing a Fixed Asset Rollforward Schedule.mp447.36MB
209. 42. Capital Budgeting - A Complete Case Study/5. Calculating the Cash Impact of Extra Working Capital Required.mp418.35MB
210. 42. Capital Budgeting - A Complete Case Study/6. Debt Repayment and Interest Expenses Calculation.mp422.13MB
211. 42. Capital Budgeting - A Complete Case Study/7. The Project's P&L Sheet.mp413.93MB
212. 42. Capital Budgeting - A Complete Case Study/8. The Project's Cash Flow Calculation.mp430.84MB
213. 42. Capital Budgeting - A Complete Case Study/9. Calculating WACC (Weighted Average Cost of Capital).mp418.52MB
214. 43. Tesla Practical Case Study - Building a Financial Planning Model/1. Organizing External Inputs in a 'Drivers' Sheet.mp431MB
215. 43. Tesla Practical Case Study - Building a Financial Planning Model/10. Forecasting 'Energy' and 'Services' Revenue.mp425.3MB
216. 43. Tesla Practical Case Study - Building a Financial Planning Model/11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp426.8MB
217. 43. Tesla Practical Case Study - Building a Financial Planning Model/12. Forecasting Operating Expenses.mp434.91MB
218. 43. Tesla Practical Case Study - Building a Financial Planning Model/13. Building a Fixed Asset Roll Forward Estimating Capex.mp456.51MB
219. 43. Tesla Practical Case Study - Building a Financial Planning Model/14. Building a Fixed Asset Roll Forward D&A Schedule.mp454.15MB
220. 43. Tesla Practical Case Study - Building a Financial Planning Model/15. Peer Comparison D&A as a Percentage of Revenues.mp413.63MB
221. 43. Tesla Practical Case Study - Building a Financial Planning Model/16. Calculating DSO, DIO, DPO.mp417.51MB
222. 43. Tesla Practical Case Study - Building a Financial Planning Model/17. Producing a Clean P&L Output Sheet.mp48.44MB
223. 43. Tesla Practical Case Study - Building a Financial Planning Model/18. Fill in the P&L Output Sheet.mp418.35MB
224. 43. Tesla Practical Case Study - Building a Financial Planning Model/19. Calculating Investments in Working Capital.mp419.05MB
225. 43. Tesla Practical Case Study - Building a Financial Planning Model/2. The Input Data We Will Work With.mp415.8MB
226. 43. Tesla Practical Case Study - Building a Financial Planning Model/20. Forecasting Unlevered Free Cash Flow.mp455.98MB
227. 43. Tesla Practical Case Study - Building a Financial Planning Model/21. Forecasting Other Assets.mp445.3MB
228. 43. Tesla Practical Case Study - Building a Financial Planning Model/22. Forecasting Other Liabilities.mp422.05MB
229. 43. Tesla Practical Case Study - Building a Financial Planning Model/23. Completing Unlevered Free Cash Flow.mp440.89MB
230. 43. Tesla Practical Case Study - Building a Financial Planning Model/24. Modeling Tesla's Financing Needs in the Forecast Period.mp442.38MB
231. 43. Tesla Practical Case Study - Building a Financial Planning Model/25. Calculating Net Income.mp414.79MB
232. 43. Tesla Practical Case Study - Building a Financial Planning Model/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp450.67MB
233. 43. Tesla Practical Case Study - Building a Financial Planning Model/27. Balancing the Balance Sheet.mp413.29MB
234. 43. Tesla Practical Case Study - Building a Financial Planning Model/3. Forecasting Tesla's Expected Deliveries.mp4114.92MB
235. 43. Tesla Practical Case Study - Building a Financial Planning Model/4. Comparing Delivery Figures with the Ones of industry Peers.mp420.98MB
236. 43. Tesla Practical Case Study - Building a Financial Planning Model/5. Estimating an Average Selling Price of Tesla Vehicles.mp441.93MB
237. 43. Tesla Practical Case Study - Building a Financial Planning Model/6. Calculating Automotive Revenue.mp446.56MB
238. 43. Tesla Practical Case Study - Building a Financial Planning Model/7. Peer Comparison Gross Profit %.mp417.19MB
239. 43. Tesla Practical Case Study - Building a Financial Planning Model/8. Calculating Automotive Gross Profit.mp427.79MB
240. 43. Tesla Practical Case Study - Building a Financial Planning Model/9. Calculating Automotive Cost of Sales.mp417.54MB
241. 44. PowerPoint - Introduction to PowerPoint/1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp418.4MB
242. 44. PowerPoint - Introduction to PowerPoint/10. Changing an Object's Size and Rotation.mp411.23MB
243. 44. PowerPoint - Introduction to PowerPoint/11. Using Slide Masters.mp422.4MB
244. 44. PowerPoint - Introduction to PowerPoint/12. Bring to Front and Send to Back - An Important PowerPoint Technique.mp415.31MB
245. 44. PowerPoint - Introduction to PowerPoint/13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp427.66MB
246. 44. PowerPoint - Introduction to PowerPoint/2. General Considerations About Slide Structure.mp426.18MB
247. 44. PowerPoint - Introduction to PowerPoint/3. Learn How to Insert Objects in PowerPoint.mp431.96MB
248. 44. PowerPoint - Introduction to PowerPoint/4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp416.62MB
249. 44. PowerPoint - Introduction to PowerPoint/5. Add Frequently Used Buttons to the Quick Access Toolbar.mp421.31MB
250. 44. PowerPoint - Introduction to PowerPoint/6. How to Easily Align Objects in PowerPoint.mp420.48MB
251. 44. PowerPoint - Introduction to PowerPoint/7. How to Edit Shapes in Your Presentation.mp426.23MB
252. 44. PowerPoint - Introduction to PowerPoint/8. How to Format Text Boxes in a PowerPoint Presentation.mp419.96MB
253. 44. PowerPoint - Introduction to PowerPoint/9. Practical Learning - Exercise 1.mp427.47MB
254. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/1. An Introduction to PowerPoint Animations.mp414.57MB
255. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/10. Practical Exercise - Creating an Organisational Chart.mp452.75MB
256. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/11. COURSE CHALLENGE - Part 4.mp426MB
257. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/2. Modifying the Beginning and Ending of a Line Object.mp410.15MB
258. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Join Shapes Together By Using Connector Lines.mp423.83MB
259. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/4. Edit Points - Learn How to Customize PowerPoint Shapes.mp48.27MB
260. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/5. Group or Ungroup Shapes, Pictures or Other Objects.mp414.69MB
261. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/6. This is How You Can Fit Text When It Is Larger than a Shape.mp413.8MB
262. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/7. Nudge Objects.mp44.38MB
263. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp420.95MB
264. 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/9. Creating Eye-Catching Text Effects in PowerPoint.mp412.39MB
265. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1. Key Excel Functions IF.mp416.66MB
266. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10. Find the Highest and Lowest Values in a Range Max & Min.mp47.55MB
267. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11. = and + are Interchangeable When You Start Typing a Formula.mp45.79MB
268. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12. Use ROUND in Your Financial Models.mp45.21MB
269. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp460.27MB
270. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp461.76MB
271. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp411.74MB
272. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17. A Useful Tool for Financial Analysis - The RANK Function.mp423.24MB
273. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Create Flexible Financial Models with CHOOSE.mp419.85MB
274. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/19. Goal Seek Will Help You Find the Result You Are Looking For.mp416.01MB
275. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/2. Enlarge the Formula Bar.mp46.26MB
276. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp426.22MB
277. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3. Key Excel Functions SUM, SUMIF, SUMIFS.mp430.68MB
278. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp431.21MB
279. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5. Key Excel Functions AVERAGE & AVERAGEIF.mp415.12MB
280. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp430.41MB
281. 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9. Working with Text in Excel.mp416.01MB
282. 6. Microsoft Excel - Financial Functions in Excel/1. Discounting Cash Flows in Microsoft Excel.mp445.68MB
283. 6. Microsoft Excel - Financial Functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.mp422.76MB
284. 6. Microsoft Excel - Financial Functions in Excel/3. Using the PMT Function to Create a Complete Loan Schedule.mp440.06MB
285. 6. Microsoft Excel - Financial Functions in Excel/4. Date Functions in Excel.mp430.81MB
286. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/1. Introduction to the Case Study.mp49.82MB
287. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10. The Mapping Exercise.mp421.61MB
288. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11. Mapping the Rows in the Database Sheet.mp438.51MB
289. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12. Building the Structure of the P&L Sheet.mp420.87MB
290. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13. A Practical Example of Professional Formatting in Excel.mp425.43MB
291. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14. Populating the P&L Sheet with SUMIF.mp430.22MB
292. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15. Learn How to Find Mistakes with COUNTIF.mp427.85MB
293. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16. Calculating Growth Rates in Excel.mp429.98MB
294. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/2. What You Will See Next.mp410.2MB
295. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/3. Understand Your Data Source Before You Start Working on It.mp428.12MB
296. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4. Ordering the Source Worksheet.mp426.56MB
297. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp424.52MB
298. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6. Learn How to Create a Database.mp420.75MB
299. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp461.55MB
300. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8. Using SUMIF to Complete the Database Sheet.mp447.93MB
301. 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9. Using INDEX & MATCH as a Substitute for VLOOKUP.mp449.65MB
302. 8. Microsoft Excel - Building Professional Charts in Excel/1. Introduction to Excel Charts.mp413.01MB
303. 8. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.mp422.26MB
304. 8. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.mp426.04MB
305. 8. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.mp432.7MB
306. 8. Microsoft Excel - Building Professional Charts in Excel/5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp413.66MB
307. 8. Microsoft Excel - Building Professional Charts in Excel/6. New Ways to Visualize Your Data - Treemap Charts.mp411.5MB
308. 8. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.mp427.55MB
309. 9. Microsoft Excel - Creating Complete Professional Charts from Scratch/1. Introduction.mp46.2MB
310. 9. Microsoft Excel - Creating Complete Professional Charts from Scratch/2. Stacked Column Chart with a Secondary Axis.mp446.4MB
311. 9. Microsoft Excel - Creating Complete Professional Charts from Scratch/3. Doughnut Chart.mp438.01MB
312. 9. Microsoft Excel - Creating Complete Professional Charts from Scratch/4. Area Chart.mp428.59MB
313. 9. Microsoft Excel - Creating Complete Professional Charts from Scratch/5. Bridge Chart.mp452.07MB