:Search:

Udemy The Complete Financial Analyst Course 2024 Giga Course

Torrent:
Info Hash: 470FABB2FE3E7A5F37D5D50B648B96250B9C3EA6
Similar Posts:
Uploader: CourseClub
Source: 1 Logo 1337x
Downloads: 3012
Type: Tutorials
Language: English
Category: Other
Size: 11.7 GB
Added: March 20, 2024, 1:40 p.m.
Peers: Seeders: 9, Leechers: 11 (Last updated: 11 months, 1 week ago)
Tracker Data:
Tracker Seeders Leechers Completed
udp://open.stealth.si:80/announce 3 4 1546
udp://exodus.desync.com:6969/announce 0 0 0
udp://tracker.cyberia.is:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.opentrackr.org:1337/announce 4 3 1443
udp://tracker.torrent.eu.org:451/announce 1 0 5
udp://explodie.org:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.birkenwald.de:6969/announce 0 1 0
udp://tracker.moeking.me:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://ipv4.tracker.harry.lu:80/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.tiny-vps.com:6969/announce 1 2 18
udp://tracker.therarbg.to:6969/announce 0 1 0
Files:
  1. [CourseClub.Me].url 122 bytes
  2. [GigaCourse.Com].url 49 bytes
  3. 1. What Does the Course Cover.mp4 67.3 MB
  4. 1. What Does the Course Cover.srt 10.1 KB
  5. 1.1 Financial Analyst - Course Curriculum.pdf 581.4 KB
  6. 1.2 Who Does What in Finance - Infographic.pdf 1.2 MB
  7. 2. Everything We Will Learn Has a Practical Application.mp4 41.8 MB
  8. 2. Everything We Will Learn Has a Practical Application.srt 4.1 KB
  9. 2.1 Quick win.xlsx 9.7 KB
  10. 3. The Best Way to Take This Course.mp4 31.1 MB
  11. 3. The Best Way to Take This Course.srt 4.4 KB
  12. 4. Download All Course Materials and FAQ.html 5.1 KB
  13. 4.1 Download all resources - Dropbox.html 134 bytes
  14. 1. Introduction.mp4 5.9 MB
  15. 1. Introduction.srt 826 bytes
  16. 2. Stacked Column Chart with a Secondary Axis.mp4 41.3 MB
  17. 2. Stacked Column Chart with a Secondary Axis.srt 7.3 KB
  18. 2.1 82. Column stacked chart-Lecture-after.xlsm 11.5 MB
  19. 2.2 82. Column stacked chart-Lecture-before.xlsm 11.5 MB
  20. 3. Doughnut Chart.mp4 34.5 MB
  21. 3. Doughnut Chart.srt 6.9 KB
  22. 3.1 83. Doughnut chart-Lecture-after.xlsm 11.5 MB
  23. 3.2 83. Doughnut chart-Lecture-before.xlsm 11.5 MB
  24. 4. Area Chart.mp4 25.4 MB
  25. 4. Area Chart.srt 4.6 KB
  26. 4.1 84. Area chart-Lecture-after.xlsm 11.5 MB
  27. 4.2 84. Area chart-Lecture-before.xlsm 11.5 MB
  28. 5. Bridge Chart.mp4 46.6 MB
  29. 5. Bridge Chart.srt 9.3 KB
  30. 5.1 85. Bridge chart-Lecture-after.xlsm 11.5 MB
  31. 5.2 85.Bridge-chart-Lecture-before.xlsm 11.5 MB
  32. 1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 22.6 MB
  33. 1. Pivot Tables - Excel's Dynamic and Interactive Tables.srt 2.4 KB
  34. 2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 29.4 MB
  35. 2. Creating a Pivot Table Choosing Row and Column Parameters.srt 5.3 KB
  36. 2.1 87. Creating-a-Pivot-Table-Lecture.xlsx 1.4 MB
  37. 3. Design the Layout and Format of Your Pivot Tables.mp4 15.6 MB
  38. 3. Design the Layout and Format of Your Pivot Tables.srt 2.6 KB
  39. 3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx 1.4 MB
  40. 4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 35.9 MB
  41. 4. Additional Techniques That Will Ease Your Work with Pivot Tables.srt 5.9 KB
  42. 4.1 89. Working-with-Pivot-Tables-Lecture.xlsx 1.9 MB
  43. 5. One of the Most Useful Excel Functions - GETPIVOTDATA.mp4 27.4 MB
  44. 5. One of the Most Useful Excel Functions - GETPIVOTDATA.srt 5.0 KB
  45. 5.1 90. GetPivotData-Lecture.xlsx 1.9 MB
  46. 6. Welcome to the Future - Pivot Table Slicers.mp4 36.2 MB
  47. 6. Welcome to the Future - Pivot Table Slicers.srt 5.5 KB
  48. 6.1 91. Slicers-Lecture.xlsx 1.9 MB
  49. 7. Introduction to the Course Challenge.mp4 12.3 MB
  50. 7. Introduction to the Course Challenge.srt 1.5 KB
  51. 8. COURSE CHALLENGE - Part 1.mp4 23.3 MB
  52. 8. COURSE CHALLENGE - Part 1.srt 1.8 KB
  53. 8.1 93. Course-challenge-before-solutions.xlsx 505.9 KB
  54. 1. Introduction to the Case Study.mp4 41.3 MB
  55. 1. Introduction to the Case Study.srt 2.8 KB
  56. 1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx 13.3 MB
  57. 10. FAQ My GETPIVOTDATA Function Doesn't Work.html 647 bytes
  58. 11. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 33.6 MB
  59. 11. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt 4.0 KB
  60. 11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx 20.8 MB
  61. 11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx 20.8 MB
  62. 12. Getting Fancy with Excel Slicers.mp4 32.4 MB
  63. 12. Getting Fancy with Excel Slicers.srt 4.0 KB
  64. 12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx 18.2 MB
  65. 12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx 20.8 MB
  66. 13. This is How the Report Can be Used in Practice by High-level Executives.mp4 36.2 MB
  67. 13. This is How the Report Can be Used in Practice by High-level Executives.srt 5.1 KB
  68. 13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx 22.8 MB
  69. 13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx 18.3 MB
  70. 2. Working with an SAP Data Extraction.mp4 37.0 MB
  71. 2. Working with an SAP Data Extraction.srt 4.5 KB
  72. 3. Preliminary Mapping of the Data Extraction.mp4 30.2 MB
  73. 3. Preliminary Mapping of the Data Extraction.srt 2.8 KB
  74. 3.1 1. Exercise - Build an FMCG Model_Mapping_after.xlsx 14.9 MB
  75. 3.2 1. Exercise - Build an FMCG Model_Mapping_before.xlsx 13.3 MB
  76. 4. Creating an Output Structure of the FMCG Model.mp4 19.7 MB
  77. 4. Creating an Output Structure of the FMCG Model.srt 3.2 KB
  78. 4.1 2. Exercise - Build an FMCG Model_Layout_after.xlsx 14.9 MB
  79. 4.2 2. Exercise - Build an FMCG Model_Layout_before.xlsx 14.9 MB
  80. 5. Improving the Layout and Appearance of the FMCG Report.mp4 23.9 MB
  81. 5. Improving the Layout and Appearance of the FMCG Report.srt 4.9 KB
  82. 5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx 14.9 MB
  83. 5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx 14.9 MB
  84. 6. Inserting Formulas and Automating Calculations.mp4 16.2 MB
  85. 6. Inserting Formulas and Automating Calculations.srt 2.9 KB
  86. 6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx 14.9 MB
  87. 6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx 14.9 MB
  88. 7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 20.1 MB
  89. 7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt 2.4 KB
  90. 7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx 20.8 MB
  91. 7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx 14.9 MB
  92. 8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 49.9 MB
  93. 8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.srt 7.7 KB
  94. 8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx 20.8 MB
  95. 8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx 20.8 MB
  96. 9. GETPIVOTDATA Fix.mp4 11.9 MB
  97. 9. GETPIVOTDATA Fix.srt 2.0 KB
  98. 1. Introduction to the Exercise.mp4 32.8 MB
  99. 1. Introduction to the Exercise.srt 4.4 KB
  100. 1.1 106. Exercise-after.xlsx 32.7 KB
  101. 1.2 106. Exerxise-before.xlsx 18.7 KB
  102. 1.3 Financial Modeling Notes.pdf 690.1 KB
  103. 2. Let's Create a Mapping of Financials.mp4 27.2 MB
  104. 2. Let's Create a Mapping of Financials.srt 3.0 KB
  105. 2.1 107. Exercise - after.xlsx 34.2 KB
  106. 2.2 107. Exercise - before.xlsx 30.5 KB
  107. 3. Building an Output P&L Sheet.mp4 26.8 MB
  108. 3. Building an Output P&L Sheet.srt 4.3 KB
  109. 3.1 108. Exercise - after.xlsx 41.5 KB
  110. 3.2 108. Exercise - before.xlsx 32.4 KB
  111. 4. Filling in the Output P&L Sheet with Historical Financials.mp4 20.6 MB
  112. 4. Filling in the Output P&L Sheet with Historical Financials.srt 3.0 KB
  113. 4.1 109. Exersice - after.xlsx 41.3 KB
  114. 4.2 109. Exersice - before.xlsx 37.6 KB
  115. 5. Calculating Percentage Variances and Applying Conditional Formatting.mp4 23.9 MB
  116. 5. Calculating Percentage Variances and Applying Conditional Formatting.srt 3.4 KB
  117. 5.1 110. Exercise - after.xlsx 51.7 KB
  118. 5.2 110. Exercise - before.xlsx 39.3 KB
  119. 6. Building an Output Balance Sheet.mp4 26.2 MB
  120. 6. Building an Output Balance Sheet.srt 4.0 KB
  121. 6.1 111. Exercise - after.xlsx 54.4 KB
  122. 6.2 111. Exercise - before.xlsx 47.5 KB
  123. 7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4 37.7 MB
  124. 7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.srt 5.6 KB
  125. 7.1 112. Exersice - before.xlsx 49.8 KB
  126. 7.2 112. Exersise - after.xlsx 57.1 KB
  127. 8. Adding the Forecast Period.mp4 28.0 MB
  128. 8. Adding the Forecast Period.srt 4.1 KB
  129. 8.1 113. Exersice - after.xlsx 55.0 KB
  130. 8.2 113. Exersice - before.xlsx 50.3 KB
  131. 1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.mp4 43.9 MB
  132. 1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.srt 5.7 KB
  133. 1.1 114. Exercise - aft.xlsx 54.9 KB
  134. 1.2 114. Exercise - bef.xlsx 52.8 KB
  135. 2. Building a Flexible Model with CHOOSE & MATCH.mp4 13.9 MB
  136. 2. Building a Flexible Model with CHOOSE & MATCH.srt 1.8 KB
  137. 2.1 115. Exercise - after.xlsx 54.7 KB
  138. 2.2 115. Exercise - before.xlsx 53.1 KB
  139. 3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4 32.6 MB
  140. 3. Building a Flexible Model with VLOOKUP & COLUMNS.srt 3.6 KB
  141. 3.1 116. Exercise - after.xlsx 55.1 KB
  142. 3.2 116. Exercise - before.xlsx 53.1 KB
  143. 4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 39.4 MB
  144. 4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt 5.7 KB
  145. 4.1 117. Exercise -after.xlsx 56.6 KB
  146. 4.2 117. Exercise before.xlsx 53.6 KB
  147. 4.3 Course notes - Building a financial model.pdf 575.2 KB
  148. 4.4 Working Capital Days.pdf 340.8 KB
  149. 5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 27.0 MB
  150. 5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt 3.5 KB
  151. 5.1 118. Exercise - after.xlsx 57.7 KB
  152. 5.2 118. Exercise - before.xlsx 54.6 KB
  153. 1. Building a Fixed Asset Roll Forward.mp4 36.4 MB
  154. 1. Building a Fixed Asset Roll Forward.srt 4.9 KB
  155. 1.1 119. Exercise - after.xlsx 62.1 KB
  156. 1.2 119. Exercise - before.xlsx 55.7 KB
  157. 2. Building a Financial Liabilities Schedule.mp4 41.9 MB
  158. 2. Building a Financial Liabilities Schedule.srt 6.2 KB
  159. 2.1 120. Exercise - after.xlsx 67.6 KB
  160. 2.2 120. Exercise - before.xlsx 58.9 KB
  161. 3. Building an Equity Schedule.mp4 32.9 MB
  162. 3. Building an Equity Schedule.srt 4.7 KB
  163. 3.1 121. Exercise - after.xlsx 69.5 KB
  164. 3.2 121. Exercise - before.xlsx 58.9 KB
  165. 4. Preparing a Cash Flow Structure.mp4 12.5 MB
  166. 4. Preparing a Cash Flow Structure.srt 2.4 KB
  167. 4.1 122. Exercise - after.xlsx 70.4 KB
  168. 4.2 122. Exercise - before.xlsx 65.6 KB
  169. 5. Calculating Cash Flows and Completing the Model.mp4 51.0 MB
  170. 5. Calculating Cash Flows and Completing the Model.srt 7.6 KB
  171. 5.1 123. Exercise - after.xlsx 72.6 KB
  172. 5.2 123. Exercise - before.xlsx 67.7 KB
  173. 1. Accounting The Science Behind Financial Figures.mp4 54.0 MB
  174. 1. Accounting The Science Behind Financial Figures.srt 2.0 KB
  175. 1.1 Accounting & Financial Statement Analysis - Notes_UPDATE.pdf 670.2 KB
  176. 2. What is Accounting and Why Do You Need It.mp4 45.8 MB
  177. 2. What is Accounting and Why Do You Need It.srt 8.7 KB
  178. 2.1 Accounting & Financial Statement Analysis - Notes_UPDATE.pdf 670.2 KB
  179. 3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 29.1 MB
  180. 3. The Importance of Bookkeeping - Good Accounting Records Are Essential.srt 4.2 KB
  181. 4. An Introduction to Financial Accounting.mp4 22.3 MB
  182. 4. An Introduction to Financial Accounting.srt 4.6 KB
  183. 5. Quiz Number 3.html 147 bytes
  184. 1. The Different Types of Accounting Standards.mp4 23.0 MB
  185. 1. The Different Types of Accounting Standards.srt 4.5 KB
  186. 1.1 The Complete Financial Analyst Course - Financial items.pdf 890.0 KB
  187. 10. Asset Categories - Practical Example.mp4 30.5 MB
  188. 10. Asset Categories - Practical Example.srt 5.5 KB
  189. 10.1 P-G-Annual_Report_2021.pdf 5.6 MB
  190. 11. Liability Categories - Practical Example.mp4 29.7 MB
  191. 11. Liability Categories - Practical Example.srt 5.4 KB
  192. 11.1 P-G-Annual_Report_2021.pdf 5.6 MB
  193. 12. Equity.mp4 15.0 MB
  194. 12. Equity.srt 3.3 KB
  195. 13. Equity Categories - Practical Example.mp4 40.0 MB
  196. 13. Equity Categories - Practical Example.srt 7.8 KB
  197. 13.1 P-G-Annual_Report_2021.pdf 5.6 MB
  198. 14. Quiz Number 4.html 147 bytes
  199. 2. The Three Financial Statements.mp4 19.1 MB
  200. 2. The Three Financial Statements.srt 3.4 KB
  201. 3. Types of Revenues.mp4 52.2 MB
  202. 3. Types of Revenues.srt 10.9 KB
  203. 4. Types of Revenues - Exercise.mp4 15.7 MB
  204. 4. Types of Revenues - Exercise.srt 3.1 KB
  205. 5. Types of Expenses.mp4 43.3 MB
  206. 5. Types of Expenses.srt 9.1 KB
  207. 6. Income Taxes.mp4 15.4 MB
  208. 6. Income Taxes.srt 3.2 KB
  209. 7. Depreciation & Amortization.mp4 37.5 MB
  210. 7. Depreciation & Amortization.srt 7.2 KB
  211. 8. The Two Types of Income Statement Formats.mp4 10.8 MB
  212. 8. The Two Types of Income Statement Formats.srt 2.0 KB
  213. 9. Balance Sheet Items.mp4 35.4 MB
  214. 9. Balance Sheet Items.srt 6.8 KB
  215. 1. Accrual Accounting.mp4 59.4 MB
  216. 1. Accrual Accounting.srt 9.0 KB
  217. 2. Revenue Recognition Criteria - Technical.mp4 39.7 MB
  218. 2. Revenue Recognition Criteria - Technical.srt 6.1 KB
  219. 3. Potential Conflicts of Interest When Recognizing Revenue.mp4 16.3 MB
  220. 3. Potential Conflicts of Interest When Recognizing Revenue.srt 3.4 KB
  221. 4. A Practical Example.mp4 50.2 MB
  222. 4. A Practical Example.srt 8.7 KB
  223. 5. FAQ Doubts Regarding Calculation.html 683 bytes
  224. 1. Cost recognition principles.mp4 22.6 MB
  225. 1. Cost recognition principles.srt 4.1 KB
  226. 2. Technical Aspects of Cost Recognition.mp4 23.2 MB
  227. 2. Technical Aspects of Cost Recognition.srt 4.9 KB
  228. 1. Microsoft Excel The World's #1 Office Software.mp4 36.3 MB
  229. 1. Microsoft Excel The World's #1 Office Software.srt 1.2 KB
  230. 1.1 Introduction to Excel's basic features.pdf 2.3 MB
  231. 10. A Beginner's Introduction to Excel Functions.mp4 18.3 MB
  232. 10. A Beginner's Introduction to Excel Functions.srt 4.4 KB
  233. 10.1 6. Functions - Lecture -Solved.xlsx 9.3 KB
  234. 10.2 6. Functions- Exercise - Solved.xlsx 81.1 KB
  235. 10.3 6. Functions- Lecture - Unsolved.xlsx 9.2 KB
  236. 10.4 6. Functions-Exercise - Unsolved.xlsx 13.3 KB
  237. 10.5 Introduction-to-Excels-basic-features.pdf 2.3 MB
  238. 11. Format Cells.mp4 31.0 MB
  239. 11. Format Cells.srt 8.0 KB
  240. 11.1 10. Format cells_after.xlsx 9.8 KB
  241. 11.2 10. Format cells_before.xlsx 9.8 KB
  242. 12. Work Efficiently by Using Cut, Copy, and Paste.mp4 12.5 MB
  243. 12. Work Efficiently by Using Cut, Copy, and Paste.srt 2.6 KB
  244. 12.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx 12.6 KB
  245. 12.2 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx 11.3 KB
  246. 12.3 Introduction-to-Excels-basic-features.pdf 2.3 MB
  247. 13. Work Efficiently by Using Cut, Copy, and Paste.html 147 bytes
  248. 14. Pasting Values, Formulas and Formats with Paste Special.mp4 9.7 MB
  249. 14. Pasting Values, Formulas and Formats with Paste Special.srt 1.9 KB
  250. 14.1 8. Paste-Special-Exercise-Text.xlsx 13.5 KB
  251. 14.2 8. Paste-Special-Solved.xlsx 13.5 KB
  252. 14.3 Introduction-to-Excels-basic-features.pdf 2.3 MB
  253. 2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 17.5 MB
  254. 2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.srt 4.8 KB
  255. 2.1 1. Introduction to Excel.pdf 2.3 MB
  256. 2.2 1. Overview-of-Excel-Exercise-Solved.xlsx 10.9 KB
  257. 2.3 1. Overview-of-Excel-Exercise-Unsolved.xlsx 10.5 KB
  258. 3. Data Entry Techniques in Excel.mp4 26.8 MB
  259. 3. Data Entry Techniques in Excel.srt 4.0 KB
  260. 3.1 2. Data-Entry - Lecture.xlsx 8.1 KB
  261. 3.2 2. Data-Entry- Exercise -Solved.xlsx 32.8 KB
  262. 3.3 2. Data-Entry-Exercise - Unsolved.xlsx 11.0 KB
  263. 4. How to Make Your Spreadsheets Look Professional.mp4 35.9 MB
  264. 4. How to Make Your Spreadsheets Look Professional.srt 7.2 KB
  265. 4.1 3. Formatting - Lecture - Solved.xlsx 9.8 KB
  266. 4.2 3. Formatting- Exercise - Solved.xlsx 11.6 KB
  267. 4.3 3. Formatting- Lecture - Unsolved.xlsx 8.9 KB
  268. 4.4 3. Formatting-Exercise - Unsolved.xlsx 11.6 KB
  269. 5. Data Entry Techniques in Excel.html 147 bytes
  270. 6. Inserting, Deleting, and Modifying Rows & Columns.mp4 9.5 MB
  271. 6. Inserting, Deleting, and Modifying Rows & Columns.srt 2.3 KB
  272. 6.1 4. Basic-Manipulations - Exercise - Solved.xlsx 32.4 KB
  273. 6.2 4. Basic-Manipulations - Exercise - Unsolved.xlsx 11.1 KB
  274. 6.3 4. Data Entry - Lecture.xlsx 8.1 KB
  275. 7. Inserting, Deleting, and Modifying Rows & Columns.html 147 bytes
  276. 8. Excel Formulas for Beginners.mp4 12.1 MB
  277. 8. Excel Formulas for Beginners.srt 3.5 KB
  278. 8.1 5. Formulas - Exercise - Unsolved.xlsx 11.7 KB
  279. 8.2 5. Formulas- Exercise - Solved.xlsx 80.1 KB
  280. 8.3 5. Formulas- Lecture - Solved.xlsx 9.4 KB
  281. 8.4 5. Formulas- Lecture - Unsolved.xlsx 9.3 KB
  282. 8.5 Introduction-to-Excels-basic-features.pdf 2.3 MB
  283. 9. Excel Formulas for Beginners.html 147 bytes
  284. 1. The Revenue Recognition Principle - Why Is It So Important.mp4 23.2 MB
  285. 1. The Revenue Recognition Principle - Why Is It So Important.srt 4.7 KB
  286. 2. The Expense Recognition Principle - When to Recognize Expenses.mp4 22.6 MB
  287. 2. The Expense Recognition Principle - When to Recognize Expenses.srt 4.1 KB
  288. 3. Historical Cost vs. Fair Value Accounting.mp4 20.4 MB
  289. 3. Historical Cost vs. Fair Value Accounting.srt 4.0 KB
  290. [CourseClub.Me].url 122 bytes
  291. [GigaCourse.Com].url 49 bytes
  292. 1. The Accounting Equation and Its Importance.mp4 15.0 MB
  293. 1. The Accounting Equation and Its Importance.srt 3.3 KB
  294. 2. Elements of the Accounting System General Ledger.mp4 14.5 MB
  295. 2. Elements of the Accounting System General Ledger.srt 2.5 KB
  296. 3. T-Accounts The Best Way to Understand Debits and Credits.mp4 29.4 MB
  297. 3. T-Accounts The Best Way to Understand Debits and Credits.srt 7.3 KB
  298. 4. P&L T-Accounts.mp4 21.7 MB
  299. 4. P&L T-Accounts.srt 4.4 KB
  300. 5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 40.6 MB
  301. 5. The Double-Entry Principle - The Core Principle of Bookkeeping.srt 7.9 KB
  302. 6. Quiz Number 5.html 147 bytes
  303. 1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 70.7 MB
  304. 1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt 14.8 KB
  305. 1.1 Exercise - Before Solutions.xlsx 17.1 KB
  306. 1.2 Exercise Part One.xlsx 17.4 KB
  307. 1.3 Practical Exercise - List of transactions.pdf 182.5 KB
  308. 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 44.0 MB
  309. 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt 11.0 KB
  310. 2.1 Exercise - Part Two.xlsx 20.1 KB
  311. 2.2 Practical Exercise - List of transactions.pdf 182.5 KB
  312. 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 46.9 MB
  313. 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt 10.2 KB
  314. 3.1 Exercise - Part Three.xlsx 19.3 KB
  315. 3.2 Practical Exercise - List of transactions.pdf 182.5 KB
  316. 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 52.0 MB
  317. 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt 9.7 KB
  318. 4.1 Exercise - Part Four.xlsx 20.7 KB
  319. 4.2 Practical Exercise - List of transactions.pdf 182.5 KB
  320. 1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 9.7 MB
  321. 1. Timing of Cash Flows and Why It Plays an Important Role in a Business.srt 1.8 KB
  322. 2. Timing of Income Principles of Revenue Recognition.mp4 44.6 MB
  323. 2. Timing of Income Principles of Revenue Recognition.srt 8.9 KB
  324. 3. Timing of Expenses Principles of Cost Recognition.mp4 23.2 MB
  325. 3. Timing of Expenses Principles of Cost Recognition.srt 5.2 KB
  326. 4. Quiz Number 6.html 147 bytes
  327. 1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 23.8 MB
  328. 1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt 4.4 KB
  329. 2. The Three Parts of Cash Flow Statements Explained.mp4 23.3 MB
  330. 2. The Three Parts of Cash Flow Statements Explained.srt 3.8 KB
  331. 3. Cash Flow Computations - The Direct Method.mp4 18.5 MB
  332. 3. Cash Flow Computations - The Direct Method.srt 3.4 KB
  333. 4. Cash Flow Computations - The Indirect Method.mp4 25.8 MB
  334. 4. Cash Flow Computations - The Indirect Method.srt 5.8 KB
  335. 5. Calculating Cash Flow in Practice A Complete Example.mp4 52.5 MB
  336. 5. Calculating Cash Flow in Practice A Complete Example.srt 12.0 KB
  337. 5.1 Cash Flow Statement_after.xlsx 16.2 KB
  338. 5.2 Cash Flow Statement_pre-solution.xlsx 15.9 KB
  339. 6. FAQ Why D&A Has Been Added in Capex.html 2.2 KB
  340. 1. Why a Company Needs to Pay Attention to Trade Receivables.mp4 23.3 MB
  341. 1. Why a Company Needs to Pay Attention to Trade Receivables.srt 4.5 KB
  342. 1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf 706.6 KB
  343. 2. What If Clients Do Not Pay on Time.mp4 24.4 MB
  344. 2. What If Clients Do Not Pay on Time.srt 5.5 KB
  345. 3. How to Handle Non-paying Customers A Case-study.mp4 22.8 MB
  346. 3. How to Handle Non-paying Customers A Case-study.srt 4.3 KB
  347. 4. A Technique to Collect Trade Receivables Sooner.mp4 13.8 MB
  348. 4. A Technique to Collect Trade Receivables Sooner.srt 3.0 KB
  349. 1. The Different Types of Inventory We Can Have.mp4 23.9 MB
  350. 1. The Different Types of Inventory We Can Have.srt 4.4 KB
  351. 2. The Connection Between Cost of Goods Sold and Inventory.mp4 14.5 MB
  352. 2. The Connection Between Cost of Goods Sold and Inventory.srt 4.3 KB
  353. 3. Cost Flow Methods.mp4 24.3 MB
  354. 3. Cost Flow Methods.srt 7.6 KB
  355. 4. Cost Flow Methods - a Practical Exercise.mp4 6.5 MB
  356. 4. Cost Flow Methods - a Practical Exercise.srt 1.7 KB
  357. 4.1 Inventory Cost Flow Methods_solved.xlsx 12.4 KB
  358. 4.2 Inventory Cost Flow Methods_unsolved.xlsx 11.5 KB
  359. 4.3 Inventory Cost Flow Methods.pptx 168.5 KB
  360. 4.4 Inventory-Cost-Flow-Methods-with-solutions.pptx 175.1 KB
  361. 5. FAQ How to Apply the Weighted Average Cost Method.html 916 bytes
  362. 1. The Different Types of Fixed Assets.mp4 18.5 MB
  363. 1. The Different Types of Fixed Assets.srt 5.1 KB
  364. 2. Capitalizing Interest Expenses.mp4 7.1 MB
  365. 2. Capitalizing Interest Expenses.srt 3.3 KB
  366. 3. Fair Value Accounting.mp4 41.2 MB
  367. 3. Fair Value Accounting.srt 4.1 KB
  368. 4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4 32.2 MB
  369. 4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.srt 6.6 KB
  370. 5. The Revaluation Model.mp4 35.2 MB
  371. 5. The Revaluation Model.srt 7.6 KB
  372. 6. The Revaluation Model - Practical Exercise.mp4 34.1 MB
  373. 6. The Revaluation Model - Practical Exercise.srt 6.6 KB
  374. 7. Intangible Assets Created Internally.mp4 16.3 MB
  375. 7. Intangible Assets Created Internally.srt 3.5 KB
  376. 1. How We Account for Trade Payables.mp4 19.9 MB
  377. 1. How We Account for Trade Payables.srt 4.3 KB
  378. 2. What Is the Difference Between Accounts Payable and Notes Payable.mp4 9.6 MB
  379. 2. What Is the Difference Between Accounts Payable and Notes Payable.srt 2.3 KB
  380. 3. Why Use E-invoicing.mp4 22.7 MB
  381. 3. Why Use E-invoicing.srt 4.7 KB
  382. 1. The Difference Between Debt and Equity.mp4 13.1 MB
  383. 1. The Difference Between Debt and Equity.srt 3.7 KB
  384. 2. Amortizing a Loan.mp4 18.2 MB
  385. 2. Amortizing a Loan.srt 4.3 KB
  386. 3. Debt Covenants.mp4 23.3 MB
  387. 3. Debt Covenants.srt 5.5 KB
  388. 4. Debt Covenants - A Practical Example.mp4 12.2 MB
  389. 4. Debt Covenants - A Practical Example.srt 2.8 KB
  390. 1. Inserting a Line Break with Alt + Enter.mp4 9.9 MB
  391. 1. Inserting a Line Break with Alt + Enter.srt 1.0 KB
  392. 1.1 9. Alt-Enter- Lecture - Solved.xlsx 9.6 KB
  393. 1.2 9. Alt-Enter- Lecture - Unsolved.xlsx 9.6 KB
  394. 1.3 9. Alt-Enter-Exercise - Solved.xlsx 11.4 KB
  395. 1.4 9. Alt-Enter-Exercise - Unsolved.xlsx 11.1 KB
  396. 2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 11.7 MB
  397. 2. Do More with Your Sales Data with Excel's Text to Columns Feature.srt 2.5 KB
  398. 2.1 10. Text-to-Columns-Exercise - Solved.xlsx 11.3 KB
  399. 2.2 10. Text-to-Columns-Exercise - Unsolved.xlsx 10.6 KB
  400. 2.3 10. Text-to-columns-Lecture - Solved.xlsx 9.9 KB
  401. 2.4 10. Text-to-columns-Lecture - Unsolved.xlsx 9.8 KB
  402. 3. Do More with Your Sales Data with Excel's Text to Columns Feature.html 147 bytes
  403. 4. Create Easily Printable Excel Documents.mp4 8.4 MB
  404. 4. Create Easily Printable Excel Documents.srt 1.5 KB
  405. 4.1 11. Set-Print-Area-Lecture - Solved.xlsx 11.2 KB
  406. 4.2 11. Set-Print-Area-Lecture - Unsolved.xlsx 11.4 KB
  407. 4.3 Useful-Tips-Tools.pdf 3.3 MB
  408. 5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 3.2 MB
  409. 5. How to Wrap Text in Excel and Adjust a Cell's Size.srt 933 bytes
  410. 5.1 12. Wrap-Text-Exercise - Solved.xlsx 10.2 KB
  411. 5.2 12. Wrap-Text-Exercise - Unsolved.xlsx 10.2 KB
  412. 5.3 12. Wrap-text-Lecture - Solved.xlsx 9.6 KB
  413. 5.4 12. Wrap-text-Lecture - Unsolved.xlsx 9.6 KB
  414. 6. Insert Hyperlinks into Excel Spreadsheets.mp4 7.2 MB
  415. 6. Insert Hyperlinks into Excel Spreadsheets.srt 1.4 KB
  416. 6.1 13. Hyperlinks-Exercise - Solved.xlsx 137.1 KB
  417. 6.2 13. Hyperlinks-Exercise - Unsolved.xlsx 136.9 KB
  418. 6.3 Useful-Tips-Tools.pdf 3.3 MB
  419. 7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 14.5 MB
  420. 7. Using Excel's Freeze Panes to Handle Large Datasets.srt 1.5 KB
  421. 7.1 14. Freeze-Panes-Lecture - Solved.xlsx 643.9 KB
  422. 7.2 14. Freeze-Panes-Lecture - Unsolved.xlsx 643.9 KB
  423. 7.3 Useful-Tips-Tools.pdf 3.3 MB
  424. 8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 15.1 MB
  425. 8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.srt 1.0 KB
  426. 8.1 Useful Tips & Tools.pdf 3.3 MB
  427. 9. A Quick Introduction to Excel's Pivot Tables.mp4 40.1 MB
  428. 9. A Quick Introduction to Excel's Pivot Tables.srt 2.7 KB
  429. 9.1 21. Pivot Tables - Exercise - Solved.xlsx 190.5 KB
  430. 9.2 21. Pivot Tables - Exercise - Unsolved.xlsx 152.2 KB
  431. 9.3 21. Pivot tables - Lecture - Solved.xlsm 897.3 KB
  432. 9.4 21. Pivot tables - Lecture - Unsolved.xlsm 687.8 KB
  433. 9.5 Useful-Tips-Tools.pdf 3.3 MB
  434. 1. The Reason Companies Lease Assets.mp4 10.1 MB
  435. 1. The Reason Companies Lease Assets.srt 2.1 KB
  436. 2. Solving a Complete Leasing Exercise.mp4 40.1 MB
  437. 2. Solving a Complete Leasing Exercise.srt 9.3 KB
  438. 2.1 Leasing Exercise - Solved.xlsx 15.1 KB
  439. 2.2 Leasing Exercise - Unsolved.xlsx 9.6 KB
  440. 2.3 Leasing exercise_lecture.xlsx 14.0 KB
  441. 1. What is Leverage and Why Companies Use Financial Leverage.mp4 53.5 MB
  442. 1. What is Leverage and Why Companies Use Financial Leverage.srt 7.2 KB
  443. 2. The Implications of Using Excessive Leverage.mp4 32.1 MB
  444. 2. The Implications of Using Excessive Leverage.srt 5.5 KB
  445. 1. The Different Types of Equity.mp4 53.4 MB
  446. 1. The Different Types of Equity.srt 6.2 KB
  447. 2. Raising Equity in Different Stages of a Company's Lifecycle.mp4 68.0 MB
  448. 2. Raising Equity in Different Stages of a Company's Lifecycle.srt 9.9 KB
  449. 3. The Types of Dividends Companies Pay to Shareholders.mp4 42.3 MB
  450. 3. The Types of Dividends Companies Pay to Shareholders.srt 5.6 KB
  451. 4. Dividend Payments - a Timeline.mp4 33.5 MB
  452. 4. Dividend Payments - a Timeline.srt 4.9 KB
  453. 5. What Are Share Repurchases and Why Companies Do Them.mp4 42.4 MB
  454. 5. What Are Share Repurchases and Why Companies Do Them.srt 5.0 KB
  455. 6. The Idea Behind Stock Splits.mp4 34.3 MB
  456. 6. The Idea Behind Stock Splits.srt 4.6 KB
  457. 1. Assessment - Accounting.html 148 bytes
  458. 1. What is a 10-K Report and Why Is It important for Investors.mp4 21.8 MB
  459. 1. What is a 10-K Report and Why Is It important for Investors.srt 3.8 KB
  460. 2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 77.5 MB
  461. 2. Finding, Downloading and Going Through the Annual Report of P&G.srt 11.1 KB
  462. 2.1 P-G-Annual_Report_2021.pdf 5.6 MB
  463. 3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 26.3 MB
  464. 3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.srt 4.2 KB
  465. 4. Indispensable Tools for Financial Statement Analysis.mp4 14.3 MB
  466. 4. Indispensable Tools for Financial Statement Analysis.srt 3.5 KB
  467. 5. Quiz Number 7.html 147 bytes
  468. [CourseClub.Me].url 122 bytes
  469. [GigaCourse.Com].url 49 bytes
  470. 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 16.8 MB
  471. 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt 3.0 KB
  472. 1.1 Financial Statement Analysis - Notes.pdf 772.9 KB
  473. 2. First Steps in Financial Statement Analysis.mp4 25.6 MB
  474. 2. First Steps in Financial Statement Analysis.srt 4.5 KB
  475. 3. Horizontal vs. Vertical Financial Statement Analysis.mp4 27.3 MB
  476. 3. Horizontal vs. Vertical Financial Statement Analysis.srt 5.6 KB
  477. 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 18.0 MB
  478. 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt 3.1 KB
  479. 4.1 Working Capital Days.pdf 340.8 KB
  480. 5. Using Accounting Ratios to Assess Business Performance.mp4 62.3 MB
  481. 5. Using Accounting Ratios to Assess Business Performance.srt 13.9 KB
  482. 6. Quiz Number 8.html 147 bytes
  483. 1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 55.6 MB
  484. 1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt 11.1 KB
  485. 1.1 P-G-Annual_Report_2021.pdf 5.6 MB
  486. 1.2 P-G-Financials-Before.xlsx 14.8 KB
  487. 1.3 P-G-Financials-With-Ratios.xlsx 15.7 KB
  488. 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 32.5 MB
  489. 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt 7.4 KB
  490. 2.1 P-G-Annual_Report_2021.pdf 5.6 MB
  491. 2.2 P-G-Financials-Before.xlsx 14.7 KB
  492. 2.3 P-G-Financials-With-Ratios.xlsx 15.7 KB
  493. 3. COURSE CHALLENGE - Part 2.mp4 30.6 MB
  494. 3. COURSE CHALLENGE - Part 2.srt 2.1 KB
  495. 3.1 2. Course Challenge.xlsx 627.6 KB
  496. 1. What You Will See Next In This Section.mp4 17.6 MB
  497. 1. What You Will See Next In This Section.srt 1.9 KB
  498. 2. How to Download Tesla's Historical Financials.mp4 16.6 MB
  499. 2. How to Download Tesla's Historical Financials.srt 4.0 KB
  500. 2.1 Tesla 2015.pdf 1.3 MB
  501. 2.2 Tesla 2016.pdf 2.2 MB
  502. 2.3 Tesla 2017.pdf 2.5 MB
  503. 2.4 Tesla 2018.pdf 3.5 MB
  504. 2.5 Tesla 2019.pdf 2.4 MB
  505. 3. Calculating and Analyzing Growth and Profitability Ratios.mp4 106.5 MB
  506. 3. Calculating and Analyzing Growth and Profitability Ratios.srt 15.6 KB
  507. 3.1 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx 1.1 MB
  508. 3.2 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx 1.1 MB
  509. 4. Calculating and Analyzing Liquidity Ratios.mp4 71.6 MB
  510. 4. Calculating and Analyzing Liquidity Ratios.srt 8.8 KB
  511. 4.1 Tesla - Financial Statement Analysis - Liquidity_after.xlsx 1.1 MB
  512. 4.2 Tesla - Financial Statement Analysis - Liquidity_before.xlsx 1.1 MB
  513. 5. Calculating and Analyzing Solvency Ratios.mp4 24.5 MB
  514. 5. Calculating and Analyzing Solvency Ratios.srt 3.4 KB
  515. 5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx 1.1 MB
  516. 5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx 1.1 MB
  517. 1. Introduction.mp4 22.3 MB
  518. 1. Introduction.srt 4.3 KB
  519. 10. Symptoms of Inefficient Working Capital - Trade Payables.mp4 15.8 MB
  520. 10. Symptoms of Inefficient Working Capital - Trade Payables.srt 3.5 KB
  521. 10.1 Working capital test_solved.xlsx 13.6 KB
  522. 10.2 Working capital test_unsolved.xlsx 12.7 KB
  523. 11. Symptoms of Inefficient Working Capital - Trade Receivables.mp4 13.8 MB
  524. 11. Symptoms of Inefficient Working Capital - Trade Receivables.srt 3.1 KB
  525. 2. The Importance of Working Capital Optimization Case Study.mp4 80.7 MB
  526. 2. The Importance of Working Capital Optimization Case Study.srt 14.3 KB
  527. 3. Overtrading vs. Excessive Investment.mp4 30.1 MB
  528. 3. Overtrading vs. Excessive Investment.srt 5.2 KB
  529. 4. Trade Receivables Management.mp4 68.7 MB
  530. 4. Trade Receivables Management.srt 12.9 KB
  531. 5. Re-order Level.mp4 28.4 MB
  532. 5. Re-order Level.srt 5.2 KB
  533. 6. Economic Order Quantity (EOQ).mp4 28.2 MB
  534. 6. Economic Order Quantity (EOQ).srt 6.3 KB
  535. 7. Inventory Optimization Techniques.mp4 45.2 MB
  536. 7. Inventory Optimization Techniques.srt 8.1 KB
  537. 8. Trade Payables Management.mp4 17.4 MB
  538. 8. Trade Payables Management.srt 3.3 KB
  539. 9. Working Capital Optimization - a Roadmap.mp4 43.5 MB
  540. 9. Working Capital Optimization - a Roadmap.srt 8.6 KB
  541. 1. Fundamentals of Business & Financial Analysis.html 151 bytes
  542. 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 21.2 MB
  543. 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt 2.1 KB
  544. 1.1 17. Formatting-a-Worksheet-Exercise - Solved.xlsx 10.8 KB
  545. 1.2 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx 10.6 KB
  546. 1.3 17. Formatting-a-worksheet-Lecture - Solved.xlsx 9.6 KB
  547. 1.4 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx 9.0 KB
  548. 1.5 Useful-Tips-Tools.pdf 3.3 MB
  549. 10. Using Absolute and Relative Cell References.html 147 bytes
  550. 11. Find and Select Cells That Meet Specific Conditions.mp4 11.9 MB
  551. 11. Find and Select Cells That Meet Specific Conditions.srt 1.8 KB
  552. 11.1 23. Select-Special-F5-Exercise - Solved.xlsx 22.3 KB
  553. 11.2 23. Select-Special-F5-Exercise - Unsolved.xlsx 21.6 KB
  554. 11.3 23. Select-Special-Lecture.xlsx 10.6 KB
  555. 11.4 Useful-Tips-Tools.pdf 3.3 MB
  556. 12. Find and Select Cells That Meet Specific Conditions.html 147 bytes
  557. 13. How to Create Dynamic Names in Excel Spreadsheets.mp4 14.0 MB
  558. 13. How to Create Dynamic Names in Excel Spreadsheets.srt 1.7 KB
  559. 13.1 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx 11.7 KB
  560. 13.2 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx 11.2 KB
  561. 13.3 24. Dynamic-Naming-Lecture - Solved.xlsx 13.8 KB
  562. 13.4 24. Dynamic-Naming-Lecture - Unsolved.xlsx 13.5 KB
  563. 13.5 Useful-Tips-Tools.pdf 3.3 MB
  564. 14. How to Create Dynamic Names in Excel Spreadsheets.html 147 bytes
  565. 15. Using Named Ranges to Make Formulas More Readable.mp4 7.7 MB
  566. 15. Using Named Ranges to Make Formulas More Readable.srt 1.8 KB
  567. 15.1 25. Defining-a-Named-Range-Exercise - Solved.xlsx 11.7 KB
  568. 15.2 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.1 KB
  569. 15.3 25. Naming-ranges-Lecture - Solved.xlsx 10.3 KB
  570. 15.4 25. Naming-ranges-Lecture - Unsolved.xlsx 8.8 KB
  571. 15.5 Useful-Tips-Tools.pdf 3.3 MB
  572. 16. Introduction to Custom Formatting in Excel.mp4 40.9 MB
  573. 16. Introduction to Custom Formatting in Excel.srt 9.3 KB
  574. 16.1 19. Custom formatting_after.xlsx 10.8 KB
  575. 16.2 19. Custom formatting_before.xlsx 10.7 KB
  576. 17. Custom Number Formatting.mp4 8.3 MB
  577. 17. Custom Number Formatting.srt 2.0 KB
  578. 17.1 31. Assigning Custom Formats - Exercise - Solved.xlsx 11.1 KB
  579. 17.2 31. Assigning Custom Formats - Exercise - Unsolved.xlsx 11.4 KB
  580. 17.3 Useful-Tips-Tools.pdf 3.3 MB
  581. 18. How to Add a Drop-down List in Excel.mp4 14.0 MB
  582. 18. How to Add a Drop-down List in Excel.srt 2.3 KB
  583. 18.1 27. Data-Validation-Lecture - Solved.xlsx 10.8 KB
  584. 18.2 27. Data-Validation-Lecture - Unsolved.xlsx 10.8 KB
  585. 18.3 27. Drop-down-List-Exercise - Solved.xlsx 77.0 KB
  586. 18.4 27. Drop-down-List-Exercise - Unsolved.xlsx 11.3 KB
  587. 19. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 21.9 MB
  588. 19. Using Custom-sort to Sort Multiple Columns Within a Table.srt 1.7 KB
  589. 19.1 28. Custom-Sort-Exercise - Solved.xlsx 11.5 KB
  590. 19.2 28. Custom-Sort-Exercise - Unsolved.xlsx 11.4 KB
  591. 19.3 28. Sort-data-Lecture - Solved.xlsx 145.6 KB
  592. 19.4 28. Sort-data-Lecture - Unsolved.xlsx 145.3 KB
  593. 19.5 Useful-Tips-Tools.pdf 3.3 MB
  594. 2. Macros Are a Great Timesaver! Here's Why..mp4 33.6 MB
  595. 2. Macros Are a Great Timesaver! Here's Why..srt 3.5 KB
  596. 2.1 18. Creating-a-Macro-Lecture - Solved.xlsx 11.2 KB
  597. 2.2 18. Creating-a-Macro-Lecture - Unsolved.xlsx 9.7 KB
  598. 2.3 18. Macros-Exercise - Solved.xlsx 145.0 KB
  599. 2.4 18. Macros-Exercise - Unsolved.xlsx 10.3 KB
  600. 2.5 Useful-Tips-Tools.pdf 3.3 MB
  601. 20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 41.9 MB
  602. 20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt 5.0 KB
  603. 20.1 29. Microsoft-Excel-Keyboard-Shortcuts.pdf 1.3 MB
  604. 20.2 29. Microsoft-Excel-Shortcuts-for-MAC.pdf 769.2 KB
  605. 20.3 Useful-Tips-Tools.pdf 3.3 MB
  606. 21. Multiply by 1.mp4 13.7 MB
  607. 21. Multiply by 1.srt 2.4 KB
  608. 21.1 30. Multiply-by-1-Lecture-after.xlsx 17.2 KB
  609. 21.2 30.+Multiply-by-1-Lecture_before.xlsx 16.5 KB
  610. 22. Find and Replace - References.mp4 21.9 MB
  611. 22. Find and Replace - References.srt 4.5 KB
  612. 22.1 31. Find-and-Replace-references-Lecture-after.xlsx 37.9 KB
  613. 22.2 31. Find-and-Replace-references-Lecture-before.xlsx 38.8 KB
  614. 23. FAQ Why Do We Replace External References and How Does This Help Us.html 702 bytes
  615. 24. Find and Replace - Formatting.mp4 12.5 MB
  616. 24. Find and Replace - Formatting.srt 2.4 KB
  617. 24.1 32. Find-replace-Lecture-after.xlsx 17.2 KB
  618. 24.2 32. Find-replace-Lecture-before.xlsx 17.2 KB
  619. 25. Green References.mp4 11.5 MB
  620. 25. Green References.srt 2.3 KB
  621. 25.1 33. Green-references-Lecture.xlsx 12.0 KB
  622. 26. Beauty Saving - The Professional Way of Saving Files.mp4 12.9 MB
  623. 26. Beauty Saving - The Professional Way of Saving Files.srt 3.2 KB
  624. 26.1 34. Beauty-saving-Lecture-after.xlsx 17.0 KB
  625. 26.2 34. Beauty-saving-Lecture-before.xlsx 17.2 KB
  626. 27. The Power of F2.mp4 16.7 MB
  627. 27. The Power of F2.srt 3.0 KB
  628. 27.1 43. F2-Lecture.xlsm 49.9 KB
  629. 28. Conditional Formatting.mp4 52.0 MB
  630. 28. Conditional Formatting.srt 7.3 KB
  631. 28.1 41. Conditional formatting - Lecture.xlsx 41.7 KB
  632. 29. Quiz Number 1.html 147 bytes
  633. 3. How to Use the Same Macro On Multiple Workbooks.mp4 10.7 MB
  634. 3. How to Use the Same Macro On Multiple Workbooks.srt 2.1 KB
  635. 3.1 19. Another-file.xlsx 8.8 KB
  636. 3.2 19. How-to-save-macros-Lecture-after.xlsm 12.6 KB
  637. 3.3 19. How-to-save-macros-Lecture-before.xlsx 6.0 KB
  638. 4. Macros Are a Great Timesaver! Here's Why..html 147 bytes
  639. 5. The Secret to Faster Scrolling in Excel.mp4 19.5 MB
  640. 5. The Secret to Faster Scrolling in Excel.srt 1.8 KB
  641. 5.1 25. Fast-Scrolling - Lecture.xlsx 642.8 KB
  642. 5.2 25. Fast-Scrolling-Exercise - Solved.xlsx 44.4 KB
  643. 5.3 25. Fast-Scrolling-Exercise - Unsolved.xlsx 43.9 KB
  644. 5.4 Useful-Tips-Tools.pdf 3.3 MB
  645. 6. Be even quicker F5 + Enter.mp4 19.1 MB
  646. 6. Be even quicker F5 + Enter.srt 2.7 KB
  647. 6.1 21. F5-go-to - Lecture.xlsm 50.8 KB
  648. 7. FAQ F5 + Enter didn't work for me.html 402 bytes
  649. 8. The Secret to Faster Scrolling in Excel.html 147 bytes
  650. 9. Using Absolute and Relative Cell References.mp4 43.5 MB
  651. 9. Using Absolute and Relative Cell References.srt 2.7 KB
  652. 9.1 22. Fixing-Cells-Exercise - Solved.xlsx 10.8 KB
  653. 9.2 22. Fixing-Cells-Exercise - Unsolved.xlsx 10.7 KB
  654. 9.3 22. Fixing-references-Lecture - Solved.xlsx 645.2 KB
  655. 9.4 22. Fixing-references-Lecture - Unsolved.xlsx 644.0 KB
  656. 9.5 Useful-Tips-Tools.pdf 3.3 MB
  657. [CourseClub.Me].url 122 bytes
  658. [GigaCourse.Com].url 49 bytes
  659. 1. Trend analysis - theory.html 2.0 KB
  660. 10. Time series analysis.mp4 67.3 MB
  661. 10. Time series analysis.srt 9.5 KB
  662. 10.1 5. Time series_after.xlsx 63.4 KB
  663. 10.2 5. Time series_before.xlsx 58.6 KB
  664. 11. Regression analysis - theory.html 4.9 KB
  665. 12. Regression analysis.mp4 42.8 MB
  666. 12. Regression analysis.srt 6.5 KB
  667. 12.1 6.1 Regression analysis_after.xlsx 69.7 KB
  668. 12.2 6.1 Regression analysis_before.xlsx 68.5 KB
  669. 12.3 6.2 Multiple regression analysis_after.xlsx 76.2 KB
  670. 12.4 6.2 Multiple regression analysis_before.xlsx 74.8 KB
  671. 2. Trend analysis.mp4 70.3 MB
  672. 2. Trend analysis.srt 9.0 KB
  673. 2.1 1. Trend analysis_after.xlsx 40.8 KB
  674. 2.2 1. Trend analysis_before.xlsx 32.8 KB
  675. 3. Comparative analysis - theory.html 2.6 KB
  676. 4. Comparative analysis.mp4 32.3 MB
  677. 4. Comparative analysis.srt 6.2 KB
  678. 4.1 2. Comparative analysis_after.xlsx 44.0 KB
  679. 4.2 2. Comparative analysis_before.xlsx 43.5 KB
  680. 5. Value-based analysis - theory.html 3.7 KB
  681. 6. Value-based analysis.mp4 37.5 MB
  682. 6. Value-based analysis.srt 6.9 KB
  683. 6.1 3. Value-based analysis_after.xlsx 47.3 KB
  684. 6.2 3. Value-based analysis_before.xlsx 46.8 KB
  685. 7. Correlation analysis - theory.html 3.9 KB
  686. 8. Correlation analysis.mp4 36.3 MB
  687. 8. Correlation analysis.srt 4.8 KB
  688. 8.1 4. Correlation_after.xlsx 55.5 KB
  689. 8.2 4. Correlation_before.xlsx 50.9 KB
  690. 9. Time series analysis - theory.html 2.0 KB
  691. 1. Finance 101 Important Financial Principles That You Will Need.mp4 26.6 MB
  692. 1. Finance 101 Important Financial Principles That You Will Need.srt 852 bytes
  693. 1.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  694. 2. Understanding the Time Value of Money.mp4 9.6 MB
  695. 2. Understanding the Time Value of Money.srt 1.7 KB
  696. 2.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  697. 2.2 Time value of money.pdf 777.3 KB
  698. 3. How Interest Rates Play an Important Role in the Economy.mp4 21.5 MB
  699. 3. How Interest Rates Play an Important Role in the Economy.srt 2.0 KB
  700. 3.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  701. 4. The Components Forming Interest Rates in Real Life.mp4 26.0 MB
  702. 4. The Components Forming Interest Rates in Real Life.srt 3.7 KB
  703. 4.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  704. 4.2 Interest rate components.pdf 807.5 KB
  705. 5. What Is Libor and What Purpose Does It Serve.mp4 27.7 MB
  706. 5. What Is Libor and What Purpose Does It Serve.srt 1.3 KB
  707. 5.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  708. 6. The Difference Between Fixed and Variable Interest Rates.mp4 26.4 MB
  709. 6. The Difference Between Fixed and Variable Interest Rates.srt 2.4 KB
  710. 6.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  711. 7. What Is Default Risk and How Does a Bank Account For It.mp4 47.8 MB
  712. 7. What Is Default Risk and How Does a Bank Account For It.srt 9.1 KB
  713. 7.1 Default risk.pdf 880.8 KB
  714. 7.2 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  715. 8. Corporate Loan Specifics.mp4 40.9 MB
  716. 8. Corporate Loan Specifics.srt 2.1 KB
  717. 8.1 Finance 101 - Introduction to the World of Finance.pdf 689.8 KB
  718. 1. Calculating the Present Value of Future Cash Flows.mp4 46.8 MB
  719. 1. Calculating the Present Value of Future Cash Flows.srt 6.1 KB
  720. 1.1 1. Calculating Future Cash Flows.pdf 810.3 KB
  721. 1.2 3.1 Present Value of Cash Flows.xlsx 9.9 KB
  722. 2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 45.9 MB
  723. 2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.srt 5.1 KB
  724. 2.1 2. NPV.pdf 192.2 KB
  725. 1. Using Annuities.mp4 22.2 MB
  726. 1. Using Annuities.srt 4.8 KB
  727. 2. Calculating a Complete Loan Schedule.mp4 44.7 MB
  728. 2. Calculating a Complete Loan Schedule.srt 9.1 KB
  729. 3. COURSE CHALLENGE - Part 3.mp4 22.4 MB
  730. 3. COURSE CHALLENGE - Part 3.srt 1.6 KB
  731. 3.1 3. Course Challenge.xlsx 537.7 KB
  732. 1. What is Capital Budgeting.mp4 12.3 MB
  733. 1. What is Capital Budgeting.srt 2.3 KB
  734. 2. When Do We Use Capital Budgeting.mp4 19.2 MB
  735. 2. When Do We Use Capital Budgeting.srt 3.5 KB
  736. 3. The Time Value of Money in a Capital Budgeting Setting.mp4 16.9 MB
  737. 3. The Time Value of Money in a Capital Budgeting Setting.srt 3.5 KB
  738. 4. Calculating Present and Future Value.mp4 31.6 MB
  739. 4. Calculating Present and Future Value.srt 8.2 KB
  740. 5. Cost of Equity.mp4 51.5 MB
  741. 5. Cost of Equity.srt 10.2 KB
  742. 6. Project-specific Beta.mp4 24.8 MB
  743. 6. Project-specific Beta.srt 4.7 KB
  744. 7. The Weighted Average Cost of Capital (WACC).mp4 14.0 MB
  745. 7. The Weighted Average Cost of Capital (WACC).srt 3.0 KB
  746. 8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 21.8 MB
  747. 8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt 5.1 KB
  748. 9. Modeling Future Cash Flows.mp4 50.5 MB
  749. 9. Modeling Future Cash Flows.srt 8.9 KB
  750. 1. An Introduction to the Case Study.mp4 22.3 MB
  751. 1. An Introduction to the Case Study.srt 4.3 KB
  752. 10. Estimating Cost of Equity.mp4 36.0 MB
  753. 10. Estimating Cost of Equity.srt 9.9 KB
  754. 10.1 8. WACC_unsolved.xlsx 35.9 KB
  755. 10.2 8. WACC.xlsx 38.0 KB
  756. 11. Discounting Project Cash Flows.mp4 24.0 MB
  757. 11. Discounting Project Cash Flows.srt 5.1 KB
  758. 11.1 9. Discounted cash flow.xlsx 39.7 KB
  759. 11.2 9.Discounted-cash-flow-unsolved.xlsx 38.7 KB
  760. 12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 42.0 MB
  761. 12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt 7.3 KB
  762. 12.1 10. Sensitivity analysis_unsolved.xlsx 39.7 KB
  763. 12.2 10. Sensitivity analysis.xlsx 40.7 KB
  764. 12.3 Capital budgeting_exercise_unsolved.xlsx 13.2 KB
  765. 12.4 Capital-budgeting-exercise-solved.xlsx 42.7 KB
  766. 13. FAQ Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet.html 378 bytes
  767. 2. Organizing Inputs In the Drivers Sheet.mp4 32.0 MB
  768. 2. Organizing Inputs In the Drivers Sheet.srt 8.1 KB
  769. 2.1 1. Drivers.xlsx 11.5 KB
  770. 3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4 32.1 MB
  771. 3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt 5.4 KB
  772. 3.1 2. Savings Forecast_unsolved.xlsx 14.7 KB
  773. 3.2 2. Savings Forecast.xlsx 16.6 KB
  774. 4. Preparing a Fixed Asset Rollforward Schedule.mp4 44.5 MB
  775. 4. Preparing a Fixed Asset Rollforward Schedule.srt 6.7 KB
  776. 4.1 3. Fixed Asset Rollforward_unsolved.xlsx 18.5 KB
  777. 4.2 3. Fixed Asset Rollforward.xlsx 19.7 KB
  778. 5. Calculating the Cash Impact of Extra Working Capital Required.mp4 16.3 MB
  779. 5. Calculating the Cash Impact of Extra Working Capital Required.srt 3.8 KB
  780. 5.1 4. Working Capital_unsolved.xlsx 21.2 KB
  781. 5.2 4. Working Capital.xlsx 21.9 KB
  782. 6. Debt Repayment and Interest Expenses Calculation.mp4 19.9 MB
  783. 6. Debt Repayment and Interest Expenses Calculation.srt 4.5 KB
  784. 6.1 5. Financing_unsolved.xlsx 30.0 KB
  785. 6.2 5. Financing.xlsx 31.0 KB
  786. 7. The Project's P&L Sheet.mp4 12.9 MB
  787. 7. The Project's P&L Sheet.srt 2.7 KB
  788. 7.1 6. P&L_unsolved.xlsx 29.7 KB
  789. 7.2 6. P&L.xlsx 31.0 KB
  790. 8. The Project's Cash Flow Calculation.mp4 29.0 MB
  791. 8. The Project's Cash Flow Calculation.srt 5.0 KB
  792. 8.1 7. Cash flow_unsolved.xlsx 29.6 KB
  793. 8.2 7. Cash flow.xlsx 31.4 KB
  794. 9. Calculating WACC (Weighted Average Cost of Capital).mp4 16.3 MB
  795. 9. Calculating WACC (Weighted Average Cost of Capital).srt 4.0 KB
  796. 9.1 8. WACC_unsolved.xlsx 35.9 KB
  797. 9.2 8. WACC.xlsx 38.0 KB
  798. 1. Organizing External Inputs in a 'Drivers' Sheet.mp4 35.1 MB
  799. 1. Organizing External Inputs in a 'Drivers' Sheet.srt 5.7 KB
  800. 1.1 0. Drivers_after.xlsx 1.4 MB
  801. 1.2 0. Drivers_before.xlsx 1.4 MB
  802. 1.3 Tesla Company Valuation - Detailed walkthrough.pdf 2.7 MB
  803. 10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 23.8 MB
  804. 10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.srt 3.8 KB
  805. 10.1 7. Energy and Other gross profit_after.xlsx 1.5 MB
  806. 10.2 7. Energy and Other gross profit_before.xlsx 1.5 MB
  807. 11. Forecasting Operating Expenses.mp4 27.4 MB
  808. 11. Forecasting Operating Expenses.srt 6.2 KB
  809. 11.1 8. Opex_after.xlsx 1.5 MB
  810. 11.2 8. Opex_before.xlsx 1.5 MB
  811. 12. Building a Fixed Asset Roll Forward PP&E.mp4 32.7 MB
  812. 12. Building a Fixed Asset Roll Forward PP&E.srt 6.1 KB
  813. 12.1 9. PP&E forecasting_after.xlsx 1.5 MB
  814. 12.2 9. PP&E forecasting_before.xlsx 1.5 MB
  815. 13. Building a Fixed Asset Roll Forward Estimating Capex.mp4 39.3 MB
  816. 13. Building a Fixed Asset Roll Forward Estimating Capex.srt 5.5 KB
  817. 13.1 10. Capex forecasting_after.xlsx 1.5 MB
  818. 13.2 10. Capex forecasting_before.xlsx 1.5 MB
  819. 14. Building a Fixed Asset Roll Forward D&A Schedule.mp4 34.0 MB
  820. 14. Building a Fixed Asset Roll Forward D&A Schedule.srt 4.5 KB
  821. 14.1 11. D&A schedule_after.xlsx 1.5 MB
  822. 14.2 11. D&A schedule_before.xlsx 1.5 MB
  823. 15. Calculating DSO, DIO, DPO.mp4 16.7 MB
  824. 15. Calculating DSO, DIO, DPO.srt 2.9 KB
  825. 16. Producing a Clean P&L Output Sheet.mp4 14.5 MB
  826. 16. Producing a Clean P&L Output Sheet.srt 2.0 KB
  827. 16.1 12. P&L_after.xlsx 1.5 MB
  828. 16.2 12. P&L_before.xlsx 1.5 MB
  829. 17. Calculating Investments in Working Capital.mp4 18.7 MB
  830. 17. Calculating Investments in Working Capital.srt 2.9 KB
  831. 17.1 13. Working capital_after.xlsx 1.5 MB
  832. 17.2 13. Working capital_before.xlsx 1.5 MB
  833. 18. Forecasting Unlevered Free Cash Flow.mp4 31.2 MB
  834. 18. Forecasting Unlevered Free Cash Flow.srt 4.7 KB
  835. 18.1 14. Cash flow - UFCF_after.xlsx 1.6 MB
  836. 18.2 14. Cash flow - UFCF_before.xlsx 1.5 MB
  837. 19. Forecasting Other Assets.mp4 44.5 MB
  838. 19. Forecasting Other Assets.srt 7.0 KB
  839. 19.1 15. Balance sheet forecasting - assets_after.xlsx 1.5 MB
  840. 19.2 15. Balance sheet forecasting - assets_before.xlsx 1.5 MB
  841. 2. Forecasting Tesla's Expected Deliveries.mp4 103.4 MB
  842. 2. Forecasting Tesla's Expected Deliveries.srt 18.7 KB
  843. 2.1 1. Deliveries_after.xlsx 1.4 MB
  844. 2.2 1. Deliveries_before.xlsx 1.4 MB
  845. 20. Forecasting Other Liabilities.mp4 20.1 MB
  846. 20. Forecasting Other Liabilities.srt 3.0 KB
  847. 20.1 15a. Balance sheet forecasting - liabilities_after.xlsx 1.6 MB
  848. 20.2 15a. Balance sheet forecasting - liabilities_before.xlsx 1.5 MB
  849. 21. Completing Unlevered Free Cash Flow.mp4 66.8 MB
  850. 21. Completing Unlevered Free Cash Flow.srt 8.1 KB
  851. 21.1 16. Complete UFCF_after.xlsx 1.6 MB
  852. 21.2 16. Complete UFCF_before.xlsx 1.6 MB
  853. 22. Modeling Tesla's Financing Needs in the Forecast Period.mp4 38.8 MB
  854. 22. Modeling Tesla's Financing Needs in the Forecast Period.srt 6.7 KB
  855. 22.1 17. Financing_after.xlsx 1.6 MB
  856. 22.2 17. Financing_before.xlsx 1.6 MB
  857. 23. Calculating Net Income.mp4 13.8 MB
  858. 23. Calculating Net Income.srt 1.8 KB
  859. 23.1 18. P&L complete_after.xlsx 1.6 MB
  860. 23.2 18. P&L complete_before.xlsx 1.6 MB
  861. 24. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 40.6 MB
  862. 24. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt 5.0 KB
  863. 24.1 19. Net cash flow_after.xlsx 1.6 MB
  864. 24.2 19. Net cash flow_before.xlsx 1.6 MB
  865. 25. Balancing the Balance Sheet.mp4 11.9 MB
  866. 25. Balancing the Balance Sheet.srt 1.5 KB
  867. 25.1 20. Complete the BS_after.xlsx 1.6 MB
  868. 25.2 20. Complete the BS_before.xlsx 1.6 MB
  869. 3. Comparing Delivery Figures with the Ones of industry Peers.mp4 19.8 MB
  870. 3. Comparing Delivery Figures with the Ones of industry Peers.srt 4.7 KB
  871. 3.1 1a. Deliveries development_after.xlsx 1.4 MB
  872. 3.2 1a. Deliveries development_before.xlsx 1.4 MB
  873. 4. Estimating an Average Selling Price of Tesla Vehicles.mp4 46.0 MB
  874. 4. Estimating an Average Selling Price of Tesla Vehicles.srt 7.0 KB
  875. 4.1 2. Average of price models_after.xlsx 1.4 MB
  876. 4.2 2. Average of price models_before.xlsx 1.4 MB
  877. 5. Calculating Automotive Revenue.mp4 40.5 MB
  878. 5. Calculating Automotive Revenue.srt 6.3 KB
  879. 5.1 3. Revenue calculation_after.xlsx 1.5 MB
  880. 5.2 3. Revenue calculation_before.xlsx 1.4 MB
  881. 6. Peer Comparison Gross Profit %.mp4 35.7 MB
  882. 6. Peer Comparison Gross Profit %.srt 7.2 KB
  883. 6.1 4. Gross profit automotive_after.xlsx 1.5 MB
  884. 6.2 4. Gross profit automotive_before.xlsx 1.5 MB
  885. 7. Calculating Automotive Gross Profit.mp4 22.3 MB
  886. 7. Calculating Automotive Gross Profit.srt 3.8 KB
  887. 7.1 5. Gross profit and cost of sales_after.xlsx 1.5 MB
  888. 7.2 5. Gross profit and cost of sales_before.xlsx 1.5 MB
  889. 8. Calculating Automotive Cost of Sales.mp4 12.7 MB
  890. 8. Calculating Automotive Cost of Sales.srt 2.6 KB
  891. 9. Forecasting 'Energy' and 'Services' Revenue.mp4 19.1 MB
  892. 9. Forecasting 'Energy' and 'Services' Revenue.srt 3.4 KB
  893. 9.1 6. Energy and Other revenue_after.xlsx 1.5 MB
  894. 9.2 6. Energy and Other revenue_before.xlsx 1.5 MB
  895. 1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.mp4 28.5 MB
  896. 1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.srt 2.9 KB
  897. 2. The Limitations of ChatGPT Advanced Data Analysis.mp4 47.9 MB
  898. 2. The Limitations of ChatGPT Advanced Data Analysis.srt 4.3 KB
  899. 1. Exploratory Data Analysis - Intro.mp4 57.2 MB
  900. 1. Exploratory Data Analysis - Intro.srt 5.4 KB
  901. 1.1 2.1_source.xlsx 170.5 KB
  902. 2. Extracting Descriptive Statistics with ChatGPT.mp4 19.3 MB
  903. 2. Extracting Descriptive Statistics with ChatGPT.srt 2.8 KB
  904. 3. Identifying Outliers.mp4 18.1 MB
  905. 3. Identifying Outliers.srt 3.7 KB
  906. 4. Correlation Analysis Hypothesis Formulation and Feature Ideas.mp4 19.2 MB
  907. 4. Correlation Analysis Hypothesis Formulation and Feature Ideas.srt 2.8 KB
  908. 5. Crafting a Comprehensive EDA Prompt.mp4 93.1 MB
  909. 5. Crafting a Comprehensive EDA Prompt.srt 11.0 KB
  910. 1. Identifying and Handling Erroneous Data.mp4 33.3 MB
  911. 1. Identifying and Handling Erroneous Data.srt 4.5 KB
  912. 1.1 3.1_output.xlsx 17.2 KB
  913. 1.2 3.1_source.xlsx 15.5 KB
  914. 2. Verifying Data for Errors.mp4 36.8 MB
  915. 2. Verifying Data for Errors.srt 4.6 KB
  916. 2.1 3.2_output.xlsx 11.6 KB
  917. 2.2 3.2_source.xlsx 16.2 KB
  918. 3. Eliminating Duplicate Rows.mp4 12.4 MB
  919. 3. Eliminating Duplicate Rows.srt 1.8 KB
  920. 3.1 3.3_output.xlsx 8.1 KB
  921. 3.2 3.3_source.xlsx 16.7 KB
  922. 4. Addressing Unit Discrepancies in Data.mp4 19.0 MB
  923. 4. Addressing Unit Discrepancies in Data.srt 2.6 KB
  924. 4.1 3.4_output.xlsx 8.9 KB
  925. 4.2 3.4_source.xlsx 17.0 KB
  926. 5. Dividing Cell Content into Multiple Cells.mp4 46.3 MB
  927. 5. Dividing Cell Content into Multiple Cells.srt 5.6 KB
  928. 5.1 3.5_source.xlsx 16.7 KB
  929. 1. Key Excel Functions IF.mp4 14.9 MB
  930. 1. Key Excel Functions IF.srt 3.9 KB
  931. 1.1 37. IF-function--Lecture-before.xlsm 17.0 KB
  932. 1.2 37. IF-function-Lecture-after.xlsm 17.9 KB
  933. 1.3 Functions - English to German.pdf 102.3 KB
  934. 1.4 Functions - English to Portuguese.pdf 146.1 KB
  935. 1.5 Functions - English to Spanish.pdf 102.4 KB
  936. 10. Working with Text in Excel.mp4 13.4 MB
  937. 10. Working with Text in Excel.srt 3.8 KB
  938. 10.1 43. Work-with-text-Lecture-after.xlsx 10.9 KB
  939. 10.2 43. Work-with-text-Lecture-before.xlsx 10.3 KB
  940. 11. Find the Highest and Lowest Values in a Range Max & Min.mp4 12.4 MB
  941. 11. Find the Highest and Lowest Values in a Range Max & Min.srt 1.1 KB
  942. 11.1 44. Excel-functions.xlsx 971.0 KB
  943. 11.2 44. Max-min-Lecture - Solved.xlsx 9.2 KB
  944. 11.3 44. Max-min-Lecture - Unsolved.xlsx 8.9 KB
  945. 11.4 44. MIN-MAX-Exercise - Solved.xlsx 14.8 KB
  946. 11.5 44. MIN-MAX-Exercise - Unsolved.xlsx 14.4 KB
  947. 11.6 Excel-Functions.pdf 3.2 MB
  948. 12. = and + are Interchangeable When You Start Typing a Formula.mp4 5.0 MB
  949. 12. = and + are Interchangeable When You Start Typing a Formula.srt 1.3 KB
  950. 12.1 45. Show-that-and-are-interchangeable-Lecture-after.xlsm 17.0 KB
  951. 12.2 45. Show-that-and-are-interchangeable-Lecture-before.xlsm 17.0 KB
  952. 13. Use ROUND in Your Financial Models.mp4 8.5 MB
  953. 13. Use ROUND in Your Financial Models.srt 1.2 KB
  954. 13.1 51. Excel-functions-Lecture.xlsx 889.9 KB
  955. 13.2 51. Round-Exercise - Solved.xlsx 11.7 KB
  956. 13.3 51. Round-Exercise - Unsolved.xlsx 11.3 KB
  957. 13.4 Excel-Functions.pdf 3.2 MB
  958. 14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 52.6 MB
  959. 14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.srt 9.0 KB
  960. 14.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx 11.1 KB
  961. 14.2 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx 10.7 KB
  962. 14.3 47. Vlookup-Hlookup-Exercise - Solved.xlsx 13.7 KB
  963. 14.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx 11.9 KB
  964. 14.5 Excel-Functions.pdf 3.2 MB
  965. 15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 99.5 MB
  966. 15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt 8.6 KB
  967. 15.1 48. Index-Match-Exercise - Solved.xlsx 12.1 KB
  968. 15.2 48. Index-Match-Exercise - Unsolved.xlsx 11.6 KB
  969. 15.3 48. Index-Match-Lecture - Solved.xlsx 11.7 KB
  970. 15.4 48. Index-Match-Lecture - Unsolved.xlsx 11.3 KB
  971. 15.5 Excel-Functions.pdf 3.2 MB
  972. 16. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html 147 bytes
  973. 17. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).mp4 40.3 MB
  974. 17. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).srt 10.4 KB
  975. 17.1 9. XLOOKUP_lecture_after.xlsm 19.0 KB
  976. 17.2 9. XLOOKUP_lecture_before.xlsm 18.8 KB
  977. 18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 19.2 MB
  978. 18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt 2.2 KB
  979. 18.1 54. Iferror - Lecture - Solved.xlsm 896.4 KB
  980. 18.2 54. Iferror - Lecture - Unsolved.xlsm 897.3 KB
  981. 18.3 54. Iferror-Exercise - Solved.xlsx 15.4 KB
  982. 18.4 54. Iferror-Exercise - Unsolved.xlsx 14.3 KB
  983. 18.5 Excel-Functions.pdf 3.2 MB
  984. 19. A Useful Tool for Financial Analysis - The RANK Function.mp4 20.1 MB
  985. 19. A Useful Tool for Financial Analysis - The RANK Function.srt 3.9 KB
  986. 19.1 50. Rank-function-Lecture-after.xlsx 12.6 KB
  987. 19.2 50. Rank-function-Lecture-before.xlsx 12.3 KB
  988. 2. Enlarge the Formula Bar.mp4 5.7 MB
  989. 2. Enlarge the Formula Bar.srt 1.7 KB
  990. 2.1 38. Enlarge-the-formula-bar-Lecture.xlsm 46.9 KB
  991. 20. Create Flexible Financial Models with CHOOSE.mp4 32.0 MB
  992. 20. Create Flexible Financial Models with CHOOSE.srt 2.8 KB
  993. 20.1 51. Choose-Exercise - Unsolved.xlsx 11.3 KB
  994. 20.2 51. Choose-Exercise-Solved.xlsx 11.7 KB
  995. 20.3 51. Choose-Lecture - Solved.xlsx 9.7 KB
  996. 20.4 51. Choose-Lecture - Unsolved.xlsx 9.3 KB
  997. 20.5 Excel-Functions.pdf 3.2 MB
  998. 21. Goal Seek Will Help You Find the Result You Are Looking For.mp4 25.4 MB
  999. 21. Goal Seek Will Help You Find the Result You Are Looking For.srt 2.7 KB
  1000. 21.1 57. Goal-Seek-Exercise - Unsolved.xlsx 16.1 KB
  1001. 21.2 57. Goal-Seek-Exercise-Solved.xlsx 16.2 KB
  1002. 21.3 57. Goal-Seek-Lecture - Solved.xlsx 9.2 KB
  1003. 21.4 57. Goal-Seek-Lecture - Unsolved.xlsx 9.1 KB
  1004. 21.5 Excel-Functions.pdf 3.2 MB
  1005. 22. Goal Seek Will Help You Find the Result You Are Looking For.html 147 bytes
  1006. 23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 41.7 MB
  1007. 23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.srt 5.2 KB
  1008. 23.1 58. Sensitivity analysis - Lecture - Solved.xlsm 897.3 KB
  1009. 23.2 58. Sensitivity analysis - Lecture - Unsolved.xlsm 897.1 KB
  1010. 23.3 58.Sensitivity-analysis-Exercise_Unsolved.xlsx 61.9 KB
  1011. 23.4 58.Sensitivity-analysis-Exercise-Solved.xlsx 62.3 KB
  1012. 24. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html 147 bytes
  1013. 25. Quiz Number 2.html 147 bytes
  1014. 3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4 27.4 MB
  1015. 3. Key Excel Functions SUM, SUMIF, SUMIFS.srt 5.2 KB
  1016. 3.1 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx 14.8 KB
  1017. 3.2 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx 14.5 KB
  1018. 3.3 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx 13.0 KB
  1019. 3.4 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx 12.9 KB
  1020. 3.5 Excel-Functions.pdf 3.2 MB
  1021. 4. A Helpful Consideration.html 1.4 KB
  1022. 5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 49.9 MB
  1023. 5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt 4.5 KB
  1024. 5.1 05 38 Counts Exercise & Text.xlsx 15.7 KB
  1025. 5.2 05 38 Counts Solved.xlsx 16.1 KB
  1026. 5.3 Excel-Functions.pdf 3.2 MB
  1027. 5.4 Lecture-Count-Countif-Countifs-Solved.xlsx 11.7 KB
  1028. 5.5 Lecture-Count-Countif-Countifs-Unsolved.xlsx 11.3 KB
  1029. 6. Key Excel Functions AVERAGE & AVERAGEIF.mp4 24.1 MB
  1030. 6. Key Excel Functions AVERAGE & AVERAGEIF.srt 2.4 KB
  1031. 6.1 41. Average-Averageif- Lecture - Solved.xlsx 9.4 KB
  1032. 6.2 41. Average-Averageif- Lecture - Unsolved.xlsx 9.0 KB
  1033. 6.3 41. Average-AverageIF-Exercise - Solved.xlsx 15.0 KB
  1034. 6.4 41. Average-AverageIF-Exercise - Unsolved.xlsx 14.6 KB
  1035. 6.5 Excel-Functions.pdf 3.2 MB
  1036. 7. Key Excel Functions Average & Averageif.html 147 bytes
  1037. 8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 49.0 MB
  1038. 8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.srt 4.9 KB
  1039. 8.1 47. Text functions - Exercise - Solved.xlsx 12.2 KB
  1040. 8.2 47. Text functions - Exercise - Unsolved.xlsx 11.7 KB
  1041. 8.3 47. Text-Functions- Lecture - Solved.xlsx 11.1 KB
  1042. 8.4 47. Text-Functions- Lecture - Unsolved.xlsx 10.6 KB
  1043. 9. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html 147 bytes
  1044. 1. Organize Messy Data.mp4 50.6 MB
  1045. 1. Organize Messy Data.srt 5.5 KB
  1046. 1.1 4.1_output.xlsx 62.0 KB
  1047. 1.2 4.1_source.xlsx 83.7 KB
  1048. 2. Data Mapping.mp4 23.0 MB
  1049. 2. Data Mapping.srt 3.7 KB
  1050. 2.1 4.2_output.xlsx 14.3 KB
  1051. 2.2 4.2_source.xlsx 9.3 KB
  1052. 3. Effective Data Classification.mp4 14.2 MB
  1053. 3. Effective Data Classification.srt 2.7 KB
  1054. 3.1 4.3_output.xlsx 6.6 KB
  1055. 3.2 4.3_source.xlsx 15.6 KB
  1056. 4. Order Data with ChatGPT.mp4 18.1 MB
  1057. 4. Order Data with ChatGPT.srt 2.8 KB
  1058. 4.1 4.4_output.xlsx 5.6 KB
  1059. 4.2 4.4_source.xlsx 17.9 KB
  1060. [CourseClub.Me].url 122 bytes
  1061. [GigaCourse.Com].url 49 bytes
  1062. 1. COUNTIFS, SUMIFS.mp4 24.8 MB
  1063. 1. COUNTIFS, SUMIFS.srt 3.2 KB
  1064. 1.1 5.1_output.xlsx 17.6 KB
  1065. 1.2 5.1_source.xlsx 17.1 KB
  1066. 2. Data Lookup.mp4 26.3 MB
  1067. 2. Data Lookup.srt 3.8 KB
  1068. 2.1 5.2_output.xlsx 18.4 KB
  1069. 2.2 5.2_source.xlsx 17.4 KB
  1070. 3. Data Ranking.mp4 24.5 MB
  1071. 3. Data Ranking.srt 3.6 KB
  1072. 3.1 5.3_output.xlsx 8.3 KB
  1073. 3.2 5.3_source.xlsx 17.4 KB
  1074. 4. Fill Until Non-blank Values.mp4 22.6 MB
  1075. 4. Fill Until Non-blank Values.srt 4.2 KB
  1076. 4.1 5.4_output.xlsx 6.1 KB
  1077. 4.2 5.4_source.xlsx 14.4 KB
  1078. 5. Translating Logic into Excel Formulas with ChatGPT.mp4 11.8 MB
  1079. 5. Translating Logic into Excel Formulas with ChatGPT.srt 3.1 KB
  1080. 5.1 5.5_output.xlsx 14.4 KB
  1081. 5.2 5.5_source.xlsx 14.0 KB
  1082. 1. Correcting Inverted Names.mp4 15.6 MB
  1083. 1. Correcting Inverted Names.srt 2.6 KB
  1084. 1.1 6.1_source.xlsx 11.4 KB
  1085. 2. Dealing with Trailing and Leading Spaces in Text Data.mp4 17.9 MB
  1086. 2. Dealing with Trailing and Leading Spaces in Text Data.srt 2.7 KB
  1087. 2.1 6.2_source.xlsx 12.4 KB
  1088. 3. Standardizing Letter Capitalization.mp4 15.7 MB
  1089. 3. Standardizing Letter Capitalization.srt 2.8 KB
  1090. 3.1 6.3_source.xlsx 18.3 KB
  1091. 4. Handling Multi-lingual Text Data.mp4 35.9 MB
  1092. 4. Handling Multi-lingual Text Data.srt 4.4 KB
  1093. 4.1 6.4_source.xlsx 13.0 KB
  1094. 5. Multiple Find and Replace at the Same Time with ChatGPT.mp4 24.0 MB
  1095. 5. Multiple Find and Replace at the Same Time with ChatGPT.srt 3.5 KB
  1096. 5.1 6.5_source.xlsx 18.0 KB
  1097. 6. Criteria-based Duplicate Removal.mp4 14.4 MB
  1098. 6. Criteria-based Duplicate Removal.srt 3.2 KB
  1099. 6.1 6.6_source.xlsx 14.5 KB
  1100. 7. Removing Duplicates Across Multiple Columns.mp4 14.6 MB
  1101. 7. Removing Duplicates Across Multiple Columns.srt 2.7 KB
  1102. 7.1 6.7_source.xlsx 15.0 KB
  1103. 1. Obtain Day and Month From Date.mp4 27.5 MB
  1104. 1. Obtain Day and Month From Date.srt 3.5 KB
  1105. 1.1 7.1_output.xlsx 18.9 KB
  1106. 1.2 7.1_source.xlsx 17.0 KB
  1107. 2. Converting Hours to Decimals.mp4 9.9 MB
  1108. 2. Converting Hours to Decimals.srt 2.1 KB
  1109. 2.1 7.2_output.xlsx 16.1 KB
  1110. 2.2 7.2_source.xlsx 14.2 KB
  1111. 3. Obtaining Age in Years, Months, Days.mp4 9.1 MB
  1112. 3. Obtaining Age in Years, Months, Days.srt 2.1 KB
  1113. 3.1 7.3_output.xlsx 14.5 KB
  1114. 3.2 7.3_source.xlsx 14.0 KB
  1115. 4. Order Dates Chronologically.mp4 12.5 MB
  1116. 4. Order Dates Chronologically.srt 2.1 KB
  1117. 4.1 7.4_output.xlsx 18.2 KB
  1118. 4.2 7.4_source.xlsx 392.3 KB
  1119. 1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.mp4 39.8 MB
  1120. 1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.srt 6.3 KB
  1121. 1.1 8.1 Free_Plan_Users_output.xlsx 146.0 KB
  1122. 1.2 8.1_source.xlsx 169.4 KB
  1123. 1.3 8.1_Transactions_output.xlsx 74.0 KB
  1124. 2. Preprocessing the 'Free plan users' Sheet (12).mp4 64.7 MB
  1125. 2. Preprocessing the 'Free plan users' Sheet (12).srt 9.5 KB
  1126. 3. Preprocessing the 'Free plan users' Sheet (22).mp4 35.7 MB
  1127. 3. Preprocessing the 'Free plan users' Sheet (22).srt 4.5 KB
  1128. 4. Working on the 'Transactions' Sheet.mp4 78.8 MB
  1129. 4. Working on the 'Transactions' Sheet.srt 6.9 KB
  1130. 5. Dealing with the Country Mapping Issue.mp4 23.3 MB
  1131. 5. Dealing with the Country Mapping Issue.srt 3.8 KB
  1132. 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 30.5 MB
  1133. 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.srt 1.1 KB
  1134. 10. Practical Learning - Exercise 1.mp4 27.5 MB
  1135. 10. Practical Learning - Exercise 1.srt 5.3 KB
  1136. 10.1 Practical Example - Organizing Notes.docx 15.5 KB
  1137. 10.2 Practical Example - Organizing Notes.pptx 1.2 MB
  1138. 11. Changing an Object's Size and Rotation.mp4 11.2 MB
  1139. 11. Changing an Object's Size and Rotation.srt 2.8 KB
  1140. 11.1 Resizing and Rotating Objects.pptx 1.2 MB
  1141. 12. Using Slide Masters.mp4 22.5 MB
  1142. 12. Using Slide Masters.srt 6.3 KB
  1143. 12.1 Slide Masters Presentation - example.pptx 43.5 KB
  1144. 13. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 15.3 MB
  1145. 13. Bring to Front and Send to Back - An Important PowerPoint Technique.srt 4.5 KB
  1146. 13.1 Bring to Front and Send to Back.pptx 1.2 MB
  1147. 14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 27.6 MB
  1148. 14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt 7.4 KB
  1149. 14.1 Insert table.pptx 1.2 MB
  1150. 2. The Structure of the PowerPoint Ribbon.mp4 27.7 MB
  1151. 2. The Structure of the PowerPoint Ribbon.srt 7.3 KB
  1152. 2.1 Introduction to PowerPoint.pdf 2.6 MB
  1153. 3. General Considerations About Slide Structure.mp4 26.4 MB
  1154. 3. General Considerations About Slide Structure.srt 6.0 KB
  1155. 3.1 Spacing within PowerPoint.pptx 1.9 MB
  1156. 3.2 Spacing-within-PowerPoint-chart.xlsx 57.3 KB
  1157. 4. Learn How to Insert Objects in PowerPoint.mp4 32.0 MB
  1158. 4. Learn How to Insert Objects in PowerPoint.srt 5.9 KB
  1159. 4.1 Insert objects.pptx 1.6 MB
  1160. 4.2 Kinemax Data.xlsx 36.4 KB
  1161. 5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 16.7 MB
  1162. 5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt 3.8 KB
  1163. 5.1 Power-Point-Master-Class-Shortcuts-For-Mac.pdf 532.4 KB
  1164. 5.2 PowerPoint Master Class - Shortcuts.pdf 440.4 KB
  1165. 6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 21.4 MB
  1166. 6. Add Frequently Used Buttons to the Quick Access Toolbar.srt 4.7 KB
  1167. 6.1 Quick Access Toolbar buttons.pptx 1.2 MB
  1168. 7. How to Easily Align Objects in PowerPoint.mp4 20.5 MB
  1169. 7. How to Easily Align Objects in PowerPoint.srt 6.3 KB
  1170. 7.1 Align and Distribute objects in Ppt.pptx 1.3 MB
  1171. 8. How to Edit Shapes in Your Presentation.mp4 26.3 MB
  1172. 8. How to Edit Shapes in Your Presentation.srt 7.1 KB
  1173. 8.1 Format Shape Menu.pptx 634.2 KB
  1174. 9. How to Format Text Boxes in a PowerPoint Presentation.mp4 19.9 MB
  1175. 9. How to Format Text Boxes in a PowerPoint Presentation.srt 5.5 KB
  1176. 9.1 Working with text.pptx 773.0 KB
  1177. 1. An Introduction to PowerPoint Animations.mp4 14.6 MB
  1178. 1. An Introduction to PowerPoint Animations.srt 5.1 KB
  1179. 1.1 Animation effects.pptx 1.2 MB
  1180. 10. Practical Exercise - Creating an Organisational Chart.mp4 52.8 MB
  1181. 10. Practical Exercise - Creating an Organisational Chart.srt 9.5 KB
  1182. 10.1 List of executives.png 62.9 KB
  1183. 10.2 Practical Example - completed.pptx 1.3 MB
  1184. 10.3 Practical Example.pptx 1.2 MB
  1185. 11. COURSE CHALLENGE - Part 4.mp4 41.8 MB
  1186. 11. COURSE CHALLENGE - Part 4.srt 3.5 KB
  1187. 11.1 4. Course Challenge - Tasks.pdf 283.0 KB
  1188. 11.2 4. Course Challenge.pptx 1.1 MB
  1189. 11.3 Sending Files with Dropbox - YouTube Tutorial.html 104 bytes
  1190. 2. Modifying the Beginning and Ending of a Line Object.mp4 10.2 MB
  1191. 2. Modifying the Beginning and Ending of a Line Object.srt 2.8 KB
  1192. 2.1 Line Begin and End type.pptx 1.2 MB
  1193. 3. Join Shapes Together By Using Connector Lines.mp4 23.8 MB
  1194. 3. Join Shapes Together By Using Connector Lines.srt 6.3 KB
  1195. 3.1 Connectors.pptx 1.2 MB
  1196. 4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4 8.3 MB
  1197. 4. Edit Points - Learn How to Customize PowerPoint Shapes.srt 2.9 KB
  1198. 4.1 Edit Points.pptx 1.2 MB
  1199. 5. Group or Ungroup Shapes, Pictures or Other Objects.mp4 14.7 MB
  1200. 5. Group or Ungroup Shapes, Pictures or Other Objects.srt 3.1 KB
  1201. 5.1 Group.pptx 1.2 MB
  1202. 6. This is How You Can Fit Text When It Is Larger Than a Shape.mp4 13.8 MB
  1203. 6. This is How You Can Fit Text When It Is Larger Than a Shape.srt 3.3 KB
  1204. 6.1 Internal Margins.pptx 1.2 MB
  1205. 7. Nudge Objects.mp4 4.4 MB
  1206. 7. Nudge Objects.srt 1.8 KB
  1207. 7.1 Nudge objects.pptx 1.2 MB
  1208. 8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 21.0 MB
  1209. 8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt 5.4 KB
  1210. 8.1 Smart Art.pptx 1.2 MB
  1211. 9. Creating Eye-Catching Text Effects in PowerPoint.mp4 12.5 MB
  1212. 9. Creating Eye-Catching Text Effects in PowerPoint.srt 3.3 KB
  1213. 9.1 Text effects.pptx 1.2 MB
  1214. 1. Who Does What in the World of Finance.mp4 649.3 MB
  1215. 1. Who Does What in the World of Finance.srt 101.9 KB
  1216. 1.1 Who Does What in Finance - Infographic.pdf 1.2 MB
  1217. 1. Next Steps.html 3.0 KB
  1218. 1. Discounting Cash Flows in Microsoft Excel.mp4 39.6 MB
  1219. 1. Discounting Cash Flows in Microsoft Excel.srt 7.2 KB
  1220. 1.1 54. FV and PV-Lecture.xlsx 10.6 KB
  1221. 2. Calculating Internal Rate of Return (IRR) in Excel.mp4 19.9 MB
  1222. 2. Calculating Internal Rate of Return (IRR) in Excel.srt 3.8 KB
  1223. 2.1 55. IRR-Lecture.xlsx 11.2 KB
  1224. 3. Using the PMT Function to Create a Complete Loan Schedule.mp4 35.3 MB
  1225. 3. Using the PMT Function to Create a Complete Loan Schedule.srt 6.8 KB
  1226. 3.1 56. Loan Schedule-Lecture.xlsx 20.2 KB
  1227. 4. Date Functions in Excel.mp4 27.5 MB
  1228. 4. Date Functions in Excel.srt 7.3 KB
  1229. 4.1 57. Date Functions-Lecture.xlsx 12.3 KB
  1230. 1. Introduction to the Case Study.mp4 9.5 MB
  1231. 1. Introduction to the Case Study.srt 1.3 KB
  1232. 10. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 47.1 MB
  1233. 10. Using INDEX & MATCH as a Substitute for VLOOKUP.srt 5.4 KB
  1234. 10.1 66. Index Match_before.xlsm 41.0 KB
  1235. 10.2 66. Index Match-Lecture-after.xlsm 13.8 MB
  1236. 11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4 33.4 MB
  1237. 11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.srt 4.2 KB
  1238. 11.1 9a. XLOOKUP_after.xlsm 45.8 KB
  1239. 11.2 9a. XLOOKUP_before.xlsm 41.0 KB
  1240. 12. The Mapping Exercise.mp4 20.3 MB
  1241. 12. The Mapping Exercise.srt 2.7 KB
  1242. 12.1 67. Mapping-Lecture-after.xlsm 50.5 KB
  1243. 12.2 67. Mapping-Lecture-before.xlsm 50.6 KB
  1244. 12.3 Mapping-exercise-explained.pdf 243.0 KB
  1245. 13. Mapping the Rows in the Database Sheet.mp4 36.3 MB
  1246. 13. Mapping the Rows in the Database Sheet.srt 8.3 KB
  1247. 13.1 68. Mapping-Lecture-after.xlsm 50.5 KB
  1248. 13.2 68. Mapping-Lecture-before.xlsm 50.6 KB
  1249. 13.3 Mapping-exercise-explained.pdf 243.0 KB
  1250. 14. Building the Structure of the P&L Sheet.mp4 18.0 MB
  1251. 14. Building the Structure of the P&L Sheet.srt 3.1 KB
  1252. 14.1 69. Building a P&L-Lecture-after.xlsm 51.8 KB
  1253. 14.2 69. Building a P&L-Lecture-before.xlsm 50.2 KB
  1254. 15. A Practical Example of Professional Formatting in Excel.mp4 23.2 MB
  1255. 15. A Practical Example of Professional Formatting in Excel.srt 4.4 KB
  1256. 15.1 70 Formatting the P&L-Lecture-after.xlsm 52.0 KB
  1257. 15.2 70. Formatting a P&L-Lecture-before.xlsm 51.8 KB
  1258. 16. Populating the P&L Sheet with SUMIF.mp4 29.2 MB
  1259. 16. Populating the P&L Sheet with SUMIF.srt 3.7 KB
  1260. 16.1 71. Formatting the P&L-Lecture-after.xlsm 53.5 KB
  1261. 16.2 71. Formatting the P&L-Lecture-before.xlsm 52.0 KB
  1262. 17. Learn How to Find Mistakes with COUNTIF.mp4 27.6 MB
  1263. 17. Learn How to Find Mistakes with COUNTIF.srt 3.7 KB
  1264. 17.1 72. Countif-Lecture-after.xlsm 54.8 KB
  1265. 17.2 72. Countif-Lecture-before.xlsm 53.5 KB
  1266. 18. Calculating Growth Rates in Excel.mp4 28.3 MB
  1267. 18. Calculating Growth Rates in Excel.srt 4.2 KB
  1268. 18.1 73. Adding % variations-Lecture-after.xlsm 56.5 KB
  1269. 18.2 73. Adding % variations-Lecture-before.xlsm 54.8 KB
  1270. 18.3 Y-o-Y Function explanation.pdf 164.9 KB
  1271. 19. Quiz Number 3.html 147 bytes
  1272. 2. What You Will See Next.mp4 9.7 MB
  1273. 2. What You Will See Next.srt 1.5 KB
  1274. 3. Understand Your Data Source Before You Start Working on It.mp4 25.5 MB
  1275. 3. Understand Your Data Source Before You Start Working on It.srt 4.1 KB
  1276. 3.1 60. Get to know the data source - Lecture.xlsm 43.0 KB
  1277. 4. Ordering the Source Worksheet.mp4 24.8 MB
  1278. 4. Ordering the Source Worksheet.srt 3.2 KB
  1279. 4.1 61. Order a worksheet_after.xlsm 41.0 KB
  1280. 4.2 61. Order a worksheet_before.xlsm 43.1 KB
  1281. 5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 22.9 MB
  1282. 5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.srt 2.8 KB
  1283. 5.1 62. Creating a code_after.xlsm 41.7 KB
  1284. 5.2 62. Creating a code_before.xlsm 41.0 KB
  1285. 6. Learn How to Create a Database.mp4 18.8 MB
  1286. 6. Learn How to Create a Database.srt 2.7 KB
  1287. 6.1 63. Creating a database_after.xlsm 39.4 KB
  1288. 6.2 63. Creating a database_before.xlsm 35.3 KB
  1289. 7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 56.9 MB
  1290. 7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.srt 7.0 KB
  1291. 7.1 64. Vlookup_after.xlsm 44.5 KB
  1292. 7.2 64. Vlookup_before.xlsm 39.5 KB
  1293. 8. Using SUMIF to Complete the Database Sheet.mp4 44.8 MB
  1294. 8. Using SUMIF to Complete the Database Sheet.srt 5.5 KB
  1295. 8.1 65. Sumif_after.xlsm 49.5 KB
  1296. 8.2 65. Sumif_before.xlsm 44.5 KB
  1297. 9. FAQ Why Net income should be 0.html 1.3 KB
  1298. 1. Practical Exercise - SUMIFS.mp4 68.9 MB
  1299. 1. Practical Exercise - SUMIFS.srt 12.3 KB
  1300. 1.1 SUMIFS_Exercise_after.xlsx 1.2 MB
  1301. 1.2 SUMIFS_Exercise_before.xlsx 1.2 MB
  1302. 1. Introduction to Excel Charts.mp4 19.9 MB
  1303. 1. Introduction to Excel Charts.srt 1.3 KB
  1304. 2. Beginner's Guide to Inserting Charts in Excel.mp4 36.2 MB
  1305. 2. Beginner's Guide to Inserting Charts in Excel.srt 2.8 KB
  1306. 2.1 75. Inserting-Charts-Lecture.xlsm 11.4 MB
  1307. 3. Modifying Excel Charts - The Easy Way.mp4 42.1 MB
  1308. 3. Modifying Excel Charts - The Easy Way.srt 3.2 KB
  1309. 3.1 76. Formatting-a-Chart-Lecture.xlsm 11.5 MB
  1310. 4. Making Your Excel Charts Sexier - Proven Tips.mp4 53.3 MB
  1311. 4. Making Your Excel Charts Sexier - Proven Tips.srt 3.8 KB
  1312. 4.1 77. Modifying-a-Chart-Lecture.xlsm 11.4 MB
  1313. 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 21.4 MB
  1314. 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.srt 1.4 KB
  1315. 5.1 78. Bridge-Charts-Lecture.xlsx 13.1 KB
  1316. 6. New Ways to Visualize Your Data - Treemap Charts.mp4 18.3 MB
  1317. 6. New Ways to Visualize Your Data - Treemap Charts.srt 1.8 KB
  1318. 6.1 79. Treemap-Charts-Lecture.xlsx 12.6 KB
  1319. 7. How to Represent Trends with Sparklines.mp4 42.9 MB
  1320. 7. How to Represent Trends with Sparklines.srt 4.5 KB
  1321. 7.1 80. Sparklines-Lecture.xlsx 9.6 KB
  1322. [CourseClub.Me].url 122 bytes
  1323. [GigaCourse.Com].url 49 bytes

Discussion