1977
maddie s secret
chelsea detective ntb
grand theft auto iv complete edition
rec-04
mad men season 5
ussr
lucky 2026 s01e03
1977
criterion-1080p
wrc-highlight
White Lotus
deadloch
Samaritan
TRAINS
blade runner 2019
laird barron
1977
1977
mountain monsters
▲
Udemy - The Complete Financial Analyst Course 2020 [FreeAllCourse]
seeders: 0
leechers: 0
Download Fast Safe Anonymous
movies, software, shows...
movies, software, shows...
Files
Udemy - The Complete Financial Analyst Course 2020 [FreeAllCourse] (Size: 10.75 GB)
| 0. Websites you may like | |||
| [FreeAllCourse.Com].url | 52 B | ||
| 1. Welcome! Course Introduction | |||
| 1. What Does the Course Cover.mp4 | 68.11 MB | ||
| 1. What Does the Course Cover.srt | 7.83 KB | ||
| 1.1 Financial Analyst - Course Curriculum.pdf | 581.35 KB | ||
| 2. Everything We Will Learn Has a Practical Application.mp4 | 43.28 MB | ||
| 2. Everything We Will Learn Has a Practical Application.srt | 4.06 KB | ||
| 2.1 Quick win.xlsx | 9.74 KB | ||
| 3. The Best Way to Take This Course.mp4 | 29.24 MB | ||
| 3. The Best Way to Take This Course.srt | 3.49 KB | ||
| 4. Download All Course Materials and FAQ.html | 5.39 KB | ||
| 4.1 Download all resources - Google Drive.html | 127 B | ||
| 4.2 Download all resources - Dropbox.html | 134 B | ||
| 10. Microsoft Excel - Working with Pivot Tables in Excel | |||
| 1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 | 23.35 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 | 64.31 MB | ||
| 2. Creating a Pivot Table Choosing Row and Column Parameters.srt | 4.64 KB | ||
| 2.1 87. Creating-a-Pivot-Table-Lecture.xlsx | 1.43 MB | ||
| 3. Design the Layout and Format of Your Pivot Tables.mp4 | 36.71 MB | ||
| 3. Design the Layout and Format of Your Pivot Tables.srt | 2.54 KB | ||
| 3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx | 1.43 MB | ||
| 4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 | 74.75 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 | 1.88 MB | ||
| 5. One of the Most Useful Excel Functions - GETPIVOTDATA.mp4 | 59.55 MB | ||
| 5. One of the Most Useful Excel Functions - GETPIVOTDATA.srt | 4.51 KB | ||
| 5.1 90. GetPivotData-Lecture.xlsx | 1.88 MB | ||
| 6. Welcome to the Future - Pivot Table Slicers.mp4 | 72.86 MB | ||
| 6. Welcome to the Future - Pivot Table Slicers.srt | 5.15 KB | ||
| 6.1 91. Slicers-Lecture.xlsx | 1.88 MB | ||
| 7. Introduction to the Course Challenge.mp4 | 13.19 MB | ||
| 7. Introduction to the Course Challenge.srt | 1.49 KB | ||
| 8. COURSE CHALLENGE - Part 1.mp4 | 24.04 MB | ||
| 8. COURSE CHALLENGE - Part 1.srt | 1.8 KB | ||
| 8.1 93. Course-challenge-before-solutions.xlsx | 505.94 KB | ||
| 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting | |||
| 1. Introduction to the Case Study.mp4 | 44.1 MB | ||
| 1. Introduction to the Case Study.srt | 2.79 KB | ||
| 1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx | 13.26 MB | ||
| 10. FAQ My GETPIVOTDATA Function Doesn't Work.html | 662 B | ||
| 11. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 | 36.41 MB | ||
| 11. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt | 4.04 KB | ||
| 11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx | 20.78 MB | ||
| 11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx | 20.82 MB | ||
| 12. Getting Fancy with Excel Slicers.mp4 | 35.82 MB | ||
| 12. Getting Fancy with Excel Slicers.srt | 4 KB | ||
| 12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx | 20.77 MB | ||
| 12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx | 18.26 MB | ||
| 13. This is How the Report Can be Used in Practice by High-level Executives.mp4 | 40.85 MB | ||
| 13. This is How the Report Can be Used in Practice by High-level Executives.srt | 5.12 KB | ||
| 13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx | 22.82 MB | ||
| 13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx | 18.26 MB | ||
| 2. Working with an SAP Data Extraction.mp4 | 39.2 MB | ||
| 2. Working with an SAP Data Extraction.srt | 4.48 KB | ||
| 3. Preliminary Mapping of the Data Extraction.mp4 | 31.18 MB | ||
| 3. Preliminary Mapping of the Data Extraction.srt | 2.78 KB | ||
| 3.1 1. Exercise - Build an FMCG Model_Mapping_after.xlsx | 14.9 MB | ||
| 3.2 1. Exercise - Build an FMCG Model_Mapping_before.xlsx | 13.26 MB | ||
| 4. Creating an Output Structure of the FMCG Model.mp4 | 22.18 MB | ||
| 4. Creating an Output Structure of the FMCG Model.srt | 3.19 KB | ||
| 4.1 2. Exercise - Build an FMCG Model_Layout_after.xlsx | 14.91 MB | ||
| 4.2 2. Exercise - Build an FMCG Model_Layout_before.xlsx | 14.9 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 3. Exercise - Build an FMCG Model_Formatting_after.xlsx | 14.91 MB | ||
| 5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx | 14.92 MB | ||
| 6. Inserting Formulas and Automating Calculations.mp4 | 18.1 MB | ||
| 6. Inserting Formulas and Automating Calculations.srt | 2.89 KB | ||
| 6.1 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx | 14.91 MB | ||
| 6.2 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx | 14.92 MB | ||
| 7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 | 21.79 MB | ||
| 7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt | 2.45 KB | ||
| 7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx | 14.91 MB | ||
| 7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx | 20.82 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 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx | 20.82 MB | ||
| 8.2 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx | 20.82 MB | ||
| 9. GETPIVOTDATA Fix.mp4 | 13.63 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 106. Exerxise-before.xlsx | 18.74 KB | ||
| 1.2 Financial Modeling Notes.pdf | 690.08 KB | ||
| 1.3 106. Exercise-after.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 - after.xlsx | 34.24 KB | ||
| 2.2 107. Exercise - before.xlsx | 30.45 KB | ||
| 3. Building an Output P&L Sheet.mp4 | 30.56 MB | ||
| 3. Building an Output P&L Sheet.srt | 4.32 KB | ||
| 3.1 108. Exercise - after.xlsx | 41.48 KB | ||
| 3.2 108. Exercise - before.xlsx | 32.36 KB | ||
| 4. Filling in the Output P&L Sheet with Historical Financials.mp4 | 23.91 MB | ||
| 4. Filling in the Output P&L Sheet with Historical Financials.srt | 3.05 KB | ||
| 4.1 109. Exersice - after.xlsx | 41.26 KB | ||
| 4.2 109. Exersice - before.xlsx | 37.63 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 - before.xlsx | 39.27 KB | ||
| 5.2 110. Exercise - after.xlsx | 41.73 KB | ||
| 6. Building an Output Balance Sheet.mp4 | 29.49 MB | ||
| 6. Building an Output Balance Sheet.srt | 4.01 KB | ||
| 6.1 111. Exercise - before.xlsx | 47.5 KB | ||
| 6.2 111. Exercise - after.xlsx | 54.43 KB | ||
| 7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4 | 43.49 MB | ||
| 7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.srt | 5.62 KB | ||
| 7.1 112. Exersice - before.xlsx | 49.8 KB | ||
| 7.2 112. Exersise - after.xlsx | 57.11 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 | 50.28 KB | ||
| 8.2 113. Exersice - after.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 | 54.94 KB | ||
| 1.2 114. Exercise - bef.xlsx | 52.8 KB | ||
| 2. Building a Flexible Model with CHOOSE & MATCH.mp4 | 16.07 MB | ||
| 2. Building a Flexible Model with CHOOSE & MATCH.srt | 1.79 KB | ||
| 2.1 115. Exercise - before.xlsx | 53.08 KB | ||
| 2.2 115. Exercise - after.xlsx | 54.67 KB | ||
| 3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4 | 36.27 MB | ||
| 3. Building a Flexible Model with VLOOKUP & COLUMNS.srt | 3.63 KB | ||
| 3.1 116. Exercise - before.xlsx | 53.08 KB | ||
| 3.2 116. Exercise - after.xlsx | 55.12 KB | ||
| 4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 | 44.5 MB | ||
| 4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt | 5.71 KB | ||
| 4.1 Working Capital Days.pdf | 340.78 KB | ||
| 4.2 117. Exercise -after.xlsx | 56.6 KB | ||
| 4.3 117. Exercise before.xlsx | 53.56 KB | ||
| 4.4 Course notes - Building a financial model.pdf | 575.23 KB | ||
| 5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 | 30.54 MB | ||
| 5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt | 3.5 KB | ||
| 5.1 118. Exercise - before.xlsx | 54.64 KB | ||
| 5.2 118. Exercise - after.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.94 MB | ||
| 1. Building a Fixed Asset Roll Forward.srt | 4.91 KB | ||
| 1.1 119. Exercise - before.xlsx | 55.75 KB | ||
| 1.2 119. Exercise - after.xlsx | 62.08 KB | ||
| 2. Building a Financial Liabilities Schedule.mp4 | 47.55 MB | ||
| 2. Building a Financial Liabilities Schedule.srt | 6.2 KB | ||
| 2.1 120. Exercise - before.xlsx | 58.9 KB | ||
| 2.2 120. Exercise - after.xlsx | 67.56 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 | 69.54 KB | ||
| 3.2 121. Exercise - before.xlsx | 58.9 KB | ||
| 4. Preparing a Cash Flow Structure.mp4 | 15.2 MB | ||
| 4. Preparing a Cash Flow Structure.srt | 2.41 KB | ||
| 4.1 122. Exercise - before.xlsx | 65.6 KB | ||
| 4.2 122. Exercise - after.xlsx | 70.35 KB | ||
| 5. Calculating Cash Flows and Completing the Model.mp4 | 57.48 MB | ||
| 5. Calculating Cash Flows and Completing the Model.srt | 7.55 KB | ||
| 5.1 123. Exercise - after.xlsx | 72.59 KB | ||
| 5.2 123. Exercise - before.xlsx | 67.69 KB | ||
| 15. Accounting - Introduction to Accounting & Bookkeeping | |||
| 1. Accounting The Science Behind Financial Figures.mp4 | 54.07 MB | ||
| 1. Accounting The Science Behind Financial Figures.srt | 2 KB | ||
| 1.1 Accounting & Financial Statement Analysis - Notes.pdf | 1.2 MB | ||
| 2. What is Accounting and Why Do You Need It.mp4 | 85.94 MB | ||
| 2. What is Accounting and Why Do You Need It.srt | 6.32 KB | ||
| 2.1 Accounting & Financial Statement Analysis - Notes.pdf | 1.18 MB | ||
| 3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 | 37.58 MB | ||
| 3. The Importance of Bookkeeping - Good Accounting Records Are Essential.srt | 3.51 KB | ||
| 3.1 Bookkeeping.mp4 | 12.37 MB | ||
| 4. An Introduction to Financial Accounting.mp4 | 44.23 MB | ||
| 4. An Introduction to Financial Accounting.srt | 3.54 KB | ||
| 4.1 Accounting & Financial Statement Analysis - Notes.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.67 MB | ||
| 1. The Different Types of Accounting Standards.srt | 3.42 KB | ||
| 1.1 The Complete Financial Analyst Course - Financial items.pdf | 890.01 KB | ||
| 10. Asset Categories - Practical Example.mp4 | 29.13 MB | ||
| 10. Asset Categories - Practical Example.srt | 4.69 KB | ||
| 10.1 P-G-Financial-Report.pdf | 4.41 MB | ||
| 11. Types of Liabilities.mp4 | 27.5 MB | ||
| 11. Types of Liabilities.srt | 5 KB | ||
| 12. Liability Categories - Practical Example.mp4 | 23.85 MB | ||
| 12. Liability Categories - Practical Example.srt | 3.38 KB | ||
| 13. Equity.mp4 | 15.02 MB | ||
| 13. Equity.srt | 2.69 KB | ||
| 14. Quiz Number 4.html | 147 B | ||
| 2. The Three Financial Statements.mp4 | 11.82 MB | ||
| 2. The Three Financial Statements.srt | 2.66 KB | ||
| 3. Types of Revenues.mp4 | 26.54 MB | ||
| 3. Types of Revenues.srt | 3.02 KB | ||
| 4. Types of Revenues - Exercise.mp4 | 18.62 MB | ||
| 4. Types of Revenues - Exercise.srt | 2.55 KB | ||
| 5. Types of Expenses.mp4 | 45.18 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 | 73.77 MB | ||
| 7. Depreciation & Amortization.srt | 6.3 KB | ||
| 8. Balance Sheet Items.mp4 | 74.45 MB | ||
| 8. Balance Sheet Items.srt | 5.38 KB | ||
| 9. Types of Assets.mp4 | 31.77 MB | ||
| 9. Types of Assets.srt | 4.63 KB | ||
| 17. Accounting - Revenue Recognition | |||
| 1. Accrual Accounting.mp4 | 13.66 MB | ||
| 1. Accrual Accounting.srt | 2.18 KB | ||
| 1.1 The Complete Financial Analyst Course - Revenue recognition.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.79 MB | ||
| 3. Potential Conflicts of Interest When Recognizing Revenue.srt | 2.57 KB | ||
| 4. A Practical Example.mp4 | 39.53 MB | ||
| 4. A Practical Example.srt | 7.19 KB | ||
| 5. FAQ Doubts Regarding Calculation.html | 683 B | ||
| 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 | 40.07 MB | ||
| 1. The Revenue Recognition Principle - Why Is It So Important.srt | 3.32 KB | ||
| 2. The Expense Recognition Principle - When to Recognize Expenses.mp4 | 33.15 MB | ||
| 2. The Expense Recognition Principle - When to Recognize Expenses.srt | 2.84 KB | ||
| 2. Microsoft Excel - Quick Introduction | |||
| 1. Microsoft Excel The World's #1 Office Software.mp4 | 36.32 MB | ||
| 1. Microsoft Excel The World's #1 Office Software.srt | 1.25 KB | ||
| 1.1 Introduction to Excel's basic features.pdf | 2.27 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 Introduction-to-Excels-basic-features.pdf | 2.26 MB | ||
| 10.2 6. Functions - Lecture -Solved.xlsx | 9.34 KB | ||
| 10.3 6. Functions- Exercise - Solved.xlsx | 81.1 KB | ||
| 10.4 6. Functions-Exercise - Unsolved.xlsx | 13.26 KB | ||
| 10.5 6. Functions- Lecture - Unsolved.xlsx | 9.24 KB | ||
| 11. Format Cells.mp4 | 29.12 MB | ||
| 11. Format Cells.srt | 6.51 KB | ||
| 11.1 10. Format cells_after.xlsx | 9.81 KB | ||
| 11.2 10. Format cells_before.xlsx | 9.81 KB | ||
| 12. Work Efficiently by Using Cut, Copy, and Paste.mp4 | 14.48 MB | ||
| 12. Work Efficiently by Using Cut, Copy, and Paste.srt | 2.64 KB | ||
| 12.1 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx | 11.34 KB | ||
| 12.2 7. Copy-Cut-Paste-Exercise - Solved.xlsx | 12.56 KB | ||
| 12.3 Introduction-to-Excels-basic-features.pdf | 2.27 MB | ||
| 13. Work Efficiently by Using Cut, Copy, and Paste.html | 147 B | ||
| 14. Pasting Values, Formulas and Formats with Paste Special.mp4 | 10.98 MB | ||
| 14. Pasting Values, Formulas and Formats with Paste Special.srt | 1.4 KB | ||
| 14.1 8. Paste-Special-Exercise-Text.xlsx | 13.47 KB | ||
| 14.2 Introduction-to-Excels-basic-features.pdf | 2.26 MB | ||
| 14.3 8. Paste-Special-Solved.xlsx | 13.46 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 | 2.27 MB | ||
| 2.2 1. Overview-of-Excel-Exercise-Unsolved.xlsx | 10.47 KB | ||
| 2.3 1. Overview-of-Excel-Exercise-Solved.xlsx | 10.88 KB | ||
| 3. Data Entry Techniques in Excel.mp4 | 28.5 MB | ||
| 3. Data Entry Techniques in Excel.srt | 4.03 KB | ||
| 3.1 2. Data-Entry - Lecture.xlsx | 8.07 KB | ||
| 3.2 2. Data-Entry-Exercise - Unsolved.xlsx | 10.97 KB | ||
| 3.3 2. Data-Entry- Exercise -Solved.xlsx | 32.76 KB | ||
| 4. How to Make Your Spreadsheets Look Professional.mp4 | 44.84 MB | ||
| 4. How to Make Your Spreadsheets Look Professional.srt | 7.16 KB | ||
| 4.1 3. Formatting- Exercise - Solved.xlsx | 11.59 KB | ||
| 4.2 3. Formatting- Lecture - Unsolved.xlsx | 8.91 KB | ||
| 4.3 3. Formatting-Exercise - Unsolved.xlsx | 11.61 KB | ||
| 4.4 3. Formatting - Lecture - Solved.xlsx | 9.85 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. Data Entry - Lecture.xlsx | 8.07 KB | ||
| 6.2 4. Basic-Manipulations - Exercise - Unsolved.xlsx | 11.06 KB | ||
| 6.3 4. Basic-Manipulations - Exercise - Solved.xlsx | 32.43 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 Introduction-to-Excels-basic-features.pdf | 2.26 MB | ||
| 8.2 5. Formulas - Exercise - Unsolved.xlsx | 11.72 KB | ||
| 8.3 5. Formulas- Lecture - Unsolved.xlsx | 9.3 KB | ||
| 8.4 5. Formulas- Lecture - Solved.xlsx | 9.36 KB | ||
| 8.5 5. Formulas- Exercise - Solved.xlsx | 80.13 KB | ||
| 9. Excel Formulas for Beginners.html | 147 B | ||
| 20. Accounting - The Core Principles of Accounting | |||
| 1. The Accounting Equation and Its Importance.mp4 | 29.17 MB | ||
| 1. The Accounting Equation and Its Importance.srt | 2.52 KB | ||
| 2. Elements of the Accounting System General Ledger.mp4 | 26.34 MB | ||
| 2. Elements of the Accounting System General Ledger.srt | 2 KB | ||
| 3. T-Accounts The Best Way to Understand Debits and Credits.mp4 | 35.6 MB | ||
| 3. T-Accounts The Best Way to Understand Debits and Credits.srt | 5.7 KB | ||
| 4. P&L T-Accounts.mp4 | 23.31 MB | ||
| 4. P&L T-Accounts.srt | 3.68 KB | ||
| 5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 | 43.78 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 | 114.78 MB | ||
| 1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt | 12.69 KB | ||
| 1.1 Practical Exercise - List of transactions.pdf | 182.53 KB | ||
| 1.2 Exercise Part One.xlsx | 17.44 KB | ||
| 1.3 Exercise - Before Solutions.xlsx | 17.13 KB | ||
| 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 | 40.01 MB | ||
| 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt | 9.61 KB | ||
| 2.1 Practical Exercise - List of transactions.pdf | 182.53 KB | ||
| 2.2 Exercise - Part Two.xlsx | 20.09 KB | ||
| 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 | 53.36 MB | ||
| 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt | 8.83 KB | ||
| 3.1 Exercise - Part Three.xlsx | 19.29 KB | ||
| 3.2 Practical Exercise - List of transactions.pdf | 182.53 KB | ||
| 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 | 98.54 MB | ||
| 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt | 8.34 KB | ||
| 4.1 Practical Exercise - List of transactions.pdf | 182.53 KB | ||
| 4.2 Exercise - Part Four.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 | 17.99 MB | ||
| 1. Timing of Cash Flows and Why It Plays an Important Role in a Business.srt | 1.52 KB | ||
| 2. Timing of Income Principles of Revenue Recognition.mp4 | 46.43 MB | ||
| 2. Timing of Income Principles of Revenue Recognition.srt | 7.51 KB | ||
| 3. Timing of Expenses Principles of Cost Recognition.mp4 | 27.7 MB | ||
| 3. Timing of Expenses Principles of Cost Recognition.srt | 4.03 KB | ||
| 4. The Four Type of Accruals Arising in Accounting Transactions.mp4 | 63.28 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 | 43.2 MB | ||
| 1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt | 3.52 KB | ||
| 2. The Three Parts of Cash Flow Statements Explained.mp4 | 33.18 MB | ||
| 2. The Three Parts of Cash Flow Statements Explained.srt | 2.68 KB | ||
| 3. Cash Flow Computations - The Direct Method.mp4 | 24.24 MB | ||
| 3. Cash Flow Computations - The Direct Method.srt | 2.69 KB | ||
| 4. Cash Flow Computations - The Indirect Method.mp4 | 56.43 MB | ||
| 4. Cash Flow Computations - The Indirect Method.srt | 4.49 KB | ||
| 5. Calculating Cash Flow in Practice A Complete Example.mp4 | 45.89 MB | ||
| 5. Calculating Cash Flow in Practice A Complete Example.srt | 8.13 KB | ||
| 5.1 Cash flow.xlsx | 57.2 KB | ||
| 6. FAQ Why D&A Has Been Added in Capex.html | 2.22 KB | ||
| 24. Advanced Accounting - Trade Receivables | |||
| 1. Why a Company Needs to Pay Attention to Trade Receivables.mp4 | 25.23 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 | 706.56 KB | ||
| 2. What If Clients Do Not Pay on Time.mp4 | 26.48 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.95 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.45 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.67 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.25 MB | ||
| 2. The Connection Between Cost of Goods Sold and Inventory.srt | 3.37 KB | ||
| 3. Cost Flow Methods.mp4 | 28.72 MB | ||
| 3. Cost Flow Methods.srt | 5.97 KB | ||
| 4. Cost Flow Methods - a Practical Exercise.mp4 | 6.74 MB | ||
| 4. Cost Flow Methods - a Practical Exercise.srt | 1.36 KB | ||
| 4.1 Inventory-Cost-Flow-Methods-with-solutions.pptx | 175.11 KB | ||
| 4.2 Inventory Cost Flow Methods_solved.xlsx | 12.38 KB | ||
| 4.3 Inventory Cost Flow Methods_unsolved.xlsx | 11.53 KB | ||
| 4.4 Inventory Cost Flow Methods.pptx | 168.54 KB | ||
| 5. FAQ How to Apply the Weighted Average Cost Method.html | 916 B | ||
| 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 | 39.95 MB | ||
| 3. Fair Value Accounting.srt | 3.16 KB | ||
| 4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4 | 35.3 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 | 38 MB | ||
| 6. The Revaluation Model - Practical Exercise.srt | 6.27 KB | ||
| 7. Intangible Assets Created Internally.mp4 | 17.69 MB | ||
| 7. Intangible Assets Created Internally.srt | 2.64 KB | ||
| 27. Advanced Accounting - Trade Payables | |||
| 1. How We Account for Trade Payables.mp4 | 22.54 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.9 MB | ||
| 2. What Is the Difference Between Accounts Payable and Notes Payable.srt | 1.8 KB | ||
| 3. Why Use E-invoicing.mp4 | 25.93 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.79 MB | ||
| 3. Debt Covenants.srt | 4.27 KB | ||
| 4. Debt Covenants - A Practical Example.mp4 | 13.68 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.18 MB | ||
| 2. Solving a Complete Leasing Exercise.srt | 5.73 KB | ||
| 2.1 Leasing Exercise - Solved.xlsx | 15.11 KB | ||
| 2.2 Leasing Exercise - Unsolved.xlsx | 9.63 KB | ||
| 3. Microsoft Excel - Useful Tools | |||
| 1. Inserting a Line Break with Alt + Enter.mp4 | 10.09 MB | ||
| 1. Inserting a Line Break with Alt + Enter.srt | 1.04 KB | ||
| 1.1 9. Alt-Enter-Exercise - Solved.xlsx | 11.4 KB | ||
| 1.2 9. Alt-Enter- Lecture - Solved.xlsx | 9.65 KB | ||
| 1.3 9. Alt-Enter- Lecture - Unsolved.xlsx | 9.64 KB | ||
| 1.4 9. Alt-Enter-Exercise - Unsolved.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-Exercise - Unsolved.xlsx | 10.57 KB | ||
| 2.2 10. Text-to-columns-Lecture - Solved.xlsx | 9.9 KB | ||
| 2.3 10. Text-to-Columns-Exercise - Solved.xlsx | 11.3 KB | ||
| 2.4 10. Text-to-columns-Lecture - Unsolved.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 | 11.42 KB | ||
| 4.2 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 4.3 11. Set-Print-Area-Lecture - Solved.xlsx | 11.22 KB | ||
| 5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 | 3.78 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 | 9.61 KB | ||
| 5.2 12. Wrap-Text-Exercise - Unsolved.xlsx | 10.17 KB | ||
| 5.3 12. Wrap-text-Lecture - Solved.xlsx | 9.61 KB | ||
| 5.4 12. Wrap-Text-Exercise - Solved.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 - Unsolved.xlsx | 136.89 KB | ||
| 6.2 13. Hyperlinks-Exercise - Solved.xlsx | 137.06 KB | ||
| 6.3 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 | 15.26 MB | ||
| 7. Using Excel's Freeze Panes to Handle Large Datasets.srt | 1.46 KB | ||
| 7.1 14. Freeze-Panes-Lecture - Solved.xlsx | 643.94 KB | ||
| 7.2 Useful-Tips-Tools.pdf | 3.3 MB | ||
| 7.3 14. Freeze-Panes-Lecture - Unsolved.xlsx | 643.87 KB | ||
| 8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 | 14.84 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 | 3.31 MB | ||
| 9. A Quick Introduction to Excel's Pivot Tables.mp4 | 41.25 MB | ||
| 9. A Quick Introduction to Excel's Pivot Tables.srt | 2.67 KB | ||
| 9.1 21. Pivot Tables - Exercise - Unsolved.xlsx | 152.17 KB | ||
| 9.2 21. Pivot tables - Lecture - Solved.xlsm | 897.26 KB | ||
| 9.3 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 9.4 21. Pivot tables - Lecture - Unsolved.xlsm | 687.83 KB | ||
| 9.5 21. Pivot Tables - Exercise - Solved.xlsx | 190.47 KB | ||
| 30. Advanced Accounting - Using Leverage | |||
| 1. What is Leverage and Why Companies Use Financial Leverage.mp4 | 57.43 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.23 MB | ||
| 1. The Different Types of Equity.srt | 5.01 KB | ||
| 2. Raising Equity in Different Stages of a Company's Lifecycle.mp4 | 71.96 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.88 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.06 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 | 33.52 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 | 131.32 MB | ||
| 2. Finding, Downloading and Going Through the Annual Report of P&G.srt | 7.86 KB | ||
| 2.1 P&G Financial Report.pdf | 4.41 MB | ||
| 3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 | 29.37 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 | 25.97 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 | 22.07 MB | ||
| 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt | 2.45 KB | ||
| 1.1 Financial Statement Analysis - Notes.pdf | 772.86 KB | ||
| 2. First Steps in Financial Statement Analysis.mp4 | 38.28 MB | ||
| 2. First Steps in Financial Statement Analysis.srt | 3.98 KB | ||
| 3. Horizontal vs. Vertical Financial Statement Analysis.mp4 | 47.24 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 | 19.83 MB | ||
| 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt | 1.66 KB | ||
| 4.1 Working Capital Days.pdf | 340.78 KB | ||
| 5. Using Accounting Ratios to Assess Business Performance.mp4 | 69.73 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 | 92.13 MB | ||
| 1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt | 7.53 KB | ||
| 1.1 P&G Financials_Before.xlsx | 12.79 KB | ||
| 1.2 P&G Financials_WithRatios.xlsx | 13.93 KB | ||
| 1.3 P&G Financials.xlsx | 14.23 KB | ||
| 1.4 P&G Financial Report.pdf | 4.41 MB | ||
| 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 | 61.67 MB | ||
| 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt | 5.03 KB | ||
| 2.1 P&G Financials_Before.xlsx | 12.79 KB | ||
| 2.2 P&G Financials.xlsx | 14.23 KB | ||
| 2.3 P&G Financial Report.pdf | 4.41 MB | ||
| 2.4 P&G Financials_WithRatios.xlsx | 13.93 KB | ||
| 3. COURSE CHALLENGE - Part 2.mp4 | 31.86 MB | ||
| 3. COURSE CHALLENGE - Part 2.srt | 2.12 KB | ||
| 3.1 2. Course Challenge.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.41 MB | ||
| 2. How to Download Tesla's Historical Financials.srt | 2.84 KB | ||
| 2.1 Tesla 2017.pdf | 2.51 MB | ||
| 2.2 Tesla 2016.pdf | 2.21 MB | ||
| 2.3 Tesla 2015.pdf | 1.29 MB | ||
| 2.4 Tesla 2018 Q2.pdf | 635.07 KB | ||
| 3. Calculating and Analyzing Growth and Profitability Ratios.mp4 | 96.51 MB | ||
| 3. Calculating and Analyzing Growth and Profitability Ratios.srt | 11.34 KB | ||
| 3.1 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx | 1.28 MB | ||
| 3.2 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx | 1.28 MB | ||
| 4. Calculating and Analyzing Liquidity Ratios.mp4 | 74.96 MB | ||
| 4. Calculating and Analyzing Liquidity Ratios.srt | 7.68 KB | ||
| 4.1 Tesla - Financial Statement Analysis - Liquidity_before.xlsx | 1.28 MB | ||
| 4.2 Tesla - Financial Statement Analysis - Liquidity_after.xlsx | 1.28 MB | ||
| 5. Calculating and Analyzing Solvency Ratios.mp4 | 18.82 MB | ||
| 5. Calculating and Analyzing Solvency Ratios.srt | 2.13 KB | ||
| 5.1 Tesla - Financial Statement Analysis - Solvency_before.xlsx | 1.28 MB | ||
| 5.2 Tesla - Financial Statement Analysis - Solvency_after.xlsx | 1.08 MB | ||
| 36. Working Capital Management | |||
| 1. Introduction.mp4 | 23.43 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_unsolved.xlsx | 12.7 KB | ||
| 10.2 Working capital test_solved.xlsx | 13.58 KB | ||
| 11. Symptoms of Inefficient Working Capital - Trade Receivables.mp4 | 13.14 MB | ||
| 11. Symptoms of Inefficient Working Capital - Trade Receivables.srt | 2.42 KB | ||
| 2. The Importance of Working Capital Optimization Case Study.mp4 | 89.98 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.15 MB | ||
| 4. Trade Receivables Management.srt | 10.39 KB | ||
| 5. Re-order Level.mp4 | 31.31 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.49 MB | ||
| 7. Inventory Optimization Techniques.srt | 6.46 KB | ||
| 8. Trade Payables Management.mp4 | 19.28 MB | ||
| 8. Trade Payables Management.srt | 2.5 KB | ||
| 9. Working Capital Optimization - a Roadmap.mp4 | 48.19 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 | 26.62 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 | 689.77 KB | ||
| 2. Understanding the Time Value of Money.mp4 | 9.72 MB | ||
| 2. Understanding the Time Value of Money.srt | 1.74 KB | ||
| 2.1 Time value of money.pdf | 777.26 KB | ||
| 2.2 Finance 101 - Introduction to the World of Finance.pdf | 689.77 KB | ||
| 3. How Interest Rates Play an Important Role in the Economy.mp4 | 23.26 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 | 689.77 KB | ||
| 4. The Components Forming Interest Rates in Real Life.mp4 | 26.58 MB | ||
| 4. The Components Forming Interest Rates in Real Life.srt | 3.74 KB | ||
| 4.1 Interest rate components.pdf | 807.55 KB | ||
| 4.2 Finance 101 - Introduction to the World of Finance.pdf | 689.77 KB | ||
| 5. What Is Libor and What Purpose Does It Serve.mp4 | 27.69 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 | 689.77 KB | ||
| 6. The Difference Between Fixed and Variable Interest Rates.mp4 | 26.86 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 | 689.77 KB | ||
| 7. What Is Default Risk and How Does a Bank Account For It.mp4 | 48.86 MB | ||
| 7. What Is Default Risk and How Does a Bank Account For It.srt | 9.07 KB | ||
| 7.1 Default risk.pdf | 880.84 KB | ||
| 7.2 Finance 101 - Introduction to the World of Finance.pdf | 689.77 KB | ||
| 8. Corporate Loan Specifics.mp4 | 41.33 MB | ||
| 8. Corporate Loan Specifics.srt | 2.11 KB | ||
| 8.1 Finance 101 - Introduction to the World of Finance.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 | 48.49 MB | ||
| 1. Calculating the Present Value of Future Cash Flows.srt | 6.11 KB | ||
| 1.1 1. Calculating Future Cash Flows.pdf | 810.28 KB | ||
| 1.2 3.1 Present Value of Cash Flows.xlsx | 9.85 KB | ||
| 2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 | 47.8 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 | 192.19 KB | ||
| 4. Microsoft Excel - Best Practices That Will Make a Difference | |||
| 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 | 22.43 MB | ||
| 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt | 2.12 KB | ||
| 1.1 17. Formatting-a-Worksheet-Exercise - Solved.xlsx | 10.76 KB | ||
| 1.2 Useful-Tips-Tools.pdf | 3.3 MB | ||
| 1.3 17. Formatting-a-worksheet-Lecture - Solved.xlsx | 9.56 KB | ||
| 1.4 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx | 10.63 KB | ||
| 1.5 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx | 8.98 KB | ||
| 10. Using Absolute and Relative Cell References.html | 147 B | ||
| 11. Find and Select Cells That Meet Specific Conditions.mp4 | 13.46 MB | ||
| 11. Find and Select Cells That Meet Specific Conditions.srt | 1.81 KB | ||
| 11.1 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 11.2 23. Select-Special-F5-Exercise - Solved.xlsx | 22.27 KB | ||
| 11.3 23. Select-Special-F5-Exercise - Unsolved.xlsx | 21.59 KB | ||
| 11.4 23. Select-Special-Lecture.xlsx | 10.56 KB | ||
| 12. Find and Select Cells That Meet Specific Conditions.html | 147 B | ||
| 13. How to Create Dynamic Names in Excel Spreadsheets.mp4 | 15.14 MB | ||
| 13. How to Create Dynamic Names in Excel Spreadsheets.srt | 1.65 KB | ||
| 13.1 24. Dynamic-Naming-Lecture - Unsolved.xlsx | 13.54 KB | ||
| 13.2 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx | 11.23 KB | ||
| 13.3 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 13.4 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx | 11.73 KB | ||
| 13.5 24. Dynamic-Naming-Lecture - Solved.xlsx | 13.83 KB | ||
| 14. How to Create Dynamic Names in Excel Spreadsheets.html | 147 B | ||
| 15. Using Named Ranges to Make Formulas More Readable.mp4 | 9.12 MB | ||
| 15. Using Named Ranges to Make Formulas More Readable.srt | 1.82 KB | ||
| 15.1 Useful-Tips-Tools.pdf | 3.3 MB | ||
| 15.2 25. Naming-ranges-Lecture - Solved.xlsx | 10.34 KB | ||
| 15.3 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx | 11.07 KB | ||
| 15.4 25. Defining-a-Named-Range-Exercise - Solved.xlsx | 11.65 KB | ||
| 15.5 25. Naming-ranges-Lecture - Unsolved.xlsx | 8.79 KB | ||
| 16. Introduction to Custom Formatting in Excel.mp4 | 37.96 MB | ||
| 16. Introduction to Custom Formatting in Excel.srt | 8.06 KB | ||
| 16.1 19. Custom formatting_before.xlsx | 10.69 KB | ||
| 16.2 19. Custom formatting_after.xlsx | 10.75 KB | ||
| 17. Custom Number Formatting.mp4 | 9.9 MB | ||
| 17. Custom Number Formatting.srt | 1.98 KB | ||
| 17.1 31. Assigning Custom Formats - Exercise - Unsolved.xlsx | 11.35 KB | ||
| 17.2 Useful-Tips-Tools.pdf | 3.3 MB | ||
| 17.3 31. Assigning Custom Formats - Exercise - Solved.xlsx | 11.08 KB | ||
| 18. How to Add a Drop-down List in Excel.mp4 | 16.29 MB | ||
| 18. How to Add a Drop-down List in Excel.srt | 2.32 KB | ||
| 18.1 27. Drop-down-List-Exercise - Solved.xlsx | 77.02 KB | ||
| 18.2 27. Data-Validation-Lecture - Solved.xlsx | 10.84 KB | ||
| 18.3 27. Drop-down-List-Exercise - Unsolved.xlsx | 11.34 KB | ||
| 18.4 27. Data-Validation-Lecture - Unsolved.xlsx | 10.84 KB | ||
| 19. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 | 22.15 MB | ||
| 19. Using Custom-sort to Sort Multiple Columns Within a Table.srt | 1.71 KB | ||
| 19.1 28. Sort-data-Lecture - Solved.xlsx | 145.65 KB | ||
| 19.2 28. Sort-data-Lecture - Unsolved.xlsx | 145.35 KB | ||
| 19.3 28. Custom-Sort-Exercise - Solved.xlsx | 11.46 KB | ||
| 19.4 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 19.5 28. Custom-Sort-Exercise - Unsolved.xlsx | 11.37 KB | ||
| 2. Macros Are a Great Timesaver! Here's Why..mp4 | 36.24 MB | ||
| 2. Macros Are a Great Timesaver! Here's Why..srt | 3.46 KB | ||
| 2.1 18. Macros-Exercise - Solved.xlsx | 145.02 KB | ||
| 2.2 18. Creating-a-Macro-Lecture - Solved.xlsx | 11.17 KB | ||
| 2.3 18. Macros-Exercise - Unsolved.xlsx | 10.34 KB | ||
| 2.4 Useful-Tips-Tools.pdf | 3.3 MB | ||
| 2.5 18. Creating-a-Macro-Lecture - Unsolved.xlsx | 9.66 KB | ||
| 20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 | 45.95 MB | ||
| 20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt | 5.03 KB | ||
| 20.1 29. Microsoft-Excel-Shortcuts-for-MAC.pdf | 769.21 KB | ||
| 20.2 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 20.3 29. Microsoft-Excel-Keyboard-Shortcuts.pdf | 1.26 MB | ||
| 21. Multiply by 1.mp4 | 14.84 MB | ||
| 21. Multiply by 1.srt | 1.74 KB | ||
| 21.1 30. Multiply-by-1-Lecture-before.xlsx | 16.47 KB | ||
| 21.2 30. Multiply-by-1-Lecture-after.xlsx | 17.21 KB | ||
| 22. Find and Replace - References.mp4 | 24.06 MB | ||
| 22. Find and Replace - References.srt | 3.45 KB | ||
| 22.1 31. Find-and-Replace-references-Lecture-after.xlsx | 37.91 KB | ||
| 22.2 31. Find-and-Replace-references-Lecture-before.xlsx | 38.79 KB | ||
| 23. FAQ Why Do We Replace External References and How Does This Help Us.html | 702 B | ||
| 24. Find and Replace - Formatting.mp4 | 13.79 MB | ||
| 24. Find and Replace - Formatting.srt | 1.91 KB | ||
| 24.1 32. Find-replace-Lecture-before.xlsx | 17.19 KB | ||
| 24.2 32. Find-replace-Lecture-after.xlsx | 17.19 KB | ||
| 25. Green References.mp4 | 12.61 MB | ||
| 25. Green References.srt | 1.7 KB | ||
| 25.1 33. Green-references-Lecture.xlsx | 12 KB | ||
| 26. Beauty Saving - The Professional Way of Saving Files.mp4 | 14.03 MB | ||
| 26. Beauty Saving - The Professional Way of Saving Files.srt | 2.54 KB | ||
| 26.1 34. Beauty-saving-Lecture-after.xlsx | 17.05 KB | ||
| 26.2 34. Beauty-saving-Lecture-before.xlsx | 17.17 KB | ||
| 27. The Power of F2.mp4 | 17.74 MB | ||
| 27. The Power of F2.srt | 2.19 KB | ||
| 27.1 43. F2-Lecture.xlsm | 49.9 KB | ||
| 28. Conditional Formatting.mp4 | 58.71 MB | ||
| 28. Conditional Formatting.srt | 6.07 KB | ||
| 28.1 41. Conditional formatting - Lecture.xlsx | 41.73 KB | ||
| 29. 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-after.xlsm | 12.59 KB | ||
| 3.2 19. Another-file.xlsx | 8.81 KB | ||
| 3.3 19. How-to-save-macros-Lecture-before.xlsx | 6.02 KB | ||
| 4. Macros Are a Great Timesaver! Here's Why..html | 147 B | ||
| 5. The Secret to Faster Scrolling in Excel.mp4 | 20.85 MB | ||
| 5. The Secret to Faster Scrolling in Excel.srt | 1.84 KB | ||
| 5.1 25. Fast-Scrolling-Exercise - Solved.xlsx | 44.35 KB | ||
| 5.2 25. Fast-Scrolling - Lecture.xlsx | 642.82 KB | ||
| 5.3 25. Fast-Scrolling-Exercise - Unsolved.xlsx | 43.9 KB | ||
| 5.4 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 6. Be even quicker F5 + Enter.mp4 | 19.79 MB | ||
| 6. Be even quicker F5 + Enter.srt | 2.16 KB | ||
| 6.1 21. F5-go-to - Lecture.xlsm | 50.76 KB | ||
| 7. FAQ F5 + Enter didn't work for me.html | 402 B | ||
| 8. The Secret to Faster Scrolling in Excel.html | 147 B | ||
| 9. Using Absolute and Relative Cell References.mp4 | 43.08 MB | ||
| 9. Using Absolute and Relative Cell References.srt | 2.71 KB | ||
| 9.1 Useful-Tips-Tools.pdf | 3.31 MB | ||
| 9.2 22. Fixing-references-Lecture - Unsolved.xlsx | 643.98 KB | ||
| 9.3 22. Fixing-references-Lecture - Solved.xlsx | 645.17 KB | ||
| 9.4 22. Fixing-Cells-Exercise - Unsolved.xlsx | 10.67 KB | ||
| 9.5 22. Fixing-Cells-Exercise - Solved.xlsx | 10.82 KB | ||
| 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.63 MB | ||
| 2. Calculating a Complete Loan Schedule.srt | 7.36 KB | ||
| 3. COURSE CHALLENGE - Part 3.mp4 | 23.46 MB | ||
| 3. COURSE CHALLENGE - Part 3.srt | 1.64 KB | ||
| 3.1 3. Course Challenge.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.91 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.85 MB | ||
| 5. Cost of Equity.srt | 8.01 KB | ||
| 6. Project-specific Beta.mp4 | 27.21 MB | ||
| 6. Project-specific Beta.srt | 3.83 KB | ||
| 7. The Weighted Average Cost of Capital (WACC).mp4 | 15.72 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.32 MB | ||
| 8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt | 4.16 KB | ||
| 9. Modeling Future Cash Flows.mp4 | 54.4 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.31 MB | ||
| 1. An Introduction to the Case Study.srt | 3.42 KB | ||
| 10. Estimating Cost of Equity.mp4 | 40.39 MB | ||
| 10. Estimating Cost of Equity.srt | 7.63 KB | ||
| 10.1 8. WACC.xlsx | 38.03 KB | ||
| 10.2 8. WACC_unsolved.xlsx | 35.93 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 | 38.75 KB | ||
| 11.2 9. Discounted cash flow.xlsx | 39.74 KB | ||
| 12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 | 43.06 MB | ||
| 12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt | 5.56 KB | ||
| 12.1 10. Sensitivity analysis.xlsx | 40.67 KB | ||
| 12.2 Capital-budgeting-exercise-solved.xlsx | 42.75 KB | ||
| 12.3 10. Sensitivity analysis_unsolved.xlsx | 39.7 KB | ||
| 12.4 Capital budgeting_exercise_unsolved.xlsx | 13.21 KB | ||
| 13. FAQ Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet.html | 378 B | ||
| 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 | 11.5 KB | ||
| 3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4 | 34.75 MB | ||
| 3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt | 4.26 KB | ||
| 3.1 2. Savings Forecast.xlsx | 16.58 KB | ||
| 3.2 2. Savings Forecast_unsolved.xlsx | 14.74 KB | ||
| 4. Preparing a Fixed Asset Rollforward Schedule.mp4 | 47.37 MB | ||
| 4. Preparing a Fixed Asset Rollforward Schedule.srt | 5.55 KB | ||
| 4.1 3. Fixed Asset Rollforward.xlsx | 19.66 KB | ||
| 4.2 3. Fixed Asset Rollforward_unsolved.xlsx | 18.54 KB | ||
| 5. Calculating the Cash Impact of Extra Working Capital Required.mp4 | 18.36 MB | ||
| 5. Calculating the Cash Impact of Extra Working Capital Required.srt | 3.03 KB | ||
| 5.1 4. Working Capital_unsolved.xlsx | 21.19 KB | ||
| 5.2 4. Working Capital.xlsx | 21.93 KB | ||
| 6. Debt Repayment and Interest Expenses Calculation.mp4 | 22.14 MB | ||
| 6. Debt Repayment and Interest Expenses Calculation.srt | 3.43 KB | ||
| 6.1 5. Financing.xlsx | 30.97 KB | ||
| 6.2 5. Financing_unsolved.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.xlsx | 31.03 KB | ||
| 7.2 6. P&L_unsolved.xlsx | 29.7 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_unsolved.xlsx | 29.64 KB | ||
| 8.2 7. Cash flow.xlsx | 31.36 KB | ||
| 9. Calculating WACC (Weighted Average Cost of Capital).mp4 | 18.53 MB | ||
| 9. Calculating WACC (Weighted Average Cost of Capital).srt | 3.52 KB | ||
| 9.1 8. WACC.xlsx | 38.03 KB | ||
| 9.2 8. WACC_unsolved.xlsx | 35.93 KB | ||
| 43. Tesla Practical Case Study - Building a Financial Planning Model | |||
| 1. Organizing External Inputs in a 'Drivers' Sheet.mp4 | 31.01 MB | ||
| 1. Organizing External Inputs in a 'Drivers' Sheet.srt | 4.37 KB | ||
| 1.1 0a. Drivers_before.xlsx | 1.27 MB | ||
| 1.2 0a. Drivers_after.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 | 1.34 MB | ||
| 10.2 6. Energy and Other revenue - After.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 - Before.xlsx | 1.35 MB | ||
| 11.2 7. Energy and Other - Gross profit, cost of sales - After.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 | 1.36 MB | ||
| 12.2 8. Opex - After.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 | 1.37 MB | ||
| 13.2 9. PP&E forecasting and comparables_after.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 | 1.37 MB | ||
| 14.2 10. PP&E schedule_before.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 | 1.37 MB | ||
| 16. FAQ Why Model D&A as a % of Revenues or as a % of Beginning PP&E.html | 818 B | ||
| 17. Calculating DSO, DIO, DPO.mp4 | 17.52 MB | ||
| 17. Calculating DSO, DIO, DPO.srt | 2.11 KB | ||
| 17.1 11. Working capital forecasting_after.xlsx | 1.52 MB | ||
| 17.2 11. Working capital forecasting_before.xlsx | 1.38 MB | ||
| 18. Producing a Clean P&L Output Sheet.mp4 | 8.44 MB | ||
| 18. Producing a Clean P&L Output Sheet.srt | 1.62 KB | ||
| 18.1 12. P&L.xlsx | 1.39 MB | ||
| 19. Fill in the P&L Output Sheet.mp4 | 18.35 MB | ||
| 19. Fill in the P&L Output Sheet.srt | 1.83 KB | ||
| 19.1 12a. P&L fill in_after.xlsx | 1.39 MB | ||
| 19.2 12a. P&L fill in_before.xlsx | 1.39 MB | ||
| 2. The Input Data We Will Work With.mp4 | 15.81 MB | ||
| 2. The Input Data We Will Work With.srt | 1.72 KB | ||
| 2.1 0aa. Inputs_after.xlsx | 1.28 MB | ||
| 2.2 0aa. Inputs_before.xlsx | 1.28 MB | ||
| 20. Calculating Investments in Working Capital.mp4 | 19.06 MB | ||
| 20. Calculating Investments in Working Capital.srt | 2.16 KB | ||
| 20.1 13. Calculating working capital_after.xlsx | 1.4 MB | ||
| 20.2 13. Calculating working capital_before.xlsx | 1.4 MB | ||
| 21. Forecasting Unlevered Free Cash Flow.mp4 | 55.99 MB | ||
| 21. Forecasting Unlevered Free Cash Flow.srt | 6.09 KB | ||
| 21.1 14. Cash flow - UFCF_before.xlsx | 1.41 MB | ||
| 21.2 14. Cash flow - UFCF_after.xlsx | 1.41 MB | ||
| 22. Forecasting Other Assets.mp4 | 45.31 MB | ||
| 22. Forecasting Other Assets.srt | 4.62 KB | ||
| 22.1 15. Balance Sheet forecasting assets_before.xlsx | 1.41 MB | ||
| 22.2 15. Balance Sheet forecasting assets_after.xlsx | 1.41 MB | ||
| 23. Forecasting Other Liabilities.mp4 | 22.06 MB | ||
| 23. Forecasting Other Liabilities.srt | 2.36 KB | ||
| 23.1 16. Balance Sheet forecasting liabilities_before.xlsx | 1.41 MB | ||
| 23.2 16. Balance Sheet forecasting liabilities_after.xlsx | 1.42 MB | ||
| 24. Completing Unlevered Free Cash Flow.mp4 | 40.9 MB | ||
| 24. Completing Unlevered Free Cash Flow.srt | 3.71 KB | ||
| 24.1 16a. Complete UFCF_before.xlsx | 1.42 MB | ||
| 24.2 16a. Complete UFCF_after.xlsx | 1.42 MB | ||
| 25. Modeling Tesla's Financing Needs in the Forecast Period.mp4 | 42.38 MB | ||
| 25. Modeling Tesla's Financing Needs in the Forecast Period.srt | 5.64 KB | ||
| 25.1 17. Financing_after.xlsx | 1.43 MB | ||
| 25.2 17. Financing_before.xlsx | 1.43 MB | ||
| 26. FAQ Doubt Regarding the Formula for Outstanding Debt.html | 1.16 KB | ||
| 27. Calculating Net Income.mp4 | 14.8 MB | ||
| 27. Calculating Net Income.srt | 1.39 KB | ||
| 27.1 18. P&L complete_before.xlsx | 1.43 MB | ||
| 27.2 18. P&L complete_after.xlsx | 1.43 MB | ||
| 28. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 | 50.68 MB | ||
| 28. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt | 4.51 KB | ||
| 28.1 19. Cash flow_complete_after.xlsx | 1.43 MB | ||
| 28.2 19. Cash flow_complete_before.xlsx | 1.43 MB | ||
| 29. Balancing the Balance Sheet.mp4 | 13.3 MB | ||
| 29. Balancing the Balance Sheet.srt | 1.18 KB | ||
| 29.1 20. Complete the BS_before.xlsx | 1.43 MB | ||
| 29.2 20. Complete the BS_after.xlsx | 1.43 MB | ||
| 3. Forecasting Tesla's Expected Deliveries.mp4 | 100.33 MB | ||
| 3. Forecasting Tesla's Expected Deliveries.srt | 16.05 KB | ||
| 3.1 1. Deliveries_before.xlsx | 1.29 MB | ||
| 3.2 1. Deliveries_after.xlsx | 1.29 MB | ||
| 4. Comparing Delivery Figures with the Ones of industry Peers.mp4 | 20.99 MB | ||
| 4. Comparing Delivery Figures with the Ones of industry Peers.srt | 3.1 KB | ||
| 4.1 1a. Deliveries development.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 | 1.31 MB | ||
| 5.2 2. Average price_before.xlsx | 1.31 MB | ||
| 6. Calculating Automotive Revenue.mp4 | 46.57 MB | ||
| 6. Calculating Automotive Revenue.srt | 4.93 KB | ||
| 6.1 3. Revenue calculation and scenarios - after.xlsx | 1.31 MB | ||
| 6.2 3. Revenue calculation and scenarios - before.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 | 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 - after.xlsx | 1.32 MB | ||
| 8.2 4a. Gross profit automotive - before.xlsx | 1.51 MB | ||
| 9. Calculating Automotive Cost of Sales.mp4 | 17.53 MB | ||
| 9. Calculating Automotive Cost of Sales.srt | 2.27 KB | ||
| 9.1 5. Cost of sales and chart.xlsx | 1.34 MB | ||
| 44. PowerPoint - Introduction to PowerPoint | |||
| 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 | 30.48 MB | ||
| 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.srt | 1.14 KB | ||
| 10. Practical Learning - Exercise 1.mp4 | 27.47 MB | ||
| 10. Practical Learning - Exercise 1.srt | 4.33 KB | ||
| 10.1 Practical Example - Organizing Notes.docx | 15.5 KB | ||
| 10.2 Practical Example - Organizing Notes.pptx | 1.23 MB | ||
| 11. Changing an Object's Size and Rotation.mp4 | 11.24 MB | ||
| 11. Changing an Object's Size and Rotation.srt | 2.2 KB | ||
| 11.1 Resizing and Rotating Objects.pptx | 1.23 MB | ||
| 12. Using Slide Masters.mp4 | 22.41 MB | ||
| 12. Using Slide Masters.srt | 5.23 KB | ||
| 12.1 Slide Masters Presentation - example.pptx | 43.49 KB | ||
| 13. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 | 15.32 MB | ||
| 13. Bring to Front and Send to Back - An Important PowerPoint Technique.srt | 3.34 KB | ||
| 13.1 Bring to Front and Send to Back.pptx | 1.23 MB | ||
| 14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 | 27.66 MB | ||
| 14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt | 6.01 KB | ||
| 14.1 Insert table.pptx | 1.21 MB | ||
| 2. The Structure of the PowerPoint Ribbon.mp4 | 27.74 MB | ||
| 2. The Structure of the PowerPoint Ribbon.srt | 5.69 KB | ||
| 2.1 Introduction to PowerPoint.pdf | 2.58 MB | ||
| 3. General Considerations About Slide Structure.mp4 | 26.19 MB | ||
| 3. General Considerations About Slide Structure.srt | 4.67 KB | ||
| 3.1 Spacing within PowerPoint.pptx | 1.86 MB | ||
| 3.2 Spacing-within-PowerPoint-chart.xlsx | 57.28 KB | ||
| 4. Learn How to Insert Objects in PowerPoint.mp4 | 31.97 MB | ||
| 4. Learn How to Insert Objects in PowerPoint.srt | 4.75 KB | ||
| 4.1 Kinemax Data.xlsx | 36.41 KB | ||
| 4.2 Insert objects.pptx | 1.64 MB | ||
| 5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 | 16.62 MB | ||
| 5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt | 3.04 KB | ||
| 5.1 PowerPoint Master Class - Shortcuts.pdf | 440.4 KB | ||
| 5.2 Power-Point-Master-Class-Shortcuts-For-Mac.pdf | 532.42 KB | ||
| 6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 | 21.32 MB | ||
| 6. Add Frequently Used Buttons to the Quick Access Toolbar.srt | 3.44 KB | ||
| 6.1 Quick Access Toolbar buttons.pptx | 1.24 MB | ||
| 7. How to Easily Align Objects in PowerPoint.mp4 | 20.49 MB | ||
| 7. How to Easily Align Objects in PowerPoint.srt | 4.86 KB | ||
| 7.1 Align and Distribute objects in Ppt.pptx | 1.25 MB | ||
| 8. How to Edit Shapes in Your Presentation.mp4 | 26.24 MB | ||
| 8. How to Edit Shapes in Your Presentation.srt | 5.9 KB | ||
| 8.1 Format Shape Menu.pptx | 634.21 KB | ||
| 9. How to Format Text Boxes in a PowerPoint Presentation.mp4 | 19.96 MB | ||
| 9. How to Format Text Boxes in a PowerPoint Presentation.srt | 4.35 KB | ||
| 9.1 Working with text.pptx | 772.99 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 | 1.21 MB | ||
| 10. Practical Exercise - Creating an Organisational Chart.mp4 | 52.76 MB | ||
| 10. Practical Exercise - Creating an Organisational Chart.srt | 7.56 KB | ||
| 10.1 Practical Example - completed.pptx | 1.24 MB | ||
| 10.2 List of executives.png | 62.91 KB | ||
| 10.3 Practical Example.pptx | 1.24 MB | ||
| 11. COURSE CHALLENGE - Part 4.mp4 | 44.06 MB | ||
| 11. COURSE CHALLENGE - Part 4.srt | 3.52 KB | ||
| 11.1 Sending Files with Dropbox - YouTube Tutorial.html | 104 B | ||
| 11.2 4. Course Challenge.pptx | 1.13 MB | ||
| 11.3 4. Course Challenge - Tasks.pdf | 283.02 KB | ||
| 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 | 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 | 1.22 MB | ||
| 4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4 | 8.28 MB | ||
| 4. Edit Points - Learn How to Customize PowerPoint Shapes.srt | 2.27 KB | ||
| 4.1 Edit Points.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 | 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 | 1.22 MB | ||
| 7. Nudge Objects.mp4 | 4.39 MB | ||
| 7. Nudge Objects.srt | 1.37 KB | ||
| 7.1 Nudge objects.pptx | 1.22 MB | ||
| 8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 | 20.96 MB | ||
| 8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt | 4.2 KB | ||
| 8.1 Smart Art.pptx | 1.22 MB | ||
| 9. Creating Eye-Catching Text Effects in PowerPoint.mp4 | 12.4 MB | ||
| 9. Creating Eye-Catching Text Effects in PowerPoint.srt | 2.4 KB | ||
| 9.1 Text effects.pptx | 1.22 MB | ||
| 46. Next Steps | |||
| 1. Next Steps.html | 4.18 KB | ||
| 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions | |||
| 1. Key Excel Functions IF.mp4 | 16.66 MB | ||
| 1. Key Excel Functions IF.srt | 2.95 KB | ||
| 1.1 Functions - English to Portuguese.pdf | 146.09 KB | ||
| 1.2 Functions - English to German.pdf | 102.32 KB | ||
| 1.3 37. IF-function-Lecture-after.xlsm | 17.94 KB | ||
| 1.4 Functions - English to Spanish.pdf | 102.37 KB | ||
| 1.5 37. IF-function--Lecture-before.xlsm | 17 KB | ||
| 10. Working with Text in Excel.mp4 | 16.02 MB | ||
| 10. Working with Text in Excel.srt | 3.08 KB | ||
| 10.1 43. Work-with-text-Lecture-after.xlsx | 10.91 KB | ||
| 10.2 43. Work-with-text-Lecture-before.xlsx | 10.33 KB | ||
| 11. Find the Highest and Lowest Values in a Range Max & Min.mp4 | 12.57 MB | ||
| 11. Find the Highest and Lowest Values in a Range Max & Min.srt | 1.06 KB | ||
| 11.1 44. Max-min-Lecture - Unsolved.xlsx | 8.95 KB | ||
| 11.2 Excel-Functions.pdf | 3.19 MB | ||
| 11.3 44. Max-min-Lecture - Solved.xlsx | 9.23 KB | ||
| 11.4 44. Excel-functions.xlsx | 971.02 KB | ||
| 11.5 44. MIN-MAX-Exercise - Unsolved.xlsx | 14.39 KB | ||
| 11.6 44. MIN-MAX-Exercise - Solved.xlsx | 14.8 KB | ||
| 12. = and + are Interchangeable When You Start Typing a Formula.mp4 | 5.8 MB | ||
| 12. = and + are Interchangeable When You Start Typing a Formula.srt | 974 B | ||
| 12.1 45. Show-that-and-are-interchangeable-Lecture-before.xlsm | 17.01 KB | ||
| 12.2 45. Show-that-and-are-interchangeable-Lecture-after.xlsm | 17.04 KB | ||
| 13. Use ROUND in Your Financial Models.mp4 | 8.83 MB | ||
| 13. Use ROUND in Your Financial Models.srt | 1.2 KB | ||
| 13.1 51. Round-Exercise - Solved.xlsx | 11.71 KB | ||
| 13.2 51. Round-Exercise - Unsolved.xlsx | 11.34 KB | ||
| 13.3 51. Excel-functions-Lecture.xlsx | 889.91 KB | ||
| 13.4 Excel-Functions.pdf | 3.18 MB | ||
| 14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 | 60.26 MB | ||
| 14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.srt | 8.95 KB | ||
| 14.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx | 11.13 KB | ||
| 14.2 47. Vlookup-Hlookup-Exercise - Solved.xlsx | 13.68 KB | ||
| 14.3 Excel-Functions.pdf | 3.19 MB | ||
| 14.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx | 11.95 KB | ||
| 14.5 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx | 10.74 KB | ||
| 15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 | 102.53 MB | ||
| 15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt | 8.59 KB | ||
| 15.1 48. Index-Match-Exercise - Solved.xlsx | 12.08 KB | ||
| 15.2 Excel-Functions.pdf | 3.19 MB | ||
| 15.3 48. Index-Match-Lecture - Solved.xlsx | 11.7 KB | ||
| 15.4 48. Index-Match-Lecture - Unsolved.xlsx | 11.29 KB | ||
| 15.5 48. Index-Match-Exercise - Unsolved.xlsx | 11.59 KB | ||
| 16. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html | 147 B | ||
| 17. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 | 20.08 MB | ||
| 17. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt | 2.2 KB | ||
| 17.1 54. Iferror - Lecture - Unsolved.xlsm | 897.26 KB | ||
| 17.2 Excel-Functions.pdf | 3.18 MB | ||
| 17.3 54. Iferror - Lecture - Solved.xlsm | 896.43 KB | ||
| 17.4 54. Iferror-Exercise - Solved.xlsx | 15.37 KB | ||
| 17.5 54. Iferror-Exercise - Unsolved.xlsx | 14.26 KB | ||
| 18. A Useful Tool for Financial Analysis - The RANK Function.mp4 | 23.25 MB | ||
| 18. A Useful Tool for Financial Analysis - The RANK Function.srt | 2.86 KB | ||
| 18.1 50. Rank-function-Lecture-before.xlsx | 12.27 KB | ||
| 18.2 50. Rank-function-Lecture-after.xlsx | 12.61 KB | ||
| 19. Create Flexible Financial Models with CHOOSE.mp4 | 33.02 MB | ||
| 19. Create Flexible Financial Models with CHOOSE.srt | 2.76 KB | ||
| 19.1 51. Choose-Lecture - Unsolved.xlsx | 9.33 KB | ||
| 19.2 Excel-Functions.pdf | 3.18 MB | ||
| 19.3 51. Choose-Lecture - Solved.xlsx | 9.69 KB | ||
| 19.4 51. Choose-Exercise-Solved.xlsx | 11.73 KB | ||
| 19.5 51. Choose-Exercise - Unsolved.xlsx | 11.32 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 | 46.89 KB | ||
| 20. Goal Seek Will Help You Find the Result You Are Looking For.mp4 | 26.68 MB | ||
| 20. Goal Seek Will Help You Find the Result You Are Looking For.srt | 2.73 KB | ||
| 20.1 Excel-Functions.pdf | 3.19 MB | ||
| 20.2 57. Goal-Seek-Lecture - Unsolved.xlsx | 9.15 KB | ||
| 20.3 57. Goal-Seek-Exercise-Solved.xlsx | 16.21 KB | ||
| 20.4 57. Goal-Seek-Lecture - Solved.xlsx | 9.17 KB | ||
| 20.5 57. Goal-Seek-Exercise - Unsolved.xlsx | 16.09 KB | ||
| 21. Goal Seek Will Help You Find the Result You Are Looking For.html | 147 B | ||
| 22. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 | 43.77 MB | ||
| 22. Perform Sensitivity Analysis with Excel's Data Tables Functionality.srt | 5.23 KB | ||
| 22.1 58. Sensitivity analysis - Lecture - Unsolved.xlsm | 897.09 KB | ||
| 22.2 58.Sensitivity-analysis-Exercise-Solved.xlsx | 62.28 KB | ||
| 22.3 58. Sensitivity analysis - Lecture - Solved.xlsm | 897.3 KB | ||
| 22.4 58.Sensitivity-analysis-Exercise_Unsolved.xlsx | 61.9 KB | ||
| 23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html | 147 B | ||
| 24. Quiz Number 2.html | 147 B | ||
| 3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4 | 30.69 MB | ||
| 3. Key Excel Functions SUM, SUMIF, SUMIFS.srt | 5.15 KB | ||
| 3.1 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx | 12.93 KB | ||
| 3.2 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx | 13.01 KB | ||
| 3.3 Excel-Functions.pdf | 3.18 MB | ||
| 3.4 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx | 14.84 KB | ||
| 3.5 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx | 14.46 KB | ||
| 4. A Helpful Consideration.html | 1.43 KB | ||
| 5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 | 51.3 MB | ||
| 5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt | 4.54 KB | ||
| 5.1 Lecture-Count-Countif-Countifs-Solved.xlsx | 11.68 KB | ||
| 5.2 Excel-Functions.pdf | 3.18 MB | ||
| 5.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx | 11.29 KB | ||
| 5.4 05 38 Counts Exercise & Text.xlsx | 15.66 KB | ||
| 5.5 05 38 Counts Solved.xlsx | 16.05 KB | ||
| 6. Key Excel Functions AVERAGE & AVERAGEIF.mp4 | 24.85 MB | ||
| 6. Key Excel Functions AVERAGE & AVERAGEIF.srt | 2.39 KB | ||
| 6.1 41. Average-AverageIF-Exercise - Unsolved.xlsx | 14.6 KB | ||
| 6.2 Excel-Functions.pdf | 3.19 MB | ||
| 6.3 41. Average-Averageif- Lecture - Unsolved.xlsx | 9.03 KB | ||
| 6.4 41. Average-AverageIF-Exercise - Solved.xlsx | 15.02 KB | ||
| 6.5 41. Average-Averageif- Lecture - Solved.xlsx | 9.4 KB | ||
| 7. Key Excel Functions Average & Averageif.html | 147 B | ||
| 8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 | 50.21 MB | ||
| 8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.srt | 4.91 KB | ||
| 8.1 47. Text functions - Exercise - Solved.xlsx | 12.24 KB | ||
| 8.2 47. Text functions - Exercise - Unsolved.xlsx | 11.71 KB | ||
| 8.3 47. Text-Functions- Lecture - Solved.xlsx | 11.1 KB | ||
| 8.4 47. Text-Functions- Lecture - Unsolved.xlsx | 10.6 KB | ||
| 9. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html | 147 B | ||
| 6. Microsoft Excel - Financial Functions in Excel | |||
| 1. Discounting Cash Flows in Microsoft Excel.mp4 | 45.69 MB | ||
| 1. Discounting Cash Flows in Microsoft Excel.srt | 7.18 KB | ||
| 1.1 54. FV and PV-Lecture.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 | 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 | 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 | 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. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 | 49.66 MB | ||
| 10. Using INDEX & MATCH as a Substitute for VLOOKUP.srt | 4.25 KB | ||
| 10.1 66. Index Match_before.xlsm | 41.02 KB | ||
| 10.2 66. Index Match-Lecture-after.xlsm | 13.85 MB | ||
| 11. The Mapping Exercise.mp4 | 21.62 MB | ||
| 11. The Mapping Exercise.srt | 2.04 KB | ||
| 11.1 Mapping-exercise-explained.pdf | 243.03 KB | ||
| 11.2 67. Mapping-Lecture-after.xlsm | 50.5 KB | ||
| 11.3 67. Mapping-Lecture-before.xlsm | 50.55 KB | ||
| 12. Mapping the Rows in the Database Sheet.mp4 | 38.52 MB | ||
| 12. Mapping the Rows in the Database Sheet.srt | 6.7 KB | ||
| 12.1 68. Mapping-Lecture-after.xlsm | 50.5 KB | ||
| 12.2 Mapping-exercise-explained.pdf | 243.03 KB | ||
| 12.3 68. Mapping-Lecture-before.xlsm | 50.55 KB | ||
| 13. Building the Structure of the P&L Sheet.mp4 | 20.87 MB | ||
| 13. Building the Structure of the P&L Sheet.srt | 2.34 KB | ||
| 13.1 69. Building a P&L-Lecture-before.xlsm | 50.24 KB | ||
| 13.2 69. Building a P&L-Lecture-after.xlsm | 51.83 KB | ||
| 14. A Practical Example of Professional Formatting in Excel.mp4 | 25.43 MB | ||
| 14. A Practical Example of Professional Formatting in Excel.srt | 3.41 KB | ||
| 14.1 70. Formatting a P&L-Lecture-before.xlsm | 51.84 KB | ||
| 14.2 70 Formatting the P&L-Lecture-after.xlsm | 51.96 KB | ||
| 15. Populating the P&L Sheet with SUMIF.mp4 | 30.23 MB | ||
| 15. Populating the P&L Sheet with SUMIF.srt | 3 KB | ||
| 15.1 71. Formatting the P&L-Lecture-before.xlsm | 52 KB | ||
| 15.2 71. Formatting the P&L-Lecture-after.xlsm | 53.51 KB | ||
| 16. Learn How to Find Mistakes with COUNTIF.mp4 | 27.85 MB | ||
| 16. Learn How to Find Mistakes with COUNTIF.srt | 2.8 KB | ||
| 16.1 72. Countif-Lecture-before.xlsm | 53.51 KB | ||
| 16.2 72. Countif-Lecture-after.xlsm | 54.78 KB | ||
| 17. Calculating Growth Rates in Excel.mp4 | 29.99 MB | ||
| 17. Calculating Growth Rates in Excel.srt | 3.31 KB | ||
| 17.1 73. Adding % variations-Lecture-after.xlsm | 56.51 KB | ||
| 17.2 73. Adding % variations-Lecture-before.xlsm | 54.78 KB | ||
| 17.3 Y-o-Y Function explanation.pdf | 164.92 KB | ||
| 18. Quiz Number 3.html | 147 B | ||
| 2. What You Will See Next.mp4 | 10.21 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 | 43.03 KB | ||
| 4. Ordering the Source Worksheet.mp4 | 26.57 MB | ||
| 4. Ordering the Source Worksheet.srt | 2.52 KB | ||
| 4.1 61. Order a worksheet_before.xlsm | 43.08 KB | ||
| 4.2 61. Order a worksheet_after.xlsm | 41.01 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_before.xlsm | 41.01 KB | ||
| 5.2 62. Creating a code_after.xlsm | 41.73 KB | ||
| 6. Learn How to Create a Database.mp4 | 20.75 MB | ||
| 6. Learn How to Create a Database.srt | 2.13 KB | ||
| 6.1 63. Creating a database_before.xlsm | 41.73 KB | ||
| 6.2 63. Creating a database_after.xlsm | 39.39 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 | 44.45 KB | ||
| 7.2 64. Vlookup_before.xlsm | 39.5 KB | ||
| 8. Using SUMIF to Complete the Database Sheet.mp4 | 47.94 MB | ||
| 8. Using SUMIF to Complete the Database Sheet.srt | 4.4 KB | ||
| 8.1 65. Sumif_before.xlsm | 44.45 KB | ||
| 8.2 65. Sumif_after.xlsm | 49.53 KB | ||
| 9. FAQ Why Net income should be 0.html | 1.28 KB | ||
| 8. Microsoft Excel - Building Professional Charts in Excel | |||
| 1. Introduction to Excel Charts.mp4 | 20.5 MB | ||
| 1. Introduction to Excel Charts.srt | 1.35 KB | ||
| 2. Beginner's Guide to Inserting Charts in Excel.mp4 | 36.48 MB | ||
| 2. Beginner's Guide to Inserting Charts in Excel.srt | 2.76 KB | ||
| 2.1 75. Inserting-Charts-Lecture.xlsm | 11.45 MB | ||
| 3. Modifying Excel Charts - The Easy Way.mp4 | 42.24 MB | ||
| 3. Modifying Excel Charts - The Easy Way.srt | 3.22 KB | ||
| 3.1 76. Formatting-a-Chart-Lecture.xlsm | 11.46 MB | ||
| 4. Making Your Excel Charts Sexier - Proven Tips.mp4 | 53.37 MB | ||
| 4. Making Your Excel Charts Sexier - Proven Tips.srt | 3.83 KB | ||
| 4.1 77. Modifying-a-Chart-Lecture.xlsm | 11.41 MB | ||
| 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 | 22.17 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 | 13.1 KB | ||
| 6. New Ways to Visualize Your Data - Treemap Charts.mp4 | 19.04 MB | ||
| 6. New Ways to Visualize Your Data - Treemap Charts.srt | 1.75 KB | ||
| 6.1 79. Treemap-Charts-Lecture.xlsx | 12.62 KB | ||
| 7. How to Represent Trends with Sparklines.mp4 | 43.97 MB | ||
| 7. How to Represent Trends with Sparklines.srt | 4.51 KB | ||
| 7.1 80. Sparklines-Lecture.xlsx | 9.59 KB | ||
| 9. Microsoft Excel - Creating Complete Professional Charts from Scratch | |||
| 1. Introduction.mp4 | 6.21 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 | 11.5 MB | ||
| 2.2 82. Column stacked chart-Lecture-before.xlsm | 11.51 MB | ||
| 3. Doughnut Chart.mp4 | 38.01 MB | ||
| 3. Doughnut Chart.srt | 5.44 KB | ||
| 3.1 83. Doughnut chart-Lecture-after.xlsm | 11.51 MB | ||
| 3.2 83. Doughnut chart-Lecture-before.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 | 11.52 MB | ||
| 4.2 84. Area chart-Lecture-after.xlsm | 11.52 MB | ||
| 5. Bridge Chart.mp4 | 52.08 MB | ||
| 5. Bridge Chart.srt | 7.61 KB | ||
| 5.1 85.Bridge-chart-Lecture-before.xlsm | 11.48 MB | ||
| 5.2 85. Bridge chart-Lecture-after.xlsm | 11.53 MB | ||
| Verify Files.txt | 1.02 KB | ||
| [FreeAllCourse.Com].url | 52 B | ||
| ▲ 1154 total files | |||
Description
The Complete Financial Analyst Course 2020 
Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!
For More Paid Udemy Courses Visit:
FreeAllCourse.Com
What you'll learn?
# Work comfortably with Microsoft Excel
# Format spreadsheets in a professional way
# Be much faster carrying out regular tasks
# Create professional charts in Microsoft Excel
# Work with large amounts of data without difficulty
# Understand Accounting and Bookkeeping principles
# Build a company’s P&L from scratch
# Build a company’s Balance Sheet from scratch
# Perform Financial Statement Analysis
# Understand the importance of timing in terms of revenue and cost recognition
# Calculate Liquidity, Solvency, Profitability, and Growth ratios in order to analyze a company’s performance
# Understand 10-K reports
# Assess whether a project is feasible through the Net Present Value Technique
# Calculate a complete loan schedule
# Understand the difference between variable and fixed interest rates
# Perform industry analysis
# Understand what drives a company’s value
# Know how to analyze a business
# Work comfortably with Microsoft PowerPoint
# Create professional company presentations in PowerPoint
# Become a successful Financial Analyst in no time – if you follow the course fully!
Description
Created by 365 Careers
Last updated 6/2020
Audio: English
Caption: English [Auto-generated]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 2 weeks | 18 | 6 | |
| 3.7 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 3.5 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 3 GB | freecoursewb | 2 weeks | 8 | 46 | |
|
Udemy - Enterprise Architecture Practitioner with the TOGAF Standard Posted by
freecoursewb in Other
|
2.9 GB | freecoursewb | 2 weeks | 5 | 47 |
All Comments