GigaCourse Com Udemy - The Complete Financial Analyst Course 2024

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