Udemy - The Complete Financial Analyst Course 2019 [TP]


0

0
seeders: 0 leechers: 3
Added 1 year ago in Other
Downloaded 46 times.
Udemy - The Complete Financial Analyst Course 2019 [TP]

Files

[Tutorialsplanet.NET] Udemy - The Complete Financial Analyst Course 2019 (9.22 GB)
▼ show more 1115 files
1. Welcome! Course Introduction
1. What Does the Course Cover.mp4 78.16 MB
1. What Does the Course Cover.vtt 7.3 KB
1.1 Financial Analyst - Course Curriculum.pdf.pdf 581.35 KB
2. Everything We Will Learn Has a Practical Application.mp4 25.7 MB
2. Everything We Will Learn Has a Practical Application.vtt 3.53 KB
2.1 Quick win.xlsx.xlsx 9.74 KB
3. The Best Way to Take This Course.mp4 31.91 MB
3. The Best Way to Take This Course.vtt 3.27 KB
4. Download All Course Materials.html 903 B
4.1 Download all course materials.html 134 B
10. Microsoft Excel - Working with Pivot Tables in Excel
1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 15.06 MB
1. Pivot Tables - Excel's Dynamic and Interactive Tables.vtt 2.01 KB
2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 38.94 MB
2. Creating a Pivot Table Choosing Row and Column Parameters.vtt 3.98 KB
2.1 87. Creating-a-Pivot-Table-Lecture.xlsx.xlsx 1.43 MB
3. Design the Layout and Format of Your Pivot Tables.mp4 21.51 MB
3. Design the Layout and Format of Your Pivot Tables.vtt 2.01 KB
3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx.xlsx 1.43 MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 45.96 MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.vtt 4.43 KB
4.1 89. Working-with-Pivot-Tables-Lecture.xlsx.xlsx 1.88 MB
5. One of the Most Useful Excel Functions - GetPivotData.mp4 36.27 MB
5. One of the Most Useful Excel Functions - GetPivotData.vtt 3.99 KB
5.1 90. GetPivotData-Lecture.xlsx.xlsx 1.88 MB
6. Welcome to the Future - Pivot Table Slicers.mp4 45.22 MB
6. Welcome to the Future - Pivot Table Slicers.vtt 4.06 KB
6.1 91. Slicers-Lecture.xlsx.xlsx 1.88 MB
7. Introduction to the Course Challenge.mp4 13.19 MB
7. Introduction to the Course Challenge.vtt 1.36 KB
8. COURSE CHALLENGE - Part 1.mp4 14.38 MB
8. COURSE CHALLENGE - Part 1.vtt 1.61 KB
8.1 93. Course-Challenge - Before solutions.xlsx.xlsx 505.49 KB
11
1. Introduction to the Case Study.mp4 26.73 MB
1. Introduction to the Case Study.vtt 2.39 KB
1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx 13.27 MB
10. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 36.4 MB
10. Combining Slicers and GETPIVOTDATA The Key to Our Success.vtt 3.32 KB
10.1 103. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx 20.77 MB
11. Getting Fancy with Excel Slicers.mp4 35.81 MB
11. Getting Fancy with Excel Slicers.vtt 3.3 KB
11.1 104. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx 22.82 MB
12. This is How the Report Can be Used in Practice by High-level Executives.mp4 40.84 MB
12. This is How the Report Can be Used in Practice by High-level Executives.vtt 4.57 KB
12.1 105. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx 22.81 MB
2. Working with an SAP Data Extraction.mp4 39.2 MB
2. Working with an SAP Data Extraction.vtt 3.65 KB
3. Preliminary Mapping of the Data Extraction.mp4 31.18 MB
3. Preliminary Mapping of the Data Extraction.vtt 2.45 KB
3.1 96. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx 14.89 MB
4. Creating an Output Structure of the FMCG Model.mp4 22.17 MB
4. Creating an Output Structure of the FMCG Model.vtt 2.53 KB
4.1 97. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx 14.91 MB
5. Improving the Layout and Appearance of the FMCG Report.mp4 27.14 MB
5. Improving the Layout and Appearance of the FMCG Report.vtt 4.03 KB
5.1 98. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx 14.91 MB
6. Inserting Formulas and Automating Calculations.mp4 18.09 MB
6. Inserting Formulas and Automating Calculations.vtt 2.44 KB
6.1 99. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx 14.91 MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 21.79 MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.vtt 2.01 KB
7.1 100. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.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.vtt 6.72 KB
8.1 101. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx 20.81 MB
9. GETPIVOTDATA fix.mp4 13.62 MB
9. GETPIVOTDATA fix.vtt 1.37 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.vtt 3.23 KB
1.1 Financial Modeling Notes.pdf.pdf 690.08 KB
1.2 106. Exercise-after.xlsx.xlsx 32.72 KB
1.3 106. Exerxise-before.xlsx.xlsx 18.74 KB
2. Let's Create a Mapping of Financials.mp4 30.73 MB
2. Let's Create a Mapping of Financials.vtt 2.81 KB
2.1 107. Exercise - after.xlsx.xlsx 34.24 KB
2.2 107. Exercise - before.xlsx.xlsx 30.45 KB
3. Building an Output P&L Sheet.mp4 30.55 MB
3. Building an Output P&L Sheet.vtt 4.02 KB
3.1 108. Exercise - before.xlsx.xlsx 32.36 KB
3.2 108. Exercise - after.xlsx.xlsx 41.48 KB
4. Filling in the Output P&L Sheet with Historical Financials.mp4 23.9 MB
4. Filling in the Output P&L Sheet with Historical Financials.vtt 2.86 KB
4.1 109. Exersice - after.xlsx.xlsx 41.26 KB
4.2 109. Exersice - before.xlsx.xlsx 37.63 KB
5. Calculating Percentage Variances and Applying Conditional Formatting.mp4 27.21 MB
5. Calculating Percentage Variances and Applying Conditional Formatting.vtt 3.23 KB
5.1 110. Exercise - after.xlsx.xlsx 41.73 KB
5.2 110. Exercise - before.xlsx.xlsx 39.27 KB
6. Building an Output Balance Sheet.mp4 29.48 MB
6. Building an Output Balance Sheet.vtt 3.75 KB
6.1 111. Exercise - before.xlsx.xlsx 47.5 KB
6.2 111. Exercise - after.xlsx.xlsx 54.43 KB
7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.mp4 43.48 MB
7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.vtt 5.25 KB
7.1 112. Exersice - before.xlsx.xlsx 49.8 KB
7.2 112. Exersise - after.xlsx.xlsx 57.11 KB
8. Adding the Forecast Period.mp4 32.15 MB
8. Adding the Forecast Period.vtt 3.81 KB
8.1 113. Exersice - after.xlsx.xlsx 54.95 KB
8.2 113. Exersice - before.xlsx.xlsx 50.28 KB
13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios
1.1 114. Exercise - aft.xlsx.xlsx 54.94 KB
1.2 114. Exercise - bef.xlsx.xlsx 52.8 KB
2. Building a Flexible Model with CHOOSE & MATCH.mp4 16.06 MB
2. Building a Flexible Model with CHOOSE & MATCH.vtt 1.71 KB
2.1 115. Exercise - after.xlsx.xlsx 54.67 KB
2.2 115. Exercise - before.xlsx.xlsx 53.08 KB
3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4 36.26 MB
3. Building a Flexible Model with VLOOKUP & COLUMNS.vtt 3.39 KB
3.1 116. Exercise - after.xlsx.xlsx 55.12 KB
3.2 116. Exercise - before.xlsx.xlsx 53.08 KB
4.1 117. Exercise before.xlsx.xlsx 53.56 KB
4.2 117. Exercise -after.xlsx.xlsx 56.6 KB
4.3 Working Capital Days.pdf.pdf 340.78 KB
4.4 Course notes - Building a financial model.pdf.pdf 575.23 KB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 30.53 MB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.vtt 3.27 KB
5.1 118. Exercise - before.xlsx.xlsx 54.64 KB
5.2 118. Exercise - after.xlsx.xlsx 57.67 KB
14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model
1. Building a Fixed Asset Roll Forward.mp4 40.93 MB
1. Building a Fixed Asset Roll Forward.vtt 4.56 KB
1.1 119. Exercise - before.xlsx.xlsx 55.75 KB
1.2 119. Exercise - after.xlsx.xlsx 62.08 KB
2. Building a Financial Liabilities Schedule.mp4 47.54 MB
2. Building a Financial Liabilities Schedule.vtt 5.75 KB
2.1 120. Exercise - after.xlsx.xlsx 67.56 KB
2.2 120. Exercise - before.xlsx.xlsx 58.9 KB
3. Building an Equity Schedule.mp4 36.56 MB
3. Building an Equity Schedule.vtt 4.39 KB
3.1 121. Exercise - before.xlsx.xlsx 58.9 KB
3.2 121. Exercise - after.xlsx.xlsx 69.54 KB
4. Preparing a Cash Flow Structure.mp4 15.2 MB
4. Preparing a Cash Flow Structure.vtt 2.25 KB
4.1 122. Exercise - after.xlsx.xlsx 70.35 KB
4.2 122. Exercise - before.xlsx.xlsx 65.6 KB
5. Calculating Cash Flows and Completing the Model.mp4 57.47 MB
5. Calculating Cash Flows and Completing the Model.vtt 7.06 KB
5.1 123. Exercise - before.xlsx.xlsx 67.69 KB
5.2 123. Exercise - after.xlsx.xlsx 72.59 KB
15. Accounting - Introduction to Accounting & Bookkeeping
1. Accounting The Science Behind Financial Figures.mp4 32.88 MB
1. Accounting The Science Behind Financial Figures.vtt 1.82 KB
1.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.2 MB
2. What is Accounting and Why Do You Need It.mp4 64.04 MB
2. What is Accounting and Why Do You Need It.vtt 6.13 KB
2.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.18 MB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 26.69 MB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.vtt 3.29 KB
4. An Introduction to Financial Accounting.mp4 31.94 MB
4. An Introduction to Financial Accounting.vtt 3.42 KB
4.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.18 MB
5. Quiz Number 3.html 147 B
16. Accounting - Types of Revenues, Costs, Assets, and Liabilities
1. The Different Types of Accounting Standards.mp4 21.66 MB
1. The Different Types of Accounting Standards.vtt 3.13 KB
1.1 The Complete Financial Analyst Course - Financial items.pdf.pdf 890.01 KB
10. Types of Liabilities.mp4 27.49 MB
10. Types of Liabilities.vtt 4.74 KB
11. Liability Categories - Practical Example.mp4 23.84 MB
11. Liability Categories - Practical Example.vtt 3.22 KB
12. Equity.mp4 15.02 MB
12. Equity.vtt 2.54 KB
13. Quiz Number 4.html 147 B
2. The Three Financial Statements.mp4 11.82 MB
2. The Three Financial Statements.vtt 2.35 KB
3. Types of Revenues.mp4 26.54 MB
3. Types of Revenues.vtt 2.98 KB
4. Types of Revenues - Exercise.mp4 18.61 MB
4. Types of Revenues - Exercise.vtt 2.43 KB
5. Types of Expenses.mp4 45.18 MB
5. Types of Expenses.vtt 6.68 KB
6. Income Taxes.mp4 17.9 MB
6. Income Taxes.vtt 2.31 KB
7. Depreciation & Amortization.mp4 40.12 MB
7. Depreciation & Amortization.vtt 5.27 KB
8. Types of Assets.mp4 31.77 MB
8. Types of Assets.vtt 4.34 KB
9. Asset Categories - Practical Example.mp4 29.13 MB
9. Asset Categories - Practical Example.vtt 4.25 KB
9.1 P-G-Financial-Report.pdf.pdf 4.4 MB
17. Accounting - Revenue Recognition
1. Accrual Accounting.mp4 13.65 MB
1. Accrual Accounting.vtt 2.02 KB
1.1 The Complete Financial Analyst Course - Revenue recognition.pdf.pdf 494.32 KB
2. Revenue Recognition Criteria - Technical.mp4 32.25 MB
2. Revenue Recognition Criteria - Technical.vtt 4.44 KB
3. Potential Conflicts of Interest When Recognizing Revenue.mp4 18.78 MB
3. Potential Conflicts of Interest When Recognizing Revenue.vtt 2.57 KB
4. A Practical Example.mp4 39.52 MB
4. A Practical Example.vtt 6.24 KB
18. Accounting - Cost Recognition
1. Technical Aspects of Cost Recognition.mp4 27.66 MB
1. Technical Aspects of Cost Recognition.vtt 3.15 KB
2. The Two Types of Income Statement Formats.mp4 7.28 MB
2. The Two Types of Income Statement Formats.vtt 1.51 KB
19. Accounting - Understanding the Big Picture Why, What, When, and How Much
1. The Revenue Recognition Principle - Why Is It So Important.mp4 24.37 MB
1. The Revenue Recognition Principle - Why Is It So Important.vtt 3.25 KB
2. The Expense Recognition Principle - When to Recognize Expenses.mp4 25.25 MB
2. The Expense Recognition Principle - When to Recognize Expenses.vtt 2.71 KB
2. Microsoft Excel - Quick Introduction
1. Microsoft Excel The World's #1 Office Software.mp4 22.03 MB
1. Microsoft Excel The World's #1 Office Software.vtt 1.12 KB
1.1 Introduction to Excel's basic features.pdf.pdf 2.26 MB
10. A Beginner's Introduction to Excel Functions.mp4 21.92 MB
10. A Beginner's Introduction to Excel Functions.vtt 3.65 KB
10.1 6. Functions- Lecture - Unsolved.xlsx.xlsx 9.24 KB
10.2 6. Functions-Exercise - Unsolved.xlsx.xlsx 13.26 KB
10.3 6. Functions- Exercise - Solved.xlsx.xlsx 81.1 KB
10.4 6. Functions - Lecture -Solved.xlsx.xlsx 9.34 KB
10.5 Introduction-to-Excels-basic-features.pdf.pdf 2.26 MB
11. Work Efficiently by Using Cut, Copy, and Paste.mp4 14.47 MB
11. Work Efficiently by Using Cut, Copy, and Paste.vtt 2.14 KB
11.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx 12.56 KB
11.2 Introduction-to-Excels-basic-features.pdf.pdf 2.26 MB
11.3 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx 11.34 KB
12. Work Efficiently by Using Cut, Copy, and Paste.html 147 B
13. Pasting Values, Formulas and Formats with Paste Special.mp4 10.97 MB
13. Pasting Values, Formulas and Formats with Paste Special.vtt 1.55 KB
13.1 Introduction-to-Excels-basic-features.pdf.pdf 2.26 MB
13.2 8. Paste-Special-Solved.xlsx.xlsx 13.46 KB
13.3 8. Paste-Special-Exercise-Text.xlsx.xlsx 13.47 KB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 22.74 MB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.vtt 3.53 KB
2.1 1. Introduction to Excel.pdf.pdf 2.27 MB
2.2 1. Overview-of-Excel-Exercise-Solved.xlsx.xlsx 10.88 KB
2.3 1. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx 10.47 KB
3. Data Entry Techniques in Excel.mp4 17.35 MB
3. Data Entry Techniques in Excel.vtt 3.07 KB
3.1 2. Data-Entry-Exercise - Unsolved.xlsx.xlsx 10.97 KB
3.2 2. Data-Entry - Lecture.xlsx.xlsx 8.07 KB
3.3 2. Data-Entry- Exercise -Solved.xlsx.xlsx 32.76 KB
4. How to Make Your Spreadsheets Look Professional.mp4 44.83 MB
4. How to Make Your Spreadsheets Look Professional.vtt 5.44 KB
4.1 3. Formatting- Exercise - Solved.xlsx.xlsx 11.59 KB
4.2 3. Formatting - Lecture - Solved.xlsx.xlsx 9.85 KB
4.3 3. Formatting- Lecture - Unsolved.xlsx.xlsx 8.91 KB
4.4 3. Formatting-Exercise - Unsolved.xlsx.xlsx 11.61 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.vtt 1.68 KB
6.1 4. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx 11.06 KB
6.2 4. Basic-Manipulations - Exercise - Solved.xlsx.xlsx 32.43 KB
6.3 4. Data Entry - Lecture.xlsx.xlsx 8.07 KB
7. Inserting, Deleting, and Modifying Rows & Columns.html 147 B
8. Excel Formulas for Beginners.mp4 14.46 MB
8. Excel Formulas for Beginners.vtt 2.89 KB
8.1 5. Formulas- Lecture - Unsolved.xlsx.xlsx 9.3 KB
8.2 5. Formulas- Exercise - Solved.xlsx.xlsx 80.13 KB
8.3 5. Formulas- Lecture - Solved.xlsx.xlsx 9.36 KB
8.4 5. Formulas - Exercise - Unsolved.xlsx.xlsx 11.72 KB
8.5 Introduction-to-Excels-basic-features.pdf.pdf 2.27 MB
9. Excel Formulas for Beginners.html 147 B
20. Accounting - The Core Principles of Accounting
1. The Accounting Equation and Its Importance.mp4 24.48 MB
1. The Accounting Equation and Its Importance.vtt 2.33 KB
2. Elements of the Accounting System General Ledger.mp4 16.09 MB
2. Elements of the Accounting System General Ledger.vtt 1.89 KB
3. T-Accounts The Best Way to Understand Debits and Credits.mp4 21.38 MB
3. T-Accounts The Best Way to Understand Debits and Credits.vtt 5.14 KB
4. P&L T-Accounts.mp4 13.32 MB
4. P&L T-Accounts.vtt 3.31 KB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 24.09 MB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.vtt 6.21 KB
6. Quiz Number 5.html 147 B
21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand
1.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
1.2 Exercise - Before Solutions.xlsx.xlsx 17.13 KB
1.3 Exercise Part One.xlsx.xlsx 17.44 KB
2.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
2.2 Exercise - Part Two.xlsx.xlsx 20.09 KB
3.1 Exercise - Part Three.xlsx.xlsx 19.29 KB
3.2 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
4.1 Exercise - Part Four.xlsx.xlsx 20.7 KB
4.2 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
21
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 68.36 MB
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).vtt 11.33 KB
1.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
1.2 Exercise - Before Solutions.xlsx.xlsx 17.13 KB
1.3 Exercise Part One.xlsx.xlsx 17.44 KB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 46.41 MB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).vtt 8.51 KB
2.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
2.2 Exercise - Part Two.xlsx.xlsx 20.09 KB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 53.35 MB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).vtt 7.87 KB
3.1 Exercise - Part Three.xlsx.xlsx 19.29 KB
3.2 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 58.94 MB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).vtt 7.47 KB
4.1 Exercise - Part Four.xlsx.xlsx 20.7 KB
4.2 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
22. Accounting - The Importance of Timing
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 13.23 MB
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.vtt 1.43 KB
2. Timing of Income Principles of Revenue Recognition.mp4 26.87 MB
2. Timing of Income Principles of Revenue Recognition.vtt 6.73 KB
3. Timing of Expenses Principles of Cost Recognition.mp4 15.8 MB
3. Timing of Expenses Principles of Cost Recognition.vtt 3.62 KB
4. The Four Type of Accruals Arising in Accounting Transactions.mp4 49.58 MB
4. The Four Type of Accruals Arising in Accounting Transactions.vtt 5.59 KB
5. Quiz Number 6.html 147 B
23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis
2. The Three Parts of Cash Flow Statements Explained.mp4 19.99 MB
2. The Three Parts of Cash Flow Statements Explained.vtt 2.6 KB
3. Cash Flow Computations - The Direct Method.mp4 19.72 MB
3. Cash Flow Computations - The Direct Method.vtt 2.48 KB
4. Cash Flow Computations - The Indirect Method.mp4 31.38 MB
4. Cash Flow Computations - The Indirect Method.vtt 4.33 KB
5. Calculating Cash Flow in Practice A Complete Example.mp4 50.62 MB
5. Calculating Cash Flow in Practice A Complete Example.vtt 7.73 KB
5.1 Cash-Flow.xlsx.xlsx 55.38 KB
23
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 27.66 MB
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.vtt 3.22 KB
2. The Three Parts of Cash Flow Statements Explained.mp4 19.99 MB
2. The Three Parts of Cash Flow Statements Explained.vtt 2.6 KB
3. Cash Flow Computations - The Direct Method.mp4 19.72 MB
3. Cash Flow Computations - The Direct Method.vtt 2.48 KB
4. Cash Flow Computations - The Indirect Method.mp4 31.38 MB
4. Cash Flow Computations - The Indirect Method.vtt 4.33 KB
5. Calculating Cash Flow in Practice A Complete Example.mp4 50.62 MB
5. Calculating Cash Flow in Practice A Complete Example.vtt 7.73 KB
5.1 Cash-Flow.xlsx.xlsx 55.38 KB
24. Advanced Accounting - Trade Receivables
1. Why a Company Needs to Pay Attention to Trade Receivables.mp4 25.22 MB
1. Why a Company Needs to Pay Attention to Trade Receivables.vtt 3.24 KB
1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf.pdf 706.56 KB
2. What If Clients Do Not Pay on Time.mp4 26.48 MB
2. What If Clients Do Not Pay on Time.vtt 4.12 KB
3. How to Handle Non-paying Customers A Case-study.mp4 24.94 MB
3. How to Handle Non-paying Customers A Case-study.vtt 3.1 KB
4. A Technique to Collect Trade Receivables Sooner.mp4 15.45 MB
4. A Technique to Collect Trade Receivables Sooner.vtt 2.32 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.vtt 3.26 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.vtt 3.14 KB
3. Cost Flow Methods.mp4 28.71 MB
3. Cost Flow Methods.vtt 5.53 KB
4. Cost Flow Methods - a Practical Exercise.mp4 6.74 MB
4. Cost Flow Methods - a Practical Exercise.vtt 1.27 KB
4.1 Inventory Cost Flow Methods_solved.xlsx.xlsx 12.38 KB
4.2 Inventory Cost Flow Methods – with solutions.pptx.pptx 174.96 KB
4.3 Inventory Cost Flow Methods.pptx.pptx 168.54 KB
4.4 Inventory Cost Flow Methods_unsolved.xlsx.xlsx 11.53 KB
26. Advanced Accounting - Fixed Assets
1. The Different Types of Fixed Assets.mp4 20.71 MB
1. The Different Types of Fixed Assets.vtt 3.84 KB
2. Capitalizing Interest Expenses.mp4 7.65 MB
2. Capitalizing Interest Expenses.vtt 2.23 KB
3. Fair Value Accounting.mp4 24.26 MB
3. Fair Value Accounting.vtt 2.94 KB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4 35.29 MB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.vtt 4.83 KB
5. The Revaluation Model.mp4 39.05 MB
5. The Revaluation Model.vtt 5.64 KB
6. The Revaluation Model - Practical Exercise.mp4 37.99 MB
6. The Revaluation Model - Practical Exercise.vtt 5.56 KB
7. Intangible Assets Created Internally.mp4 17.7 MB
7. Intangible Assets Created Internally.vtt 2.43 KB
27. Advanced Accounting - Trade Payables
1. How We Account for Trade Payables.mp4 22.54 MB
1. How We Account for Trade Payables.vtt 3.44 KB
2. What Is the Difference Between Accounts Payable and Notes Payable.mp4 10.89 MB
2. What Is the Difference Between Accounts Payable and Notes Payable.vtt 1.67 KB
3. Why Use E-invoicing.mp4 25.92 MB
3. Why Use E-invoicing.vtt 3.36 KB
28. Advanced Accounting - Financial Liabilities
1. The Difference Between Debt and Equity.mp4 14.81 MB
1. The Difference Between Debt and Equity.vtt 2.75 KB
2. Amortizing a Loan.mp4 20.65 MB
2. Amortizing a Loan.vtt 3.18 KB
3. Debt Covenants.mp4 25.79 MB
3. Debt Covenants.vtt 4.11 KB
4. Debt Covenants - A Practical Example.mp4 13.67 MB
4. Debt Covenants - A Practical Example.vtt 2.17 KB
29. Advanced Accounting - Leasing Liabilties
1. The Reason Companies Lease Assets.mp4 11.11 MB
1. The Reason Companies Lease Assets.vtt 1.51 KB
2. Solving a Complete Leasing Exercise.mp4 38.17 MB
2. Solving a Complete Leasing Exercise.vtt 5.2 KB
2.1 Leasing exercises.pdf.pdf 156.14 KB
2.2 Leasing Exercise 2 - Unsolved.xlsx.xlsx 9.63 KB
2.3 Leasing-Exercise-2-Solved.xlsx.xlsx 11.18 KB
3. Microsoft Excel - Useful Tools
1. Inserting a Line Break with Alt + Enter.mp4 6.18 MB
1. Inserting a Line Break with Alt + Enter.vtt 935 B
1.1 9. Alt-Enter-Exercise - Unsolved.xlsx.xlsx 11.12 KB
1.2 9. Alt-Enter- Lecture - Solved.xlsx.xlsx 9.65 KB
1.3 9. Alt-Enter-Exercise - Solved.xlsx.xlsx 11.4 KB
1.4 9. Alt-Enter- Lecture - Unsolved.xlsx.xlsx 9.64 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.vtt 2.05 KB
2.1 10. Text-to-columns-Lecture - Solved.xlsx.xlsx 9.9 KB
2.2 10. Text-to-Columns-Exercise - Solved.xlsx.xlsx 11.3 KB
2.3 10. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx 10.57 KB
2.4 10. Text-to-columns-Lecture - Unsolved.xlsx.xlsx 9.76 KB
3. Do More with Your Sales Data with Excel's Text to Columns Feature.html 147 B
4. Create Easily Printable Excel Documents.mp4 9.2 MB
4. Create Easily Printable Excel Documents.vtt 1.32 KB
4.1 11. Set-Print-Area-Lecture - Solved.xlsx.xlsx 11.22 KB
4.2 Useful-Tips-Tools.pdf.pdf 3.31 MB
4.3 11. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx 11.42 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.vtt 835 B
5.1 12. Wrap-text-Lecture - Solved.xlsx.xlsx 9.61 KB
5.2 12. Wrap-Text-Exercise - Unsolved.xlsx.xlsx 10.17 KB
5.3 12. Wrap-text-Lecture - Unsolved.xlsx.xlsx 9.61 KB
5.4 12. Wrap-Text-Exercise - Solved.xlsx.xlsx 10.2 KB
6. Insert Hyperlinks into Excel Spreadsheets.mp4 8.24 MB
6. Insert Hyperlinks into Excel Spreadsheets.vtt 1.25 KB
6.1 13. Hyperlinks-Exercise - Unsolved.xlsx.xlsx 136.89 KB
6.2 13. Hyperlinks-Exercise - Solved.xlsx.xlsx 137.06 KB
6.3 Useful-Tips-Tools.pdf.pdf 3.3 MB
7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 15.25 MB
7. Using Excel's Freeze Panes to Handle Large Datasets.vtt 1.27 KB
7.1 14. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx 643.87 KB
7.2 14. Freeze-Panes-Lecture - Solved.xlsx.xlsx 643.94 KB
7.3 Useful-Tips-Tools.pdf.pdf 3.31 MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 9.19 MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.vtt 953 B
8.1 Useful Tips & Tools.pdf.pdf 3.3 MB
9. A Quick Introduction to Excel's Pivot Tables.mp4 25.37 MB
9. A Quick Introduction to Excel's Pivot Tables.vtt 2.41 KB
9.1 21. Pivot tables - Lecture - Solved.xlsm.xlsm 897.26 KB
9.2 21. Pivot Tables - Exercise - Unsolved.xlsx.xlsx 152.17 KB
9.3 21. Pivot tables - Lecture - Unsolved.xlsm.xlsm 687.83 KB
9.4 21. Pivot Tables - Exercise - Solved.xlsx.xlsx 190.47 KB
9.5 Useful-Tips-Tools.pdf.pdf 3.3 MB
30. Advanced Accounting - Using Leverage
1. What is Leverage and Why Companies Use Financial Leverage.mp4 57.42 MB
1. What is Leverage and Why Companies Use Financial Leverage.vtt 5.36 KB
2. The Implications of Using Excessive Leverage.mp4 34.49 MB
2. The Implications of Using Excessive Leverage.vtt 4.06 KB
31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments
1. The Different Types of Equity.mp4 55.22 MB
1. The Different Types of Equity.vtt 4.71 KB
2. Raising Equity in Different Stages of a Company's Lifecycle.mp4 71.95 MB
2. Raising Equity in Different Stages of a Company's Lifecycle.vtt 7.11 KB
3. The Types of Dividends Companies Pay to Shareholders.mp4 44.87 MB
3. The Types of Dividends Companies Pay to Shareholders.vtt 4.23 KB
4. Dividend Payments - a Timeline.mp4 36.18 MB
4. Dividend Payments - a Timeline.vtt 3.52 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.vtt 3.89 KB
6. The Idea Behind Stock Splits.mp4 36.05 MB
6. The Idea Behind Stock Splits.vtt 3.64 KB
32. Financial Statement Analysis - An Introduction
1. What is a 10-K Report and Why Is It important for Investors.mp4 27.34 MB
1. What is a 10-K Report and Why Is It important for Investors.vtt 2.79 KB
2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 74.9 MB
2. Finding, Downloading and Going Through the Annual Report of P&G.vtt 7.12 KB
2.1 P&G Financial Report.pdf.pdf 4.41 MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 25.85 MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.vtt 2.78 KB
4. Indispensable Tools for Financial Statement Analysis.mp4 15.33 MB
4. Indispensable Tools for Financial Statement Analysis.vtt 1.5 KB
5. Quiz Number 7.html 147 B
33. Financial Statement Analysis - Subtleties
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 18.45 MB
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.vtt 2.22 KB
1.1 Financial Statement Analysis - Notes.pdf.pdf 772.86 KB
2. First Steps in Financial Statement Analysis.mp4 32.03 MB
2. First Steps in Financial Statement Analysis.vtt 3.6 KB
3. Horizontal vs. Vertical Financial Statement Analysis.mp4 28.21 MB
3. Horizontal vs. Vertical Financial Statement Analysis.vtt 4.03 KB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 11.85 MB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).vtt 1.52 KB
4.1 Working Capital Days.pdf.pdf 340.78 KB
5. Using Accounting Ratios to Assess Business Performance.mp4 36.8 MB
5. Using Accounting Ratios to Assess Business Performance.vtt 8.11 KB
6. Quiz Number 8.html 147 B
34
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 55.77 MB
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).vtt 6.71 KB
1.1 P&G Financials_Before.xlsx.xlsx 12.79 KB
1.2 P&G Financial Report.pdf.pdf 4.4 MB
1.3 P&G Financials.xlsx.xlsx 14.23 KB
1.4 P&G Financials_WithRatios.xlsx.xlsx 13.93 KB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 36.93 MB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).vtt 4.54 KB
2.1 P&G Financial Report.pdf.pdf 4.4 MB
2.2 P&G Financials.xlsx.xlsx 14.23 KB
2.3 P&G Financials_Before.xlsx.xlsx 12.79 KB
2.4 P&G Financials_WithRatios.xlsx.xlsx 13.93 KB
3. COURSE CHALLENGE - Part 2.mp4 18.75 MB
3. COURSE CHALLENGE - Part 2.vtt 1.92 KB
3.1 2. Course Challenge.xlsx.xlsx 627.6 KB
35. Financial Statement Analysis - Tesla Exercise
1. What You Will See Next In This Section.mp4 18.33 MB
1. What You Will See Next In This Section.vtt 1.33 KB
2. How to Download Tesla's Historical Financials.mp4 14.4 MB
2. How to Download Tesla's Historical Financials.vtt 2.62 KB
2.1 Tesla 2017.pdf.pdf 2.5 MB
2.2 Tesla 2015.pdf.pdf 1.29 MB
2.3 Tesla 2018 Q2.pdf.pdf 635.07 KB
2.4 Tesla 2016.pdf.pdf 2.21 MB
3. Calculating and Analyzing Growth and Profitability Ratios.mp4 96.5 MB
3. Calculating and Analyzing Growth and Profitability Ratios.vtt 10.95 KB
3.1 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx.xlsx 1.28 MB
3.2 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx.xlsx 1.28 MB
4. Calculating and Analyzing Liquidity Ratios.mp4 74.95 MB
4. Calculating and Analyzing Liquidity Ratios.vtt 7.38 KB
4.1 Tesla - Financial Statement Analysis - Liquidity_before.xlsx.xlsx 1.28 MB
4.2 Tesla - Financial Statement Analysis - Liquidity_after.xlsx.xlsx 1.28 MB
5. Calculating and Analyzing Solvency Ratios.mp4 20.03 MB
5. Calculating and Analyzing Solvency Ratios.vtt 1.98 KB
5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx.xlsx 1.28 MB
5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx.xlsx 1.28 MB
36. Working Capital Management
1. Introduction.mp4 23.42 MB
1. Introduction.vtt 3.32 KB
10. Symptoms of Inefficient Working Capital - Trade Payables.mp4 17.94 MB
10. Symptoms of Inefficient Working Capital - Trade Payables.vtt 2.62 KB
10.1 Working capital test_unsolved.xlsx.xlsx 12.7 KB
10.2 Working capital test_solved.xlsx.xlsx 13.58 KB
2. The Importance of Working Capital Optimization Case Study.mp4 89.97 MB
2. The Importance of Working Capital Optimization Case Study.vtt 10.16 KB
3. Overtrading vs. Excessive Investment.mp4 33.11 MB
3. Overtrading vs. Excessive Investment.vtt 4.07 KB
4. Trade Receivables Management.mp4 76.14 MB
4. Trade Receivables Management.vtt 9.93 KB
5. Re-order Level.mp4 31.31 MB
5. Re-order Level.vtt 3.72 KB
6. Economic Order Quantity (EOQ).mp4 31.85 MB
6. Economic Order Quantity (EOQ).vtt 4.86 KB
7. Inventory Optimization Techniques.mp4 50.48 MB
7. Inventory Optimization Techniques.vtt 6.18 KB
8. Trade Payables Management.mp4 19.27 MB
8. Trade Payables Management.vtt 2.45 KB
9. Working Capital Optimization - a Roadmap.mp4 48.18 MB
9. Working Capital Optimization - a Roadmap.vtt 5.97 KB
37. Fundamentals of Business & Financial Analysis
1. Fundamentals of Business & Financial Analysis.html 151 B
38. Finance 101 - The Time Value of Money and Interest Rate Components
1. Finance 101 Important Financial Principles That You Will Need.mp4 16.09 MB
1. Finance 101 Important Financial Principles That You Will Need.vtt 790 B
1.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
2. Understanding the Time Value of Money.mp4 6.23 MB
2. Understanding the Time Value of Money.vtt 1.58 KB
2.1 Time value of money.pdf.pdf 777.26 KB
2.2 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
3. How Interest Rates Play an Important Role in the Economy.mp4 13.75 MB
3. How Interest Rates Play an Important Role in the Economy.vtt 1.8 KB
3.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
4. The Components Forming Interest Rates in Real Life.mp4 16.63 MB
4. The Components Forming Interest Rates in Real Life.vtt 3.4 KB
4.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
4.2 Interest rate components.pdf.pdf 807.55 KB
5. What Is Libor and What Purpose Does It Serve.mp4 17.13 MB
5. What Is Libor and What Purpose Does It Serve.vtt 1.24 KB
5.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
6. The Difference Between Fixed and Variable Interest Rates.mp4 17.03 MB
6. The Difference Between Fixed and Variable Interest Rates.vtt 2.22 KB
6.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
7. What Is Default Risk and How Does a Bank Account For It.mp4 31.16 MB
7. What Is Default Risk and How Does a Bank Account For It.vtt 8.16 KB
7.1 Default risk.pdf.pdf 880.84 KB
7.2 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
8. Corporate Loan Specifics.mp4 25.76 MB
8. Corporate Loan Specifics.vtt 1.94 KB
8.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 689.77 KB
39. Finance 101 - The Value of Cash Flows with Different Timing
1. Calculating the Present Value of Future Cash Flows.mp4 29.79 MB
1. Calculating the Present Value of Future Cash Flows.vtt 5.49 KB
1.1 3.1 Present Value of Cash Flows.xlsx.xlsx 9.85 KB
1.2 1. Calculating Future Cash Flows.pdf.pdf 810.28 KB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 29.11 MB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.vtt 4.62 KB
2.1 2. NPV.pdf.pdf 192.19 KB
4. Microsoft Excel - Best Practices That Will Make a Difference
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 13.84 MB
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.vtt 2.15 KB
1.1 Useful-Tips-Tools.pdf.pdf 3.3 MB
1.2 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx 8.98 KB
1.3 17. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx 10.76 KB
1.4 17. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx 9.56 KB
1.5 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx 10.63 KB
10. Find and Select Cells That Meet Specific Conditions.mp4 13.45 MB
10. Find and Select Cells That Meet Specific Conditions.vtt 1.5 KB
10.1 23. Select-Special-F5-Exercise - Solved.xlsx.xlsx 22.27 KB
10.2 23. Select-Special-Lecture.xlsx.xlsx 10.56 KB
10.3 23. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx 21.59 KB
10.4 Useful-Tips-Tools.pdf.pdf 3.31 MB
11. Find and Select Cells That Meet Specific Conditions.html 147 B
12. How to Create Dynamic Names in Excel Spreadsheets.mp4 15.14 MB
12. How to Create Dynamic Names in Excel Spreadsheets.vtt 1.35 KB
12.1 24. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx 13.54 KB
12.2 24. Dynamic-Naming-Lecture - Solved.xlsx.xlsx 13.83 KB
12.3 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx 11.73 KB
12.4 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx 11.23 KB
12.5 Useful-Tips-Tools.pdf.pdf 3.3 MB
13. How to Create Dynamic Names in Excel Spreadsheets.html 147 B
14. Using Named Ranges to Make Formulas More Readable.mp4 9.11 MB
14. Using Named Ranges to Make Formulas More Readable.vtt 1.65 KB
14.1 25. Naming-ranges-Lecture - Unsolved.xlsx.xlsx 8.79 KB
14.2 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx 11.07 KB
14.3 25. Naming-ranges-Lecture - Solved.xlsx.xlsx 10.34 KB
14.4 Useful-Tips-Tools.pdf.pdf 3.3 MB
14.5 25. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx 11.65 KB
15. Custom Number Formatting.mp4 9.89 MB
15. Custom Number Formatting.vtt 1.56 KB
15.1 31. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx 11.35 KB
15.2 Useful-Tips-Tools.pdf.pdf 3.31 MB
15.3 31. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx 11.08 KB
16. How to Add a Drop-down List in Excel.mp4 16.29 MB
16. How to Add a Drop-down List in Excel.vtt 1.77 KB
16.1 27. Drop-down-List-Exercise - Unsolved.xlsx.xlsx 11.34 KB
16.2 27. Data-Validation-Lecture - Solved.xlsx.xlsx 10.84 KB
16.3 27. Data-Validation-Lecture - Unsolved.xlsx.xlsx 10.84 KB
16.4 27. Drop-down-List-Exercise - Solved.xlsx.xlsx 77.02 KB
17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 13.57 MB
17. Using Custom-sort to Sort Multiple Columns Within a Table.vtt 1.57 KB
17.1 28. Sort-data-Lecture - Solved.xlsx.xlsx 145.65 KB
17.2 28. Sort-data-Lecture - Unsolved.xlsx.xlsx 145.35 KB
17.3 28. Custom-Sort-Exercise - Unsolved.xlsx.xlsx 11.37 KB
17.4 Useful-Tips-Tools.pdf.pdf 3.31 MB
17.5 28. Custom-Sort-Exercise - Solved.xlsx.xlsx 11.46 KB
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 45.95 MB
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.vtt 4.42 KB
18.1 Useful-Tips-Tools.pdf.pdf 3.31 MB
18.2 29. Microsoft-Excel-Shortcuts-for-MAC.pdf.pdf 769.21 KB
18.3 29. Microsoft-Excel-Keyboard-Shortcuts.pdf.pdf 1.26 MB
19. Multiply by 1.mp4 14.83 MB
19. Multiply by 1.vtt 1.66 KB
19.1 30. Multiply-by-1-Lecture-before.xlsx.xlsx 16.47 KB
19.2 30. Multiply-by-1-Lecture-after.xlsx.xlsx 17.21 KB
2. Macros Are a Great Timesaver! Here's Why..mp4 21.41 MB
2. Macros Are a Great Timesaver! Here's Why..vtt 2.98 KB
2.1 18. Macros-Exercise - Unsolved.xlsx.xlsx 10.34 KB
2.2 18. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx 9.66 KB
2.3 18. Macros-Exercise - Solved.xlsx.xlsx 145.02 KB
2.4 Useful-Tips-Tools.pdf.pdf 3.31 MB
2.5 18. Creating-a-Macro-Lecture - Solved.xlsx.xlsx 11.17 KB
20. Find and Replace - References.mp4 24.06 MB
20. Find and Replace - References.vtt 3.3 KB
20.1 31. Find-and-Replace-references-Lecture-after.xlsx.xlsx 37.91 KB
20.2 31. Find-and-Replace-references-Lecture-before.xlsx.xlsx 38.79 KB
21. Find and Replace - Formatting.mp4 13.78 MB
21. Find and Replace - Formatting.vtt 1.84 KB
21.1 32. Find-replace-Lecture-after.xlsx.xlsx 17.19 KB
21.2 32. Find-replace-Lecture-before.xlsx.xlsx 17.19 KB
22. Green References.mp4 12.6 MB
22. Green References.vtt 1.71 KB
22.1 33. Green-references-Lecture.xlsx.xlsx 12 KB
23. Beauty Saving - The Professional Way of Saving Files.mp4 14.02 MB
23. Beauty Saving - The Professional Way of Saving Files.vtt 2.45 KB
23.1 34. Beauty-saving-Lecture-before.xlsx.xlsx 17.17 KB
23.2 34. Beauty-saving-Lecture-after.xlsx.xlsx 17.05 KB
24. The Power of F2.mp4 17.74 MB
24. The Power of F2.vtt 2.07 KB
24.1 43. F2-Lecture.xlsm.xlsm 49.9 KB
25. Conditional Formatting.mp4 58.7 MB
25. Conditional Formatting.vtt 5.62 KB
25.1 41. Conditional formatting - Lecture.xlsx.xlsx 41.73 KB
26. Quiz Number 1.html 147 B
3. How to Use the Same Macro On Multiple Workbooks.mp4 12.77 MB
3. How to Use the Same Macro On Multiple Workbooks.vtt 1.58 KB
3.1 19. How-to-save-macros-Lecture-after.xlsm.xlsm 12.59 KB
3.2 19. How-to-save-macros-Lecture-before.xlsx.xlsx 6.02 KB
3.3 19. Another-file.xlsx.xlsx 8.81 KB
4. Macros Are a Great Timesaver! Here's Why..html 147 B
5. The Secret to Faster Scrolling in Excel.mp4 20.84 MB
5. The Secret to Faster Scrolling in Excel.vtt 1.62 KB
5.1 Useful-Tips-Tools.pdf.pdf 3.31 MB
5.2 25. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx 43.9 KB
5.3 25. Fast-Scrolling-Exercise - Solved.xlsx.xlsx 44.35 KB
5.4 25. Fast-Scrolling - Lecture.xlsx.xlsx 642.82 KB
6. Be even quicker F5 + Enter.mp4 19.78 MB
6. Be even quicker F5 + Enter.vtt 2 KB
6.1 21. F5-go-to - Lecture.xlsm.xlsm 50.76 KB
7. The Secret to Faster Scrolling in Excel.html 147 B
8. Using Absolute and Relative Cell References.mp4 27.03 MB
8. Using Absolute and Relative Cell References.vtt 2.39 KB
8.1 22. Fixing-references-Lecture - Unsolved.xlsx.xlsx 643.98 KB
8.2 Useful-Tips-Tools.pdf.pdf 3.3 MB
8.3 22. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx 10.67 KB
8.4 22. Fixing-Cells-Exercise - Solved.xlsx.xlsx 10.82 KB
8.5 22. Fixing-references-Lecture - Solved.xlsx.xlsx 645.17 KB
9. Using Absolute and Relative Cell References.html 147 B
40. Finance 101 - Loan Calculations
1. Using Annuities.mp4 24.24 MB
1. Using Annuities.vtt 3.59 KB
2. Calculating a Complete Loan Schedule.mp4 49.62 MB
2. Calculating a Complete Loan Schedule.vtt 6.58 KB
3. COURSE CHALLENGE - Part 3.mp4 13.88 MB
3. COURSE CHALLENGE - Part 3.vtt 1.48 KB
3.1 3. Course Challenge.xlsx.xlsx 537.67 KB
41. Capital Budgeting - Basic Notions
1. What is Capital Budgeting.mp4 13.24 MB
1. What is Capital Budgeting.vtt 1.79 KB
2. When Do We Use Capital Budgeting.mp4 20.52 MB
2. When Do We Use Capital Budgeting.vtt 2.61 KB
3. The Time Value of Money in a Capital Budgeting Setting.mp4 18.9 MB
3. The Time Value of Money in a Capital Budgeting Setting.vtt 2.79 KB
4. Calculating Present and Future Value.mp4 37.5 MB
4. Calculating Present and Future Value.vtt 6.27 KB
5. Cost of Equity.mp4 55.84 MB
5. Cost of Equity.vtt 7.44 KB
6. Project-specific Beta.mp4 27.21 MB
6. Project-specific Beta.vtt 3.5 KB
7. The Weighted Average Cost of Capital (WACC).mp4 15.71 MB
7. The Weighted Average Cost of Capital (WACC).vtt 2.33 KB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 24.31 MB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.vtt 3.89 KB
9. Modeling Future Cash Flows.mp4 54.39 MB
9. Modeling Future Cash Flows.vtt 6.68 KB
42. Capital Budgeting - A Complete Case Study
1. An Introduction to the Case Study.mp4 25.3 MB
1. An Introduction to the Case Study.vtt 3.23 KB
10. Estimating Cost of Equity.mp4 40.38 MB
10. Estimating Cost of Equity.vtt 7.16 KB
10.1 8. WACC_unsolved.xlsx.xlsx 35.93 KB
10.2 8. WACC.xlsx.xlsx 38.03 KB
11. Discounting Project Cash Flows.mp4 25.9 MB
11. Discounting Project Cash Flows.vtt 3.61 KB
11.1 9. Discounted cash flow_unsolved.xlsx.xlsx 38.72 KB
11.2 9. Discounted cash flow.xlsx.xlsx 39.74 KB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 43.05 MB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.vtt 5.27 KB
12.1 Capital budgeting_exercise_unsolved.xlsx.xlsx 13.21 KB
12.2 Capital-budgeting-exercise-solved.xlsx.xlsx 42.75 KB
12.3 10. Sensitivity analysis_unsolved.xlsx.xlsx 39.7 KB
12.4 10. Sensitivity analysis.xlsx.xlsx 40.67 KB
2. Organizing Inputs In the Drivers Sheet.mp4 38.16 MB
2. Organizing Inputs In the Drivers Sheet.vtt 6.22 KB
2.1 1. Drivers.xlsx.xlsx 11.5 KB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4 34.74 MB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.vtt 4.12 KB
3.1 2. Savings Forecast_unsolved.xlsx.xlsx 14.74 KB
3.2 2. Savings Forecast.xlsx.xlsx 16.58 KB
4. Preparing a Fixed Asset Rollforward Schedule.mp4 47.36 MB
4. Preparing a Fixed Asset Rollforward Schedule.vtt 5.28 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 18.54 KB
4.2 3. Fixed Asset Rollforward.xlsx.xlsx 19.66 KB
5. Calculating the Cash Impact of Extra Working Capital Required.mp4 18.36 MB
5. Calculating the Cash Impact of Extra Working Capital Required.vtt 2.85 KB
5.1 4. Working Capital.xlsx.xlsx 21.93 KB
5.2 4. Working Capital_unsolved.xlsx.xlsx 21.19 KB
6. Debt Repayment and Interest Expenses Calculation.mp4 22.13 MB
6. Debt Repayment and Interest Expenses Calculation.vtt 3.3 KB
6.1 5. Financing_unsolved.xlsx.xlsx 29.99 KB
6.2 5. Financing.xlsx.xlsx 30.97 KB
7. The Project's P&L Sheet.mp4 13.93 MB
7. The Project's P&L Sheet.vtt 2.12 KB
7.1 6. P&L.xlsx.xlsx 31.03 KB
7.2 6. P&L_unsolved.xlsx.xlsx 29.7 KB
8. The Project's Cash Flow Calculation.mp4 30.84 MB
8. The Project's Cash Flow Calculation.vtt 3.7 KB
8.1 7. Cash flow_unsolved.xlsx.xlsx 29.64 KB
8.2 7. Cash flow.xlsx.xlsx 31.36 KB
9. Calculating WACC (Weighted Average Cost of Capital).mp4 18.52 MB
9. Calculating WACC (Weighted Average Cost of Capital).vtt 3.26 KB
9.1 8. WACC_unsolved.xlsx.xlsx 35.93 KB
9.2 8. WACC.xlsx.xlsx 38.03 KB
43. Tesla Practical Case Study - Building a Financial Planning Model
1. Organizing External Inputs in a 'Drivers' Sheet.mp4 31 MB
1. Organizing External Inputs in a 'Drivers' Sheet.vtt 4.27 KB
1.1 0a. Drivers_after.xlsx.xlsx 1.27 MB
1.2 0a. Drivers_before.xlsx.xlsx 1.27 MB
10. Forecasting 'Energy' and 'Services' Revenue.mp4 25.3 MB
10. Forecasting 'Energy' and 'Services' Revenue.vtt 2.99 KB
10.1 6. Energy and Other revenue - Before.xlsx.xlsx 1.34 MB
10.2 6. Energy and Other revenue - After.xlsx.xlsx 1.34 MB
11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 26.8 MB
11. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.vtt 2.36 KB
11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx 1.35 MB
11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx 1.35 MB
12. Forecasting Operating Expenses.mp4 34.91 MB
12. Forecasting Operating Expenses.vtt 5.15 KB
12.1 8. Opex - Before.xlsx.xlsx 1.36 MB
12.2 8. Opex - After.xlsx.xlsx 1.36 MB
13. Building a Fixed Asset Roll Forward Estimating Capex.mp4 56.51 MB
13. Building a Fixed Asset Roll Forward Estimating Capex.vtt 6.1 KB
13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx 1.37 MB
13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx 1.37 MB
14. Building a Fixed Asset Roll Forward D&A Schedule.mp4 54.15 MB
14. Building a Fixed Asset Roll Forward D&A Schedule.vtt 4.13 KB
14.1 10. PP&E schedule_before.xlsx.xlsx 1.37 MB
14.2 10. PP&E schedule_after.xlsx.xlsx 1.37 MB
15. Peer Comparison D&A as a Percentage of Revenues.mp4 13.63 MB
15. Peer Comparison D&A as a Percentage of Revenues.vtt 1.62 KB
15.1 10a. PP&E comparison.xlsx.xlsx 1.37 MB
16. Calculating DSO, DIO, DPO.mp4 17.51 MB
16. Calculating DSO, DIO, DPO.vtt 2.03 KB
16.1 11. Working capital forecasting_after.xlsx.xlsx 1.52 MB
16.2 11. Working capital forecasting_before.xlsx.xlsx 1.38 MB
17. Producing a Clean P&L Output Sheet.mp4 8.43 MB
17. Producing a Clean P&L Output Sheet.vtt 1.54 KB
17.1 12. P&L.xlsx.xlsx 1.39 MB
18. Fill in the P&L Output Sheet.mp4 18.36 MB
18. Fill in the P&L Output Sheet.vtt 1.74 KB
18.1 12a. P&L fill in_after.xlsx.xlsx 1.39 MB
18.2 12a. P&L fill in_before.xlsx.xlsx 1.39 MB
19. Calculating Investments in Working Capital.mp4 19.05 MB
19. Calculating Investments in Working Capital.vtt 2.09 KB
19.1 13. Calculating working capital_after.xlsx.xlsx 1.4 MB
19.2 13. Calculating working capital_before.xlsx.xlsx 1.4 MB
2. The Input Data We Will Work With.mp4 15.8 MB
2. The Input Data We Will Work With.vtt 1.57 KB
2.1 0aa. Inputs_after.xlsx.xlsx 1.28 MB
2.2 0aa. Inputs_before.xlsx.xlsx 1.28 MB
20. Forecasting Unlevered Free Cash Flow.mp4 55.98 MB
20. Forecasting Unlevered Free Cash Flow.vtt 5.79 KB
20.1 14. Cash flow - UFCF_before.xlsx.xlsx 1.41 MB
20.2 14. Cash flow - UFCF_after.xlsx.xlsx 1.41 MB
21. Forecasting Other Assets.mp4 45.3 MB
21. Forecasting Other Assets.vtt 4.33 KB
21.1 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.41 MB
21.2 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.41 MB
22. Forecasting Other Liabilities.mp4 22.05 MB
22. Forecasting Other Liabilities.vtt 2.39 KB
22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx 1.42 MB
22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx 1.41 MB
23. Completing Unlevered Free Cash Flow.mp4 40.89 MB
23. Completing Unlevered Free Cash Flow.vtt 3.35 KB
23.1 16a. Complete UFCF_before.xlsx.xlsx 1.42 MB
23.2 16a. Complete UFCF_after.xlsx.xlsx 1.42 MB
24. Modeling Tesla's Financing Needs in the Forecast Period.mp4 42.38 MB
24. Modeling Tesla's Financing Needs in the Forecast Period.vtt 5.04 KB
24.1 17. Financing_before.xlsx.xlsx 1.43 MB
24.2 17. Financing_after.xlsx.xlsx 1.43 MB
25. Calculating Net Income.mp4 14.79 MB
25. Calculating Net Income.vtt 1.29 KB
25.1 18. P&L complete_before.xlsx.xlsx 1.43 MB
25.2 18. P&L complete_after.xlsx.xlsx 1.43 MB
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 50.67 MB
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt 4.17 KB
26.1 19. Cash flow_complete_after.xlsx.xlsx 1.43 MB
26.2 19. Cash flow_complete_before.xlsx.xlsx 1.43 MB
27. Balancing the Balance Sheet.mp4 13.29 MB
27. Balancing the Balance Sheet.vtt 1.12 KB
27.1 20. Complete the BS_before.xlsx.xlsx 1.43 MB
27.2 20. Complete the BS_after.xlsx.xlsx 1.43 MB
3. Forecasting Tesla's Expected Deliveries.mp4 114.92 MB
3. Forecasting Tesla's Expected Deliveries.vtt 14.34 KB
3.1 1. Deliveries_after.xlsx.xlsx 1.29 MB
3.2 1. Deliveries_before.xlsx.xlsx 1.29 MB
4. Comparing Delivery Figures with the Ones of industry Peers.mp4 20.98 MB
4. Comparing Delivery Figures with the Ones of industry Peers.vtt 3.01 KB
4.1 1a. Deliveries development.xlsx.xlsx 1.3 MB
5. Estimating an Average Selling Price of Tesla Vehicles.mp4 41.93 MB
5. Estimating an Average Selling Price of Tesla Vehicles.vtt 4.78 KB
5.1 2. Average price_after.xlsx.xlsx 1.31 MB
5.2 2. Average price_before.xlsx.xlsx 1.31 MB
6. Calculating Automotive Revenue.mp4 46.56 MB
6. Calculating Automotive Revenue.vtt 4.79 KB
6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx 1.31 MB
6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx 1.31 MB
7. Peer Comparison Gross Profit %.mp4 17.19 MB
7. Peer Comparison Gross Profit %.vtt 2.59 KB
7.1 4. Gross profit automotive.xlsx.xlsx 1.32 MB
8. Calculating Automotive Gross Profit.mp4 27.78 MB
8. Calculating Automotive Gross Profit.vtt 2.83 KB
8.1 4a. Gross profit automotive - before.xlsx.xlsx 1.51 MB
8.2 4a. Gross profit automotive - after.xlsx.xlsx 1.32 MB
9. Calculating Automotive Cost of Sales.mp4 17.53 MB
9. Calculating Automotive Cost of Sales.vtt 2.14 KB
9.1 5. Cost of sales and chart.xlsx.xlsx 1.34 MB
44. PowerPoint - Introduction to PowerPoint
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 18.4 MB
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.vtt 1.04 KB
10. Changing an Object's Size and Rotation.mp4 11.23 MB
10. Changing an Object's Size and Rotation.vtt 2.06 KB
10.1 Resizing and Rotating Objects.pptx.pptx 1.23 MB
11. Using Slide Masters.mp4 22.4 MB
11. Using Slide Masters.vtt 5.11 KB
11.1 Slide Masters Presentation - example.pptx.pptx 43.49 KB
12. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 15.31 MB
12. Bring to Front and Send to Back - An Important PowerPoint Technique.vtt 3.22 KB
12.1 Bring to Front and Send to Back.pptx.pptx 1.23 MB
13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 27.65 MB
13. Learn How to Create, Edit, Resize and Format PowerPoint Tables.vtt 5.65 KB
13.1 Insert table.pptx.pptx 1.21 MB
2. General Considerations About Slide Structure.mp4 26.18 MB
2. General Considerations About Slide Structure.vtt 4.5 KB
2.1 Spacing-within-PowerPoint-chart.xlsx.xlsx 57.28 KB
2.2 Spacing within PowerPoint.pptx.pptx 1.86 MB
3. Learn How to Insert Objects in PowerPoint.mp4 31.96 MB
3. Learn How to Insert Objects in PowerPoint.vtt 4.5 KB
3.1 Insert objects.pptx.pptx 1.64 MB
3.2 Kinemax Data.xlsx.xlsx 36.41 KB
4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 16.63 MB
4. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.vtt 2.92 KB
4.1 PowerPoint Master Class - Shortcuts.pdf.pdf 440.4 KB
4.2 Power-Point-Master-Class-Shortcuts-For-Mac.pdf.pdf 532.42 KB
5. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 21.32 MB
5. Add Frequently Used Buttons to the Quick Access Toolbar.vtt 3.47 KB
5.1 Quick Access Toolbar buttons.pptx.pptx 1.24 MB
6. How to Easily Align Objects in PowerPoint.mp4 20.48 MB
6. How to Easily Align Objects in PowerPoint.vtt 4.61 KB
6.1 Align and Distribute objects in Ppt.pptx.pptx 1.25 MB
7. How to Edit Shapes in Your Presentation.mp4 26.23 MB
7. How to Edit Shapes in Your Presentation.vtt 5.61 KB
7.1 Format Shape Menu.pptx.pptx 634.21 KB
8. How to Format Text Boxes in a PowerPoint Presentation.mp4 19.95 MB
8. How to Format Text Boxes in a PowerPoint Presentation.vtt 4.08 KB
8.1 Working with text.pptx.pptx 772.99 KB
9. Practical Learning - Exercise 1.mp4 27.47 MB
9. Practical Learning - Exercise 1.vtt 4.15 KB
9.1 Practical Example - Organizing Notes.docx.docx 15.5 KB
9.2 Practical Example - Organizing Notes.pptx.pptx 1.23 MB
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.vtt 3.79 KB
1.1 Animation effects.pptx.pptx 1.21 MB
10. Practical Exercise - Creating an Organisational Chart.mp4 52.75 MB
10. Practical Exercise - Creating an Organisational Chart.vtt 7.06 KB
10.1 Practical Example.pptx.pptx 1.24 MB
10.2 List of executives.png.png 62.91 KB
10.3 Practical Example - completed.pptx.pptx 1.24 MB
11. COURSE CHALLENGE - Part 4.mp4 26 MB
11. COURSE CHALLENGE - Part 4.vtt 3.18 KB
11.1 4. Course Challenge.pptx.pptx 1.13 MB
11.2 Sending Files with Dropbox - YouTube Tutorial.html 104 B
11.3 4. Course Challenge - Tasks.pdf.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.vtt 2.02 KB
2.1 Line Begin and End type.pptx.pptx 1.23 MB
3. Join Shapes Together By Using Connector Lines.mp4 23.84 MB
3. Join Shapes Together By Using Connector Lines.vtt 4.75 KB
3.1 Connectors.pptx.pptx 1.22 MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4 8.27 MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.vtt 2.23 KB
4.1 Edit Points.pptx.pptx 1.21 MB
5. Group or Ungroup Shapes, Pictures or Other Objects.mp4 14.69 MB
5. Group or Ungroup Shapes, Pictures or Other Objects.vtt 2.15 KB
5.1 Group.pptx.pptx 1.22 MB
6. This is How You Can Fit Text When It Is Larger than a Shape.mp4 13.8 MB
6. This is How You Can Fit Text When It Is Larger than a Shape.vtt 2.43 KB
6.1 Internal Margins.pptx.pptx 1.22 MB
7. Nudge Objects.mp4 4.39 MB
7. Nudge Objects.vtt 1.3 KB
7.1 Nudge objects.pptx.pptx 1.22 MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 20.95 MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.vtt 4.12 KB
8.1 Smart Art.pptx.pptx 1.22 MB
9. Creating Eye-Catching Text Effects in PowerPoint.mp4 12.4 MB
9. Creating Eye-Catching Text Effects in PowerPoint.vtt 2.28 KB
9.1 Text effects.pptx.pptx 1.22 MB
46. Bonus Lecture
1. Bonus Lecture Next Steps.html 4.05 KB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions
1. Key Excel Functions IF.mp4 16.66 MB
1. Key Excel Functions IF.vtt 2.7 KB
1.1 37. IF-function--Lecture-before.xlsm.xlsm 17 KB
1.2 Functions - English to Spanish.pdf.pdf 102.37 KB
1.3 Functions - English to German.pdf.pdf 102.32 KB
1.4 Functions - English to Portuguese.pdf.pdf 146.09 KB
1.5 37. IF-function-Lecture-after.xlsm.xlsm 17.94 KB
10. Find the Highest and Lowest Values in a Range Max & Min.mp4 7.55 MB
10. Find the Highest and Lowest Values in a Range Max & Min.vtt 1.02 KB
10.1 44. Excel-functions.xlsx.xlsx 971.02 KB
10.2 44. MIN-MAX-Exercise - Solved.xlsx.xlsx 14.8 KB
10.3 44. Max-min-Lecture - Solved.xlsx.xlsx 9.23 KB
10.4 44. MIN-MAX-Exercise - Unsolved.xlsx.xlsx 14.39 KB
10.5 44. Max-min-Lecture - Unsolved.xlsx.xlsx 8.95 KB
10.6 Excel-Functions.pdf.pdf 3.18 MB
11. = and + are Interchangeable When You Start Typing a Formula.mp4 5.8 MB
11. = and + are Interchangeable When You Start Typing a Formula.vtt 874 B
11.1 45. Show-that-and-are-interchangeable-Lecture-before.xlsm.xlsm 17.01 KB
11.2 45. Show-that-and-are-interchangeable-Lecture-after.xlsm.xlsm 17.04 KB
12. Use ROUND in Your Financial Models.mp4 5.21 MB
12. Use ROUND in Your Financial Models.vtt 1.17 KB
12.1 51. Excel-functions-Lecture.xlsx.xlsx 889.91 KB
12.2 51. Round-Exercise - Solved.xlsx.xlsx 11.71 KB
12.3 Excel-Functions.pdf.pdf 3.18 MB
12.4 51. Round-Exercise - Unsolved.xlsx.xlsx 11.34 KB
13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 60.26 MB
13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.vtt 7.85 KB
13.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx 11.13 KB
13.2 47. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx 13.68 KB
13.3 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx 10.74 KB
13.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx 11.95 KB
13.5 Excel-Functions.pdf.pdf 3.18 MB
14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 61.77 MB
14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.vtt 7.67 KB
14.1 48. Index-Match-Exercise - Unsolved.xlsx.xlsx 11.59 KB
14.2 48. Index-Match-Lecture - Solved.xlsx.xlsx 11.7 KB
14.3 Excel-Functions.pdf.pdf 3.18 MB
14.4 48. Index-Match-Lecture - Unsolved.xlsx.xlsx 11.29 KB
14.5 48. Index-Match-Exercise - Solved.xlsx.xlsx 12.08 KB
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html 147 B
16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 11.75 MB
16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.vtt 1.95 KB
16.1 54. Iferror - Lecture - Solved.xlsm.xlsm 896.43 KB
16.2 54. Iferror-Exercise - Unsolved.xlsx.xlsx 14.26 KB
16.3 Excel-Functions.pdf.pdf 3.19 MB
16.4 54. Iferror - Lecture - Unsolved.xlsm.xlsm 897.26 KB
16.5 54. Iferror-Exercise - Solved.xlsx.xlsx 15.37 KB
17. A Useful Tool for Financial Analysis - The RANK Function.mp4 23.24 MB
17. A Useful Tool for Financial Analysis - The RANK Function.vtt 2.82 KB
17.1 50. Rank-function-Lecture-after.xlsx.xlsx 12.61 KB
17.2 50. Rank-function-Lecture-before.xlsx.xlsx 12.27 KB
18. Create Flexible Financial Models with CHOOSE.mp4 19.85 MB
18. Create Flexible Financial Models with CHOOSE.vtt 2.54 KB
18.1 51. Choose-Exercise-Solved.xlsx.xlsx 11.73 KB
18.2 Excel-Functions.pdf.pdf 3.18 MB
18.3 51. Choose-Exercise - Unsolved.xlsx.xlsx 11.32 KB
18.4 51. Choose-Lecture - Solved.xlsx.xlsx 9.69 KB
18.5 51. Choose-Lecture - Unsolved.xlsx.xlsx 9.33 KB
19. Goal Seek Will Help You Find the Result You Are Looking For.mp4 16.02 MB
19. Goal Seek Will Help You Find the Result You Are Looking For.vtt 2.44 KB
19.1 57. Goal-Seek-Exercise-Solved.xlsx.xlsx 16.21 KB
19.2 57. Goal-Seek-Lecture - Solved.xlsx.xlsx 9.17 KB
19.3 Excel-Functions.pdf.pdf 3.19 MB
19.4 57. Goal-Seek-Lecture - Unsolved.xlsx.xlsx 9.15 KB
19.5 57. Goal-Seek-Exercise - Unsolved.xlsx.xlsx 16.09 KB
2. Enlarge the Formula Bar.mp4 6.26 MB
2. Enlarge the Formula Bar.vtt 1.27 KB
2.1 38. Enlarge-the-formula-bar-Lecture.xlsm.xlsm 46.89 KB
20. Goal Seek Will Help You Find the Result You Are Looking For.html 147 B
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 26.22 MB
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.vtt 4.62 KB
21.1 58.Sensitivity-analysis-Exercise-Solved.xlsx.xlsx 62.28 KB
21.2 58. Sensitivity analysis - Lecture - Solved.xlsm.xlsm 897.3 KB
21.3 58.Sensitivity-analysis-Exercise_Unsolved.xlsx.xlsx 61.9 KB
21.4 58. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm 897.09 KB
22. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html 147 B
23. Quiz Number 2.html 147 B
3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4 30.68 MB
3. Key Excel Functions SUM, SUMIF, SUMIFS.vtt 4.28 KB
3.1 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx 14.84 KB
3.2 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx 14.46 KB
3.3 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx 12.93 KB
3.4 Excel-Functions.pdf.pdf 3.19 MB
3.5 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx 13.01 KB
4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 31.21 MB
4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.vtt 4 KB
4.1 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx 11.29 KB
4.2 40.Counts-Exercise-Solved.xlsx.xlsx 16.07 KB
4.3 Excel-Functions.pdf.pdf 3.19 MB
4.4 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx 11.68 KB
4.5 40.Counts-Exercise-Unsolved.xlsx.xlsx 15.56 KB
5. Key Excel Functions AVERAGE & AVERAGEIF.mp4 15.12 MB
5. Key Excel Functions AVERAGE & AVERAGEIF.vtt 2.15 KB
5.1 41. Average-Averageif- Lecture - Solved.xlsx.xlsx 9.4 KB
5.2 41. Average-AverageIF-Exercise - Solved.xlsx.xlsx 15.02 KB
5.3 41. Average-Averageif- Lecture - Unsolved.xlsx.xlsx 9.03 KB
5.4 Excel-Functions.pdf.pdf 3.18 MB
5.5 41. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx 14.6 KB
6. Key Excel Functions Average & Averageif.html 147 B
7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 30.41 MB
7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.vtt 5.09 KB
7.1 47. Text-Functions- Lecture - Solved.xlsx.xlsx 11.1 KB
7.2 47. Text functions - Exercise - Unsolved.xlsx.xlsx 11.71 KB
7.3 47. Text-Functions- Lecture - Unsolved.xlsx.xlsx 10.6 KB
7.4 47. Text functions - Exercise - Solved.xlsx.xlsx 12.24 KB
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html 147 B
9. Working with Text in Excel.mp4 16.02 MB
9. Working with Text in Excel.vtt 2.8 KB
9.1 43. Work-with-text-Lecture-after.xlsx.xlsx 10.91 KB
9.2 43. Work-with-text-Lecture-before.xlsx.xlsx 10.33 KB
6. Microsoft Excel - Financial Functions in Excel
1. Discounting Cash Flows in Microsoft Excel.mp4 45.68 MB
1. Discounting Cash Flows in Microsoft Excel.vtt 6.31 KB
1.1 54. FV and PV-Lecture.xlsx.xlsx 10.64 KB
2. Calculating Internal Rate of Return (IRR) in Excel.mp4 22.76 MB
2. Calculating Internal Rate of Return (IRR) in Excel.vtt 3.29 KB
2.1 55. IRR-Lecture.xlsx.xlsx 11.2 KB
3. Using the PMT Function to Create a Complete Loan Schedule.mp4 40.06 MB
3. Using the PMT Function to Create a Complete Loan Schedule.vtt 5.85 KB
3.1 56. Loan Schedule-Lecture.xlsx.xlsx 20.17 KB
4. Date Functions in Excel.mp4 30.8 MB
4. Date Functions in Excel.vtt 5.53 KB
4.1 57. Date Functions-Lecture.xlsx.xlsx 12.25 KB
7
1. Introduction to the Case Study.mp4 9.83 MB
1. Introduction to the Case Study.vtt 957 B
10. The Mapping Exercise.mp4 21.62 MB
10. The Mapping Exercise.vtt 1.93 KB
10.1 67. Mapping-Lecture-before.xlsm.xlsm 50.55 KB
10.2 67. Mapping-Lecture-after.xlsm.xlsm 50.5 KB
10.3 Mapping-exercise-explained.pdf.pdf 243.03 KB
11. Mapping the Rows in the Database Sheet.mp4 38.51 MB
11. Mapping the Rows in the Database Sheet.vtt 6.3 KB
11.1 Mapping-exercise-explained.pdf.pdf 243.03 KB
11.2 68. Mapping-Lecture-before.xlsm.xlsm 50.55 KB
11.3 68. Mapping-Lecture-after.xlsm.xlsm 50.5 KB
12. Building the Structure of the P&L Sheet.mp4 20.88 MB
12. Building the Structure of the P&L Sheet.vtt 2.5 KB
12.1 69. Building a P&L-Lecture-after.xlsm.xlsm 51.83 KB
12.2 69. Building a P&L-Lecture-before.xlsm.xlsm 50.24 KB
13. A Practical Example of Professional Formatting in Excel.mp4 25.42 MB
13. A Practical Example of Professional Formatting in Excel.vtt 3.49 KB
13.1 70 Formatting the P&L-Lecture-after.xlsm.xlsm 51.96 KB
13.2 70. Formatting a P&L-Lecture-before.xlsm.xlsm 51.84 KB
14. Populating the P&L Sheet with SUMIF.mp4 30.22 MB
14. Populating the P&L Sheet with SUMIF.vtt 2.99 KB
14.1 71. Formatting the P&L-Lecture-before.xlsm.xlsm 52 KB
14.2 71. Formatting the P&L-Lecture-after.xlsm.xlsm 53.51 KB
15. Learn How to Find Mistakes with COUNTIF.mp4 27.84 MB
15. Learn How to Find Mistakes with COUNTIF.vtt 2.8 KB
15.1 72. Countif-Lecture-before.xlsm.xlsm 53.51 KB
15.2 72. Countif-Lecture-after.xlsm.xlsm 54.78 KB
16. Calculating Growth Rates in Excel.mp4 29.98 MB
16. Calculating Growth Rates in Excel.vtt 3.32 KB
16.1 73. Adding % variations-Lecture-after.xlsm.xlsm 56.51 KB
16.2 Y-o-Y Function explanation.pdf.pdf 164.92 KB
16.3 73. Adding % variations-Lecture-before.xlsm.xlsm 54.78 KB
17. Quiz Number 3.html 147 B
2. What You Will See Next.mp4 10.21 MB
2. What You Will See Next.vtt 1.09 KB
3. Understand Your Data Source Before You Start Working on It.mp4 28.11 MB
3. Understand Your Data Source Before You Start Working on It.vtt 3.25 KB
3.1 60. Get to know the data source - Lecture.xlsm.xlsm 43.03 KB
4. Ordering the Source Worksheet.mp4 26.56 MB
4. Ordering the Source Worksheet.vtt 2.5 KB
4.1 61. Order a worksheet_after.xlsm.xlsm 41.01 KB
4.2 61. Order a worksheet_before.xlsm.xlsm 43.08 KB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 24.52 MB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.vtt 2.33 KB
5.1 62. Creating a code_before.xlsm.xlsm 41.01 KB
5.2 62. Creating a code_after.xlsm.xlsm 41.73 KB
6. Learn How to Create a Database.mp4 20.74 MB
6. Learn How to Create a Database.vtt 2.1 KB
6.1 63. Creating a database_after.xlsm.xlsm 39.39 KB
6.2 63. Creating a database_before.xlsm.xlsm 41.73 KB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 61.54 MB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.vtt 5.72 KB
7.1 64. Vlookup_after.xlsm.xlsm 44.45 KB
7.2 64. Vlookup_before.xlsm.xlsm 39.5 KB
8. Using SUMIF to Complete the Database Sheet.mp4 47.93 MB
8. Using SUMIF to Complete the Database Sheet.vtt 4.37 KB
8.1 65. Sumif_before.xlsm.xlsm 44.45 KB
8.2 65. Sumif_after.xlsm.xlsm 49.53 KB
9. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 49.65 MB
9. Using INDEX & MATCH as a Substitute for VLOOKUP.vtt 4.29 KB
9.1 66. Index Match-Lecture-after.xlsm.xlsm 13.86 MB
9.2 66. Index Match_before.xlsm.xlsm 41.02 KB
8. Microsoft Excel - Building Professional Charts in Excel
1. Introduction to Excel Charts.mp4 13 MB
1. Introduction to Excel Charts.vtt 1.22 KB
2. Beginner's Guide to Inserting Charts in Excel.mp4 22.26 MB
2. Beginner's Guide to Inserting Charts in Excel.vtt 2.68 KB
2.1 75. Inserting-Charts-Lecture.xlsm.xlsm 11.45 MB
3. Modifying Excel Charts - The Easy Way.mp4 26.04 MB
3. Modifying Excel Charts - The Easy Way.vtt 2.82 KB
3.1 76. Formatting-a-Chart-Lecture.xlsm.xlsm 11.45 MB
4. Making Your Excel Charts Sexier - Proven Tips.mp4 32.7 MB
4. Making Your Excel Charts Sexier - Proven Tips.vtt 3.27 KB
4.1 77. Modifying-a-Chart-Lecture.xlsm.xlsm 11.41 MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 13.65 MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.vtt 1.77 KB
5.1 78. Bridge-Charts-Lecture.xlsx.xlsx 13.1 KB
6. New Ways to Visualize Your Data - Treemap Charts.mp4 11.5 MB
6. New Ways to Visualize Your Data - Treemap Charts.vtt 1.58 KB
6.1 79. Treemap-Charts-Lecture.xlsx.xlsx 12.62 KB
7. How to Represent Trends with Sparklines.mp4 27.55 MB
7. How to Represent Trends with Sparklines.vtt 4.06 KB
7.1 80. Sparklines-Lecture.xlsx.xlsx 9.59 KB
9. Microsoft Excel - Creating Complete Professional Charts from Scratch
1. Introduction.mp4 6.21 MB
1. Introduction.vtt 643 B
2. Stacked Column Chart with a Secondary Axis.mp4 46.4 MB
2. Stacked Column Chart with a Secondary Axis.vtt 5.59 KB
2.1 82. Column stacked chart-Lecture-after.xlsm.xlsm 11.5 MB
2.2 82. Column stacked chart-Lecture-before.xlsm.xlsm 11.5 MB
3. Doughnut Chart.mp4 38.01 MB
3. Doughnut Chart.vtt 5.25 KB
3.1 83. Doughnut chart-Lecture-before.xlsm.xlsm 11.51 MB
3.2 83. Doughnut chart-Lecture-after.xlsm.xlsm 11.52 MB
4. Area Chart.mp4 28.59 MB
4. Area Chart.vtt 3.48 KB
4.1 84. Area chart-Lecture-before.xlsm.xlsm 11.52 MB
4.2 84. Area chart-Lecture-after.xlsm.xlsm 11.52 MB
5. Bridge Chart.mp4 52.07 MB
5. Bridge Chart.vtt 7.15 KB
5.1 85. Bridge chart-Lecture-after.xlsm.xlsm 11.53 MB
5.2 85.Bridge-chart-Lecture-before.xlsm.xlsm 11.47 MB
[Tutorialsplanet.NET].url 128 B

Description

Udemy - The Complete Financial Analyst Course 2019 [TP]

Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!

For more Udemy Courses: https://tutorialsplanet.net

Related Torrents

Tracker name
ahttp://0d.kebhana.mx:443/announce
udp://bigfoot1942.sektori.org:6969/announce
https://tracker.fastdownload.xyz:443/announce
https://opentracker.xyz:443/announce
http://open.trackerlist.xyz:80/announce
http://torrent.nwps.ws:80/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.tiny-vps.com:6969/announce
http://t.nyaatracker.com:80/announce
udp://tracker.birkenwald.de:6969/announce
udp://tracker.vanitycore.co:6969/announce
udp://tracker.torrent.eu.org:451/announce
udp://retracker.lanta-net.ru:2710/announce
udp://retracker.hotplug.ru:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.uw0.xyz:6969/announce
udp://exodus.desync.com:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://explodie.org:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.iamhansen.xyz:2000/announce
udp://tracker.toss.li:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.justseed.it:1337/announce
https://2.track.ga:443/announce
udp://open.stealth.si:80/announce
udp://zephir.monocul.us:6969/announce
udp://open.demonii.si:1337/announce
Torrent hash: 21B69B7EE2075CB1FAA3D1961E98D337C82D3B2C

0 Comment

Login to post comments