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