Udemy The Complete Financial Analyst Course 2020 | 00F2EDFC77CCF8475158139C7A23691032A3AFA5

Udemy The Complete Financial Analyst Course 2020

Name	Udemy-The.Complete.Financial.Analyst.Course.2020	DOWNLOAD Copy Link
Total Size	10.0 GB
Total Files	1115
Hash	00F2EDFC77CCF8475158139C7A23691032A3AFA5

/1. Welcome! Course Introduction/
1. What Does the Course Cover.mp4	82.0 MB
1. What Does the Course Cover.srt	8.0 KB
1.1 Financial Analyst - Course Curriculum.pdf.pdf	595.3 KB
2. Everything We Will Learn Has a Practical Application.mp4	26.9 MB
2. Everything We Will Learn Has a Practical Application.srt	4.2 KB
2.1 Quick win.xlsx.xlsx	10.0 KB
3. The Best Way to Take This Course.mp4	33.5 MB
3. The Best Way to Take This Course.srt	3.6 KB
4. Download All Course Materials.html	0.8 KB
4.1 Download all course materials.html	0.1 KB
/10. Microsoft Excel - Working with Pivot Tables in Excel/
1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4	15.8 MB
1. Pivot Tables - Excel's Dynamic and Interactive Tables.srt	2.4 KB
2. Creating a Pivot Table Choosing Row and Column Parameters.mp4	40.8 MB
2. Creating a Pivot Table Choosing Row and Column Parameters.srt	4.8 KB
2.1 87. Creating-a-Pivot-Table-Lecture.xlsx.xlsx	1.5 MB
3. Design the Layout and Format of Your Pivot Tables.mp4	22.6 MB
3. Design the Layout and Format of Your Pivot Tables.srt	2.6 KB
3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx.xlsx	1.5 MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4	48.2 MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.srt	5.6 KB
4.1 89. Working-with-Pivot-Tables-Lecture.xlsx.xlsx	2.0 MB
5. One of the Most Useful Excel Functions - GetPivotData.mp4	38.0 MB
5. One of the Most Useful Excel Functions - GetPivotData.srt	4.6 KB
5.1 90. GetPivotData-Lecture.xlsx.xlsx	2.0 MB
6. Welcome to the Future - Pivot Table Slicers.mp4	47.4 MB
6. Welcome to the Future - Pivot Table Slicers.srt	5.3 KB
6.1 91. Slicers-Lecture.xlsx.xlsx	2.0 MB
7. Introduction to the Course Challenge.mp4	13.8 MB
7. Introduction to the Course Challenge.srt	1.5 KB
8. COURSE CHALLENGE - Part 1.mp4	15.1 MB
8. COURSE CHALLENGE - Part 1.srt	1.8 KB
8.1 93. Course-Challenge - Before solutions.xlsx.xlsx	517.6 KB
/11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/
1. Introduction to the Case Study.mp4	28.0 MB
1. Introduction to the Case Study.srt	2.9 KB
1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx	13.9 MB
10. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4	38.2 MB
10. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt	4.1 KB
10.1 103. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx	21.8 MB
11. Getting Fancy with Excel Slicers.mp4	37.6 MB
11. Getting Fancy with Excel Slicers.srt	4.1 KB
11.1 104. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx	23.9 MB
12. This is How the Report Can be Used in Practice by High-level Executives.mp4	42.8 MB
12. This is How the Report Can be Used in Practice by High-level Executives.srt	5.2 KB
12.1 105. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx	23.9 MB
2. Working with an SAP Data Extraction.mp4	41.1 MB
2. Working with an SAP Data Extraction.srt	4.6 KB
3. Preliminary Mapping of the Data Extraction.mp4	32.7 MB
3. Preliminary Mapping of the Data Extraction.srt	2.8 KB
3.1 96. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx	15.6 MB
4. Creating an Output Structure of the FMCG Model.mp4	23.2 MB
4. Creating an Output Structure of the FMCG Model.srt	3.3 KB
4.1 97. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx	15.6 MB
5. Improving the Layout and Appearance of the FMCG Report.mp4	28.5 MB
5. Improving the Layout and Appearance of the FMCG Report.srt	5.1 KB
5.1 98. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx	15.6 MB
6. Inserting Formulas and Automating Calculations.mp4	19.0 MB
6. Inserting Formulas and Automating Calculations.srt	42.5 MB
6.1 99. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx	15.6 MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4	22.8 MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt	2.5 KB
7.1 100. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx	21.8 MB
8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4	56.8 MB
8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.srt	7.9 KB
8.1 101. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx	21.8 MB
9. GETPIVOTDATA fix.mp4	14.3 MB
9. GETPIVOTDATA fix.srt	1.5 KB
/12. Modeling in Excel - Building a Complete 3-statement Model/
1. Introduction to the Exercise.mp4	38.4 MB
1. Introduction to the Exercise.srt	3.7 KB
1.1 Financial Modeling Notes.pdf.pdf	706.6 KB
1.2 106. Exerxise-before.xlsx.xlsx	19.2 KB
1.3 106. Exercise-after.xlsx.xlsx	33.5 KB
2. Let's Create a Mapping of Financials.mp4	32.2 MB
2. Let's Create a Mapping of Financials.srt	3.1 KB
2.1 107. Exercise - before.xlsx.xlsx	31.2 KB
2.2 107. Exercise - after.xlsx.xlsx	35.1 KB
3. Building an Output P&L Sheet.mp4	32.0 MB
3. Building an Output P&L Sheet.srt	4.4 KB
3.1 108. Exercise - before.xlsx.xlsx	33.1 KB
3.2 108. Exercise - after.xlsx.xlsx	42.5 KB
4. Filling in the Output P&L Sheet with Historical Financials.mp4	25.1 MB
4. Filling in the Output P&L Sheet with Historical Financials.srt	3.1 KB
4.1 109. Exersice - before.xlsx.xlsx	38.5 KB
4.2 109. Exersice - after.xlsx.xlsx	42.2 KB
5. Calculating Percentage Variances and Applying Conditional Formatting.mp4	28.5 MB
5. Calculating Percentage Variances and Applying Conditional Formatting.srt	3.5 KB
5.1 110. Exercise - after.xlsx.xlsx	42.7 KB
5.2 110. Exercise - before.xlsx.xlsx	40.2 KB
6. Building an Output Balance Sheet.mp4	30.9 MB
6. Building an Output Balance Sheet.srt	4.1 KB
6.1 111. Exercise - after.xlsx.xlsx	55.7 KB
6.2 111. Exercise - before.xlsx.xlsx	48.6 KB
7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.mp4	45.6 MB
7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.srt	5.8 KB
7.1 112. Exersise - after.xlsx.xlsx	58.5 KB
7.2 112. Exersice - before.xlsx.xlsx	51.0 KB
8. Adding the Forecast Period.mp4	33.7 MB
8. Adding the Forecast Period.srt	4.2 KB
8.1 113. Exersice - before.xlsx.xlsx	51.5 KB
8.2 113. Exersice - after.xlsx.xlsx	56.3 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	51.8 MB
1. Calculating Historical Percentage Ratios and Use INDEX and MATCH for Scenarios.srt	5.9 KB
1.1 114. Exercise - aft.xlsx.xlsx	56.3 KB
1.2 114. Exercise - bef.xlsx.xlsx	54.1 KB
2. Building a Flexible Model with CHOOSE & MATCH.mp4	16.8 MB
2. Building a Flexible Model with CHOOSE & MATCH.srt	1.8 KB
2.1 115. Exercise - after.xlsx.xlsx	56.0 KB
2.2 115. Exercise - before.xlsx.xlsx	54.4 KB
3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4	38.0 MB
3. Building a Flexible Model with VLOOKUP & COLUMNS.srt	3.7 KB
3.1 116. Exercise - before.xlsx.xlsx	54.4 KB
3.2 116. Exercise - after.xlsx.xlsx	56.4 KB
4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4	46.6 MB
4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt	5.8 KB
4.1 Working Capital Days.pdf.pdf	349.0 KB
4.2 Course notes - Building a financial model.pdf.pdf	589.0 KB
4.3 117. Exercise -after.xlsx.xlsx	58.0 KB
4.4 117. Exercise before.xlsx.xlsx	54.8 KB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4	32.0 MB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt	3.6 KB
5.1 118. Exercise - before.xlsx.xlsx	56.0 KB
5.2 118. Exercise - after.xlsx.xlsx	59.1 KB
/14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/
1. Building a Fixed Asset Roll Forward.mp4	42.9 MB
1. Building a Fixed Asset Roll Forward.srt	5.0 KB
1.1 119. Exercise - after.xlsx.xlsx	63.6 KB
1.2 119. Exercise - before.xlsx.xlsx	57.1 KB
2. Building a Financial Liabilities Schedule.mp4	49.9 MB
2. Building a Financial Liabilities Schedule.srt	6.3 KB
2.1 120. Exercise - after.xlsx.xlsx	69.2 KB
2.2 120. Exercise - before.xlsx.xlsx	60.3 KB
3. Building an Equity Schedule.mp4	38.3 MB
3. Building an Equity Schedule.srt	4.8 KB
3.1 121. Exercise - after.xlsx.xlsx	71.2 KB
3.2 121. Exercise - before.xlsx.xlsx	60.3 KB
4. Preparing a Cash Flow Structure.mp4	15.9 MB
4. Preparing a Cash Flow Structure.srt	2.5 KB
4.1 122. Exercise - before.xlsx.xlsx	67.2 KB
4.2 122. Exercise - after.xlsx.xlsx	72.0 KB
5. Calculating Cash Flows and Completing the Model.mp4	60.3 MB
5. Calculating Cash Flows and Completing the Model.srt	7.7 KB
5.1 123. Exercise - before.xlsx.xlsx	69.3 KB
5.2 123. Exercise - after.xlsx.xlsx	74.3 KB
/15. Accounting - Introduction to Accounting & Bookkeeping/
1. Accounting The Science Behind Financial Figures.mp4	34.5 MB
1. Accounting The Science Behind Financial Figures.srt	2.0 KB
1.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf	1.3 MB
2. What is Accounting and Why Do You Need It.mp4	67.1 MB
2. What is Accounting and Why Do You Need It.srt	7.0 KB
2.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf	1.2 MB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4	28.0 MB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.srt	3.7 KB
4. An Introduction to Financial Accounting.mp4	33.5 MB
4. An Introduction to Financial Accounting.srt	3.9 KB
4.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf	1.2 MB
5. Quiz Number 3.html	0.1 KB
/16. Accounting - Types of Revenues, Costs, Assets, and Liabilities/
1. The Different Types of Accounting Standards.mp4	22.7 MB
1. The Different Types of Accounting Standards.srt	3.5 KB
1.1 The Complete Financial Analyst Course - Financial items.pdf.pdf	911.4 KB
10. Types of Liabilities.mp4	28.8 MB
10. Types of Liabilities.srt	5.1 KB
11. Liability Categories - Practical Example.mp4	25.0 MB
11. Liability Categories - Practical Example.srt	3.5 KB
12. Equity.mp4	15.7 MB
12. Equity.srt	2.8 KB
13. Quiz Number 4.html	0.1 KB
2. The Three Financial Statements.mp4	12.4 MB
2. The Three Financial Statements.srt	2.7 KB
3. Types of Revenues.mp4	27.8 MB
3. Types of Revenues.srt	3.1 KB
4. Types of Revenues - Exercise.mp4	19.5 MB
4. Types of Revenues - Exercise.srt	2.6 KB
5. Types of Expenses.mp4	47.4 MB
5. Types of Expenses.srt	7.2 KB
6. Income Taxes.mp4	18.8 MB
6. Income Taxes.srt	2.4 KB
7. Depreciation & Amortization.mp4	42.1 MB
7. Depreciation & Amortization.srt	5.9 KB
8. Types of Assets.mp4	33.3 MB
8. Types of Assets.srt	4.7 KB
9. Asset Categories - Practical Example.mp4	30.5 MB
9. Asset Categories - Practical Example.srt	4.8 KB
9.1 P-G-Financial-Report.pdf.pdf	4.6 MB
/17. Accounting - Revenue Recognition/
1. Accrual Accounting.mp4	14.3 MB
1. Accrual Accounting.srt	2.2 KB
1.1 The Complete Financial Analyst Course - Revenue recognition.pdf.pdf	506.2 KB
2. Revenue Recognition Criteria - Technical.mp4	33.8 MB
2. Revenue Recognition Criteria - Technical.srt	5.0 KB
3. Potential Conflicts of Interest When Recognizing Revenue.mp4	19.7 MB
3. Potential Conflicts of Interest When Recognizing Revenue.srt	2.6 KB
4. A Practical Example.mp4	41.4 MB
4. A Practical Example.srt	7.4 KB
/18. Accounting - Cost Recognition/
1. Technical Aspects of Cost Recognition.mp4	29.0 MB
1. Technical Aspects of Cost Recognition.srt	3.4 KB
2. The Two Types of Income Statement Formats.mp4	7.6 MB
2. The Two Types of Income Statement Formats.srt	1.6 KB
/19. Accounting - Understanding the Big Picture Why, What, When, and How Much/
1. The Revenue Recognition Principle - Why Is It So Important.mp4	25.6 MB
1. The Revenue Recognition Principle - Why Is It So Important.srt	3.7 KB
2. The Expense Recognition Principle - When to Recognize Expenses.mp4	26.5 MB
2. The Expense Recognition Principle - When to Recognize Expenses.srt	3.1 KB
/2. Microsoft Excel - Quick Introduction/
1. Microsoft Excel The World's #1 Office Software.mp4	23.1 MB
1. Microsoft Excel The World's #1 Office Software.srt	1.3 KB
1.1 Introduction to Excel's basic features.pdf.pdf	2.4 MB
10. A Beginner's Introduction to Excel Functions.mp4	23.0 MB
10. A Beginner's Introduction to Excel Functions.srt	4.5 KB
10.1 6. Functions- Lecture - Unsolved.xlsx.xlsx	9.5 KB
10.2 6. Functions-Exercise - Unsolved.xlsx.xlsx	13.6 KB
10.3 6. Functions- Exercise - Solved.xlsx.xlsx	83.0 KB
10.4 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
10.5 6. Functions - Lecture -Solved.xlsx.xlsx	9.6 KB
11. Work Efficiently by Using Cut, Copy, and Paste.mp4	15.2 MB
11. Work Efficiently by Using Cut, Copy, and Paste.srt	2.7 KB
11.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx	12.9 KB
11.2 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
11.3 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx	11.6 KB
12. Work Efficiently by Using Cut, Copy, and Paste.html	0.1 KB
13. Pasting Values, Formulas and Formats with Paste Special.mp4	11.5 MB
13. Pasting Values, Formulas and Formats with Paste Special.srt	1.4 KB
13.1 8. Paste-Special-Solved.xlsx.xlsx	13.8 KB
13.2 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
13.3 8. Paste-Special-Exercise-Text.xlsx.xlsx	13.8 KB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4	23.9 MB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.srt	5.0 KB
2.1 1. Introduction to Excel.pdf.pdf	2.4 MB
2.2 1. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx	10.7 KB
2.3 1. Overview-of-Excel-Exercise-Solved.xlsx.xlsx	11.1 KB
3. Data Entry Techniques in Excel.mp4	18.2 MB
3. Data Entry Techniques in Excel.srt	4.1 KB
3.1 2. Data-Entry-Exercise - Unsolved.xlsx.xlsx	11.2 KB
3.2 2. Data-Entry - Lecture.xlsx.xlsx	8.3 KB
3.3 2. Data-Entry- Exercise -Solved.xlsx.xlsx	33.5 KB
4. How to Make Your Spreadsheets Look Professional.mp4	47.0 MB
4. How to Make Your Spreadsheets Look Professional.srt	7.3 KB
4.1 3. Formatting-Exercise - Unsolved.xlsx.xlsx	11.9 KB
4.2 3. Formatting- Lecture - Unsolved.xlsx.xlsx	9.1 KB
4.3 3. Formatting - Lecture - Solved.xlsx.xlsx	10.1 KB
4.4 3. Formatting- Exercise - Solved.xlsx.xlsx	11.9 KB
5. Data Entry Techniques in Excel.html	0.1 KB
6. Inserting, Deleting, and Modifying Rows & Columns.mp4	13.0 MB
6. Inserting, Deleting, and Modifying Rows & Columns.srt	2.4 KB
6.1 4. Basic-Manipulations - Exercise - Solved.xlsx.xlsx	33.2 KB
6.2 4. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx	11.3 KB
6.3 4. Data Entry - Lecture.xlsx.xlsx	8.3 KB
7. Inserting, Deleting, and Modifying Rows & Columns.html	0.1 KB
8. Excel Formulas for Beginners.mp4	15.1 MB
8. Excel Formulas for Beginners.srt	3.6 KB
8.1 5. Formulas- Lecture - Solved.xlsx.xlsx	9.6 KB
8.2 5. Formulas- Exercise - Solved.xlsx.xlsx	82.1 KB
8.3 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
8.4 5. Formulas - Exercise - Unsolved.xlsx.xlsx	12.0 KB
8.5 5. Formulas- Lecture - Unsolved.xlsx.xlsx	9.5 KB
9. Excel Formulas for Beginners.html	0.1 KB
/20. Accounting - The Core Principles of Accounting/
1. The Accounting Equation and Its Importance.mp4	25.7 MB
1. The Accounting Equation and Its Importance.srt	2.6 KB
2. Elements of the Accounting System General Ledger.mp4	16.9 MB
2. Elements of the Accounting System General Ledger.srt	2.1 KB
3. T-Accounts The Best Way to Understand Debits and Credits.mp4	22.4 MB
3. T-Accounts The Best Way to Understand Debits and Credits.srt	5.8 KB
4. P&L T-Accounts.mp4	14.0 MB
4. P&L T-Accounts.srt	3.8 KB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4	25.3 MB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.srt	7.2 KB
6. Quiz Number 5.html	0.1 KB
/21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4	71.7 MB
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt	13.0 KB
1.1 Exercise - Before Solutions.xlsx.xlsx	17.5 KB
1.2 Exercise Part One.xlsx.xlsx	17.9 KB
1.3 Practical Exercise - List of transactions.pdf.pdf	186.9 KB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4	48.7 MB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt	9.8 KB
2.1 Exercise - Part Two.xlsx.xlsx	20.6 KB
2.2 Practical Exercise - List of transactions.pdf.pdf	186.9 KB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4	55.9 MB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt	9.0 KB
3.1 Practical Exercise - List of transactions.pdf.pdf	186.9 KB
3.2 Exercise - Part Three.xlsx.xlsx	19.8 KB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4	61.8 MB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt	8.5 KB
4.1 Practical Exercise - List of transactions.pdf.pdf	186.9 KB
4.2 Exercise - Part Four.xlsx.xlsx	21.2 KB
/22. Accounting - The Importance of Timing/
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4	13.9 MB
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.srt	1.6 KB
2. Timing of Income Principles of Revenue Recognition.mp4	28.2 MB
2. Timing of Income Principles of Revenue Recognition.srt	7.7 KB
3. Timing of Expenses Principles of Cost Recognition.mp4	16.6 MB
3. Timing of Expenses Principles of Cost Recognition.srt	4.1 KB
4. The Four Type of Accruals Arising in Accounting Transactions.mp4	52.0 MB
4. The Four Type of Accruals Arising in Accounting Transactions.srt	6.3 KB
5. Quiz Number 6.html	0.1 KB
/23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4	29.0 MB
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt	3.7 KB
2. The Three Parts of Cash Flow Statements Explained.mp4	21.0 MB
2. The Three Parts of Cash Flow Statements Explained.srt	2.9 KB
3. Cash Flow Computations - The Direct Method.mp4	20.7 MB
3. Cash Flow Computations - The Direct Method.srt	2.8 KB
4. Cash Flow Computations - The Indirect Method.mp4	32.9 MB
4. Cash Flow Computations - The Indirect Method.srt	4.9 KB
5. Calculating Cash Flow in Practice A Complete Example.mp4	53.1 MB
5. Calculating Cash Flow in Practice A Complete Example.srt	8.8 KB
5.1 Cash-Flow.xlsx.xlsx	56.7 KB
/24. Advanced Accounting - Trade Receivables/
1. Why a Company Needs to Pay Attention to Trade Receivables.mp4	26.4 MB
1. Why a Company Needs to Pay Attention to Trade Receivables.srt	3.6 KB
1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf.pdf	723.5 KB
2. What If Clients Do Not Pay on Time.mp4	27.8 MB
2. What If Clients Do Not Pay on Time.srt	4.4 KB
3. How to Handle Non-paying Customers A Case-study.mp4	26.2 MB
3. How to Handle Non-paying Customers A Case-study.srt	3.5 KB
4. A Technique to Collect Trade Receivables Sooner.mp4	16.2 MB
4. A Technique to Collect Trade Receivables Sooner.srt	2.5 KB
/25. Advanced Accounting - Inventory/
1. The Different Types of Inventory We Can Have.mp4	28.0 MB
1. The Different Types of Inventory We Can Have.srt	3.6 KB
2. The Connection Between Cost of Goods Sold and Inventory.mp4	18.1 MB
2. The Connection Between Cost of Goods Sold and Inventory.srt	3.5 KB
3. Cost Flow Methods.mp4	30.1 MB
3. Cost Flow Methods.srt	6.1 KB
4. Cost Flow Methods - a Practical Exercise.mp4	7.1 MB
4. Cost Flow Methods - a Practical Exercise.srt	1.4 KB
4.1 Inventory Cost Flow Methods_solved.xlsx.xlsx	12.7 KB
4.2 Inventory Cost Flow Methods_unsolved.xlsx.xlsx	11.8 KB
4.3 Inventory Cost Flow Methods – with solutions.pptx.pptx	179.2 KB
4.4 Inventory Cost Flow Methods.pptx.pptx	172.6 KB
/26. Advanced Accounting - Fixed Assets/
1. The Different Types of Fixed Assets.mp4	21.7 MB
1. The Different Types of Fixed Assets.srt	4.1 KB
2. Capitalizing Interest Expenses.mp4	8.0 MB
2. Capitalizing Interest Expenses.srt	2.6 KB
3. Fair Value Accounting.mp4	25.4 MB
3. Fair Value Accounting.srt	3.3 KB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4	37.0 MB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.srt	5.4 KB
5. The Revaluation Model.mp4	40.9 MB
5. The Revaluation Model.srt	6.5 KB
6. The Revaluation Model - Practical Exercise.mp4	39.8 MB
6. The Revaluation Model - Practical Exercise.srt	6.4 KB
7. Intangible Assets Created Internally.mp4	18.6 MB
7. Intangible Assets Created Internally.srt	2.7 KB
/27. Advanced Accounting - Trade Payables/
1. How We Account for Trade Payables.mp4	23.6 MB
1. How We Account for Trade Payables.srt	3.6 KB
2. What Is the Difference Between Accounts Payable and Notes Payable.mp4	11.4 MB
2. What Is the Difference Between Accounts Payable and Notes Payable.srt	1.8 KB
3. Why Use E-invoicing.mp4	27.2 MB
3. Why Use E-invoicing.srt	3.7 KB
/28. Advanced Accounting - Financial Liabilities/
1. The Difference Between Debt and Equity.mp4	15.5 MB
1. The Difference Between Debt and Equity.srt	2.9 KB
2. Amortizing a Loan.mp4	21.6 MB
2. Amortizing a Loan.srt	3.6 KB
3. Debt Covenants.mp4	27.0 MB
3. Debt Covenants.srt	4.4 KB
4. Debt Covenants - A Practical Example.mp4	14.3 MB
4. Debt Covenants - A Practical Example.srt	2.3 KB
/29. Advanced Accounting - Leasing Liabilties/
1. The Reason Companies Lease Assets.mp4	11.7 MB
1. The Reason Companies Lease Assets.srt	1.7 KB
2. Solving a Complete Leasing Exercise.mp4	40.0 MB
2. Solving a Complete Leasing Exercise.srt	5.9 KB
2.1 Leasing exercises.pdf.pdf	159.9 KB
2.2 Leasing-Exercise-2-Solved.xlsx.xlsx	11.4 KB
2.3 Leasing Exercise 2 - Unsolved.xlsx.xlsx	9.9 KB
/3. Microsoft Excel - Useful Tools/
1. Inserting a Line Break with Alt + Enter.mp4	6.5 MB
1. Inserting a Line Break with Alt + Enter.srt	1.1 KB
1.1 9. Alt-Enter-Exercise - Solved.xlsx.xlsx	11.7 KB
1.2 9. Alt-Enter- Lecture - Unsolved.xlsx.xlsx	9.9 KB
1.3 9. Alt-Enter- Lecture - Solved.xlsx.xlsx	9.9 KB
1.4 9. Alt-Enter-Exercise - Unsolved.xlsx.xlsx	11.4 KB
2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4	14.5 MB
2. Do More with Your Sales Data with Excel's Text to Columns Feature.srt	2.5 KB
2.1 10. Text-to-columns-Lecture - Solved.xlsx.xlsx	10.1 KB
2.2 10. Text-to-Columns-Exercise - Solved.xlsx.xlsx	11.6 KB
2.3 10. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx	10.8 KB
2.4 10. Text-to-columns-Lecture - Unsolved.xlsx.xlsx	10.0 KB
3. Do More with Your Sales Data with Excel's Text to Columns Feature.html	0.1 KB
4. Create Easily Printable Excel Documents.mp4	9.6 MB
4. Create Easily Printable Excel Documents.srt	1.5 KB
4.1 11. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx	11.7 KB
4.2 11. Set-Print-Area-Lecture - Solved.xlsx.xlsx	11.5 KB
4.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4	4.0 MB
5. How to Wrap Text in Excel and Adjust a Cell's Size.srt	0.9 KB
5.1 12. Wrap-text-Lecture - Unsolved.xlsx.xlsx	9.8 KB
5.2 12. Wrap-text-Lecture - Solved.xlsx.xlsx	9.8 KB
5.3 12. Wrap-Text-Exercise - Unsolved.xlsx.xlsx	10.4 KB
5.4 12. Wrap-Text-Exercise - Solved.xlsx.xlsx	10.4 KB
6. Insert Hyperlinks into Excel Spreadsheets.mp4	8.6 MB
6. Insert Hyperlinks into Excel Spreadsheets.srt	1.4 KB
6.1 13. Hyperlinks-Exercise - Solved.xlsx.xlsx	140.4 KB
6.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
6.3 13. Hyperlinks-Exercise - Unsolved.xlsx.xlsx	140.2 KB
7. Using Excel's Freeze Panes to Handle Large Datasets.mp4	16.0 MB
7. Using Excel's Freeze Panes to Handle Large Datasets.srt	1.5 KB
7.1 14. Freeze-Panes-Lecture - Solved.xlsx.xlsx	659.4 KB
7.2 14. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx	659.3 KB
7.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4	9.6 MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.srt	1.1 KB
8.1 Useful Tips & Tools.pdf.pdf	3.5 MB
9. A Quick Introduction to Excel's Pivot Tables.mp4	26.6 MB
9. A Quick Introduction to Excel's Pivot Tables.srt	2.7 KB
9.1 21. Pivot tables - Lecture - Unsolved.xlsm.xlsm	704.3 KB
9.2 21. Pivot tables - Lecture - Solved.xlsm.xlsm	918.8 KB
9.3 21. Pivot Tables - Exercise - Solved.xlsx.xlsx	195.0 KB
9.4 21. Pivot Tables - Exercise - Unsolved.xlsx.xlsx	155.8 KB
9.5 Useful-Tips-Tools.pdf.pdf	3.5 MB
/30. Advanced Accounting - Using Leverage/
1. What is Leverage and Why Companies Use Financial Leverage.mp4	60.2 MB
1. What is Leverage and Why Companies Use Financial Leverage.srt	5.6 KB
2. The Implications of Using Excessive Leverage.mp4	36.2 MB
2. The Implications of Using Excessive Leverage.srt	4.3 KB
/31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/
1. The Different Types of Equity.mp4	57.9 MB
1. The Different Types of Equity.srt	5.1 KB
2. Raising Equity in Different Stages of a Company's Lifecycle.mp4	75.4 MB
2. Raising Equity in Different Stages of a Company's Lifecycle.srt	8.0 KB
3. The Types of Dividends Companies Pay to Shareholders.mp4	47.1 MB
3. The Types of Dividends Companies Pay to Shareholders.srt	4.6 KB
4. Dividend Payments - a Timeline.mp4	37.9 MB
4. Dividend Payments - a Timeline.srt	4.0 KB
5. What Are Share Repurchases and Why Companies Do Them.mp4	46.0 MB
5. What Are Share Repurchases and Why Companies Do Them.srt	4.2 KB
6. The Idea Behind Stock Splits.mp4	37.8 MB
6. The Idea Behind Stock Splits.srt	4.0 KB
/32. Financial Statement Analysis - An Introduction/
1. What is a 10-K Report and Why Is It important for Investors.mp4	28.7 MB
1. What is a 10-K Report and Why Is It important for Investors.srt	3.1 KB
2. Finding, Downloading and Going Through the Annual Report of P&G.mp4	78.5 MB
2. Finding, Downloading and Going Through the Annual Report of P&G.srt	8.1 KB
2.1 P&G Financial Report.pdf.pdf	4.6 MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4	27.1 MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.srt	3.1 KB
4. Indispensable Tools for Financial Statement Analysis.mp4	16.1 MB
4. Indispensable Tools for Financial Statement Analysis.srt	1.7 KB
5. Quiz Number 7.html	0.1 KB
/33. Financial Statement Analysis - Subtleties/
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4	19.3 MB
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt	2.5 KB
1.1 Financial Statement Analysis - Notes.pdf.pdf	791.4 KB
2. First Steps in Financial Statement Analysis.mp4	33.6 MB
2. First Steps in Financial Statement Analysis.srt	4.1 KB
3. Horizontal vs. Vertical Financial Statement Analysis.mp4	29.6 MB
3. Horizontal vs. Vertical Financial Statement Analysis.srt	4.6 KB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4	12.4 MB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt	1.7 KB
4.1 Working Capital Days.pdf.pdf	349.0 KB
5. Using Accounting Ratios to Assess Business Performance.mp4	38.6 MB
5. Using Accounting Ratios to Assess Business Performance.srt	9.2 KB
6. Quiz Number 8.html	0.1 KB
/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	58.5 MB
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt	7.7 KB
1.1 P&G Financials.xlsx.xlsx	14.6 KB
1.2 P&G Financial Report.pdf.pdf	4.6 MB
1.3 P&G Financials_WithRatios.xlsx.xlsx	14.3 KB
1.4 P&G Financials_Before.xlsx.xlsx	13.1 KB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4	38.7 MB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt	5.1 KB
2.1 P&G Financials.xlsx.xlsx	14.6 KB
2.2 P&G Financial Report.pdf.pdf	4.6 MB
2.3 P&G Financials_Before.xlsx.xlsx	13.1 KB
2.4 P&G Financials_WithRatios.xlsx.xlsx	14.3 KB
3. COURSE CHALLENGE - Part 2.mp4	19.7 MB
3. COURSE CHALLENGE - Part 2.srt	2.2 KB
3.1 2. Course Challenge.xlsx.xlsx	642.7 KB
/35. Financial Statement Analysis - Tesla Exercise/
1. What You Will See Next In This Section.mp4	19.2 MB
1. What You Will See Next In This Section.srt	1.4 KB
2. How to Download Tesla's Historical Financials.mp4	15.1 MB
2. How to Download Tesla's Historical Financials.srt	2.9 KB
2.1 Tesla 2017.pdf.pdf	2.6 MB
2.2 Tesla 2015.pdf.pdf	1.4 MB
2.3 Tesla 2016.pdf.pdf	2.3 MB
2.4 Tesla 2018 Q2.pdf.pdf	650.3 KB
3. Calculating and Analyzing Growth and Profitability Ratios.mp4	101.2 MB
3. Calculating and Analyzing Growth and Profitability Ratios.srt	11.6 KB
3.1 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx.xlsx	1.3 MB
3.2 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx.xlsx	1.3 MB
4. Calculating and Analyzing Liquidity Ratios.mp4	78.6 MB
4. Calculating and Analyzing Liquidity Ratios.srt	7.9 KB
4.1 Tesla - Financial Statement Analysis - Liquidity_before.xlsx.xlsx	1.3 MB
4.2 Tesla - Financial Statement Analysis - Liquidity_after.xlsx.xlsx	1.3 MB
5. Calculating and Analyzing Solvency Ratios.mp4	21.0 MB
5. Calculating and Analyzing Solvency Ratios.srt	2.1 KB
5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx.xlsx	1.3 MB
5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx.xlsx	1.3 MB
/36. Working Capital Management/
1. Introduction.mp4	24.6 MB
1. Introduction.srt	3.6 KB
10. Symptoms of Inefficient Working Capital - Trade Payables.mp4	18.8 MB
10. Symptoms of Inefficient Working Capital - Trade Payables.srt	2.9 KB
10.1 Working capital test_solved.xlsx.xlsx	13.9 KB
10.2 Working capital test_unsolved.xlsx.xlsx	13.0 KB
2. The Importance of Working Capital Optimization Case Study.mp4	94.3 MB
2. The Importance of Working Capital Optimization Case Study.srt	11.2 KB
3. Overtrading vs. Excessive Investment.mp4	34.7 MB
3. Overtrading vs. Excessive Investment.srt	4.4 KB
4. Trade Receivables Management.mp4	79.8 MB
4. Trade Receivables Management.srt	10.6 KB
5. Re-order Level.mp4	32.8 MB
5. Re-order Level.srt	4.2 KB
6. Economic Order Quantity (EOQ).mp4	33.4 MB
6. Economic Order Quantity (EOQ).srt	5.2 KB
7. Inventory Optimization Techniques.mp4	52.9 MB
7. Inventory Optimization Techniques.srt	6.6 KB
8. Trade Payables Management.mp4	20.2 MB
8. Trade Payables Management.srt	2.6 KB
9. Working Capital Optimization - a Roadmap.mp4	50.5 MB
9. Working Capital Optimization - a Roadmap.srt	6.6 KB
/37. Fundamentals of Business & Financial Analysis/
1. Fundamentals of Business & Financial Analysis.html	0.2 KB
/38. Finance 101 - The Time Value of Money and Interest Rate Components/
1. Finance 101 Important Financial Principles That You Will Need.mp4	16.9 MB
1. Finance 101 Important Financial Principles That You Will Need.srt	0.9 KB
1.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
2. Understanding the Time Value of Money.mp4	6.5 MB
2. Understanding the Time Value of Money.srt	1.8 KB
2.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
2.2 Time value of money.pdf.pdf	795.9 KB
3. How Interest Rates Play an Important Role in the Economy.mp4	14.4 MB
3. How Interest Rates Play an Important Role in the Economy.srt	2.0 KB
3.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
4. The Components Forming Interest Rates in Real Life.mp4	17.4 MB
4. The Components Forming Interest Rates in Real Life.srt	3.8 KB
4.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
4.2 Interest rate components.pdf.pdf	826.9 KB
5. What Is Libor and What Purpose Does It Serve.mp4	18.0 MB
5. What Is Libor and What Purpose Does It Serve.srt	1.4 KB
5.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
6. The Difference Between Fixed and Variable Interest Rates.mp4	17.9 MB
6. The Difference Between Fixed and Variable Interest Rates.srt	2.5 KB
6.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
7. What Is Default Risk and How Does a Bank Account For It.mp4	32.7 MB
7. What Is Default Risk and How Does a Bank Account For It.srt	9.3 KB
7.1 Default risk.pdf.pdf	902.0 KB
7.2 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
8. Corporate Loan Specifics.mp4	27.0 MB
8. Corporate Loan Specifics.srt	2.2 KB
8.1 Finance 101 - Introduction to the World of Finance.pdf.pdf	706.3 KB
/39. Finance 101 - The Value of Cash Flows with Different Timing/
1. Calculating the Present Value of Future Cash Flows.mp4	31.2 MB
1. Calculating the Present Value of Future Cash Flows.srt	6.3 KB
1.1 1. Calculating Future Cash Flows.pdf.pdf	829.7 KB
1.2 3.1 Present Value of Cash Flows.xlsx.xlsx	10.1 KB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4	30.5 MB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.srt	5.2 KB
2.1 2. NPV.pdf.pdf	196.8 KB
/4. Microsoft Excel - Best Practices That Will Make a Difference/
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4	14.5 MB
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt	2.2 KB
1.1 Useful-Tips-Tools.pdf.pdf	3.5 MB
1.2 17. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx	9.8 KB
1.3 17. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx	11.0 KB
1.4 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx	9.2 KB
1.5 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx	10.9 KB
10. Find and Select Cells That Meet Specific Conditions.mp4	14.1 MB
10. Find and Select Cells That Meet Specific Conditions.srt	1.9 KB
10.1 23. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx	22.1 KB
10.2 23. Select-Special-F5-Exercise - Solved.xlsx.xlsx	22.8 KB
10.3 23. Select-Special-Lecture.xlsx.xlsx	10.8 KB
10.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
11. Find and Select Cells That Meet Specific Conditions.html	0.1 KB
12. How to Create Dynamic Names in Excel Spreadsheets.mp4	15.9 MB
12. How to Create Dynamic Names in Excel Spreadsheets.srt	1.7 KB
12.1 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx	11.5 KB
12.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
12.3 24. Dynamic-Naming-Lecture - Solved.xlsx.xlsx	14.2 KB
12.4 24. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx	13.9 KB
12.5 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx	12.0 KB
13. How to Create Dynamic Names in Excel Spreadsheets.html	0.1 KB
14. Using Named Ranges to Make Formulas More Readable.mp4	9.5 MB
14. Using Named Ranges to Make Formulas More Readable.srt	1.9 KB
14.1 25. Naming-ranges-Lecture - Unsolved.xlsx.xlsx	9.0 KB
14.2 25. Naming-ranges-Lecture - Solved.xlsx.xlsx	10.6 KB
14.3 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx	11.3 KB
14.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
14.5 25. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx	11.9 KB
15. Custom Number Formatting.mp4	10.4 MB
15. Custom Number Formatting.srt	2.0 KB
15.1 Useful-Tips-Tools.pdf.pdf	3.5 MB
15.2 31. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx	11.3 KB
15.3 31. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx	11.6 KB
16. How to Add a Drop-down List in Excel.mp4	17.1 MB
16. How to Add a Drop-down List in Excel.srt	2.4 KB
16.1 27. Data-Validation-Lecture - Solved.xlsx.xlsx	11.1 KB
16.2 27. Data-Validation-Lecture - Unsolved.xlsx.xlsx	11.1 KB
16.3 27. Drop-down-List-Exercise - Unsolved.xlsx.xlsx	11.6 KB
16.4 27. Drop-down-List-Exercise - Solved.xlsx.xlsx	78.9 KB
17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4	14.2 MB
17. Using Custom-sort to Sort Multiple Columns Within a Table.srt	1.8 KB
17.1 28. Sort-data-Lecture - Solved.xlsx.xlsx	149.1 KB
17.2 28. Custom-Sort-Exercise - Unsolved.xlsx.xlsx	11.6 KB
17.3 28. Sort-data-Lecture - Unsolved.xlsx.xlsx	148.8 KB
17.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
17.5 28. Custom-Sort-Exercise - Solved.xlsx.xlsx	11.7 KB
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4	48.2 MB
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt	5.2 KB
18.1 29. Microsoft-Excel-Shortcuts-for-MAC.pdf.pdf	787.7 KB
18.2 29. Microsoft-Excel-Keyboard-Shortcuts.pdf.pdf	1.3 MB
18.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
19. Multiply by 1.mp4	15.6 MB
19. Multiply by 1.srt	1.8 KB
19.1 30. Multiply-by-1-Lecture-before.xlsx.xlsx	16.9 KB
19.2 30. Multiply-by-1-Lecture-after.xlsx.xlsx	17.6 KB
2. Macros Are a Great Timesaver! Here's Why..mp4	22.4 MB
2. Macros Are a Great Timesaver! Here's Why..srt	3.5 KB
2.1 18. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx	9.9 KB
2.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
2.3 18. Creating-a-Macro-Lecture - Solved.xlsx.xlsx	11.4 KB
2.4 18. Macros-Exercise - Unsolved.xlsx.xlsx	10.6 KB
2.5 18. Macros-Exercise - Solved.xlsx.xlsx	148.5 KB
20. Find and Replace - References.mp4	25.2 MB
20. Find and Replace - References.srt	3.5 KB
20.1 31. Find-and-Replace-references-Lecture-before.xlsx.xlsx	39.7 KB
20.2 31. Find-and-Replace-references-Lecture-after.xlsx.xlsx	38.8 KB
21. Find and Replace - Formatting.mp4	14.5 MB
21. Find and Replace - Formatting.srt	2.0 KB
21.1 32. Find-replace-Lecture-before.xlsx.xlsx	17.6 KB
21.2 32. Find-replace-Lecture-after.xlsx.xlsx	17.6 KB
22. Green References.mp4	13.2 MB
22. Green References.srt	1.7 KB
22.1 33. Green-references-Lecture.xlsx.xlsx	12.3 KB
23. Beauty Saving - The Professional Way of Saving Files.mp4	14.7 MB
23. Beauty Saving - The Professional Way of Saving Files.srt	2.6 KB
23.1 34. Beauty-saving-Lecture-before.xlsx.xlsx	17.6 KB
23.2 34. Beauty-saving-Lecture-after.xlsx.xlsx	17.5 KB
24. The Power of F2.mp4	18.6 MB
24. The Power of F2.srt	2.2 KB
24.1 43. F2-Lecture.xlsm.xlsm	51.1 KB
25. Conditional Formatting.mp4	61.6 MB
25. Conditional Formatting.srt	6.2 KB
25.1 41. Conditional formatting - Lecture.xlsx.xlsx	42.7 KB
26. Quiz Number 1.html	0.1 KB
3. How to Use the Same Macro On Multiple Workbooks.mp4	13.4 MB
3. How to Use the Same Macro On Multiple Workbooks.srt	1.7 KB
3.1 19. How-to-save-macros-Lecture-before.xlsx.xlsx	6.2 KB
3.2 19. How-to-save-macros-Lecture-after.xlsm.xlsm	12.9 KB
3.3 19. Another-file.xlsx.xlsx	9.0 KB
4. Macros Are a Great Timesaver! Here's Why..html	0.1 KB
5. The Secret to Faster Scrolling in Excel.mp4	21.8 MB
5. The Secret to Faster Scrolling in Excel.srt	1.9 KB
5.1 25. Fast-Scrolling-Exercise - Solved.xlsx.xlsx	45.4 KB
5.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
5.3 25. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx	45.0 KB
5.4 25. Fast-Scrolling - Lecture.xlsx.xlsx	658.2 KB
6. Be even quicker F5 + Enter.mp4	20.7 MB
6. Be even quicker F5 + Enter.srt	2.2 KB
6.1 21. F5-go-to - Lecture.xlsm.xlsm	52.0 KB
7. The Secret to Faster Scrolling in Excel.html	0.1 KB
8. Using Absolute and Relative Cell References.mp4	28.3 MB
8. Using Absolute and Relative Cell References.srt	2.8 KB
8.1 22. Fixing-references-Lecture - Unsolved.xlsx.xlsx	659.4 KB
8.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
8.3 22. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx	10.9 KB
8.4 22. Fixing-references-Lecture - Solved.xlsx.xlsx	660.7 KB
8.5 22. Fixing-Cells-Exercise - Solved.xlsx.xlsx	11.1 KB
9. Using Absolute and Relative Cell References.html	0.1 KB
/40. Finance 101 - Loan Calculations/
1. Using Annuities.mp4	25.4 MB
1. Using Annuities.srt	4.0 KB
2. Calculating a Complete Loan Schedule.mp4	52.0 MB
2. Calculating a Complete Loan Schedule.srt	7.5 KB
3. COURSE CHALLENGE - Part 3.mp4	14.6 MB
3. COURSE CHALLENGE - Part 3.srt	1.7 KB
3.1 3. Course Challenge.xlsx.xlsx	550.6 KB
/41. Capital Budgeting - Basic Notions/
1. What is Capital Budgeting.mp4	13.9 MB
1. What is Capital Budgeting.srt	1.9 KB
2. When Do We Use Capital Budgeting.mp4	21.5 MB
2. When Do We Use Capital Budgeting.srt	2.8 KB
3. The Time Value of Money in a Capital Budgeting Setting.mp4	19.8 MB
3. The Time Value of Money in a Capital Budgeting Setting.srt	2.8 KB
4. Calculating Present and Future Value.mp4	39.3 MB
4. Calculating Present and Future Value.srt	6.8 KB
5. Cost of Equity.mp4	58.6 MB
5. Cost of Equity.srt	8.2 KB
6. Project-specific Beta.mp4	28.5 MB
6. Project-specific Beta.srt	3.9 KB
7. The Weighted Average Cost of Capital (WACC).mp4	16.5 MB
7. The Weighted Average Cost of Capital (WACC).srt	2.5 KB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4	25.5 MB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt	4.3 KB
9. Modeling Future Cash Flows.mp4	57.0 MB
9. Modeling Future Cash Flows.srt	7.3 KB
/42. Capital Budgeting - A Complete Case Study/
1. An Introduction to the Case Study.mp4	26.5 MB
1. An Introduction to the Case Study.srt	3.5 KB
10. Estimating Cost of Equity.mp4	42.3 MB
10. Estimating Cost of Equity.srt	7.8 KB
10.1 8. WACC_unsolved.xlsx.xlsx	36.8 KB
10.2 8. WACC.xlsx.xlsx	38.9 KB
11. Discounting Project Cash Flows.mp4	27.2 MB
11. Discounting Project Cash Flows.srt	3.8 KB
11.1 9.Discounted-cash-flow-unsolved.xlsx.xlsx	39.7 KB
11.2 9. Discounted cash flow.xlsx.xlsx	40.7 KB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4	45.1 MB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt	5.7 KB
12.1 10. Sensitivity analysis.xlsx.xlsx	41.6 KB
12.2 Capital budgeting_exercise_unsolved.xlsx.xlsx	13.5 KB
12.3 Capital-budgeting-exercise-solved.xlsx.xlsx	43.8 KB
12.4 10. Sensitivity analysis_unsolved.xlsx.xlsx	40.6 KB
2. Organizing Inputs In the Drivers Sheet.mp4	40.0 MB
2. Organizing Inputs In the Drivers Sheet.srt	6.7 KB
2.1 1. Drivers.xlsx.xlsx	11.8 KB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4	36.4 MB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt	4.4 KB
3.1 2. Savings Forecast_unsolved.xlsx.xlsx	15.1 KB
3.2 2. Savings Forecast.xlsx.xlsx	17.0 KB
4. Preparing a Fixed Asset Rollforward Schedule.mp4	49.7 MB
4. Preparing a Fixed Asset Rollforward Schedule.srt	5.7 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx	19.0 KB
4.2 3. Fixed Asset Rollforward.xlsx.xlsx	20.1 KB
5. Calculating the Cash Impact of Extra Working Capital Required.mp4	19.2 MB
5. Calculating the Cash Impact of Extra Working Capital Required.srt	3.1 KB
5.1 4. Working Capital_unsolved.xlsx.xlsx	21.7 KB
5.2 4. Working Capital.xlsx.xlsx	22.5 KB
6. Debt Repayment and Interest Expenses Calculation.mp4	23.2 MB
6. Debt Repayment and Interest Expenses Calculation.srt	3.5 KB
6.1 5. Financing.xlsx.xlsx	31.7 KB
6.2 5. Financing_unsolved.xlsx.xlsx	30.7 KB
7. The Project's P&L Sheet.mp4	14.6 MB
7. The Project's P&L Sheet.srt	2.3 KB
7.1 6. P&L_unsolved.xlsx.xlsx	30.4 KB
7.2 6. P&L.xlsx.xlsx	31.8 KB
8. The Project's Cash Flow Calculation.mp4	32.3 MB
8. The Project's Cash Flow Calculation.srt	4.1 KB
8.1 7. Cash flow.xlsx.xlsx	32.1 KB
8.2 7. Cash flow_unsolved.xlsx.xlsx	30.4 KB
9. Calculating WACC (Weighted Average Cost of Capital).mp4	19.4 MB
9. Calculating WACC (Weighted Average Cost of Capital).srt	3.6 KB
9.1 8. WACC.xlsx.xlsx	38.9 KB
9.2 8. WACC_unsolved.xlsx.xlsx	36.8 KB
/43. Tesla Practical Case Study - Building a Financial Planning Model/
1. Organizing External Inputs in a 'Drivers' Sheet.mp4	32.5 MB
1. Organizing External Inputs in a 'Drivers' Sheet.srt	4.5 KB
1.1 0a. Drivers_before.xlsx.xlsx	1.3 MB
1.2 0a. Drivers_after.xlsx.xlsx	1.3 MB
10. Forecasting 'Energy' and 'Services' Revenue.mp4	26.5 MB
10. Forecasting 'Energy' and 'Services' Revenue.srt	3.2 KB
10.1 6. Energy and Other revenue - Before.xlsx.xlsx	1.4 MB
10.2 6. Energy and Other revenue - After.xlsx.xlsx	1.4 MB
11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4	28.1 MB
11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.srt	2.6 KB
11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx	1.4 MB
11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx	1.4 MB
12. Forecasting Operating Expenses.mp4	36.6 MB
12. Forecasting Operating Expenses.srt	5.5 KB
12.1 8. Opex - Before.xlsx.xlsx	1.4 MB
12.2 8. Opex - After.xlsx.xlsx	1.4 MB
13. Building a Fixed Asset Roll Forward Estimating Capex.mp4	59.3 MB
13. Building a Fixed Asset Roll Forward Estimating Capex.srt	6.6 KB
13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx	1.4 MB
13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx	1.4 MB
14. Building a Fixed Asset Roll Forward D&A Schedule.mp4	56.8 MB
14. Building a Fixed Asset Roll Forward D&A Schedule.srt	4.6 KB
14.1 10. PP&E schedule_after.xlsx.xlsx	1.4 MB
14.2 10. PP&E schedule_before.xlsx.xlsx	1.4 MB
15. Peer Comparison D&A as a Percentage of Revenues.mp4	14.3 MB
15. Peer Comparison D&A as a Percentage of Revenues.srt	1.7 KB
15.1 10a. PP&E comparison.xlsx.xlsx	1.4 MB
16. Calculating DSO, DIO, DPO.mp4	18.4 MB
16. Calculating DSO, DIO, DPO.srt	2.2 KB
16.1 11. Working capital forecasting_before.xlsx.xlsx	1.4 MB
16.2 11. Working capital forecasting_after.xlsx.xlsx	1.6 MB
17. Producing a Clean P&L Output Sheet.mp4	8.9 MB
17. Producing a Clean P&L Output Sheet.srt	1.7 KB
17.1 12. P&L.xlsx.xlsx	1.5 MB
18. Fill in the P&L Output Sheet.mp4	19.2 MB
18. Fill in the P&L Output Sheet.srt	1.9 KB
18.1 12a. P&L fill in_after.xlsx.xlsx	1.5 MB
18.2 12a. P&L fill in_before.xlsx.xlsx	1.5 MB
19. Calculating Investments in Working Capital.mp4	20.0 MB
19. Calculating Investments in Working Capital.srt	2.2 KB
19.1 13. Calculating working capital_before.xlsx.xlsx	1.5 MB
19.2 13. Calculating working capital_after.xlsx.xlsx	1.5 MB
2. The Input Data We Will Work With.mp4	16.6 MB
2. The Input Data We Will Work With.srt	1.8 KB
2.1 0aa. Inputs_before.xlsx.xlsx	1.3 MB
2.2 0aa. Inputs_after.xlsx.xlsx	1.3 MB
20. Forecasting Unlevered Free Cash Flow.mp4	58.7 MB
20. Forecasting Unlevered Free Cash Flow.srt	6.2 KB
20.1 14. Cash flow - UFCF_before.xlsx.xlsx	1.5 MB
20.2 14. Cash flow - UFCF_after.xlsx.xlsx	1.5 MB
21. Forecasting Other Assets.mp4	47.5 MB
21. Forecasting Other Assets.srt	4.7 KB
21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx	1.5 MB
21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx	1.5 MB
22. Forecasting Other Liabilities.mp4	23.1 MB
22. Forecasting Other Liabilities.srt	2.4 KB
22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx	1.5 MB
22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx	1.5 MB
23. Completing Unlevered Free Cash Flow.mp4	42.9 MB
23. Completing Unlevered Free Cash Flow.srt	3.8 KB
23.1 16a. Complete UFCF_before.xlsx.xlsx	1.5 MB
23.2 16a. Complete UFCF_after.xlsx.xlsx	1.5 MB
24. Modeling Tesla's Financing Needs in the Forecast Period.mp4	44.4 MB
24. Modeling Tesla's Financing Needs in the Forecast Period.srt	5.8 KB
24.1 17. Financing_before.xlsx.xlsx	1.5 MB
24.2 17. Financing_after.xlsx.xlsx	1.5 MB
25. Calculating Net Income.mp4	15.5 MB
25. Calculating Net Income.srt	1.4 KB
25.1 18. P&L complete_after.xlsx.xlsx	1.5 MB
25.2 18. P&L complete_before.xlsx.xlsx	1.5 MB
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4	53.1 MB
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt	4.6 KB
26.1 19. Cash flow_complete_after.xlsx.xlsx	1.5 MB
26.2 19. Cash flow_complete_before.xlsx.xlsx	1.5 MB
27. Balancing the Balance Sheet.mp4	13.9 MB
27. Balancing the Balance Sheet.srt	1.2 KB
27.1 20. Complete the BS_before.xlsx.xlsx	1.5 MB
27.2 20. Complete the BS_after.xlsx.xlsx	1.5 MB
3. Forecasting Tesla's Expected Deliveries.mp4	120.5 MB
3. Forecasting Tesla's Expected Deliveries.srt	15.8 KB
3.1 1. Deliveries_after.xlsx.xlsx	1.4 MB
3.2 1. Deliveries_before.xlsx.xlsx	1.4 MB
4. Comparing Delivery Figures with the Ones of industry Peers.mp4	22.0 MB
4. Comparing Delivery Figures with the Ones of industry Peers.srt	3.2 KB
4.1 1a. Deliveries development.xlsx.xlsx	1.4 MB
5. Estimating an Average Selling Price of Tesla Vehicles.mp4	44.0 MB
5. Estimating an Average Selling Price of Tesla Vehicles.srt	5.3 KB
5.1 2. Average price_after.xlsx.xlsx	1.4 MB
5.2 2. Average price_before.xlsx.xlsx	1.4 MB
6. Calculating Automotive Revenue.mp4	48.8 MB
6. Calculating Automotive Revenue.srt	5.1 KB
6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx	1.4 MB
6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx	1.4 MB
7. Peer Comparison Gross Profit %.mp4	18.0 MB
7. Peer Comparison Gross Profit %.srt	2.8 KB
7.1 4. Gross profit automotive.xlsx.xlsx	1.4 MB
8. Calculating Automotive Gross Profit.mp4	29.1 MB
8. Calculating Automotive Gross Profit.srt	2.9 KB
8.1 4a. Gross profit automotive - before.xlsx.xlsx	1.6 MB
8.2 4a. Gross profit automotive - after.xlsx.xlsx	1.4 MB
9. Calculating Automotive Cost of Sales.mp4	18.4 MB
9. Calculating Automotive Cost of Sales.srt	2.3 KB
9.1 5. Cost of sales and chart.xlsx.xlsx	1.4 MB
/44. PowerPoint - Introduction to PowerPoint/
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4	19.3 MB
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.srt	1.2 KB
10. Changing an Object's Size and Rotation.mp4	11.8 MB
10. Changing an Object's Size and Rotation.srt	2.2 KB
10.1 Resizing and Rotating Objects.pptx.pptx	1.3 MB
11. Using Slide Masters.mp4	23.5 MB
11. Using Slide Masters.srt	5.4 KB
11.1 Slide Masters Presentation - example.pptx.pptx	44.5 KB
12. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4	16.1 MB
12. Bring to Front and Send to Back - An Important PowerPoint Technique.srt	3.4 KB
12.1 Bring to Front and Send to Back.pptx.pptx	1.3 MB
13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4	29.0 MB
13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt	6.2 KB
13.1 Insert table.pptx.pptx	1.3 MB
2. General Considerations About Slide Structure.mp4	27.4 MB
2. General Considerations About Slide Structure.srt	4.8 KB
2.1 Spacing within PowerPoint.pptx.pptx	1.9 MB
2.2 Spacing-within-PowerPoint-chart.xlsx.xlsx	58.7 KB
3. Learn How to Insert Objects in PowerPoint.mp4	33.5 MB
3. Learn How to Insert Objects in PowerPoint.srt	4.9 KB
3.1 Kinemax Data.xlsx.xlsx	37.3 KB
3.2 Insert objects.pptx.pptx	1.7 MB
4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4	17.4 MB
4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt	3.1 KB
4.1 PowerPoint Master Class - Shortcuts.pdf.pdf	451.0 KB
4.2 Power-Point-Master-Class-Shortcuts-For-Mac.pdf.pdf	545.2 KB
5. Add Frequently Used Buttons to the Quick Access Toolbar.mp4	22.3 MB
5. Add Frequently Used Buttons to the Quick Access Toolbar.srt	3.5 KB
5.1 Quick Access Toolbar buttons.pptx.pptx	1.3 MB
6. How to Easily Align Objects in PowerPoint.mp4	21.5 MB
6. How to Easily Align Objects in PowerPoint.srt	5.0 KB
6.1 Align and Distribute objects in Ppt.pptx.pptx	1.3 MB
7. How to Edit Shapes in Your Presentation.mp4	27.5 MB
7. How to Edit Shapes in Your Presentation.srt	6.0 KB
7.1 Format Shape Menu.pptx.pptx	649.4 KB
8. How to Format Text Boxes in a PowerPoint Presentation.mp4	20.9 MB
8. How to Format Text Boxes in a PowerPoint Presentation.srt	4.5 KB
8.1 Working with text.pptx.pptx	791.5 KB
9. Practical Learning - Exercise 1.mp4	28.8 MB
9. Practical Learning - Exercise 1.srt	4.4 KB
9.1 Practical Example - Organizing Notes.pptx.pptx	1.3 MB
9.2 Practical Example - Organizing Notes.docx.docx	15.9 KB
/45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/
1. An Introduction to PowerPoint Animations.mp4	15.3 MB
1. An Introduction to PowerPoint Animations.srt	4.1 KB
1.1 Animation effects.pptx.pptx	1.3 MB
10. Practical Exercise - Creating an Organisational Chart.mp4	55.3 MB
10. Practical Exercise - Creating an Organisational Chart.srt	7.7 KB
10.1 Practical Example.pptx.pptx	1.3 MB
10.2 Practical Example - completed.pptx.pptx	1.3 MB
10.3 List of executives.png.png	64.4 KB
11. COURSE CHALLENGE - Part 4.mp4	27.3 MB
11. COURSE CHALLENGE - Part 4.srt	3.6 KB
11.1 4. Course Challenge.pptx.pptx	1.2 MB
11.2 4. Course Challenge - Tasks.pdf.pdf	289.8 KB
11.3 Sending Files with Dropbox - YouTube Tutorial.html	0.1 KB
2. Modifying the Beginning and Ending of a Line Object.mp4	10.6 MB
2. Modifying the Beginning and Ending of a Line Object.srt	2.2 KB
2.1 Line Begin and End type.pptx.pptx	1.3 MB
3. Join Shapes Together By Using Connector Lines.mp4	25.0 MB
3. Join Shapes Together By Using Connector Lines.srt	5.2 KB
3.1 Connectors.pptx.pptx	1.3 MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4	8.7 MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.srt	2.3 KB
4.1 Edit Points.pptx.pptx	1.3 MB
5. Group or Ungroup Shapes, Pictures or Other Objects.mp4	15.4 MB
5. Group or Ungroup Shapes, Pictures or Other Objects.srt	2.3 KB
5.1 Group.pptx.pptx	1.3 MB
6. This is How You Can Fit Text When It Is Larger than a Shape.mp4	14.5 MB
6. This is How You Can Fit Text When It Is Larger than a Shape.srt	2.6 KB
6.1 Internal Margins.pptx.pptx	1.3 MB
7. Nudge Objects.mp4	4.6 MB
7. Nudge Objects.srt	1.4 KB
7.1 Nudge objects.pptx.pptx	1.3 MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4	22.0 MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt	4.3 KB
8.1 Smart Art.pptx.pptx	1.3 MB
9. Creating Eye-Catching Text Effects in PowerPoint.mp4	13.0 MB
9. Creating Eye-Catching Text Effects in PowerPoint.srt	2.5 KB
9.1 Text effects.pptx.pptx	1.3 MB
/46. Bonus Lecture/
1. Bonus Lecture Next Steps.html	4.2 KB
/5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/
1. Key Excel Functions IF.mp4	17.5 MB
1. Key Excel Functions IF.srt	50.0 MB
1.1 Functions - English to Portuguese.pdf.pdf	149.6 KB
1.2 37. IF-function--Lecture-before.xlsm.xlsm	17.4 KB
1.3 Functions - English to Spanish.pdf.pdf	104.8 KB
1.4 Functions - English to German.pdf.pdf	104.8 KB
1.5 37. IF-function-Lecture-after.xlsm.xlsm	18.4 KB
10. Find the Highest and Lowest Values in a Range Max & Min.mp4	7.9 MB
10. Find the Highest and Lowest Values in a Range Max & Min.srt	1.1 KB
10.1 44. MIN-MAX-Exercise - Solved.xlsx.xlsx	15.2 KB
10.2 44. Max-min-Lecture - Unsolved.xlsx.xlsx	9.2 KB
10.3 44. MIN-MAX-Exercise - Unsolved.xlsx.xlsx	14.7 KB
10.4 Excel-Functions.pdf.pdf	3.3 MB
10.5 44. Excel-functions.xlsx.xlsx	994.3 KB
10.6 44. Max-min-Lecture - Solved.xlsx.xlsx	9.4 KB
11. = and + are Interchangeable When You Start Typing a Formula.mp4	6.1 MB
11. = and + are Interchangeable When You Start Typing a Formula.srt	1.0 KB
11.1 45. Show-that-and-are-interchangeable-Lecture-before.xlsm.xlsm	17.4 KB
11.2 45. Show-that-and-are-interchangeable-Lecture-after.xlsm.xlsm	17.4 KB
12. Use ROUND in Your Financial Models.mp4	5.5 MB
12. Use ROUND in Your Financial Models.srt	1.2 KB
12.1 51. Excel-functions-Lecture.xlsx.xlsx	911.3 KB
12.2 Excel-Functions.pdf.pdf	3.3 MB
12.3 51. Round-Exercise - Solved.xlsx.xlsx	12.0 KB
12.4 51. Round-Exercise - Unsolved.xlsx.xlsx	11.6 KB
13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4	63.2 MB
13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.srt	9.2 KB
13.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx	11.4 KB
13.2 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx	11.0 KB
13.3 47. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx	14.0 KB
13.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx	12.2 KB
13.5 Excel-Functions.pdf.pdf	3.3 MB
14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4	64.8 MB
14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt	8.8 KB
14.1 48. Index-Match-Exercise - Unsolved.xlsx.xlsx	11.9 KB
14.2 48. Index-Match-Lecture - Unsolved.xlsx.xlsx	11.6 KB
14.3 Excel-Functions.pdf.pdf	3.3 MB
14.4 48. Index-Match-Lecture - Solved.xlsx.xlsx	12.0 KB
14.5 48. Index-Match-Exercise - Solved.xlsx.xlsx	12.4 KB
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html	0.1 KB
16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4	12.3 MB
16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt	2.2 KB
16.1 54. Iferror - Lecture - Solved.xlsm.xlsm	917.9 KB
16.2 54. Iferror - Lecture - Unsolved.xlsm.xlsm	918.8 KB
16.3 54. Iferror-Exercise - Solved.xlsx.xlsx	15.7 KB
16.4 54. Iferror-Exercise - Unsolved.xlsx.xlsx	14.6 KB
16.5 Excel-Functions.pdf.pdf	3.3 MB
17. A Useful Tool for Financial Analysis - The RANK Function.mp4	24.4 MB
17. A Useful Tool for Financial Analysis - The RANK Function.srt	2.9 KB
17.1 50. Rank-function-Lecture-after.xlsx.xlsx	12.9 KB
17.2 50. Rank-function-Lecture-before.xlsx.xlsx	12.6 KB
18. Create Flexible Financial Models with CHOOSE.mp4	20.8 MB
18. Create Flexible Financial Models with CHOOSE.srt	2.8 KB
18.1 Excel-Functions.pdf.pdf	3.3 MB
18.2 51. Choose-Lecture - Unsolved.xlsx.xlsx	9.6 KB
18.3 51. Choose-Exercise-Solved.xlsx.xlsx	22.3 KB
18.4 51. Choose-Lecture - Solved.xlsx.xlsx	9.9 KB
18.5 51. Choose-Exercise - Unsolved.xlsx.xlsx	11.6 KB
19. Goal Seek Will Help You Find the Result You Are Looking For.mp4	16.8 MB
19. Goal Seek Will Help You Find the Result You Are Looking For.srt	2.8 KB
19.1 57. Goal-Seek-Lecture - Unsolved.xlsx.xlsx	9.4 KB
19.2 57. Goal-Seek-Exercise-Solved.xlsx.xlsx	16.6 KB
19.3 Excel-Functions.pdf.pdf	3.3 MB
19.4 57. Goal-Seek-Exercise - Unsolved.xlsx.xlsx	16.5 KB
19.5 57. Goal-Seek-Lecture - Solved.xlsx.xlsx	9.4 KB
2. Enlarge the Formula Bar.mp4	6.6 MB
2. Enlarge the Formula Bar.srt	1.4 KB
2.1 38. Enlarge-the-formula-bar-Lecture.xlsm.xlsm	48.0 KB
20. Goal Seek Will Help You Find the Result You Are Looking For.html	0.1 KB
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4	27.5 MB
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.srt	5.4 KB
21.1 58. Sensitivity analysis - Lecture - Solved.xlsm.xlsm	918.8 KB
21.2 58.Sensitivity-analysis-Exercise-Solved.xlsx.xlsx	63.8 KB
21.3 58. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm	918.6 KB
21.4 58.Sensitivity-analysis-Exercise_Unsolved.xlsx.xlsx	63.4 KB
22. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html	0.1 KB
23. Quiz Number 2.html	0.1 KB
3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4	32.2 MB
3. Key Excel Functions SUM, SUMIF, SUMIFS.srt	5.3 KB
3.1 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx	13.3 KB
3.2 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx	13.2 KB
3.3 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx	14.8 KB
3.4 Excel-Functions.pdf.pdf	3.3 MB
3.5 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx	15.2 KB
4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4	32.7 MB
4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt	4.6 KB
4.1 Excel-Functions.pdf.pdf	3.3 MB
4.2 40.Counts-Exercise-Unsolved.xlsx.xlsx	15.9 KB
4.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx	12.0 KB
4.4 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx	11.6 KB
4.5 40.Counts-Exercise-Solved.xlsx.xlsx	16.5 KB
5. Key Excel Functions AVERAGE & AVERAGEIF.mp4	15.9 MB
5. Key Excel Functions AVERAGE & AVERAGEIF.srt	2.4 KB
5.1 Excel-Functions.pdf.pdf	3.3 MB
5.2 41. Average-Averageif- Lecture - Solved.xlsx.xlsx	9.6 KB
5.3 41. Average-Averageif- Lecture - Unsolved.xlsx.xlsx	9.2 KB
5.4 41. Average-AverageIF-Exercise - Solved.xlsx.xlsx	15.4 KB
5.5 41. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx	15.0 KB
6. Key Excel Functions Average & Averageif.html	0.1 KB
7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4	31.9 MB
7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.srt	5.0 KB
7.1 47. Text functions - Exercise - Solved.xlsx.xlsx	12.5 KB
7.2 47. Text-Functions- Lecture - Solved.xlsx.xlsx	11.4 KB
7.3 47. Text-Functions- Lecture - Unsolved.xlsx.xlsx	10.9 KB
7.4 47. Text functions - Exercise - Unsolved.xlsx.xlsx	12.0 KB
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html	0.1 KB
9. Working with Text in Excel.mp4	16.8 MB
9. Working with Text in Excel.srt	3.2 KB
9.1 43. Work-with-text-Lecture-before.xlsx.xlsx	10.6 KB
9.2 43. Work-with-text-Lecture-after.xlsx.xlsx	11.2 KB
/6. Microsoft Excel - Financial Functions in Excel/
1. Discounting Cash Flows in Microsoft Excel.mp4	47.9 MB
1. Discounting Cash Flows in Microsoft Excel.srt	7.4 KB
1.1 54. FV and PV-Lecture.xlsx.xlsx	10.9 KB
2. Calculating Internal Rate of Return (IRR) in Excel.mp4	23.9 MB
2. Calculating Internal Rate of Return (IRR) in Excel.srt	3.9 KB
2.1 55. IRR-Lecture.xlsx.xlsx	11.5 KB
3. Using the PMT Function to Create a Complete Loan Schedule.mp4	42.0 MB
3. Using the PMT Function to Create a Complete Loan Schedule.srt	7.0 KB
3.1 56. Loan Schedule-Lecture.xlsx.xlsx	20.7 KB
4. Date Functions in Excel.mp4	32.3 MB
4. Date Functions in Excel.srt	5.9 KB
4.1 57. Date Functions-Lecture.xlsx.xlsx	12.5 KB
/7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/
1. Introduction to the Case Study.mp4	10.3 MB
1. Introduction to the Case Study.srt	1.0 KB
10. The Mapping Exercise.mp4	22.7 MB
10. The Mapping Exercise.srt	2.1 KB
10.1 Mapping-exercise-explained.pdf.pdf	248.9 KB
10.2 67. Mapping-Lecture-after.xlsm.xlsm	51.7 KB
10.3 67. Mapping-Lecture-before.xlsm.xlsm	51.8 KB
11. Mapping the Rows in the Database Sheet.mp4	40.4 MB
11. Mapping the Rows in the Database Sheet.srt	6.9 KB
11.1 Mapping-exercise-explained.pdf.pdf	248.9 KB
11.2 68. Mapping-Lecture-after.xlsm.xlsm	51.7 KB
11.3 68. Mapping-Lecture-before.xlsm.xlsm	51.8 KB
12. Building the Structure of the P&L Sheet.mp4	21.9 MB
12. Building the Structure of the P&L Sheet.srt	2.4 KB
12.1 69. Building a P&L-Lecture-after.xlsm.xlsm	53.1 KB
12.2 69. Building a P&L-Lecture-before.xlsm.xlsm	51.4 KB
13. A Practical Example of Professional Formatting in Excel.mp4	26.7 MB
13. A Practical Example of Professional Formatting in Excel.srt	3.5 KB
13.1 70. Formatting a P&L-Lecture-before.xlsm.xlsm	53.1 KB
13.2 70 Formatting the P&L-Lecture-after.xlsm.xlsm	53.2 KB
14. Populating the P&L Sheet with SUMIF.mp4	31.7 MB
14. Populating the P&L Sheet with SUMIF.srt	3.1 KB
14.1 71. Formatting the P&L-Lecture-after.xlsm.xlsm	54.8 KB
14.2 71. Formatting the P&L-Lecture-before.xlsm.xlsm	53.2 KB
15. Learn How to Find Mistakes with COUNTIF.mp4	29.2 MB
15. Learn How to Find Mistakes with COUNTIF.srt	2.9 KB
15.1 72. Countif-Lecture-before.xlsm.xlsm	54.8 KB
15.2 72. Countif-Lecture-after.xlsm.xlsm	56.1 KB
16. Calculating Growth Rates in Excel.mp4	31.4 MB
16. Calculating Growth Rates in Excel.srt	3.4 KB
16.1 Y-o-Y Function explanation.pdf.pdf	168.9 KB
16.2 73. Adding % variations-Lecture-after.xlsm.xlsm	57.9 KB
16.3 73. Adding % variations-Lecture-before.xlsm.xlsm	56.1 KB
17. Quiz Number 3.html	0.1 KB
2. What You Will See Next.mp4	10.7 MB
2. What You Will See Next.srt	1.1 KB
3. Understand Your Data Source Before You Start Working on It.mp4	29.5 MB
3. Understand Your Data Source Before You Start Working on It.srt	3.2 KB
3.1 60. Get to know the data source - Lecture.xlsm.xlsm	44.1 KB
4. Ordering the Source Worksheet.mp4	27.8 MB
4. Ordering the Source Worksheet.srt	2.6 KB
4.1 61. Order a worksheet_after.xlsm.xlsm	42.0 KB
4.2 61. Order a worksheet_before.xlsm.xlsm	44.1 KB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4	25.7 MB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.srt	2.3 KB
5.1 62. Creating a code_after.xlsm.xlsm	42.7 KB
5.2 62. Creating a code_before.xlsm.xlsm	42.0 KB
6. Learn How to Create a Database.mp4	21.8 MB
6. Learn How to Create a Database.srt	41.6 MB
6.1 63. Creating a database_after.xlsm.xlsm	40.3 KB
6.2 63. Creating a database_before.xlsm.xlsm	42.7 KB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4	64.5 MB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.srt	5.7 KB
7.1 64. Vlookup_after.xlsm.xlsm	45.5 KB
7.2 64. Vlookup_before.xlsm.xlsm	50.7 KB
8. Using SUMIF to Complete the Database Sheet.mp4	50.3 MB
8. Using SUMIF to Complete the Database Sheet.srt	4.5 KB
8.1 65. Sumif_before.xlsm.xlsm	45.5 KB
8.2 65. Sumif_after.xlsm.xlsm	50.7 KB
9. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4	52.1 MB
9. Using INDEX & MATCH as a Substitute for VLOOKUP.srt	4.4 KB
9.1 66. Index Match-Lecture-after.xlsm.xlsm	14.5 MB
9.2 66. Index Match_before.xlsm.xlsm	42.0 KB
/8. Microsoft Excel - Building Professional Charts in Excel/
1. Introduction to Excel Charts.mp4	13.6 MB
1. Introduction to Excel Charts.srt	1.4 KB
2. Beginner's Guide to Inserting Charts in Excel.mp4	23.3 MB
2. Beginner's Guide to Inserting Charts in Excel.srt	2.8 KB
2.1 75. Inserting-Charts-Lecture.xlsm.xlsm	12.0 MB
3. Modifying Excel Charts - The Easy Way.mp4	27.3 MB
3. Modifying Excel Charts - The Easy Way.srt	3.3 KB
3.1 76. Formatting-a-Chart-Lecture.xlsm.xlsm	12.0 MB
4. Making Your Excel Charts Sexier - Proven Tips.mp4	34.3 MB
4. Making Your Excel Charts Sexier - Proven Tips.srt	3.9 KB
4.1 77. Modifying-a-Chart-Lecture.xlsm.xlsm	12.0 MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4	14.3 MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.srt	1.4 KB
5.1 78. Bridge-Charts-Lecture.xlsx.xlsx	13.4 KB
6. New Ways to Visualize Your Data - Treemap Charts.mp4	12.1 MB
6. New Ways to Visualize Your Data - Treemap Charts.srt	1.8 KB
6.1 79. Treemap-Charts-Lecture.xlsx.xlsx	12.9 KB
7. How to Represent Trends with Sparklines.mp4	28.9 MB
7. How to Represent Trends with Sparklines.srt	4.6 KB
7.1 80. Sparklines-Lecture.xlsx.xlsx	9.8 KB
/9. Microsoft Excel - Creating Complete Professional Charts from Scratch/
1. Introduction.mp4	6.5 MB
1. Introduction.srt	0.7 KB
2. Stacked Column Chart with a Secondary Axis.mp4	48.7 MB
2. Stacked Column Chart with a Secondary Axis.srt	5.8 KB
2.1 82. Column stacked chart-Lecture-after.xlsm.xlsm	12.1 MB
2.2 82. Column stacked chart-Lecture-before.xlsm.xlsm	12.1 MB
3. Doughnut Chart.mp4	39.9 MB
3. Doughnut Chart.srt	5.6 KB
3.1 83. Doughnut chart-Lecture-before.xlsm.xlsm	12.1 MB
3.2 83. Doughnut chart-Lecture-after.xlsm.xlsm	12.1 MB
4. Area Chart.mp4	30.0 MB
4. Area Chart.srt	3.6 KB
4.1 84. Area chart-Lecture-before.xlsm.xlsm	12.1 MB
4.2 84. Area chart-Lecture-after.xlsm.xlsm	12.1 MB
5. Bridge Chart.mp4	54.6 MB
5. Bridge Chart.srt	7.8 KB
5.1 85. Bridge chart-Lecture-after.xlsm.xlsm	12.1 MB
5.2 85.Bridge-chart-Lecture-before.xlsm.xlsm	12.0 MB
Total files 1115