| 1. Welcome! Course Introduction | |||
| 1. What Does the Course Cover.mp4 | 78.16 MB | ||
| 1. What Does the Course Cover.srt | 7.83 KB | ||
| 1.1 Financial Analyst - Course Curriculum.pdf.pdf | 581.35 KB | ||
| 2. Everything We Will Learn Has a Practical Application.mp4 | 25.7 MB | ||
| 2. Everything We Will Learn Has a Practical Application.srt | 4.06 KB | ||
| 2.1 Quick win.xlsx.xlsx | 9.74 KB | ||
| 3. The Best Way to Take This Course.mp4 | 31.91 MB | ||
| 3. The Best Way to Take This Course.srt | 3.53 KB | ||
| 4. Download All Course Materials.html | 774 B | ||
| 4.1 Download all course materials.html | 127 B | ||
| 10. Microsoft Excel - Working with Pivot Tables in Excel | |||
| 1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 | 15.07 MB | ||
| 1. Pivot Tables - Excel's Dynamic and Interactive Tables.srt | 2.35 KB | ||
| 2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 | 38.94 MB | ||
| 2. Creating a Pivot Table Choosing Row and Column Parameters.srt | 4.64 KB | ||
| 2.1 87. Creating-a-Pivot-Table-Lecture.xlsx.xlsx | 1.43 MB | ||
| 3. Design the Layout and Format of Your Pivot Tables.mp4 | 21.51 MB | ||
| 3. Design the Layout and Format of Your Pivot Tables.srt | 2.54 KB | ||
| 3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx.xlsx | 1.43 MB | ||
| 4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 | 45.96 MB | ||
| 4. Additional Techniques That Will Ease Your Work with Pivot Tables.srt | 5.5 KB | ||
| 4.1 89. Working-with-Pivot-Tables-Lecture.xlsx.xlsx | 1.88 MB | ||
| 5. One of the Most Useful Excel Functions - GetPivotData.mp4 | 36.27 MB | ||
| 5. One of the Most Useful Excel Functions - GetPivotData.srt | 4.51 KB | ||
| 5.1 90. GetPivotData-Lecture.xlsx.xlsx | 1.88 MB | ||
| 6. Welcome to the Future - Pivot Table Slicers.mp4 | 45.22 MB | ||
| 6. Welcome to the Future - Pivot Table Slicers.srt | 5.15 KB | ||
| 6.1 91. Slicers-Lecture.xlsx.xlsx | 1.88 MB | ||
| 7. Introduction to the Course Challenge.mp4 | 13.18 MB | ||
| 7. Introduction to the Course Challenge.srt | 1.49 KB | ||
| 8. COURSE CHALLENGE - Part 1.mp4 | 14.38 MB | ||
| 8. COURSE CHALLENGE - Part 1.srt | 1.8 KB | ||
| 8.1 93. Course-Challenge - Before solutions.xlsx.xlsx | 505.49 KB | ||
| 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting | |||
| 1. Introduction to the Case Study.mp4 | 26.74 MB | ||
| 1. Introduction to the Case Study.srt | 2.79 KB | ||
| 1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx | 13.26 MB | ||
| 10. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 | 36.4 MB | ||
| 10. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt | 4.04 KB | ||
| 10.1 103. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx | 20.78 MB | ||
| 11. Getting Fancy with Excel Slicers.mp4 | 35.81 MB | ||
| 11. Getting Fancy with Excel Slicers.srt | 4 KB | ||
| 11.1 104. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx | 22.82 MB | ||
| 12. This is How the Report Can be Used in Practice by High-level Executives.mp4 | 40.84 MB | ||
| 12. This is How the Report Can be Used in Practice by High-level Executives.srt | 5.12 KB | ||
| 12.1 105. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx | 22.81 MB | ||
| 2. Working with an SAP Data Extraction.mp4 | 39.19 MB | ||
| 2. Working with an SAP Data Extraction.srt | 4.48 KB | ||
| 3. Preliminary Mapping of the Data Extraction.mp4 | 31.17 MB | ||
| 3. Preliminary Mapping of the Data Extraction.srt | 2.78 KB | ||
| 3.1 96. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx | 14.89 MB | ||
| 4. Creating an Output Structure of the FMCG Model.mp4 | 22.17 MB | ||
| 4. Creating an Output Structure of the FMCG Model.srt | 3.19 KB | ||
| 4.1 97. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx | 14.92 MB | ||
| 5. Improving the Layout and Appearance of the FMCG Report.mp4 | 27.13 MB | ||
| 5. Improving the Layout and Appearance of the FMCG Report.srt | 4.93 KB | ||
| 5.1 98. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx | 14.91 MB | ||
| 6. Inserting Formulas and Automating Calculations.mp4 | 18.09 MB | ||
| 6. Inserting Formulas and Automating Calculations.srt | 40.57 MB | ||
| 6.1 99. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx | 14.91 MB | ||
| 7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 | 21.78 MB | ||
| 7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt | 2.45 KB | ||
| 7.1 100. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx | 20.81 MB | ||
| 8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 | 54.16 MB | ||
| 8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.srt | 7.71 KB | ||
| 8.1 101. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx | 20.82 MB | ||
| 9. GETPIVOTDATA fix.mp4 | 13.62 MB | ||
| 9. GETPIVOTDATA fix.srt | 1.5 KB | ||
| 12. Modeling in Excel - Building a Complete 3-statement Model | |||
| 1. Introduction to the Exercise.mp4 | 36.65 MB | ||
| 1. Introduction to the Exercise.srt | 3.65 KB | ||
| 1.1 Financial Modeling Notes.pdf.pdf | 690.08 KB | ||
| 1.2 106. Exerxise-before.xlsx.xlsx | 18.74 KB | ||
| 1.3 106. Exercise-after.xlsx.xlsx | 32.72 KB | ||
| 2. Let's Create a Mapping of Financials.mp4 | 30.73 MB | ||
| 2. Let's Create a Mapping of Financials.srt | 3.02 KB | ||
| 2.1 107. Exercise - before.xlsx.xlsx | 30.45 KB | ||
| 2.2 107. Exercise - after.xlsx.xlsx | 34.24 KB | ||
| 3. Building an Output P&L Sheet.mp4 | 30.55 MB | ||
| 3. Building an Output P&L Sheet.srt | 4.32 KB | ||
| 3.1 108. Exercise - before.xlsx.xlsx | 32.36 KB | ||
| 3.2 108. Exercise - after.xlsx.xlsx | 41.48 KB | ||
| 4. Filling in the Output P&L Sheet with Historical Financials.mp4 | 23.9 MB | ||
| 4. Filling in the Output P&L Sheet with Historical Financials.srt | 3.05 KB | ||
| 4.1 109. Exersice - before.xlsx.xlsx | 37.63 KB | ||
| 4.2 109. Exersice - after.xlsx.xlsx | 41.26 KB | ||
| 5. Calculating Percentage Variances and Applying Conditional Formatting.mp4 | 27.21 MB | ||
| 5. Calculating Percentage Variances and Applying Conditional Formatting.srt | 3.44 KB | ||
| 5.1 110. Exercise - after.xlsx.xlsx | 41.73 KB | ||
| 5.2 110. Exercise - before.xlsx.xlsx | 39.27 KB | ||
| 6. Building an Output Balance Sheet.mp4 | 29.48 MB | ||
| 6. Building an Output Balance Sheet.srt | 4.01 KB | ||
| 6.1 111. Exercise - after.xlsx.xlsx | 54.43 KB | ||
| 6.2 111. Exercise - before.xlsx.xlsx | 47.5 KB | ||
| 7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.mp4 | 43.48 MB | ||
| 7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.srt | 5.62 KB | ||
| 7.1 112. Exersise - after.xlsx.xlsx | 57.11 KB | ||
| 7.2 112. Exersice - before.xlsx.xlsx | 49.8 KB | ||
| 8. Adding the Forecast Period.mp4 | 32.16 MB | ||
| 8. Adding the Forecast Period.srt | 4.08 KB | ||
| 8.1 113. Exersice - before.xlsx.xlsx | 50.28 KB | ||
| 8.2 113. Exersice - after.xlsx.xlsx | 54.95 KB | ||
| 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios | |||
| 1. Calculating Historical Percentage Ratios and Use INDEX and MATCH for Scenarios.mp4 | 49.35 MB | ||
| 1. Calculating Historical Percentage Ratios and Use INDEX and MATCH for Scenarios.srt | 5.74 KB | ||
| 1.1 114. Exercise - aft.xlsx.xlsx | 54.94 KB | ||
| 1.2 114. Exercise - bef.xlsx.xlsx | 52.8 KB | ||
| 2. Building a Flexible Model with CHOOSE & MATCH.mp4 | 16.06 MB | ||
| 2. Building a Flexible Model with CHOOSE & MATCH.srt | 1.79 KB | ||
| 2.1 115. Exercise - after.xlsx.xlsx | 54.67 KB | ||
| 2.2 115. Exercise - before.xlsx.xlsx | 53.08 KB | ||
| 3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4 | 36.26 MB | ||
| 3. Building a Flexible Model with VLOOKUP & COLUMNS.srt | 3.63 KB | ||
| 3.1 116. Exercise - before.xlsx.xlsx | 53.08 KB | ||
| 3.2 116. Exercise - after.xlsx.xlsx | 55.12 KB | ||
| 4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 | 44.49 MB | ||
| 4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt | 5.71 KB | ||
| 4.1 Working Capital Days.pdf.pdf | 340.78 KB | ||
| 4.2 Course notes - Building a financial model.pdf.pdf | 575.23 KB | ||
| 4.3 117. Exercise -after.xlsx.xlsx | 56.6 KB | ||
| 4.4 117. Exercise before.xlsx.xlsx | 53.56 KB | ||
| 5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 | 30.53 MB | ||
| 5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt | 3.5 KB | ||
| 5.1 118. Exercise - before.xlsx.xlsx | 54.64 KB | ||
| 5.2 118. Exercise - after.xlsx.xlsx | 57.67 KB | ||
| 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model | |||
| 1. Building a Fixed Asset Roll Forward.mp4 | 40.93 MB | ||
| 1. Building a Fixed Asset Roll Forward.srt | 4.91 KB | ||
| 1.1 119. Exercise - after.xlsx.xlsx | 62.08 KB | ||
| 1.2 119. Exercise - before.xlsx.xlsx | 55.75 KB | ||
| 2. Building a Financial Liabilities Schedule.mp4 | 47.54 MB | ||
| 2. Building a Financial Liabilities Schedule.srt | 6.2 KB | ||
| 2.1 120. Exercise - after.xlsx.xlsx | 67.56 KB | ||
| 2.2 120. Exercise - before.xlsx.xlsx | 58.9 KB | ||
| 3. Building an Equity Schedule.mp4 | 36.56 MB | ||
| 3. Building an Equity Schedule.srt | 4.73 KB | ||
| 3.1 121. Exercise - after.xlsx.xlsx | 69.54 KB | ||
| 3.2 121. Exercise - before.xlsx.xlsx | 58.9 KB | ||
| 4. Preparing a Cash Flow Structure.mp4 | 15.19 MB | ||
| 4. Preparing a Cash Flow Structure.srt | 2.41 KB | ||
| 4.1 122. Exercise - before.xlsx.xlsx | 65.6 KB | ||
| 4.2 122. Exercise - after.xlsx.xlsx | 70.35 KB | ||
| 5. Calculating Cash Flows and Completing the Model.mp4 | 57.47 MB | ||
| 5. Calculating Cash Flows and Completing the Model.srt | 7.55 KB | ||
| 5.1 123. Exercise - before.xlsx.xlsx | 67.69 KB | ||
| 5.2 123. Exercise - after.xlsx.xlsx | 72.59 KB | ||
| 15. Accounting - Introduction to Accounting & Bookkeeping | |||
| 1. Accounting The Science Behind Financial Figures.mp4 | 32.88 MB | ||
| 1. Accounting The Science Behind Financial Figures.srt | 2 KB | ||
| 1.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf | 1.2 MB | ||
| 2. What is Accounting and Why Do You Need It.mp4 | 64.04 MB | ||
| 2. What is Accounting and Why Do You Need It.srt | 6.81 KB | ||
| 2.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf | 1.18 MB | ||
| 3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 | 26.68 MB | ||
| 3. The Importance of Bookkeeping - Good Accounting Records Are Essential.srt | 3.66 KB | ||
| 4. An Introduction to Financial Accounting.mp4 | 31.94 MB | ||
| 4. An Introduction to Financial Accounting.srt | 3.8 KB | ||
| 4.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf | 1.18 MB | ||
| 5. Quiz Number 3.html | 147 B | ||
| 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities | |||
| 1. The Different Types of Accounting Standards.mp4 | 21.66 MB | ||
| 1. The Different Types of Accounting Standards.srt | 3.42 KB | ||
| 1.1 The Complete Financial Analyst Course - Financial items.pdf.pdf | 890.01 KB | ||
| 10. Types of Liabilities.mp4 | 27.49 MB | ||
| 10. Types of Liabilities.srt | 5 KB | ||
| 11. Liability Categories - Practical Example.mp4 | 23.84 MB | ||
| 11. Liability Categories - Practical Example.srt | 3.38 KB | ||
| 12. Equity.mp4 | 15.01 MB | ||
| 12. Equity.srt | 2.69 KB | ||
| 13. Quiz Number 4.html | 147 B | ||
| 2. The Three Financial Statements.mp4 | 11.81 MB | ||
| 2. The Three Financial Statements.srt | 2.66 KB | ||
| 3. Types of Revenues.mp4 | 26.53 MB | ||
| 3. Types of Revenues.srt | 3.02 KB | ||
| 4. Types of Revenues - Exercise.mp4 | 18.61 MB | ||
| 4. Types of Revenues - Exercise.srt | 2.55 KB | ||
| 5. Types of Expenses.mp4 | 45.17 MB | ||
| 5. Types of Expenses.srt | 7.06 KB | ||
| 6. Income Taxes.mp4 | 17.9 MB | ||
| 6. Income Taxes.srt | 2.38 KB | ||
| 7. Depreciation & Amortization.mp4 | 40.12 MB | ||
| 7. Depreciation & Amortization.srt | 5.77 KB | ||
| 8. Types of Assets.mp4 | 31.77 MB | ||
| 8. Types of Assets.srt | 4.63 KB | ||
| 9. Asset Categories - Practical Example.mp4 | 29.13 MB | ||
| 9. Asset Categories - Practical Example.srt | 4.69 KB | ||
| 9.1 P-G-Financial-Report.pdf.pdf | 4.41 MB | ||
| 17. Accounting - Revenue Recognition | |||
| 1. Accrual Accounting.mp4 | 13.65 MB | ||
| 1. Accrual Accounting.srt | 2.18 KB | ||
| 1.1 The Complete Financial Analyst Course - Revenue recognition.pdf.pdf | 494.32 KB | ||
| 2. Revenue Recognition Criteria - Technical.mp4 | 32.24 MB | ||
| 2. Revenue Recognition Criteria - Technical.srt | 4.87 KB | ||
| 3. Potential Conflicts of Interest When Recognizing Revenue.mp4 | 18.78 MB | ||
| 3. Potential Conflicts of Interest When Recognizing Revenue.srt | 2.57 KB | ||
| 4. A Practical Example.mp4 | 39.52 MB | ||
| 4. A Practical Example.srt | 7.19 KB | ||
| 18. Accounting - Cost Recognition | |||
| 1. Technical Aspects of Cost Recognition.mp4 | 27.66 MB | ||
| 1. Technical Aspects of Cost Recognition.srt | 3.34 KB | ||
| 2. The Two Types of Income Statement Formats.mp4 | 7.28 MB | ||
| 2. The Two Types of Income Statement Formats.srt | 1.55 KB | ||
| 19. Accounting - Understanding the Big Picture Why, What, When, and How Much | |||
| 1. The Revenue Recognition Principle - Why Is It So Important.mp4 | 24.37 MB | ||
| 1. The Revenue Recognition Principle - Why Is It So Important.srt | 3.6 KB | ||
| 2. The Expense Recognition Principle - When to Recognize Expenses.mp4 | 25.24 MB | ||
| 2. The Expense Recognition Principle - When to Recognize Expenses.srt | 2.98 KB | ||
| 2. Microsoft Excel - Quick Introduction | |||
| 1. Microsoft Excel The World's #1 Office Software.mp4 | 22.03 MB | ||
| 1. Microsoft Excel The World's #1 Office Software.srt | 1.25 KB | ||
| 1.1 Introduction to Excel's basic features.pdf.pdf | 2.26 MB | ||
| 10. A Beginner's Introduction to Excel Functions.mp4 | 21.93 MB | ||
| 10. A Beginner's Introduction to Excel Functions.srt | 4.41 KB | ||
| 10.1 6. Functions- Lecture - Unsolved.xlsx.xlsx | 9.24 KB | ||
| 10.2 6. Functions-Exercise - Unsolved.xlsx.xlsx | 13.26 KB | ||
| 10.3 6. Functions- Exercise - Solved.xlsx.xlsx | 81.1 KB | ||
| 10.4 Introduction-to-Excels-basic-features.pdf.pdf | 2.26 MB | ||
| 10.5 6. Functions - Lecture -Solved.xlsx.xlsx | 9.34 KB | ||
| 11. Work Efficiently by Using Cut, Copy, and Paste.mp4 | 14.47 MB | ||
| 11. Work Efficiently by Using Cut, Copy, and Paste.srt | 2.64 KB | ||
| 11.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx | 12.56 KB | ||
| 11.2 Introduction-to-Excels-basic-features.pdf.pdf | 2.27 MB | ||
| 11.3 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx | 11.34 KB | ||
| 12. Work Efficiently by Using Cut, Copy, and Paste.html | 147 B | ||
| 13. Pasting Values, Formulas and Formats with Paste Special.mp4 | 10.97 MB | ||
| 13. Pasting Values, Formulas and Formats with Paste Special.srt | 1.4 KB | ||
| 13.1 8. Paste-Special-Solved.xlsx.xlsx | 13.46 KB | ||
| 13.2 Introduction-to-Excels-basic-features.pdf.pdf | 2.27 MB | ||
| 13.3 8. Paste-Special-Exercise-Text.xlsx.xlsx | 13.47 KB | ||
| 2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 | 22.75 MB | ||
| 2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.srt | 4.84 KB | ||
| 2.1 1. Introduction to Excel.pdf.pdf | 2.26 MB | ||
| 2.2 1. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx | 10.47 KB | ||
| 2.3 1. Overview-of-Excel-Exercise-Solved.xlsx.xlsx | 10.88 KB | ||
| 3. Data Entry Techniques in Excel.mp4 | 17.35 MB | ||
| 3. Data Entry Techniques in Excel.srt | 4.03 KB | ||
| 3.1 2. Data-Entry-Exercise - Unsolved.xlsx.xlsx | 10.97 KB | ||
| 3.2 2. Data-Entry - Lecture.xlsx.xlsx | 8.07 KB | ||
| 3.3 2. Data-Entry- Exercise -Solved.xlsx.xlsx | 32.76 KB | ||
| 4. How to Make Your Spreadsheets Look Professional.mp4 | 44.83 MB | ||
| 4. How to Make Your Spreadsheets Look Professional.srt | 7.16 KB | ||
| 4.1 3. Formatting-Exercise - Unsolved.xlsx.xlsx | 11.61 KB | ||
| 4.2 3. Formatting- Lecture - Unsolved.xlsx.xlsx | 8.91 KB | ||
| 4.3 3. Formatting - Lecture - Solved.xlsx.xlsx | 9.85 KB | ||
| 4.4 3. Formatting- Exercise - Solved.xlsx.xlsx | 11.59 KB | ||
| 5. Data Entry Techniques in Excel.html | 147 B | ||
| 6. Inserting, Deleting, and Modifying Rows & Columns.mp4 | 12.35 MB | ||
| 6. Inserting, Deleting, and Modifying Rows & Columns.srt | 2.32 KB | ||
| 6.1 4. Basic-Manipulations - Exercise - Solved.xlsx.xlsx | 32.43 KB | ||
| 6.2 4. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx | 11.06 KB | ||
| 6.3 4. Data Entry - Lecture.xlsx.xlsx | 8.07 KB | ||
| 7. Inserting, Deleting, and Modifying Rows & Columns.html | 147 B | ||
| 8. Excel Formulas for Beginners.mp4 | 14.45 MB | ||
| 8. Excel Formulas for Beginners.srt | 3.49 KB | ||
| 8.1 5. Formulas- Lecture - Solved.xlsx.xlsx | 9.36 KB | ||
| 8.2 5. Formulas- Exercise - Solved.xlsx.xlsx | 80.13 KB | ||
| 8.3 Introduction-to-Excels-basic-features.pdf.pdf | 2.26 MB | ||
| 8.4 5. Formulas - Exercise - Unsolved.xlsx.xlsx | 11.72 KB | ||
| 8.5 5. Formulas- Lecture - Unsolved.xlsx.xlsx | 9.3 KB | ||
| 9. Excel Formulas for Beginners.html | 147 B | ||
| 20. Accounting - The Core Principles of Accounting | |||
| 1. The Accounting Equation and Its Importance.mp4 | 24.48 MB | ||
| 1. The Accounting Equation and Its Importance.srt | 2.57 KB | ||
| 2. Elements of the Accounting System General Ledger.mp4 | 16.1 MB | ||
| 2. Elements of the Accounting System General Ledger.srt | 2.07 KB | ||
| 3. T-Accounts The Best Way to Understand Debits and Credits.mp4 | 21.38 MB | ||
| 3. T-Accounts The Best Way to Understand Debits and Credits.srt | 5.7 KB | ||
| 4. P&L T-Accounts.mp4 | 13.32 MB | ||
| 4. P&L T-Accounts.srt | 3.68 KB | ||
| 5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 | 24.09 MB | ||
| 5. The Double-Entry Principle - The Core Principle of Bookkeeping.srt | 6.99 KB | ||
| 6. Quiz Number 5.html | 147 B | ||
| 21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand | |||
| 1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 | 68.36 MB | ||
| 1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt | 12.69 KB | ||
| 1.1 Exercise - Before Solutions.xlsx.xlsx | 17.13 KB | ||
| 1.2 Exercise Part One.xlsx.xlsx | 17.44 KB | ||
| 1.3 Practical Exercise - List of transactions.pdf.pdf | 182.53 KB | ||
| 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 | 46.41 MB | ||
| 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt | 9.53 KB | ||
| 2.1 Exercise - Part Two.xlsx.xlsx | 20.09 KB | ||
| 2.2 Practical Exercise - List of transactions.pdf.pdf | 182.53 KB | ||
| 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 | 53.35 MB | ||
| 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt | 8.83 KB | ||
| 3.1 Practical Exercise - List of transactions.pdf.pdf | 182.53 KB | ||
| 3.2 Exercise - Part Three.xlsx.xlsx | 19.29 KB | ||
| 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 | 58.94 MB | ||
| 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt | 8.34 KB | ||
| 4.1 Practical Exercise - List of transactions.pdf.pdf | 182.53 KB | ||
| 4.2 Exercise - Part Four.xlsx.xlsx | 20.7 KB | ||
| 22. Accounting - The Importance of Timing | |||
| 1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 | 13.23 MB | ||
| 1. Timing of Cash Flows and Why It Plays an Important Role in a Business.srt | 1.58 KB | ||
| 2. Timing of Income Principles of Revenue Recognition.mp4 | 26.87 MB | ||
| 2. Timing of Income Principles of Revenue Recognition.srt | 7.51 KB | ||
| 3. Timing of Expenses Principles of Cost Recognition.mp4 | 15.8 MB | ||
| 3. Timing of Expenses Principles of Cost Recognition.srt | 4.03 KB | ||
| 4. The Four Type of Accruals Arising in Accounting Transactions.mp4 | 49.58 MB | ||
| 4. The Four Type of Accruals Arising in Accounting Transactions.srt | 6.18 KB | ||
| 5. Quiz Number 6.html | 147 B | ||
| 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis | |||
| 1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 | 27.65 MB | ||
| 1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt | 3.58 KB | ||
| 2. The Three Parts of Cash Flow Statements Explained.mp4 | 19.99 MB | ||
| 2. The Three Parts of Cash Flow Statements Explained.srt | 2.85 KB | ||
| 3. Cash Flow Computations - The Direct Method.mp4 | 19.72 MB | ||
| 3. Cash Flow Computations - The Direct Method.srt | 2.75 KB | ||
| 4. Cash Flow Computations - The Indirect Method.mp4 | 31.38 MB | ||
| 4. Cash Flow Computations - The Indirect Method.srt | 4.77 KB | ||
| 5. Calculating Cash Flow in Practice A Complete Example.mp4 | 50.62 MB | ||
| 5. Calculating Cash Flow in Practice A Complete Example.srt | 8.61 KB | ||
| 5.1 Cash-Flow.xlsx.xlsx | 55.38 KB | ||
| 24. Advanced Accounting - Trade Receivables | |||
| 1. Why a Company Needs to Pay Attention to Trade Receivables.mp4 | 25.22 MB | ||
| 1. Why a Company Needs to Pay Attention to Trade Receivables.srt | 3.47 KB | ||
| 1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf.pdf | 706.56 KB | ||
| 2. What If Clients Do Not Pay on Time.mp4 | 26.47 MB | ||
| 2. What If Clients Do Not Pay on Time.srt | 4.3 KB | ||
| 3. How to Handle Non-paying Customers A Case-study.mp4 | 24.94 MB | ||
| 3. How to Handle Non-paying Customers A Case-study.srt | 3.4 KB | ||
| 4. A Technique to Collect Trade Receivables Sooner.mp4 | 15.44 MB | ||
| 4. A Technique to Collect Trade Receivables Sooner.srt | 2.45 KB | ||
| 25. Advanced Accounting - Inventory | |||
| 1. The Different Types of Inventory We Can Have.mp4 | 26.66 MB | ||
| 1. The Different Types of Inventory We Can Have.srt | 3.5 KB | ||
| 2. The Connection Between Cost of Goods Sold and Inventory.mp4 | 17.24 MB | ||
| 2. The Connection Between Cost of Goods Sold and Inventory.srt | 3.37 KB | ||
| 3. Cost Flow Methods.mp4 | 28.71 MB | ||
| 3. Cost Flow Methods.srt | 5.97 KB | ||
| 4. Cost Flow Methods - a Practical Exercise.mp4 | 6.75 MB | ||
| 4. Cost Flow Methods - a Practical Exercise.srt | 1.36 KB | ||
| 4.1 Inventory Cost Flow Methods_solved.xlsx.xlsx | 12.38 KB | ||
| 4.2 Inventory Cost Flow Methods_unsolved.xlsx.xlsx | 11.53 KB | ||
| 4.3 Inventory Cost Flow Methods – with solutions.pptx.pptx | 174.96 KB | ||
| 4.4 Inventory Cost Flow Methods.pptx.pptx | 168.54 KB | ||
| 26. Advanced Accounting - Fixed Assets | |||
| 1. The Different Types of Fixed Assets.mp4 | 20.72 MB | ||
| 1. The Different Types of Fixed Assets.srt | 4.02 KB | ||
| 2. Capitalizing Interest Expenses.mp4 | 7.66 MB | ||
| 2. Capitalizing Interest Expenses.srt | 2.56 KB | ||
| 3. Fair Value Accounting.mp4 | 24.26 MB | ||
| 3. Fair Value Accounting.srt | 3.2 KB | ||
| 4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4 | 35.29 MB | ||
| 4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.srt | 5.25 KB | ||
| 5. The Revaluation Model.mp4 | 39.05 MB | ||
| 5. The Revaluation Model.srt | 6.36 KB | ||
| 6. The Revaluation Model - Practical Exercise.mp4 | 37.99 MB | ||
| 6. The Revaluation Model - Practical Exercise.srt | 6.27 KB | ||
| 7. Intangible Assets Created Internally.mp4 | 17.7 MB | ||
| 7. Intangible Assets Created Internally.srt | 2.64 KB | ||
| 27. Advanced Accounting - Trade Payables | |||
| 1. How We Account for Trade Payables.mp4 | 22.53 MB | ||
| 1. How We Account for Trade Payables.srt | 3.52 KB | ||
| 2. What Is the Difference Between Accounts Payable and Notes Payable.mp4 | 10.89 MB | ||
| 2. What Is the Difference Between Accounts Payable and Notes Payable.srt | 1.8 KB | ||
| 3. Why Use E-invoicing.mp4 | 25.92 MB | ||
| 3. Why Use E-invoicing.srt | 3.62 KB | ||
| 28. Advanced Accounting - Financial Liabilities | |||
| 1. The Difference Between Debt and Equity.mp4 | 14.8 MB | ||
| 1. The Difference Between Debt and Equity.srt | 2.86 KB | ||
| 2. Amortizing a Loan.mp4 | 20.65 MB | ||
| 2. Amortizing a Loan.srt | 3.51 KB | ||
| 3. Debt Covenants.mp4 | 25.78 MB | ||
| 3. Debt Covenants.srt | 4.27 KB | ||
| 4. Debt Covenants - A Practical Example.mp4 | 13.67 MB | ||
| 4. Debt Covenants - A Practical Example.srt | 2.25 KB | ||
| 29. Advanced Accounting - Leasing Liabilties | |||
| 1. The Reason Companies Lease Assets.mp4 | 11.11 MB | ||
| 1. The Reason Companies Lease Assets.srt | 1.66 KB | ||
| 2. Solving a Complete Leasing Exercise.mp4 | 38.17 MB | ||
| 2. Solving a Complete Leasing Exercise.srt | 5.73 KB | ||
| 2.1 Leasing exercises.pdf.pdf | 156.14 KB | ||
| 2.2 Leasing-Exercise-2-Solved.xlsx.xlsx | 11.18 KB | ||
| 2.3 Leasing Exercise 2 - Unsolved.xlsx.xlsx | 9.63 KB | ||
| 3. Microsoft Excel - Useful Tools | |||
| 1. Inserting a Line Break with Alt + Enter.mp4 | 6.17 MB | ||
| 1. Inserting a Line Break with Alt + Enter.srt | 1.04 KB | ||
| 1.1 9. Alt-Enter-Exercise - Solved.xlsx.xlsx | 11.4 KB | ||
| 1.2 9. Alt-Enter- Lecture - Unsolved.xlsx.xlsx | 9.64 KB | ||
| 1.3 9. Alt-Enter- Lecture - Solved.xlsx.xlsx | 9.65 KB | ||
| 1.4 9. Alt-Enter-Exercise - Unsolved.xlsx.xlsx | 11.12 KB | ||
| 2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 | 13.87 MB | ||
| 2. Do More with Your Sales Data with Excel's Text to Columns Feature.srt | 2.48 KB | ||
| 2.1 10. Text-to-columns-Lecture - Solved.xlsx.xlsx | 9.9 KB | ||
| 2.2 10. Text-to-Columns-Exercise - Solved.xlsx.xlsx | 11.3 KB | ||
| 2.3 10. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx | 10.57 KB | ||
| 2.4 10. Text-to-columns-Lecture - Unsolved.xlsx.xlsx | 9.76 KB | ||
| 3. Do More with Your Sales Data with Excel's Text to Columns Feature.html | 147 B | ||
| 4. Create Easily Printable Excel Documents.mp4 | 9.2 MB | ||
| 4. Create Easily Printable Excel Documents.srt | 1.51 KB | ||
| 4.1 11. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx | 11.42 KB | ||
| 4.2 11. Set-Print-Area-Lecture - Solved.xlsx.xlsx | 11.22 KB | ||
| 4.3 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 | 3.79 MB | ||
| 5. How to Wrap Text in Excel and Adjust a Cell's Size.srt | 933 B | ||
| 5.1 12. Wrap-text-Lecture - Unsolved.xlsx.xlsx | 9.61 KB | ||
| 5.2 12. Wrap-text-Lecture - Solved.xlsx.xlsx | 9.61 KB | ||
| 5.3 12. Wrap-Text-Exercise - Unsolved.xlsx.xlsx | 10.17 KB | ||
| 5.4 12. Wrap-Text-Exercise - Solved.xlsx.xlsx | 10.2 KB | ||
| 6. Insert Hyperlinks into Excel Spreadsheets.mp4 | 8.25 MB | ||
| 6. Insert Hyperlinks into Excel Spreadsheets.srt | 1.4 KB | ||
| 6.1 13. Hyperlinks-Exercise - Solved.xlsx.xlsx | 137.06 KB | ||
| 6.2 Useful-Tips-Tools.pdf.pdf | 3.31 MB | ||
| 6.3 13. Hyperlinks-Exercise - Unsolved.xlsx.xlsx | 136.89 KB | ||
| 7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 | 15.25 MB | ||
| 7. Using Excel's Freeze Panes to Handle Large Datasets.srt | 1.46 KB | ||
| 7.1 14. Freeze-Panes-Lecture - Solved.xlsx.xlsx | 643.94 KB | ||
| 7.2 14. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx | 643.87 KB | ||
| 7.3 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 | 9.18 MB | ||
| 8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.srt | 1.03 KB | ||
| 8.1 Useful Tips & Tools.pdf.pdf | 3.3 MB | ||
| 9. A Quick Introduction to Excel's Pivot Tables.mp4 | 25.37 MB | ||
| 9. A Quick Introduction to Excel's Pivot Tables.srt | 2.67 KB | ||
| 9.1 21. Pivot tables - Lecture - Unsolved.xlsm.xlsm | 687.83 KB | ||
| 9.2 21. Pivot tables - Lecture - Solved.xlsm.xlsm | 897.26 KB | ||
| 9.3 21. Pivot Tables - Exercise - Solved.xlsx.xlsx | 190.47 KB | ||
| 9.4 21. Pivot Tables - Exercise - Unsolved.xlsx.xlsx | 152.17 KB | ||
| 9.5 Useful-Tips-Tools.pdf.pdf | 3.31 MB | ||
| 30. Advanced Accounting - Using Leverage | |||
| 1. What is Leverage and Why Companies Use Financial Leverage.mp4 | 57.42 MB | ||
| 1. What is Leverage and Why Companies Use Financial Leverage.srt | 5.51 KB | ||
| 2. The Implications of Using Excessive Leverage.mp4 | 34.49 MB | ||
| 2. The Implications of Using Excessive Leverage.srt | 4.2 KB | ||
| 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments | |||
| 1. The Different Types of Equity.mp4 | 55.22 MB | ||
| 1. The Different Types of Equity.srt | 5.01 KB | ||
| 2. Raising Equity in Different Stages of a Company's Lifecycle.mp4 | 71.95 MB | ||
| 2. Raising Equity in Different Stages of a Company's Lifecycle.srt | 7.86 KB | ||
| 3. The Types of Dividends Companies Pay to Shareholders.mp4 | 44.87 MB | ||
| 3. The Types of Dividends Companies Pay to Shareholders.srt | 4.54 KB | ||
| 4. Dividend Payments - a Timeline.mp4 | 36.18 MB | ||
| 4. Dividend Payments - a Timeline.srt | 3.87 KB | ||
| 5. What Are Share Repurchases and Why Companies Do Them.mp4 | 43.91 MB | ||
| 5. What Are Share Repurchases and Why Companies Do Them.srt | 4.1 KB | ||
| 6. The Idea Behind Stock Splits.mp4 | 36.05 MB | ||
| 6. The Idea Behind Stock Splits.srt | 3.87 KB | ||
| 32. Financial Statement Analysis - An Introduction | |||
| 1. What is a 10-K Report and Why Is It important for Investors.mp4 | 27.34 MB | ||
| 1. What is a 10-K Report and Why Is It important for Investors.srt | 3.08 KB | ||
| 2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 | 74.9 MB | ||
| 2. Finding, Downloading and Going Through the Annual Report of P&G.srt | 7.86 KB | ||
| 2.1 P&G Financial Report.pdf.pdf | 4.4 MB | ||
| 3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 | 25.84 MB | ||
| 3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.srt | 3.04 KB | ||
| 4. Indispensable Tools for Financial Statement Analysis.mp4 | 15.32 MB | ||
| 4. Indispensable Tools for Financial Statement Analysis.srt | 1.63 KB | ||
| 5. Quiz Number 7.html | 147 B | ||
| 33. Financial Statement Analysis - Subtleties | |||
| 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 | 18.45 MB | ||
| 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt | 2.45 KB | ||
| 1.1 Financial Statement Analysis - Notes.pdf.pdf | 772.86 KB | ||
| 2. First Steps in Financial Statement Analysis.mp4 | 32.03 MB | ||
| 2. First Steps in Financial Statement Analysis.srt | 3.98 KB | ||
| 3. Horizontal vs. Vertical Financial Statement Analysis.mp4 | 28.21 MB | ||
| 3. Horizontal vs. Vertical Financial Statement Analysis.srt | 4.44 KB | ||
| 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 | 11.85 MB | ||
| 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt | 1.66 KB | ||
| 4.1 Working Capital Days.pdf.pdf | 340.78 KB | ||
| 5. Using Accounting Ratios to Assess Business Performance.mp4 | 36.8 MB | ||
| 5. Using Accounting Ratios to Assess Business Performance.srt | 8.94 KB | ||
| 6. Quiz Number 8.html | 147 B | ||
| 34. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials | |||
| 1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 | 55.77 MB | ||
| 1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt | 7.53 KB | ||
| 1.1 P&G Financials.xlsx.xlsx | 14.23 KB | ||
| 1.2 P&G Financial Report.pdf.pdf | 4.4 MB | ||
| 1.3 P&G Financials_WithRatios.xlsx.xlsx | 13.93 KB | ||
| 1.4 P&G Financials_Before.xlsx.xlsx | 12.79 KB | ||
| 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 | 36.92 MB | ||
| 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt | 5.03 KB | ||
| 2.1 P&G Financials.xlsx.xlsx | 14.23 KB | ||
| 2.2 P&G Financial Report.pdf.pdf | 4.4 MB | ||
| 2.3 P&G Financials_Before.xlsx.xlsx | 12.79 KB | ||
| 2.4 P&G Financials_WithRatios.xlsx.xlsx | 13.93 KB | ||
| 3. COURSE CHALLENGE - Part 2.mp4 | 18.74 MB | ||
| 3. COURSE CHALLENGE - Part 2.srt | 2.12 KB | ||
| 3.1 2. Course Challenge.xlsx.xlsx | 627.6 KB | ||
| 35. Financial Statement Analysis - Tesla Exercise | |||
| 1. What You Will See Next In This Section.mp4 | 18.33 MB | ||
| 1. What You Will See Next In This Section.srt | 1.39 KB | ||
| 2. How to Download Tesla's Historical Financials.mp4 | 14.4 MB | ||
| 2. How to Download Tesla's Historical Financials.srt | 2.84 KB | ||
| 2.1 Tesla 2017.pdf.pdf | 2.5 MB | ||
| 2.2 Tesla 2015.pdf.pdf | 1.29 MB | ||
| 2.3 Tesla 2016.pdf.pdf | 2.21 MB | ||
| 2.4 Tesla 2018 Q2.pdf.pdf | 635.07 KB | ||
| 3. Calculating and Analyzing Growth and Profitability Ratios.mp4 | 96.5 MB | ||
| 3. Calculating and Analyzing Growth and Profitability Ratios.srt | 11.34 KB | ||
| 3.1 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx.xlsx | 1.28 MB | ||
| 3.2 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx.xlsx | 1.28 MB | ||
| 4. Calculating and Analyzing Liquidity Ratios.mp4 | 74.95 MB | ||
| 4. Calculating and Analyzing Liquidity Ratios.srt | 7.68 KB | ||
| 4.1 Tesla - Financial Statement Analysis - Liquidity_before.xlsx.xlsx | 1.28 MB | ||
| 4.2 Tesla - Financial Statement Analysis - Liquidity_after.xlsx.xlsx | 1.28 MB | ||
| 5. Calculating and Analyzing Solvency Ratios.mp4 | 20.03 MB | ||
| 5. Calculating and Analyzing Solvency Ratios.srt | 2.09 KB | ||
| 5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx.xlsx | 1.28 MB | ||
| 5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx.xlsx | 1.28 MB | ||
| 36. Working Capital Management | |||
| 1. Introduction.mp4 | 23.42 MB | ||
| 1. Introduction.srt | 3.51 KB | ||
| 10. Symptoms of Inefficient Working Capital - Trade Payables.mp4 | 17.94 MB | ||
| 10. Symptoms of Inefficient Working Capital - Trade Payables.srt | 2.8 KB | ||
| 10.1 Working capital test_solved.xlsx.xlsx | 13.58 KB | ||
| 10.2 Working capital test_unsolved.xlsx.xlsx | 12.7 KB | ||
| 2. The Importance of Working Capital Optimization Case Study.mp4 | 89.97 MB | ||
| 2. The Importance of Working Capital Optimization Case Study.srt | 10.97 KB | ||
| 3. Overtrading vs. Excessive Investment.mp4 | 33.11 MB | ||
| 3. Overtrading vs. Excessive Investment.srt | 4.27 KB | ||
| 4. Trade Receivables Management.mp4 | 76.14 MB | ||
| 4. Trade Receivables Management.srt | 10.39 KB | ||
| 5. Re-order Level.mp4 | 31.3 MB | ||
| 5. Re-order Level.srt | 4.05 KB | ||
| 6. Economic Order Quantity (EOQ).mp4 | 31.85 MB | ||
| 6. Economic Order Quantity (EOQ).srt | 5.09 KB | ||
| 7. Inventory Optimization Techniques.mp4 | 50.48 MB | ||
| 7. Inventory Optimization Techniques.srt | 6.46 KB | ||
| 8. Trade Payables Management.mp4 | 19.27 MB | ||
| 8. Trade Payables Management.srt | 2.5 KB | ||
| 9. Working Capital Optimization - a Roadmap.mp4 | 48.18 MB | ||
| 9. Working Capital Optimization - a Roadmap.srt | 6.49 KB | ||
| 37. Fundamentals of Business & Financial Analysis | |||
| 1. Fundamentals of Business & Financial Analysis.html | 151 B | ||
| 38. Finance 101 - The Time Value of Money and Interest Rate Components | |||
| 1. Finance 101 Important Financial Principles That You Will Need.mp4 | 16.09 MB | ||
| 1. Finance 101 Important Financial Principles That You Will Need.srt | 852 B | ||
| 1.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 2. Understanding the Time Value of Money.mp4 | 6.22 MB | ||
| 2. Understanding the Time Value of Money.srt | 1.74 KB | ||
| 2.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 2.2 Time value of money.pdf.pdf | 777.26 KB | ||
| 3. How Interest Rates Play an Important Role in the Economy.mp4 | 13.75 MB | ||
| 3. How Interest Rates Play an Important Role in the Economy.srt | 1.99 KB | ||
| 3.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 4. The Components Forming Interest Rates in Real Life.mp4 | 16.63 MB | ||
| 4. The Components Forming Interest Rates in Real Life.srt | 3.74 KB | ||
| 4.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 4.2 Interest rate components.pdf.pdf | 807.55 KB | ||
| 5. What Is Libor and What Purpose Does It Serve.mp4 | 17.13 MB | ||
| 5. What Is Libor and What Purpose Does It Serve.srt | 1.34 KB | ||
| 5.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 6. The Difference Between Fixed and Variable Interest Rates.mp4 | 17.02 MB | ||
| 6. The Difference Between Fixed and Variable Interest Rates.srt | 2.43 KB | ||
| 6.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 7. What Is Default Risk and How Does a Bank Account For It.mp4 | 31.16 MB | ||
| 7. What Is Default Risk and How Does a Bank Account For It.srt | 9.07 KB | ||
| 7.1 Default risk.pdf.pdf | 880.84 KB | ||
| 7.2 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 8. Corporate Loan Specifics.mp4 | 25.76 MB | ||
| 8. Corporate Loan Specifics.srt | 2.11 KB | ||
| 8.1 Finance 101 - Introduction to the World of Finance.pdf.pdf | 689.77 KB | ||
| 39. Finance 101 - The Value of Cash Flows with Different Timing | |||
| 1. Calculating the Present Value of Future Cash Flows.mp4 | 29.79 MB | ||
| 1. Calculating the Present Value of Future Cash Flows.srt | 6.11 KB | ||
| 1.1 1. Calculating Future Cash Flows.pdf.pdf | 810.28 KB | ||
| 1.2 3.1 Present Value of Cash Flows.xlsx.xlsx | 9.85 KB | ||
| 2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 | 29.11 MB | ||
| 2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.srt | 5.11 KB | ||
| 2.1 2. NPV.pdf.pdf | 192.19 KB | ||
| 4. Microsoft Excel - Best Practices That Will Make a Difference | |||
| 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 | 13.84 MB | ||
| 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt | 2.12 KB | ||
| 1.1 Useful-Tips-Tools.pdf.pdf | 3.31 MB | ||
| 1.2 17. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx | 9.56 KB | ||
| 1.3 17. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx | 10.76 KB | ||
| 1.4 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx | 8.98 KB | ||
| 1.5 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx | 10.63 KB | ||
| 10. Find and Select Cells That Meet Specific Conditions.mp4 | 13.45 MB | ||
| 10. Find and Select Cells That Meet Specific Conditions.srt | 1.81 KB | ||
| 10.1 23. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx | 21.59 KB | ||
| 10.2 23. Select-Special-F5-Exercise - Solved.xlsx.xlsx | 22.27 KB | ||
| 10.3 23. Select-Special-Lecture.xlsx.xlsx | 10.56 KB | ||
| 10.4 Useful-Tips-Tools.pdf.pdf | 3.31 MB | ||
| 11. Find and Select Cells That Meet Specific Conditions.html | 147 B | ||
| 12. How to Create Dynamic Names in Excel Spreadsheets.mp4 | 15.15 MB | ||
| 12. How to Create Dynamic Names in Excel Spreadsheets.srt | 1.65 KB | ||
| 12.1 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx | 11.23 KB | ||
| 12.2 Useful-Tips-Tools.pdf.pdf | 3.31 MB | ||
| 12.3 24. Dynamic-Naming-Lecture - Solved.xlsx.xlsx | 13.83 KB | ||
| 12.4 24. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx | 13.54 KB | ||
| 12.5 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx | 11.73 KB | ||
| 13. How to Create Dynamic Names in Excel Spreadsheets.html | 147 B | ||
| 14. Using Named Ranges to Make Formulas More Readable.mp4 | 9.11 MB | ||
| 14. Using Named Ranges to Make Formulas More Readable.srt | 1.82 KB | ||
| 14.1 25. Naming-ranges-Lecture - Unsolved.xlsx.xlsx | 8.79 KB | ||
| 14.2 25. Naming-ranges-Lecture - Solved.xlsx.xlsx | 10.34 KB | ||
| 14.3 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx | 11.07 KB | ||
| 14.4 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 14.5 25. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx | 11.65 KB | ||
| 15. Custom Number Formatting.mp4 | 9.89 MB | ||
| 15. Custom Number Formatting.srt | 1.98 KB | ||
| 15.1 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 15.2 31. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx | 11.08 KB | ||
| 15.3 31. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx | 11.35 KB | ||
| 16. How to Add a Drop-down List in Excel.mp4 | 16.29 MB | ||
| 16. How to Add a Drop-down List in Excel.srt | 2.32 KB | ||
| 16.1 27. Data-Validation-Lecture - Solved.xlsx.xlsx | 10.84 KB | ||
| 16.2 27. Data-Validation-Lecture - Unsolved.xlsx.xlsx | 10.84 KB | ||
| 16.3 27. Drop-down-List-Exercise - Unsolved.xlsx.xlsx | 11.34 KB | ||
| 16.4 27. Drop-down-List-Exercise - Solved.xlsx.xlsx | 77.02 KB | ||
| 17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 | 13.57 MB | ||
| 17. Using Custom-sort to Sort Multiple Columns Within a Table.srt | 1.71 KB | ||
| 17.1 28. Sort-data-Lecture - Solved.xlsx.xlsx | 145.65 KB | ||
| 17.2 28. Custom-Sort-Exercise - Unsolved.xlsx.xlsx | 11.37 KB | ||
| 17.3 28. Sort-data-Lecture - Unsolved.xlsx.xlsx | 145.35 KB | ||
| 17.4 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 17.5 28. Custom-Sort-Exercise - Solved.xlsx.xlsx | 11.46 KB | ||
| 18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 | 45.95 MB | ||
| 18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt | 5.03 KB | ||
| 18.1 29. Microsoft-Excel-Shortcuts-for-MAC.pdf.pdf | 769.21 KB | ||
| 18.2 29. Microsoft-Excel-Keyboard-Shortcuts.pdf.pdf | 1.26 MB | ||
| 18.3 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 19. Multiply by 1.mp4 | 14.84 MB | ||
| 19. Multiply by 1.srt | 1.74 KB | ||
| 19.1 30. Multiply-by-1-Lecture-before.xlsx.xlsx | 16.47 KB | ||
| 19.2 30. Multiply-by-1-Lecture-after.xlsx.xlsx | 17.21 KB | ||
| 2. Macros Are a Great Timesaver! Here's Why..mp4 | 21.41 MB | ||
| 2. Macros Are a Great Timesaver! Here's Why..srt | 3.46 KB | ||
| 2.1 18. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx | 9.66 KB | ||
| 2.2 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 2.3 18. Creating-a-Macro-Lecture - Solved.xlsx.xlsx | 11.17 KB | ||
| 2.4 18. Macros-Exercise - Unsolved.xlsx.xlsx | 10.34 KB | ||
| 2.5 18. Macros-Exercise - Solved.xlsx.xlsx | 145.02 KB | ||
| 20. Find and Replace - References.mp4 | 24.05 MB | ||
| 20. Find and Replace - References.srt | 3.45 KB | ||
| 20.1 31. Find-and-Replace-references-Lecture-before.xlsx.xlsx | 38.79 KB | ||
| 20.2 31. Find-and-Replace-references-Lecture-after.xlsx.xlsx | 37.91 KB | ||
| 21. Find and Replace - Formatting.mp4 | 13.78 MB | ||
| 21. Find and Replace - Formatting.srt | 1.91 KB | ||
| 21.1 32. Find-replace-Lecture-before.xlsx.xlsx | 17.19 KB | ||
| 21.2 32. Find-replace-Lecture-after.xlsx.xlsx | 17.19 KB | ||
| 22. Green References.mp4 | 12.6 MB | ||
| 22. Green References.srt | 1.7 KB | ||
| 22.1 33. Green-references-Lecture.xlsx.xlsx | 12 KB | ||
| 23. Beauty Saving - The Professional Way of Saving Files.mp4 | 14.03 MB | ||
| 23. Beauty Saving - The Professional Way of Saving Files.srt | 2.54 KB | ||
| 23.1 34. Beauty-saving-Lecture-before.xlsx.xlsx | 17.17 KB | ||
| 23.2 34. Beauty-saving-Lecture-after.xlsx.xlsx | 17.05 KB | ||
| 24. The Power of F2.mp4 | 17.73 MB | ||
| 24. The Power of F2.srt | 2.19 KB | ||
| 24.1 43. F2-Lecture.xlsm.xlsm | 49.9 KB | ||
| 25. Conditional Formatting.mp4 | 58.7 MB | ||
| 25. Conditional Formatting.srt | 6.07 KB | ||
| 25.1 41. Conditional formatting - Lecture.xlsx.xlsx | 41.73 KB | ||
| 26. Quiz Number 1.html | 147 B | ||
| 3. How to Use the Same Macro On Multiple Workbooks.mp4 | 12.76 MB | ||
| 3. How to Use the Same Macro On Multiple Workbooks.srt | 1.68 KB | ||
| 3.1 19. How-to-save-macros-Lecture-before.xlsx.xlsx | 6.02 KB | ||
| 3.2 19. How-to-save-macros-Lecture-after.xlsm.xlsm | 12.59 KB | ||
| 3.3 19. Another-file.xlsx.xlsx | 8.81 KB | ||
| 4. Macros Are a Great Timesaver! Here's Why..html | 147 B | ||
| 5. The Secret to Faster Scrolling in Excel.mp4 | 20.84 MB | ||
| 5. The Secret to Faster Scrolling in Excel.srt | 1.84 KB | ||
| 5.1 25. Fast-Scrolling-Exercise - Solved.xlsx.xlsx | 44.35 KB | ||
| 5.2 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 5.3 25. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx | 43.9 KB | ||
| 5.4 25. Fast-Scrolling - Lecture.xlsx.xlsx | 642.82 KB | ||
| 6. Be even quicker F5 + Enter.mp4 | 19.78 MB | ||
| 6. Be even quicker F5 + Enter.srt | 2.16 KB | ||
| 6.1 21. F5-go-to - Lecture.xlsm.xlsm | 50.76 KB | ||
| 7. The Secret to Faster Scrolling in Excel.html | 147 B | ||
| 8. Using Absolute and Relative Cell References.mp4 | 27.03 MB | ||
| 8. Using Absolute and Relative Cell References.srt | 2.71 KB | ||
| 8.1 22. Fixing-references-Lecture - Unsolved.xlsx.xlsx | 643.98 KB | ||
| 8.2 Useful-Tips-Tools.pdf.pdf | 3.3 MB | ||
| 8.3 22. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx | 10.67 KB | ||
| 8.4 22. Fixing-references-Lecture - Solved.xlsx.xlsx | 645.17 KB | ||
| 8.5 22. Fixing-Cells-Exercise - Solved.xlsx.xlsx | 10.82 KB | ||
| 9. Using Absolute and Relative Cell References.html | 147 B | ||
| 40. Finance 101 - Loan Calculations | |||
| 1. Using Annuities.mp4 | 24.24 MB | ||
| 1. Using Annuities.srt | 3.92 KB | ||
| 2. Calculating a Complete Loan Schedule.mp4 | 49.62 MB | ||
| 2. Calculating a Complete Loan Schedule.srt | 7.36 KB | ||
| 3. COURSE CHALLENGE - Part 3.mp4 | 13.88 MB | ||
| 3. COURSE CHALLENGE - Part 3.srt | 1.64 KB | ||
| 3.1 3. Course Challenge.xlsx.xlsx | 537.67 KB | ||
| 41. Capital Budgeting - Basic Notions | |||
| 1. What is Capital Budgeting.mp4 | 13.24 MB | ||
| 1. What is Capital Budgeting.srt | 1.89 KB | ||
| 2. When Do We Use Capital Budgeting.mp4 | 20.52 MB | ||
| 2. When Do We Use Capital Budgeting.srt | 2.7 KB | ||
| 3. The Time Value of Money in a Capital Budgeting Setting.mp4 | 18.9 MB | ||
| 3. The Time Value of Money in a Capital Budgeting Setting.srt | 2.78 KB | ||
| 4. Calculating Present and Future Value.mp4 | 37.5 MB | ||
| 4. Calculating Present and Future Value.srt | 6.66 KB | ||
| 5. Cost of Equity.mp4 | 55.84 MB | ||
| 5. Cost of Equity.srt | 8.01 KB | ||
| 6. Project-specific Beta.mp4 | 27.2 MB | ||
| 6. Project-specific Beta.srt | 3.83 KB | ||
| 7. The Weighted Average Cost of Capital (WACC).mp4 | 15.71 MB | ||
| 7. The Weighted Average Cost of Capital (WACC).srt | 2.48 KB | ||
| 8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 | 24.31 MB | ||
| 8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt | 4.16 KB | ||
| 9. Modeling Future Cash Flows.mp4 | 54.39 MB | ||
| 9. Modeling Future Cash Flows.srt | 7.15 KB | ||
| 42. Capital Budgeting - A Complete Case Study | |||
| 1. An Introduction to the Case Study.mp4 | 25.3 MB | ||
| 1. An Introduction to the Case Study.srt | 3.42 KB | ||
| 10. Estimating Cost of Equity.mp4 | 40.38 MB | ||
| 10. Estimating Cost of Equity.srt | 7.63 KB | ||
| 10.1 8. WACC_unsolved.xlsx.xlsx | 35.93 KB | ||
| 10.2 8. WACC.xlsx.xlsx | 38.03 KB | ||
| 11. Discounting Project Cash Flows.mp4 | 25.9 MB | ||
| 11. Discounting Project Cash Flows.srt | 3.76 KB | ||
| 11.1 9.Discounted-cash-flow-unsolved.xlsx.xlsx | 38.75 KB | ||
| 11.2 9. Discounted cash flow.xlsx.xlsx | 39.74 KB | ||
| 12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 | 43.05 MB | ||
| 12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt | 5.56 KB | ||
| 12.1 10. Sensitivity analysis.xlsx.xlsx | 40.67 KB | ||
| 12.2 Capital budgeting_exercise_unsolved.xlsx.xlsx | 13.21 KB | ||
| 12.3 Capital-budgeting-exercise-solved.xlsx.xlsx | 42.75 KB | ||
| 12.4 10. Sensitivity analysis_unsolved.xlsx.xlsx | 39.7 KB | ||
| 2. Organizing Inputs In the Drivers Sheet.mp4 | 38.16 MB | ||
| 2. Organizing Inputs In the Drivers Sheet.srt | 6.59 KB | ||
| 2.1 1. Drivers.xlsx.xlsx | 11.5 KB | ||
| 3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4 | 34.74 MB | ||
| 3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt | 4.26 KB | ||
| 3.1 2. Savings Forecast_unsolved.xlsx.xlsx | 14.74 KB | ||
| 3.2 2. Savings Forecast.xlsx.xlsx | 16.58 KB | ||
| 4. Preparing a Fixed Asset Rollforward Schedule.mp4 | 47.36 MB | ||
| 4. Preparing a Fixed Asset Rollforward Schedule.srt | 5.55 KB | ||
| 4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx | 18.54 KB | ||
| 4.2 3. Fixed Asset Rollforward.xlsx.xlsx | 19.66 KB | ||
| 5. Calculating the Cash Impact of Extra Working Capital Required.mp4 | 18.35 MB | ||
| 5. Calculating the Cash Impact of Extra Working Capital Required.srt | 3.03 KB | ||
| 5.1 4. Working Capital_unsolved.xlsx.xlsx | 21.19 KB | ||
| 5.2 4. Working Capital.xlsx.xlsx | 21.93 KB | ||
| 6. Debt Repayment and Interest Expenses Calculation.mp4 | 22.13 MB | ||
| 6. Debt Repayment and Interest Expenses Calculation.srt | 3.43 KB | ||
| 6.1 5. Financing.xlsx.xlsx | 30.97 KB | ||
| 6.2 5. Financing_unsolved.xlsx.xlsx | 29.99 KB | ||
| 7. The Project's P&L Sheet.mp4 | 13.93 MB | ||
| 7. The Project's P&L Sheet.srt | 2.23 KB | ||
| 7.1 6. P&L_unsolved.xlsx.xlsx | 29.7 KB | ||
| 7.2 6. P&L.xlsx.xlsx | 31.03 KB | ||
| 8. The Project's Cash Flow Calculation.mp4 | 30.84 MB | ||
| 8. The Project's Cash Flow Calculation.srt | 3.98 KB | ||
| 8.1 7. Cash flow.xlsx.xlsx | 31.36 KB | ||
| 8.2 7. Cash flow_unsolved.xlsx.xlsx | 29.64 KB | ||
| 9. Calculating WACC (Weighted Average Cost of Capital).mp4 | 18.52 MB | ||
| 9. Calculating WACC (Weighted Average Cost of Capital).srt | 3.52 KB | ||
| 9.1 8. WACC.xlsx.xlsx | 38.03 KB | ||
| 9.2 8. WACC_unsolved.xlsx.xlsx | 35.93 KB | ||
| 43. Tesla Practical Case Study - Building a Financial Planning Model | |||
| 1. Organizing External Inputs in a 'Drivers' Sheet.mp4 | 31 MB | ||
| 1. Organizing External Inputs in a 'Drivers' Sheet.srt | 4.37 KB | ||
| 1.1 0a. Drivers_before.xlsx.xlsx | 1.27 MB | ||
| 1.2 0a. Drivers_after.xlsx.xlsx | 1.27 MB | ||
| 10. Forecasting 'Energy' and 'Services' Revenue.mp4 | 25.3 MB | ||
| 10. Forecasting 'Energy' and 'Services' Revenue.srt | 3.14 KB | ||
| 10.1 6. Energy and Other revenue - Before.xlsx.xlsx | 1.34 MB | ||
| 10.2 6. Energy and Other revenue - After.xlsx.xlsx | 1.34 MB | ||
| 11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 | 26.8 MB | ||
| 11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.srt | 2.53 KB | ||
| 11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx | 1.35 MB | ||
| 11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx | 1.35 MB | ||
| 12. Forecasting Operating Expenses.mp4 | 34.91 MB | ||
| 12. Forecasting Operating Expenses.srt | 5.41 KB | ||
| 12.1 8. Opex - Before.xlsx.xlsx | 1.36 MB | ||
| 12.2 8. Opex - After.xlsx.xlsx | 1.36 MB | ||
| 13. Building a Fixed Asset Roll Forward Estimating Capex.mp4 | 56.51 MB | ||
| 13. Building a Fixed Asset Roll Forward Estimating Capex.srt | 6.43 KB | ||
| 13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx | 1.37 MB | ||
| 13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx | 1.37 MB | ||
| 14. Building a Fixed Asset Roll Forward D&A Schedule.mp4 | 54.15 MB | ||
| 14. Building a Fixed Asset Roll Forward D&A Schedule.srt | 4.45 KB | ||
| 14.1 10. PP&E schedule_after.xlsx.xlsx | 1.37 MB | ||
| 14.2 10. PP&E schedule_before.xlsx.xlsx | 1.37 MB | ||
| 15. Peer Comparison D&A as a Percentage of Revenues.mp4 | 13.63 MB | ||
| 15. Peer Comparison D&A as a Percentage of Revenues.srt | 1.62 KB | ||
| 15.1 10a. PP&E comparison.xlsx.xlsx | 1.37 MB | ||
| 16. Calculating DSO, DIO, DPO.mp4 | 17.51 MB | ||
| 16. Calculating DSO, DIO, DPO.srt | 2.11 KB | ||
| 16.1 11. Working capital forecasting_before.xlsx.xlsx | 1.38 MB | ||
| 16.2 11. Working capital forecasting_after.xlsx.xlsx | 1.52 MB | ||
| 17. Producing a Clean P&L Output Sheet.mp4 | 8.44 MB | ||
| 17. Producing a Clean P&L Output Sheet.srt | 1.62 KB | ||
| 17.1 12. P&L.xlsx.xlsx | 1.39 MB | ||
| 18. Fill in the P&L Output Sheet.mp4 | 18.35 MB | ||
| 18. Fill in the P&L Output Sheet.srt | 1.83 KB | ||
| 18.1 12a. P&L fill in_after.xlsx.xlsx | 1.39 MB | ||
| 18.2 12a. P&L fill in_before.xlsx.xlsx | 1.39 MB | ||
| 19. Calculating Investments in Working Capital.mp4 | 19.05 MB | ||
| 19. Calculating Investments in Working Capital.srt | 2.16 KB | ||
| 19.1 13. Calculating working capital_before.xlsx.xlsx | 1.4 MB | ||
| 19.2 13. Calculating working capital_after.xlsx.xlsx | 1.4 MB | ||
| 2. The Input Data We Will Work With.mp4 | 15.8 MB | ||
| 2. The Input Data We Will Work With.srt | 1.72 KB | ||
| 2.1 0aa. Inputs_before.xlsx.xlsx | 1.28 MB | ||
| 2.2 0aa. Inputs_after.xlsx.xlsx | 1.28 MB | ||
| 20. Forecasting Unlevered Free Cash Flow.mp4 | 55.98 MB | ||
| 20. Forecasting Unlevered Free Cash Flow.srt | 6.09 KB | ||
| 20.1 14. Cash flow - UFCF_before.xlsx.xlsx | 1.41 MB | ||
| 20.2 14. Cash flow - UFCF_after.xlsx.xlsx | 1.41 MB | ||
| 21. Forecasting Other Assets.mp4 | 45.3 MB | ||
| 21. Forecasting Other Assets.srt | 4.62 KB | ||
| 21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx | 1.41 MB | ||
| 21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx | 1.41 MB | ||
| 22. Forecasting Other Liabilities.mp4 | 22.05 MB | ||
| 22. Forecasting Other Liabilities.srt | 2.36 KB | ||
| 22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx | 1.42 MB | ||
| 22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx | 1.41 MB | ||
| 23. Completing Unlevered Free Cash Flow.mp4 | 40.89 MB | ||
| 23. Completing Unlevered Free Cash Flow.srt | 3.71 KB | ||
| 23.1 16a. Complete UFCF_before.xlsx.xlsx | 1.42 MB | ||
| 23.2 16a. Complete UFCF_after.xlsx.xlsx | 1.42 MB | ||
| 24. Modeling Tesla's Financing Needs in the Forecast Period.mp4 | 42.38 MB | ||
| 24. Modeling Tesla's Financing Needs in the Forecast Period.srt | 5.64 KB | ||
| 24.1 17. Financing_before.xlsx.xlsx | 1.43 MB | ||
| 24.2 17. Financing_after.xlsx.xlsx | 1.43 MB | ||
| 25. Calculating Net Income.mp4 | 14.79 MB | ||
| 25. Calculating Net Income.srt | 1.39 KB | ||
| 25.1 18. P&L complete_after.xlsx.xlsx | 1.43 MB | ||
| 25.2 18. P&L complete_before.xlsx.xlsx | 1.43 MB | ||
| 26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 | 50.67 MB | ||
| 26. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt | 4.51 KB | ||
| 26.1 19. Cash flow_complete_after.xlsx.xlsx | 1.43 MB | ||
| 26.2 19. Cash flow_complete_before.xlsx.xlsx | 1.43 MB | ||
| 27. Balancing the Balance Sheet.mp4 | 13.29 MB | ||
| 27. Balancing the Balance Sheet.srt | 1.18 KB | ||
| 27.1 20. Complete the BS_before.xlsx.xlsx | 1.43 MB | ||
| 27.2 20. Complete the BS_after.xlsx.xlsx | 1.43 MB | ||
| 3. Forecasting Tesla's Expected Deliveries.mp4 | 114.92 MB | ||
| 3. Forecasting Tesla's Expected Deliveries.srt | 15.38 KB | ||
| 3.1 1. Deliveries_after.xlsx.xlsx | 1.29 MB | ||
| 3.2 1. Deliveries_before.xlsx.xlsx | 1.29 MB | ||
| 4. Comparing Delivery Figures with the Ones of industry Peers.mp4 | 20.98 MB | ||
| 4. Comparing Delivery Figures with the Ones of industry Peers.srt | 3.1 KB | ||
| 4.1 1a. Deliveries development.xlsx.xlsx | 1.3 MB | ||
| 5. Estimating an Average Selling Price of Tesla Vehicles.mp4 | 41.93 MB | ||
| 5. Estimating an Average Selling Price of Tesla Vehicles.srt | 5.17 KB | ||
| 5.1 2. Average price_after.xlsx.xlsx | 1.31 MB | ||
| 5.2 2. Average price_before.xlsx.xlsx | 1.31 MB | ||
| 6. Calculating Automotive Revenue.mp4 | 46.56 MB | ||
| 6. Calculating Automotive Revenue.srt | 4.93 KB | ||
| 6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx | 1.31 MB | ||
| 6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx | 1.31 MB | ||
| 7. Peer Comparison Gross Profit %.mp4 | 17.19 MB | ||
| 7. Peer Comparison Gross Profit %.srt | 2.72 KB | ||
| 7.1 4. Gross profit automotive.xlsx.xlsx | 1.32 MB | ||
| 8. Calculating Automotive Gross Profit.mp4 | 27.79 MB | ||
| 8. Calculating Automotive Gross Profit.srt | 2.88 KB | ||
| 8.1 4a. Gross profit automotive - before.xlsx.xlsx | 1.51 MB | ||
| 8.2 4a. Gross profit automotive - after.xlsx.xlsx | 1.32 MB | ||
| 9. Calculating Automotive Cost of Sales.mp4 | 17.54 MB | ||
| 9. Calculating Automotive Cost of Sales.srt | 2.27 KB | ||
| 9.1 5. Cost of sales and chart.xlsx.xlsx | 1.34 MB | ||
| 44. PowerPoint - Introduction to PowerPoint | |||
| 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 | 18.4 MB | ||
| 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.srt | 1.14 KB | ||
| 10. Changing an Object's Size and Rotation.mp4 | 11.23 MB | ||
| 10. Changing an Object's Size and Rotation.srt | 2.2 KB | ||
| 10.1 Resizing and Rotating Objects.pptx.pptx | 1.23 MB | ||
| 11. Using Slide Masters.mp4 | 22.4 MB | ||
| 11. Using Slide Masters.srt | 5.23 KB | ||
| 11.1 Slide Masters Presentation - example.pptx.pptx | 43.49 KB | ||
| 12. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 | 15.31 MB | ||
| 12. Bring to Front and Send to Back - An Important PowerPoint Technique.srt | 3.34 KB | ||
| 12.1 Bring to Front and Send to Back.pptx.pptx | 1.23 MB | ||
| 13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 | 27.66 MB | ||
| 13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt | 6.01 KB | ||
| 13.1 Insert table.pptx.pptx | 1.21 MB | ||
| 2. General Considerations About Slide Structure.mp4 | 26.18 MB | ||
| 2. General Considerations About Slide Structure.srt | 4.67 KB | ||
| 2.1 Spacing within PowerPoint.pptx.pptx | 1.86 MB | ||
| 2.2 Spacing-within-PowerPoint-chart.xlsx.xlsx | 57.28 KB | ||
| 3. Learn How to Insert Objects in PowerPoint.mp4 | 31.96 MB | ||
| 3. Learn How to Insert Objects in PowerPoint.srt | 4.75 KB | ||
| 3.1 Kinemax Data.xlsx.xlsx | 36.41 KB | ||
| 3.2 Insert objects.pptx.pptx | 1.64 MB | ||
| 4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 | 16.62 MB | ||
| 4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt | 3.04 KB | ||
| 4.1 PowerPoint Master Class - Shortcuts.pdf.pdf | 440.4 KB | ||
| 4.2 Power-Point-Master-Class-Shortcuts-For-Mac.pdf.pdf | 532.42 KB | ||
| 5. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 | 21.31 MB | ||
| 5. Add Frequently Used Buttons to the Quick Access Toolbar.srt | 3.44 KB | ||
| 5.1 Quick Access Toolbar buttons.pptx.pptx | 1.24 MB | ||
| 6. How to Easily Align Objects in PowerPoint.mp4 | 20.48 MB | ||
| 6. How to Easily Align Objects in PowerPoint.srt | 4.86 KB | ||
| 6.1 Align and Distribute objects in Ppt.pptx.pptx | 1.25 MB | ||
| 7. How to Edit Shapes in Your Presentation.mp4 | 26.23 MB | ||
| 7. How to Edit Shapes in Your Presentation.srt | 5.9 KB | ||
| 7.1 Format Shape Menu.pptx.pptx | 634.21 KB | ||
| 8. How to Format Text Boxes in a PowerPoint Presentation.mp4 | 19.96 MB | ||
| 8. How to Format Text Boxes in a PowerPoint Presentation.srt | 4.35 KB | ||
| 8.1 Working with text.pptx.pptx | 772.99 KB | ||
| 9. Practical Learning - Exercise 1.mp4 | 27.47 MB | ||
| 9. Practical Learning - Exercise 1.srt | 4.33 KB | ||
| 9.1 Practical Example - Organizing Notes.pptx.pptx | 1.23 MB | ||
| 9.2 Practical Example - Organizing Notes.docx.docx | 15.5 KB | ||
| 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User | |||
| 1. An Introduction to PowerPoint Animations.mp4 | 14.57 MB | ||
| 1. An Introduction to PowerPoint Animations.srt | 4.01 KB | ||
| 1.1 Animation effects.pptx.pptx | 1.21 MB | ||
| 10. Practical Exercise - Creating an Organisational Chart.mp4 | 52.75 MB | ||
| 10. Practical Exercise - Creating an Organisational Chart.srt | 7.56 KB | ||
| 10.1 Practical Example.pptx.pptx | 1.24 MB | ||
| 10.2 Practical Example - completed.pptx.pptx | 1.24 MB | ||
| 10.3 List of executives.png.png | 62.91 KB | ||
| 11. COURSE CHALLENGE - Part 4.mp4 | 26 MB | ||
| 11. COURSE CHALLENGE - Part 4.srt | 3.52 KB | ||
| 11.1 4. Course Challenge.pptx.pptx | 1.13 MB | ||
| 11.2 4. Course Challenge - Tasks.pdf.pdf | 283.02 KB | ||
| 11.3 Sending Files with Dropbox - YouTube Tutorial.html | 104 B | ||
| 2. Modifying the Beginning and Ending of a Line Object.mp4 | 10.15 MB | ||
| 2. Modifying the Beginning and Ending of a Line Object.srt | 2.15 KB | ||
| 2.1 Line Begin and End type.pptx.pptx | 1.23 MB | ||
| 3. Join Shapes Together By Using Connector Lines.mp4 | 23.83 MB | ||
| 3. Join Shapes Together By Using Connector Lines.srt | 5.05 KB | ||
| 3.1 Connectors.pptx.pptx | 1.22 MB | ||
| 4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4 | 8.27 MB | ||
| 4. Edit Points - Learn How to Customize PowerPoint Shapes.srt | 2.27 KB | ||
| 4.1 Edit Points.pptx.pptx | 1.21 MB | ||
| 5. Group or Ungroup Shapes, Pictures or Other Objects.mp4 | 14.69 MB | ||
| 5. Group or Ungroup Shapes, Pictures or Other Objects.srt | 2.26 KB | ||
| 5.1 Group.pptx.pptx | 1.22 MB | ||
| 6. This is How You Can Fit Text When It Is Larger than a Shape.mp4 | 13.8 MB | ||
| 6. This is How You Can Fit Text When It Is Larger than a Shape.srt | 2.57 KB | ||
| 6.1 Internal Margins.pptx.pptx | 1.22 MB | ||
| 7. Nudge Objects.mp4 | 4.38 MB | ||
| 7. Nudge Objects.srt | 1.37 KB | ||
| 7.1 Nudge objects.pptx.pptx | 1.22 MB | ||
| 8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 | 20.95 MB | ||
| 8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt | 4.2 KB | ||
| 8.1 Smart Art.pptx.pptx | 1.22 MB | ||
| 9. Creating Eye-Catching Text Effects in PowerPoint.mp4 | 12.39 MB | ||
| 9. Creating Eye-Catching Text Effects in PowerPoint.srt | 2.4 KB | ||
| 9.1 Text effects.pptx.pptx | 1.22 MB | ||
| 46. Bonus Lecture | |||
| 1. Bonus Lecture Next Steps.html | 4.08 KB | ||
| 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions | |||
| 1. Key Excel Functions IF.mp4 | 16.66 MB | ||
| 1. Key Excel Functions IF.srt | 47.69 MB | ||
| 1.1 Functions - English to Portuguese.pdf.pdf | 146.09 KB | ||
| 1.2 37. IF-function--Lecture-before.xlsm.xlsm | 17 KB | ||
| 1.3 Functions - English to Spanish.pdf.pdf | 102.37 KB | ||
| 1.4 Functions - English to German.pdf.pdf | 102.32 KB | ||
| 1.5 37. IF-function-Lecture-after.xlsm.xlsm | 17.94 KB | ||
| 10. Find the Highest and Lowest Values in a Range Max & Min.mp4 | 7.55 MB | ||
| 10. Find the Highest and Lowest Values in a Range Max & Min.srt | 1.06 KB | ||
| 10.1 44. MIN-MAX-Exercise - Solved.xlsx.xlsx | 14.8 KB | ||
| 10.2 44. Max-min-Lecture - Unsolved.xlsx.xlsx | 8.95 KB | ||
| 10.3 44. MIN-MAX-Exercise - Unsolved.xlsx.xlsx | 14.39 KB | ||
| 10.4 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 10.5 44. Excel-functions.xlsx.xlsx | 971.02 KB | ||
| 10.6 44. Max-min-Lecture - Solved.xlsx.xlsx | 9.23 KB | ||
| 11. = and + are Interchangeable When You Start Typing a Formula.mp4 | 5.79 MB | ||
| 11. = and + are Interchangeable When You Start Typing a Formula.srt | 974 B | ||
| 11.1 45. Show-that-and-are-interchangeable-Lecture-before.xlsm.xlsm | 17.01 KB | ||
| 11.2 45. Show-that-and-are-interchangeable-Lecture-after.xlsm.xlsm | 17.04 KB | ||
| 12. Use ROUND in Your Financial Models.mp4 | 5.21 MB | ||
| 12. Use ROUND in Your Financial Models.srt | 1.2 KB | ||
| 12.1 51. Excel-functions-Lecture.xlsx.xlsx | 889.91 KB | ||
| 12.2 Excel-Functions.pdf.pdf | 3.19 MB | ||
| 12.3 51. Round-Exercise - Solved.xlsx.xlsx | 11.71 KB | ||
| 12.4 51. Round-Exercise - Unsolved.xlsx.xlsx | 11.34 KB | ||
| 13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 | 60.27 MB | ||
| 13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.srt | 8.95 KB | ||
| 13.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx | 11.13 KB | ||
| 13.2 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx | 10.74 KB | ||
| 13.3 47. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx | 13.68 KB | ||
| 13.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx | 11.95 KB | ||
| 13.5 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 | 61.76 MB | ||
| 14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt | 8.59 KB | ||
| 14.1 48. Index-Match-Exercise - Unsolved.xlsx.xlsx | 11.59 KB | ||
| 14.2 48. Index-Match-Lecture - Unsolved.xlsx.xlsx | 11.29 KB | ||
| 14.3 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 14.4 48. Index-Match-Lecture - Solved.xlsx.xlsx | 11.7 KB | ||
| 14.5 48. Index-Match-Exercise - Solved.xlsx.xlsx | 12.08 KB | ||
| 15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html | 147 B | ||
| 16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 | 11.74 MB | ||
| 16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt | 2.2 KB | ||
| 16.1 54. Iferror - Lecture - Solved.xlsm.xlsm | 896.43 KB | ||
| 16.2 54. Iferror - Lecture - Unsolved.xlsm.xlsm | 897.26 KB | ||
| 16.3 54. Iferror-Exercise - Solved.xlsx.xlsx | 15.37 KB | ||
| 16.4 54. Iferror-Exercise - Unsolved.xlsx.xlsx | 14.26 KB | ||
| 16.5 Excel-Functions.pdf.pdf | 3.19 MB | ||
| 17. A Useful Tool for Financial Analysis - The RANK Function.mp4 | 23.24 MB | ||
| 17. A Useful Tool for Financial Analysis - The RANK Function.srt | 2.86 KB | ||
| 17.1 50. Rank-function-Lecture-after.xlsx.xlsx | 12.61 KB | ||
| 17.2 50. Rank-function-Lecture-before.xlsx.xlsx | 12.27 KB | ||
| 18. Create Flexible Financial Models with CHOOSE.mp4 | 19.85 MB | ||
| 18. Create Flexible Financial Models with CHOOSE.srt | 2.76 KB | ||
| 18.1 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 18.2 51. Choose-Lecture - Unsolved.xlsx.xlsx | 9.33 KB | ||
| 18.3 51. Choose-Exercise-Solved.xlsx.xlsx | 21.73 KB | ||
| 18.4 51. Choose-Lecture - Solved.xlsx.xlsx | 9.69 KB | ||
| 18.5 51. Choose-Exercise - Unsolved.xlsx.xlsx | 11.32 KB | ||
| 19. Goal Seek Will Help You Find the Result You Are Looking For.mp4 | 16.01 MB | ||
| 19. Goal Seek Will Help You Find the Result You Are Looking For.srt | 2.73 KB | ||
| 19.1 57. Goal-Seek-Lecture - Unsolved.xlsx.xlsx | 9.15 KB | ||
| 19.2 57. Goal-Seek-Exercise-Solved.xlsx.xlsx | 16.21 KB | ||
| 19.3 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 19.4 57. Goal-Seek-Exercise - Unsolved.xlsx.xlsx | 16.09 KB | ||
| 19.5 57. Goal-Seek-Lecture - Solved.xlsx.xlsx | 9.17 KB | ||
| 2. Enlarge the Formula Bar.mp4 | 6.26 MB | ||
| 2. Enlarge the Formula Bar.srt | 1.4 KB | ||
| 2.1 38. Enlarge-the-formula-bar-Lecture.xlsm.xlsm | 46.89 KB | ||
| 20. Goal Seek Will Help You Find the Result You Are Looking For.html | 147 B | ||
| 21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 | 26.22 MB | ||
| 21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.srt | 5.23 KB | ||
| 21.1 58. Sensitivity analysis - Lecture - Solved.xlsm.xlsm | 897.3 KB | ||
| 21.2 58.Sensitivity-analysis-Exercise-Solved.xlsx.xlsx | 62.28 KB | ||
| 21.3 58. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm | 897.09 KB | ||
| 21.4 58.Sensitivity-analysis-Exercise_Unsolved.xlsx.xlsx | 61.9 KB | ||
| 22. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html | 147 B | ||
| 23. Quiz Number 2.html | 147 B | ||
| 3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4 | 30.68 MB | ||
| 3. Key Excel Functions SUM, SUMIF, SUMIFS.srt | 5.15 KB | ||
| 3.1 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx | 13.01 KB | ||
| 3.2 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx | 12.93 KB | ||
| 3.3 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx | 14.46 KB | ||
| 3.4 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 3.5 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx | 14.84 KB | ||
| 4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 | 31.21 MB | ||
| 4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt | 4.54 KB | ||
| 4.1 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 4.2 40.Counts-Exercise-Unsolved.xlsx.xlsx | 15.56 KB | ||
| 4.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx | 11.68 KB | ||
| 4.4 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx | 11.29 KB | ||
| 4.5 40.Counts-Exercise-Solved.xlsx.xlsx | 16.07 KB | ||
| 5. Key Excel Functions AVERAGE & AVERAGEIF.mp4 | 15.12 MB | ||
| 5. Key Excel Functions AVERAGE & AVERAGEIF.srt | 2.39 KB | ||
| 5.1 Excel-Functions.pdf.pdf | 3.18 MB | ||
| 5.2 41. Average-Averageif- Lecture - Solved.xlsx.xlsx | 9.4 KB | ||
| 5.3 41. Average-Averageif- Lecture - Unsolved.xlsx.xlsx | 9.03 KB | ||
| 5.4 41. Average-AverageIF-Exercise - Solved.xlsx.xlsx | 15.02 KB | ||
| 5.5 41. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx | 14.6 KB | ||
| 6. Key Excel Functions Average & Averageif.html | 147 B | ||
| 7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 | 30.41 MB | ||
| 7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.srt | 4.91 KB | ||
| 7.1 47. Text functions - Exercise - Solved.xlsx.xlsx | 12.24 KB | ||
| 7.2 47. Text-Functions- Lecture - Solved.xlsx.xlsx | 11.1 KB | ||
| 7.3 47. Text-Functions- Lecture - Unsolved.xlsx.xlsx | 10.6 KB | ||
| 7.4 47. Text functions - Exercise - Unsolved.xlsx.xlsx | 11.71 KB | ||
| 8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html | 147 B | ||
| 9. Working with Text in Excel.mp4 | 16.01 MB | ||
| 9. Working with Text in Excel.srt | 3.08 KB | ||
| 9.1 43. Work-with-text-Lecture-before.xlsx.xlsx | 10.33 KB | ||
| 9.2 43. Work-with-text-Lecture-after.xlsx.xlsx | 10.91 KB | ||
| 6. Microsoft Excel - Financial Functions in Excel | |||
| 1. Discounting Cash Flows in Microsoft Excel.mp4 | 45.68 MB | ||
| 1. Discounting Cash Flows in Microsoft Excel.srt | 7.18 KB | ||
| 1.1 54. FV and PV-Lecture.xlsx.xlsx | 10.64 KB | ||
| 2. Calculating Internal Rate of Return (IRR) in Excel.mp4 | 22.76 MB | ||
| 2. Calculating Internal Rate of Return (IRR) in Excel.srt | 3.79 KB | ||
| 2.1 55. IRR-Lecture.xlsx.xlsx | 11.2 KB | ||
| 3. Using the PMT Function to Create a Complete Loan Schedule.mp4 | 40.06 MB | ||
| 3. Using the PMT Function to Create a Complete Loan Schedule.srt | 6.79 KB | ||
| 3.1 56. Loan Schedule-Lecture.xlsx.xlsx | 20.17 KB | ||
| 4. Date Functions in Excel.mp4 | 30.81 MB | ||
| 4. Date Functions in Excel.srt | 5.79 KB | ||
| 4.1 57. Date Functions-Lecture.xlsx.xlsx | 12.25 KB | ||
| 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch | |||
| 1. Introduction to the Case Study.mp4 | 9.82 MB | ||
| 1. Introduction to the Case Study.srt | 1004 B | ||
| 10. The Mapping Exercise.mp4 | 21.61 MB | ||
| 10. The Mapping Exercise.srt | 2.04 KB | ||
| 10.1 Mapping-exercise-explained.pdf.pdf | 243.03 KB | ||
| 10.2 67. Mapping-Lecture-after.xlsm.xlsm | 50.5 KB | ||
| 10.3 67. Mapping-Lecture-before.xlsm.xlsm | 50.55 KB | ||
| 11. Mapping the Rows in the Database Sheet.mp4 | 38.51 MB | ||
| 11. Mapping the Rows in the Database Sheet.srt | 6.7 KB | ||
| 11.1 Mapping-exercise-explained.pdf.pdf | 243.03 KB | ||
| 11.2 68. Mapping-Lecture-after.xlsm.xlsm | 50.5 KB | ||
| 11.3 68. Mapping-Lecture-before.xlsm.xlsm | 50.55 KB | ||
| 12. Building the Structure of the P&L Sheet.mp4 | 20.87 MB | ||
| 12. Building the Structure of the P&L Sheet.srt | 2.34 KB | ||
| 12.1 69. Building a P&L-Lecture-after.xlsm.xlsm | 51.83 KB | ||
| 12.2 69. Building a P&L-Lecture-before.xlsm.xlsm | 50.24 KB | ||
| 13. A Practical Example of Professional Formatting in Excel.mp4 | 25.43 MB | ||
| 13. A Practical Example of Professional Formatting in Excel.srt | 3.41 KB | ||
| 13.1 70. Formatting a P&L-Lecture-before.xlsm.xlsm | 51.84 KB | ||
| 13.2 70 Formatting the P&L-Lecture-after.xlsm.xlsm | 51.96 KB | ||
| 14. Populating the P&L Sheet with SUMIF.mp4 | 30.22 MB | ||
| 14. Populating the P&L Sheet with SUMIF.srt | 3 KB | ||
| 14.1 71. Formatting the P&L-Lecture-after.xlsm.xlsm | 53.51 KB | ||
| 14.2 71. Formatting the P&L-Lecture-before.xlsm.xlsm | 52 KB | ||
| 15. Learn How to Find Mistakes with COUNTIF.mp4 | 27.85 MB | ||
| 15. Learn How to Find Mistakes with COUNTIF.srt | 2.8 KB | ||
| 15.1 72. Countif-Lecture-before.xlsm.xlsm | 53.51 KB | ||
| 15.2 72. Countif-Lecture-after.xlsm.xlsm | 54.78 KB | ||
| 16. Calculating Growth Rates in Excel.mp4 | 29.98 MB | ||
| 16. Calculating Growth Rates in Excel.srt | 3.31 KB | ||
| 16.1 Y-o-Y Function explanation.pdf.pdf | 164.92 KB | ||
| 16.2 73. Adding % variations-Lecture-after.xlsm.xlsm | 56.51 KB | ||
| 16.3 73. Adding % variations-Lecture-before.xlsm.xlsm | 54.78 KB | ||
| 17. Quiz Number 3.html | 147 B | ||
| 2. What You Will See Next.mp4 | 10.2 MB | ||
| 2. What You Will See Next.srt | 1.1 KB | ||
| 3. Understand Your Data Source Before You Start Working on It.mp4 | 28.12 MB | ||
| 3. Understand Your Data Source Before You Start Working on It.srt | 3.17 KB | ||
| 3.1 60. Get to know the data source - Lecture.xlsm.xlsm | 43.03 KB | ||
| 4. Ordering the Source Worksheet.mp4 | 26.56 MB | ||
| 4. Ordering the Source Worksheet.srt | 2.52 KB | ||
| 4.1 61. Order a worksheet_after.xlsm.xlsm | 41.01 KB | ||
| 4.2 61. Order a worksheet_before.xlsm.xlsm | 43.08 KB | ||
| 5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 | 24.52 MB | ||
| 5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.srt | 2.25 KB | ||
| 5.1 62. Creating a code_after.xlsm.xlsm | 41.73 KB | ||
| 5.2 62. Creating a code_before.xlsm.xlsm | 41.01 KB | ||
| 6. Learn How to Create a Database.mp4 | 20.75 MB | ||
| 6. Learn How to Create a Database.srt | 39.65 MB | ||
| 6.1 63. Creating a database_after.xlsm.xlsm | 39.39 KB | ||
| 6.2 63. Creating a database_before.xlsm.xlsm | 41.73 KB | ||
| 7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 | 61.55 MB | ||
| 7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.srt | 5.6 KB | ||
| 7.1 64. Vlookup_after.xlsm.xlsm | 44.45 KB | ||
| 7.2 64. Vlookup_before.xlsm.xlsm | 49.5 KB | ||
| 8. Using SUMIF to Complete the Database Sheet.mp4 | 47.93 MB | ||
| 8. Using SUMIF to Complete the Database Sheet.srt | 4.4 KB | ||
| 8.1 65. Sumif_before.xlsm.xlsm | 44.45 KB | ||
| 8.2 65. Sumif_after.xlsm.xlsm | 49.53 KB | ||
| 9. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 | 49.65 MB | ||
| 9. Using INDEX & MATCH as a Substitute for VLOOKUP.srt | 4.25 KB | ||
| 9.1 66. Index Match-Lecture-after.xlsm.xlsm | 13.85 MB | ||
| 9.2 66. Index Match_before.xlsm.xlsm | 41.02 KB | ||
| 8. Microsoft Excel - Building Professional Charts in Excel | |||
| 1. Introduction to Excel Charts.mp4 | 13.01 MB | ||
| 1. Introduction to Excel Charts.srt | 1.35 KB | ||
| 2. Beginner's Guide to Inserting Charts in Excel.mp4 | 22.26 MB | ||
| 2. Beginner's Guide to Inserting Charts in Excel.srt | 2.76 KB | ||
| 2.1 75. Inserting-Charts-Lecture.xlsm.xlsm | 11.46 MB | ||
| 3. Modifying Excel Charts - The Easy Way.mp4 | 26.04 MB | ||
| 3. Modifying Excel Charts - The Easy Way.srt | 3.22 KB | ||
| 3.1 76. Formatting-a-Chart-Lecture.xlsm.xlsm | 11.45 MB | ||
| 4. Making Your Excel Charts Sexier - Proven Tips.mp4 | 32.7 MB | ||
| 4. Making Your Excel Charts Sexier - Proven Tips.srt | 3.83 KB | ||
| 4.1 77. Modifying-a-Chart-Lecture.xlsm.xlsm | 11.4 MB | ||
| 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 | 13.66 MB | ||
| 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.srt | 1.37 KB | ||
| 5.1 78. Bridge-Charts-Lecture.xlsx.xlsx | 13.1 KB | ||
| 6. New Ways to Visualize Your Data - Treemap Charts.mp4 | 11.5 MB | ||
| 6. New Ways to Visualize Your Data - Treemap Charts.srt | 1.75 KB | ||
| 6.1 79. Treemap-Charts-Lecture.xlsx.xlsx | 12.62 KB | ||
| 7. How to Represent Trends with Sparklines.mp4 | 27.55 MB | ||
| 7. How to Represent Trends with Sparklines.srt | 4.51 KB | ||
| 7.1 80. Sparklines-Lecture.xlsx.xlsx | 9.59 KB | ||
| 9. Microsoft Excel - Creating Complete Professional Charts from Scratch | |||
| 1. Introduction.mp4 | 6.2 MB | ||
| 1. Introduction.srt | 662 B | ||
| 2. Stacked Column Chart with a Secondary Axis.mp4 | 46.4 MB | ||
| 2. Stacked Column Chart with a Secondary Axis.srt | 5.7 KB | ||
| 2.1 82. Column stacked chart-Lecture-after.xlsm.xlsm | 11.5 MB | ||
| 2.2 82. Column stacked chart-Lecture-before.xlsm.xlsm | 11.51 MB | ||
| 3. Doughnut Chart.mp4 | 38.01 MB | ||
| 3. Doughnut Chart.srt | 5.44 KB | ||
| 3.1 83. Doughnut chart-Lecture-before.xlsm.xlsm | 11.51 MB | ||
| 3.2 83. Doughnut chart-Lecture-after.xlsm.xlsm | 11.51 MB | ||
| 4. Area Chart.mp4 | 28.59 MB | ||
| 4. Area Chart.srt | 3.56 KB | ||
| 4.1 84. Area chart-Lecture-before.xlsm.xlsm | 11.51 MB | ||
| 4.2 84. Area chart-Lecture-after.xlsm.xlsm | 11.52 MB | ||
| 5. Bridge Chart.mp4 | 52.07 MB | ||
| 5. Bridge Chart.srt | 7.61 KB | ||
| 5.1 85. Bridge chart-Lecture-after.xlsm.xlsm | 11.53 MB | ||
| 5.2 85.Bridge-chart-Lecture-before.xlsm.xlsm | 11.47 MB | ||
| [CourseClub.Me].url | 48 B | ||
| [DesireCourse.Net].url | 51 B | ||
| ▲ 1117 total files | |||
The Complete Financial Analyst Course 2020
Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!
For More Courses Visit: https://desirecourse.net
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - ISO 26262 Automotive Functional Safety - The Blueprint Method Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 4 days | 1 | 17 |
|
Udemy - Databricks Playbook - Operate, Govern and Defend the Lakehouse Posted by
freecoursewb in Other
|
2.3 GB | freecoursewb | 5 days | 1 | 6 |
| 426.3 MB | freecoursewb | 5 days | 33 | 10 | |
| 473.8 MB | freecoursewb | 1 week | 16 | 5 | |
| 3.7 GB | freecoursewb | 2 weeks | 5 | 7 |
All Comments