Torrent Info
Title [GigaCourse.Com] Udemy - The Complete Financial Analyst Course 2024
Category XXX
Size 11.72GB
Files List
Please note that this page does not hosts or makes available any of the listed filenames. You cannot download any of those files from here.
[CourseClub.Me].url 122B
[CourseClub.Me].url 122B
[CourseClub.Me].url 122B
[CourseClub.Me].url 122B
[CourseClub.Me].url 122B
[CourseClub.Me].url 122B
[GigaCourse.Com].url 49B
[GigaCourse.Com].url 49B
[GigaCourse.Com].url 49B
[GigaCourse.Com].url 49B
[GigaCourse.Com].url 49B
[GigaCourse.Com].url 49B
1.1 0. Drivers_after.xlsx 1.43MB
1.1 1. Calculating Future Cash Flows.pdf 810.28KB
1.1 106. Exercise-after.xlsx 32.72KB
1.1 114. Exercise - aft.xlsx 54.94KB
1.1 119. Exercise - after.xlsx 62.08KB
1.1 17. Formatting-a-Worksheet-Exercise - Solved.xlsx 10.76KB
1.1 2.1_source.xlsx 170.47KB
1.1 3.1_output.xlsx 17.18KB
1.1 37. IF-function--Lecture-before.xlsm 17.00KB
1.1 4.1_output.xlsx 62.00KB
1.1 5.1_output.xlsx 17.60KB
1.1 54. FV and PV-Lecture.xlsx 10.64KB
1.1 6.1_source.xlsx 11.43KB
1.1 7.1_output.xlsx 18.94KB
1.1 8.1 Free_Plan_Users_output.xlsx 146.04KB
1.1 9. Alt-Enter- Lecture - Solved.xlsx 9.65KB
1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx 13.27MB
1.1 Accounting & Financial Statement Analysis - Notes_UPDATE.pdf 670.17KB
1.1 Animation effects.pptx 1.21MB
1.1 Exercise - Before Solutions.xlsx 17.13KB
1.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
1.1 Financial Analyst - Course Curriculum.pdf 581.35KB
1.1 Financial Statement Analysis - Notes.pdf 772.86KB
1.1 Introduction to Excel's basic features.pdf 2.26MB
1.1 P-G-Annual_Report_2021.pdf 5.55MB
1.1 SUMIFS_Exercise_after.xlsx 1.21MB
1.1 The Complete Financial Analyst Course - Financial items.pdf 890.01KB
1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf 706.56KB
1.1 Who Does What in Finance - Infographic.pdf 1.22MB
1.2 0. Drivers_before.xlsx 1.42MB
1.2 106. Exerxise-before.xlsx 18.74KB
1.2 114. Exercise - bef.xlsx 52.80KB
1.2 119. Exercise - before.xlsx 55.75KB
1.2 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx 10.63KB
1.2 3.1_source.xlsx 15.50KB
1.2 3.1 Present Value of Cash Flows.xlsx 9.85KB
1.2 37. IF-function-Lecture-after.xlsm 17.94KB
1.2 4.1_source.xlsx 83.67KB
1.2 5.1_source.xlsx 17.10KB
1.2 7.1_source.xlsx 16.95KB
1.2 8.1_source.xlsx 169.40KB
1.2 9. Alt-Enter- Lecture - Unsolved.xlsx 9.64KB
1.2 Exercise Part One.xlsx 17.44KB
1.2 P-G-Financials-Before.xlsx 14.80KB
1.2 SUMIFS_Exercise_before.xlsx 1.21MB
1.2 Who Does What in Finance - Infographic.pdf 1.22MB
1.3 17. Formatting-a-worksheet-Lecture - Solved.xlsx 9.56KB
1.3 8.1_Transactions_output.xlsx 74.03KB
1.3 9. Alt-Enter-Exercise - Solved.xlsx 11.40KB
1.3 Financial Modeling Notes.pdf 690.08KB
1.3 Functions - English to German.pdf 102.32KB
1.3 P-G-Financials-With-Ratios.xlsx 15.67KB
1.3 Practical Exercise - List of transactions.pdf 182.53KB
1.3 Tesla Company Valuation - Detailed walkthrough.pdf 2.70MB
1.4 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx 8.98KB
1.4 9. Alt-Enter-Exercise - Unsolved.xlsx 11.12KB
1.4 Functions - English to Portuguese.pdf 146.09KB
1.5 Functions - English to Spanish.pdf 102.37KB
1.5 Useful-Tips-Tools.pdf 3.30MB
1. Accounting The Science Behind Financial Figures.mp4 54.02MB
1. Accounting The Science Behind Financial Figures.srt 2.00KB
1. Accrual Accounting.mp4 59.39MB
1. Accrual Accounting.srt 9.01KB
1. An Introduction to PowerPoint Animations.mp4 14.57MB
1. An Introduction to PowerPoint Animations.srt 5.06KB
1. An Introduction to the Case Study.mp4 22.35MB
1. An Introduction to the Case Study.srt 4.26KB
1. Assessment - Accounting.html 148B
1. Building a Fixed Asset Roll Forward.mp4 36.37MB
1. Building a Fixed Asset Roll Forward.srt 4.91KB
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 23.80MB
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt 4.36KB
1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.mp4 43.92MB
1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.srt 5.74KB
1. Calculating the Present Value of Future Cash Flows.mp4 46.83MB
1. Calculating the Present Value of Future Cash Flows.srt 6.11KB
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 55.60MB
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt 11.06KB
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 70.73MB
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt 14.77KB
1. Correcting Inverted Names.mp4 15.57MB
1. Correcting Inverted Names.srt 2.62KB
1. Cost recognition principles.mp4 22.65MB
1. Cost recognition principles.srt 4.10KB
1. COUNTIFS, SUMIFS.mp4 24.75MB
1. COUNTIFS, SUMIFS.srt 3.22KB
1. Discounting Cash Flows in Microsoft Excel.mp4 39.56MB
1. Discounting Cash Flows in Microsoft Excel.srt 7.18KB
1. Exploratory Data Analysis - Intro.mp4 57.15MB
1. Exploratory Data Analysis - Intro.srt 5.38KB
1. Finance 101 Important Financial Principles That You Will Need.mp4 26.57MB
1. Finance 101 Important Financial Principles That You Will Need.srt 852B
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 16.83MB
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt 3.03KB
1. Fundamentals of Business & Financial Analysis.html 151B
1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.mp4 28.52MB
1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.srt 2.94KB
1. How We Account for Trade Payables.mp4 19.90MB
1. How We Account for Trade Payables.srt 4.34KB
1. Identifying and Handling Erroneous Data.mp4 33.28MB
1. Identifying and Handling Erroneous Data.srt 4.48KB
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 21.23MB
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt 2.12KB
1. Inserting a Line Break with Alt + Enter.mp4 9.87MB
1. Inserting a Line Break with Alt + Enter.srt 1.04KB
1. Introduction.mp4 5.93MB
1. Introduction.mp4 22.25MB
1. Introduction.srt 826B
1. Introduction.srt 4.31KB
1. Introduction to Excel Charts.mp4 19.92MB
1. Introduction to Excel Charts.srt 1.35KB
1. Introduction to the Case Study.mp4 41.32MB
1. Introduction to the Case Study.mp4 9.54MB
1. Introduction to the Case Study.srt 2.79KB
1. Introduction to the Case Study.srt 1.29KB
1. Introduction to the Exercise.mp4 32.77MB
1. Introduction to the Exercise.srt 4.44KB
1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.mp4 39.78MB
1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.srt 6.34KB
1. Key Excel Functions IF.mp4 14.91MB
1. Key Excel Functions IF.srt 3.86KB
1. Microsoft Excel The World's #1 Office Software.mp4 36.31MB
1. Microsoft Excel The World's #1 Office Software.srt 1.25KB
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 30.45MB
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.srt 1.14KB
1. Next Steps.html 2.95KB
1. Obtain Day and Month From Date.mp4 27.54MB
1. Obtain Day and Month From Date.srt 3.46KB
1. Organize Messy Data.mp4 50.64MB
1. Organize Messy Data.srt 5.49KB
1. Organizing External Inputs in a 'Drivers' Sheet.mp4 35.09MB
1. Organizing External Inputs in a 'Drivers' Sheet.srt 5.74KB
1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 22.56MB
1. Pivot Tables - Excel's Dynamic and Interactive Tables.srt 2.35KB
1. Practical Exercise - SUMIFS.mp4 68.93MB
1. Practical Exercise - SUMIFS.srt 12.30KB
1. The Accounting Equation and Its Importance.mp4 15.03MB
1. The Accounting Equation and Its Importance.srt 3.25KB
1. The Difference Between Debt and Equity.mp4 13.13MB
1. The Difference Between Debt and Equity.srt 3.72KB
1. The Different Types of Accounting Standards.mp4 23.01MB
1. The Different Types of Accounting Standards.srt 4.53KB
1. The Different Types of Equity.mp4 53.43MB
1. The Different Types of Equity.srt 6.22KB
1. The Different Types of Fixed Assets.mp4 18.46MB
1. The Different Types of Fixed Assets.srt 5.14KB
1. The Different Types of Inventory We Can Have.mp4 23.95MB
1. The Different Types of Inventory We Can Have.srt 4.44KB
1. The Reason Companies Lease Assets.mp4 10.05MB
1. The Reason Companies Lease Assets.srt 2.08KB
1. The Revenue Recognition Principle - Why Is It So Important.mp4 23.21MB
1. The Revenue Recognition Principle - Why Is It So Important.srt 4.73KB
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 9.71MB
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.srt 1.79KB
1. Trend analysis - theory.html 1.99KB
1. Using Annuities.mp4 22.22MB
1. Using Annuities.srt 4.84KB
1. What Does the Course Cover.mp4 67.31MB
1. What Does the Course Cover.srt 10.07KB
1. What is a 10-K Report and Why Is It important for Investors.mp4 21.79MB
1. What is a 10-K Report and Why Is It important for Investors.srt 3.77KB
1. What is Capital Budgeting.mp4 12.32MB
1. What is Capital Budgeting.srt 2.32KB
1. What is Leverage and Why Companies Use Financial Leverage.mp4 53.54MB
1. What is Leverage and Why Companies Use Financial Leverage.srt 7.23KB
1. What You Will See Next In This Section.mp4 17.64MB
1. What You Will See Next In This Section.srt 1.86KB
1. Who Does What in the World of Finance.mp4 649.34MB
1. Who Does What in the World of Finance.srt 101.89KB
1. Why a Company Needs to Pay Attention to Trade Receivables.mp4 23.30MB
1. Why a Company Needs to Pay Attention to Trade Receivables.srt 4.52KB
10.1 43. Work-with-text-Lecture-after.xlsx 10.91KB
10.1 5. Time series_after.xlsx 63.43KB
10.1 6. Functions - Lecture -Solved.xlsx 9.34KB
10.1 66. Index Match_before.xlsm 41.02KB
10.1 7. Energy and Other gross profit_after.xlsx 1.49MB
10.1 8. WACC_unsolved.xlsx 35.93KB
10.1 List of executives.png 62.91KB
10.1 P-G-Annual_Report_2021.pdf 5.55MB
10.1 Practical Example - Organizing Notes.docx 15.50KB
10.1 Working capital test_solved.xlsx 13.58KB
10.2 43. Work-with-text-Lecture-before.xlsx 10.33KB
10.2 5. Time series_before.xlsx 58.64KB
10.2 6. Functions- Exercise - Solved.xlsx 81.10KB
10.2 66. Index Match-Lecture-after.xlsm 13.85MB
10.2 7. Energy and Other gross profit_before.xlsx 1.49MB
10.2 8. WACC.xlsx 38.03KB
10.2 Practical Example - completed.pptx 1.25MB
10.2 Practical Example - Organizing Notes.pptx 1.23MB
10.2 Working capital test_unsolved.xlsx 12.70KB
10.3 6. Functions- Lecture - Unsolved.xlsx 9.24KB
10.3 Practical Example.pptx 1.24MB
10.4 6. Functions-Exercise - Unsolved.xlsx 13.26KB
10.5 Introduction-to-Excels-basic-features.pdf 2.26MB
10. A Beginner's Introduction to Excel Functions.mp4 18.32MB
10. A Beginner's Introduction to Excel Functions.srt 4.41KB
10. Asset Categories - Practical Example.mp4 30.53MB
10. Asset Categories - Practical Example.srt 5.50KB
10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 23.85MB
10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.srt 3.78KB
10. Estimating Cost of Equity.mp4 36.02MB
10. Estimating Cost of Equity.srt 9.94KB
10. FAQ My GETPIVOTDATA Function Doesn't Work.html 647B
10. Practical Exercise - Creating an Organisational Chart.mp4 52.83MB
10. Practical Exercise - Creating an Organisational Chart.srt 9.48KB
10. Practical Learning - Exercise 1.mp4 27.48MB
10. Practical Learning - Exercise 1.srt 5.31KB
10. Symptoms of Inefficient Working Capital - Trade Payables.mp4 15.84MB
10. Symptoms of Inefficient Working Capital - Trade Payables.srt 3.52KB
10. Time series analysis.mp4 67.28MB
10. Time series analysis.srt 9.54KB
10. Using Absolute and Relative Cell References.html 147B
10. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 47.10MB
10. Using INDEX & MATCH as a Substitute for VLOOKUP.srt 5.42KB
10. Working with Text in Excel.mp4 13.37MB
10. Working with Text in Excel.srt 3.75KB
11.1 10. Format cells_after.xlsx 9.81KB
11.1 23. Select-Special-F5-Exercise - Solved.xlsx 22.27KB
11.1 4. Course Challenge - Tasks.pdf 283.02KB
11.1 44. Excel-functions.xlsx 971.02KB
11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx 20.78MB
11.1 8. Opex_after.xlsx 1.49MB
11.1 9. Discounted cash flow.xlsx 39.74KB
11.1 9a. XLOOKUP_after.xlsm 45.80KB
11.1 P-G-Annual_Report_2021.pdf 5.55MB
11.1 Resizing and Rotating Objects.pptx 1.23MB
11.2 10. Format cells_before.xlsx 9.81KB
11.2 23. Select-Special-F5-Exercise - Unsolved.xlsx 21.59KB
11.2 4. Course Challenge.pptx 1.13MB
11.2 44. Max-min-Lecture - Solved.xlsx 9.23KB
11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx 20.82MB
11.2 8. Opex_before.xlsx 1.49MB
11.2 9.Discounted-cash-flow-unsolved.xlsx 38.75KB
11.2 9a. XLOOKUP_before.xlsm 41.01KB
11.3 23. Select-Special-Lecture.xlsx 10.56KB
11.3 44. Max-min-Lecture - Unsolved.xlsx 8.95KB
11.3 Sending Files with Dropbox - YouTube Tutorial.html 104B
11.4 44. MIN-MAX-Exercise - Solved.xlsx 14.80KB
11.4 Useful-Tips-Tools.pdf 3.30MB
11.5 44. MIN-MAX-Exercise - Unsolved.xlsx 14.39KB
11.6 Excel-Functions.pdf 3.19MB
11. Changing an Object's Size and Rotation.mp4 11.24MB
11. Changing an Object's Size and Rotation.srt 2.78KB
11. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 33.61MB
11. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt 4.04KB
11. COURSE CHALLENGE - Part 4.mp4 41.79MB
11. COURSE CHALLENGE - Part 4.srt 3.52KB
11. Discounting Project Cash Flows.mp4 24.01MB
11. Discounting Project Cash Flows.srt 5.06KB
11. Find and Select Cells That Meet Specific Conditions.mp4 11.90MB
11. Find and Select Cells That Meet Specific Conditions.srt 1.81KB
11. Find the Highest and Lowest Values in a Range Max & Min.mp4 12.39MB
11. Find the Highest and Lowest Values in a Range Max & Min.srt 1.06KB
11. Forecasting Operating Expenses.mp4 27.45MB
11. Forecasting Operating Expenses.srt 6.24KB
11. Format Cells.mp4 30.97MB
11. Format Cells.srt 8.05KB
11. Liability Categories - Practical Example.mp4 29.72MB
11. Liability Categories - Practical Example.srt 5.37KB
11. Regression analysis - theory.html 4.85KB
11. Symptoms of Inefficient Working Capital - Trade Receivables.mp4 13.80MB
11. Symptoms of Inefficient Working Capital - Trade Receivables.srt 3.08KB
11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4 33.39MB
11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.srt 4.24KB
12. = and + are Interchangeable When You Start Typing a Formula.mp4 5.03MB
12. = and + are Interchangeable When You Start Typing a Formula.srt 1.27KB
12.1 10. Sensitivity analysis_unsolved.xlsx 39.70KB
12.1 45. Show-that-and-are-interchangeable-Lecture-after.xlsm 17.04KB
12.1 6.1 Regression analysis_after.xlsx 69.67KB
12.1 67. Mapping-Lecture-after.xlsm 50.50KB
12.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx 12.56KB
12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx 18.25MB
12.1 9. PP&E forecasting_after.xlsx 1.50MB
12.1 Slide Masters Presentation - example.pptx 43.49KB
12.2 10. Sensitivity analysis.xlsx 40.67KB
12.2 45. Show-that-and-are-interchangeable-Lecture-before.xlsm 17.01KB
12.2 6.1 Regression analysis_before.xlsx 68.55KB
12.2 67. Mapping-Lecture-before.xlsm 50.55KB
12.2 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx 11.34KB
12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx 20.78MB
12.2 9. PP&E forecasting_before.xlsx 1.50MB
12.3 6.2 Multiple regression analysis_after.xlsx 76.22KB
12.3 Capital budgeting_exercise_unsolved.xlsx 13.21KB
12.3 Introduction-to-Excels-basic-features.pdf 2.27MB
12.3 Mapping-exercise-explained.pdf 243.03KB
12.4 6.2 Multiple regression analysis_before.xlsx 74.80KB
12.4 Capital-budgeting-exercise-solved.xlsx 42.75KB
12. Building a Fixed Asset Roll Forward PP&E.mp4 32.74MB
12. Building a Fixed Asset Roll Forward PP&E.srt 6.07KB
12. Equity.mp4 15.05MB
12. Equity.srt 3.31KB
12. Find and Select Cells That Meet Specific Conditions.html 147B
12. Getting Fancy with Excel Slicers.mp4 32.41MB
12. Getting Fancy with Excel Slicers.srt 4.00KB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 41.98MB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt 7.32KB
12. Regression analysis.mp4 42.82MB
12. Regression analysis.srt 6.46KB
12. The Mapping Exercise.mp4 20.30MB
12. The Mapping Exercise.srt 2.74KB
12. Using Slide Masters.mp4 22.45MB
12. Using Slide Masters.srt 6.27KB
12. Work Efficiently by Using Cut, Copy, and Paste.mp4 12.50MB
12. Work Efficiently by Using Cut, Copy, and Paste.srt 2.64KB
13.1 10. Capex forecasting_after.xlsx 1.51MB
13.1 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx 11.73KB
13.1 51. Excel-functions-Lecture.xlsx 889.91KB
13.1 68. Mapping-Lecture-after.xlsm 50.50KB
13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx 22.82MB
13.1 Bring to Front and Send to Back.pptx 1.23MB
13.1 P-G-Annual_Report_2021.pdf 5.55MB
13.2 10. Capex forecasting_before.xlsx 1.50MB
13.2 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx 11.23KB
13.2 51. Round-Exercise - Solved.xlsx 11.71KB
13.2 68. Mapping-Lecture-before.xlsm 50.55KB
13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx 18.26MB
13.3 24. Dynamic-Naming-Lecture - Solved.xlsx 13.83KB
13.3 51. Round-Exercise - Unsolved.xlsx 11.34KB
13.3 Mapping-exercise-explained.pdf 243.03KB
13.4 24. Dynamic-Naming-Lecture - Unsolved.xlsx 13.54KB
13.4 Excel-Functions.pdf 3.19MB
13.5 Useful-Tips-Tools.pdf 3.31MB
13. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 15.30MB
13. Bring to Front and Send to Back - An Important PowerPoint Technique.srt 4.50KB
13. Building a Fixed Asset Roll Forward Estimating Capex.mp4 39.30MB
13. Building a Fixed Asset Roll Forward Estimating Capex.srt 5.47KB
13. Equity Categories - Practical Example.mp4 39.97MB
13. Equity Categories - Practical Example.srt 7.83KB
13. FAQ Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet.html 378B
13. How to Create Dynamic Names in Excel Spreadsheets.mp4 14.02MB
13. How to Create Dynamic Names in Excel Spreadsheets.srt 1.65KB
13. Mapping the Rows in the Database Sheet.mp4 36.27MB
13. Mapping the Rows in the Database Sheet.srt 8.33KB
13. This is How the Report Can be Used in Practice by High-level Executives.mp4 36.18MB
13. This is How the Report Can be Used in Practice by High-level Executives.srt 5.12KB
13. Use ROUND in Your Financial Models.mp4 8.48MB
13. Use ROUND in Your Financial Models.srt 1.20KB
13. Work Efficiently by Using Cut, Copy, and Paste.html 147B
14.1 11. D&A schedule_after.xlsx 1.51MB
14.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx 11.13KB
14.1 69. Building a P&L-Lecture-after.xlsm 51.83KB
14.1 8. Paste-Special-Exercise-Text.xlsx 13.47KB
14.1 Insert table.pptx 1.21MB
14.2 11. D&A schedule_before.xlsx 1.51MB
14.2 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx 10.74KB
14.2 69. Building a P&L-Lecture-before.xlsm 50.24KB
14.2 8. Paste-Special-Solved.xlsx 13.46KB
14.3 47. Vlookup-Hlookup-Exercise - Solved.xlsx 13.68KB
14.3 Introduction-to-Excels-basic-features.pdf 2.26MB
14.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx 11.95KB
14.5 Excel-Functions.pdf 3.19MB
14. Building a Fixed Asset Roll Forward D&A Schedule.mp4 34.02MB
14. Building a Fixed Asset Roll Forward D&A Schedule.srt 4.48KB
14. Building the Structure of the P&L Sheet.mp4 17.96MB
14. Building the Structure of the P&L Sheet.srt 3.07KB
14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 52.57MB
14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.srt 8.95KB
14. How to Create Dynamic Names in Excel Spreadsheets.html 147B
14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 27.64MB
14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt 7.44KB
14. Pasting Values, Formulas and Formats with Paste Special.mp4 9.71MB
14. Pasting Values, Formulas and Formats with Paste Special.srt 1.88KB
14. Quiz Number 4.html 147B
15.1 25. Defining-a-Named-Range-Exercise - Solved.xlsx 11.65KB
15.1 48. Index-Match-Exercise - Solved.xlsx 12.08KB
15.1 70 Formatting the P&L-Lecture-after.xlsm 51.96KB
15.2 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.07KB
15.2 48. Index-Match-Exercise - Unsolved.xlsx 11.59KB
15.2 70. Formatting a P&L-Lecture-before.xlsm 51.84KB
15.3 25. Naming-ranges-Lecture - Solved.xlsx 10.34KB
15.3 48. Index-Match-Lecture - Solved.xlsx 11.70KB
15.4 25. Naming-ranges-Lecture - Unsolved.xlsx 8.79KB
15.4 48. Index-Match-Lecture - Unsolved.xlsx 11.29KB
15.5 Excel-Functions.pdf 3.18MB
15.5 Useful-Tips-Tools.pdf 3.31MB
15. A Practical Example of Professional Formatting in Excel.mp4 23.17MB
15. A Practical Example of Professional Formatting in Excel.srt 4.43KB
15. Calculating DSO, DIO, DPO.mp4 16.67MB
15. Calculating DSO, DIO, DPO.srt 2.87KB
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 99.54MB
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt 8.59KB
15. Using Named Ranges to Make Formulas More Readable.mp4 7.65MB
15. Using Named Ranges to Make Formulas More Readable.srt 1.82KB
16.1 12. P&L_after.xlsx 1.54MB
16.1 19. Custom formatting_after.xlsx 10.75KB
16.1 71. Formatting the P&L-Lecture-after.xlsm 53.51KB
16.2 12. P&L_before.xlsx 1.54MB
16.2 19. Custom formatting_before.xlsx 10.69KB
16.2 71. Formatting the P&L-Lecture-before.xlsm 52.00KB
16. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html 147B
16. Introduction to Custom Formatting in Excel.mp4 40.94MB
16. Introduction to Custom Formatting in Excel.srt 9.30KB
16. Populating the P&L Sheet with SUMIF.mp4 29.18MB
16. Populating the P&L Sheet with SUMIF.srt 3.69KB
16. Producing a Clean P&L Output Sheet.mp4 14.47MB
16. Producing a Clean P&L Output Sheet.srt 2.01KB
17.1 13. Working capital_after.xlsx 1.55MB
17.1 31. Assigning Custom Formats - Exercise - Solved.xlsx 11.08KB
17.1 72. Countif-Lecture-after.xlsm 54.78KB
17.1 9. XLOOKUP_lecture_after.xlsm 18.95KB
17.2 13. Working capital_before.xlsx 1.54MB
17.2 31. Assigning Custom Formats - Exercise - Unsolved.xlsx 11.35KB
17.2 72. Countif-Lecture-before.xlsm 53.51KB
17.2 9. XLOOKUP_lecture_before.xlsm 18.77KB
17.3 Useful-Tips-Tools.pdf 3.30MB
17. Calculating Investments in Working Capital.mp4 18.69MB
17. Calculating Investments in Working Capital.srt 2.86KB
17. Custom Number Formatting.mp4 8.27MB
17. Custom Number Formatting.srt 1.98KB
17. Learn How to Find Mistakes with COUNTIF.mp4 27.58MB
17. Learn How to Find Mistakes with COUNTIF.srt 3.69KB
17. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).mp4 40.27MB
17. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).srt 10.41KB
18.1 14. Cash flow - UFCF_after.xlsx 1.56MB
18.1 27. Data-Validation-Lecture - Solved.xlsx 10.84KB
18.1 54. Iferror - Lecture - Solved.xlsm 896.43KB
18.1 73. Adding % variations-Lecture-after.xlsm 56.51KB
18.2 14. Cash flow - UFCF_before.xlsx 1.55MB
18.2 27. Data-Validation-Lecture - Unsolved.xlsx 10.84KB
18.2 54. Iferror - Lecture - Unsolved.xlsm 897.26KB
18.2 73. Adding % variations-Lecture-before.xlsm 54.78KB
18.3 27. Drop-down-List-Exercise - Solved.xlsx 77.02KB
18.3 54. Iferror-Exercise - Solved.xlsx 15.37KB
18.3 Y-o-Y Function explanation.pdf 164.92KB
18.4 27. Drop-down-List-Exercise - Unsolved.xlsx 11.34KB
18.4 54. Iferror-Exercise - Unsolved.xlsx 14.26KB
18.5 Excel-Functions.pdf 3.18MB
18. Calculating Growth Rates in Excel.mp4 28.30MB
18. Calculating Growth Rates in Excel.srt 4.21KB
18. Forecasting Unlevered Free Cash Flow.mp4 31.22MB
18. Forecasting Unlevered Free Cash Flow.srt 4.74KB
18. How to Add a Drop-down List in Excel.mp4 13.99MB
18. How to Add a Drop-down List in Excel.srt 2.32KB
18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 19.20MB
18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt 2.20KB
19.1 15. Balance sheet forecasting - assets_after.xlsx 1.55MB
19.1 28. Custom-Sort-Exercise - Solved.xlsx 11.46KB
19.1 50. Rank-function-Lecture-after.xlsx 12.61KB
19.2 15. Balance sheet forecasting - assets_before.xlsx 1.55MB
19.2 28. Custom-Sort-Exercise - Unsolved.xlsx 11.37KB
19.2 50. Rank-function-Lecture-before.xlsx 12.27KB
19.3 28. Sort-data-Lecture - Solved.xlsx 145.65KB
19.4 28. Sort-data-Lecture - Unsolved.xlsx 145.35KB
19.5 Useful-Tips-Tools.pdf 3.30MB
19. A Useful Tool for Financial Analysis - The RANK Function.mp4 20.14MB
19. A Useful Tool for Financial Analysis - The RANK Function.srt 3.89KB
19. Forecasting Other Assets.mp4 44.47MB
19. Forecasting Other Assets.srt 6.98KB
19. Quiz Number 3.html 147B
19. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 21.95MB
19. Using Custom-sort to Sort Multiple Columns Within a Table.srt 1.71KB
2.1 1. Deliveries_after.xlsx 1.44MB
2.1 1. Drivers.xlsx 11.50KB
2.1 1. Introduction to Excel.pdf 2.26MB
2.1 1. Trend analysis_after.xlsx 40.76KB
2.1 10. Text-to-Columns-Exercise - Solved.xlsx 11.30KB
2.1 107. Exercise - after.xlsx 34.24KB
2.1 115. Exercise - after.xlsx 54.67KB
2.1 120. Exercise - after.xlsx 67.56KB
2.1 18. Creating-a-Macro-Lecture - Solved.xlsx 11.17KB
2.1 2. NPV.pdf 192.19KB
2.1 3.2_output.xlsx 11.60KB
2.1 38. Enlarge-the-formula-bar-Lecture.xlsm 46.89KB
2.1 4.2_output.xlsx 14.30KB
2.1 5.2_output.xlsx 18.39KB
2.1 55. IRR-Lecture.xlsx 11.20KB
2.1 6.2_source.xlsx 12.36KB
2.1 7.2_output.xlsx 16.12KB
2.1 75. Inserting-Charts-Lecture.xlsm 11.45MB
2.1 82. Column stacked chart-Lecture-after.xlsm 11.50MB
2.1 87. Creating-a-Pivot-Table-Lecture.xlsx 1.43MB
2.1 Accounting & Financial Statement Analysis - Notes_UPDATE.pdf 670.17KB
2.1 Exercise - Part Two.xlsx 20.09KB
2.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
2.1 Introduction to PowerPoint.pdf 2.58MB
2.1 Leasing Exercise - Solved.xlsx 15.11KB
2.1 Line Begin and End type.pptx 1.23MB
2.1 P-G-Annual_Report_2021.pdf 5.55MB
2.1 P-G-Annual_Report_2021.pdf 5.55MB
2.1 Quick win.xlsx 9.74KB
2.1 Tesla 2015.pdf 1.29MB
2.2 1. Deliveries_before.xlsx 1.43MB
2.2 1. Overview-of-Excel-Exercise-Solved.xlsx 10.88KB
2.2 1. Trend analysis_before.xlsx 32.83KB
2.2 10. Text-to-Columns-Exercise - Unsolved.xlsx 10.57KB
2.2 107. Exercise - before.xlsx 30.45KB
2.2 115. Exercise - before.xlsx 53.08KB
2.2 120. Exercise - before.xlsx 58.90KB
2.2 18. Creating-a-Macro-Lecture - Unsolved.xlsx 9.66KB
2.2 3.2_source.xlsx 16.18KB
2.2 4.2_source.xlsx 9.29KB
2.2 5.2_source.xlsx 17.38KB
2.2 7.2_source.xlsx 14.21KB
2.2 82. Column stacked chart-Lecture-before.xlsm 11.51MB
2.2 Leasing Exercise - Unsolved.xlsx 9.63KB
2.2 P-G-Financials-Before.xlsx 14.65KB
2.2 Practical Exercise - List of transactions.pdf 182.53KB
2.2 Tesla 2016.pdf 2.22MB
2.2 Time value of money.pdf 777.26KB
2.3 1. Overview-of-Excel-Exercise-Unsolved.xlsx 10.47KB
2.3 10. Text-to-columns-Lecture - Solved.xlsx 9.90KB
2.3 18. Macros-Exercise - Solved.xlsx 145.02KB
2.3 Leasing exercise_lecture.xlsx 14.04KB
2.3 P-G-Financials-With-Ratios.xlsx 15.75KB
2.3 Tesla 2017.pdf 2.50MB
2.4 10. Text-to-columns-Lecture - Unsolved.xlsx 9.76KB
2.4 18. Macros-Exercise - Unsolved.xlsx 10.34KB
2.4 Tesla 2018.pdf 3.48MB
2.5 Tesla 2019.pdf 2.37MB
2.5 Useful-Tips-Tools.pdf 3.31MB
2. Amortizing a Loan.mp4 18.18MB
2. Amortizing a Loan.srt 4.29KB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 45.90MB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.srt 5.11KB
2. Beginner's Guide to Inserting Charts in Excel.mp4 36.21MB
2. Beginner's Guide to Inserting Charts in Excel.srt 2.76KB
2. Building a Financial Liabilities Schedule.mp4 41.85MB
2. Building a Financial Liabilities Schedule.srt 6.20KB
2. Building a Flexible Model with CHOOSE & MATCH.mp4 13.93MB
2. Building a Flexible Model with CHOOSE & MATCH.srt 1.79KB
2. Calculating a Complete Loan Schedule.mp4 44.72MB
2. Calculating a Complete Loan Schedule.srt 9.13KB
2. Calculating Internal Rate of Return (IRR) in Excel.mp4 19.85MB
2. Calculating Internal Rate of Return (IRR) in Excel.srt 3.79KB
2. Capitalizing Interest Expenses.mp4 7.05MB
2. Capitalizing Interest Expenses.srt 3.25KB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 32.47MB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt 7.36KB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 43.96MB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt 10.96KB
2. Converting Hours to Decimals.mp4 9.87MB
2. Converting Hours to Decimals.srt 2.14KB
2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 29.41MB
2. Creating a Pivot Table Choosing Row and Column Parameters.srt 5.28KB
2. Data Lookup.mp4 26.32MB
2. Data Lookup.srt 3.81KB
2. Data Mapping.mp4 23.04MB
2. Data Mapping.srt 3.68KB
2. Dealing with Trailing and Leading Spaces in Text Data.mp4 17.89MB
2. Dealing with Trailing and Leading Spaces in Text Data.srt 2.73KB
2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 11.74MB
2. Do More with Your Sales Data with Excel's Text to Columns Feature.srt 2.48KB
2. Elements of the Accounting System General Ledger.mp4 14.53MB
2. Elements of the Accounting System General Ledger.srt 2.54KB
2. Enlarge the Formula Bar.mp4 5.71MB
2. Enlarge the Formula Bar.srt 1.71KB
2. Everything We Will Learn Has a Practical Application.mp4 41.78MB
2. Everything We Will Learn Has a Practical Application.srt 4.06KB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 17.54MB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.srt 4.84KB
2. Extracting Descriptive Statistics with ChatGPT.mp4 19.32MB
2. Extracting Descriptive Statistics with ChatGPT.srt 2.82KB
2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 77.51MB
2. Finding, Downloading and Going Through the Annual Report of P&G.srt 11.07KB
2. First Steps in Financial Statement Analysis.mp4 25.61MB
2. First Steps in Financial Statement Analysis.srt 4.49KB
2. Forecasting Tesla's Expected Deliveries.mp4 103.40MB
2. Forecasting Tesla's Expected Deliveries.srt 18.71KB
2. How to Download Tesla's Historical Financials.mp4 16.65MB
2. How to Download Tesla's Historical Financials.srt 3.96KB
2. Let's Create a Mapping of Financials.mp4 27.18MB
2. Let's Create a Mapping of Financials.srt 3.02KB
2. Macros Are a Great Timesaver! Here's Why..mp4 33.56MB
2. Macros Are a Great Timesaver! Here's Why..srt 3.46KB
2. Modifying the Beginning and Ending of a Line Object.mp4 10.17MB
2. Modifying the Beginning and Ending of a Line Object.srt 2.80KB
2. Organizing Inputs In the Drivers Sheet.mp4 31.99MB
2. Organizing Inputs In the Drivers Sheet.srt 8.09KB
2. Preprocessing the 'Free plan users' Sheet (12).mp4 64.71MB
2. Preprocessing the 'Free plan users' Sheet (12).srt 9.46KB
2. Raising Equity in Different Stages of a Company's Lifecycle.mp4 67.96MB
2. Raising Equity in Different Stages of a Company's Lifecycle.srt 9.86KB
2. Revenue Recognition Criteria - Technical.mp4 39.73MB
2. Revenue Recognition Criteria - Technical.srt 6.08KB
2. Solving a Complete Leasing Exercise.mp4 40.12MB
2. Solving a Complete Leasing Exercise.srt 9.27KB
2. Stacked Column Chart with a Secondary Axis.mp4 41.26MB
2. Stacked Column Chart with a Secondary Axis.srt 7.27KB
2. Technical Aspects of Cost Recognition.mp4 23.19MB
2. Technical Aspects of Cost Recognition.srt 4.95KB
2. The Connection Between Cost of Goods Sold and Inventory.mp4 14.50MB
2. The Connection Between Cost of Goods Sold and Inventory.srt 4.26KB
2. The Expense Recognition Principle - When to Recognize Expenses.mp4 22.64MB
2. The Expense Recognition Principle - When to Recognize Expenses.srt 4.10KB
2. The Implications of Using Excessive Leverage.mp4 32.13MB
2. The Implications of Using Excessive Leverage.srt 5.50KB
2. The Importance of Working Capital Optimization Case Study.mp4 80.70MB
2. The Importance of Working Capital Optimization Case Study.srt 14.34KB
2. The Limitations of ChatGPT Advanced Data Analysis.mp4 47.93MB
2. The Limitations of ChatGPT Advanced Data Analysis.srt 4.29KB
2. The Structure of the PowerPoint Ribbon.mp4 27.68MB
2. The Structure of the PowerPoint Ribbon.srt 7.29KB
2. The Three Financial Statements.mp4 19.14MB
2. The Three Financial Statements.srt 3.41KB
2. The Three Parts of Cash Flow Statements Explained.mp4 23.32MB
2. The Three Parts of Cash Flow Statements Explained.srt 3.81KB
2. Timing of Income Principles of Revenue Recognition.mp4 44.60MB
2. Timing of Income Principles of Revenue Recognition.srt 8.86KB
2. Trend analysis.mp4 70.31MB
2. Trend analysis.srt 8.97KB
2. Understanding the Time Value of Money.mp4 9.65MB
2. Understanding the Time Value of Money.srt 1.74KB
2. Verifying Data for Errors.mp4 36.79MB
2. Verifying Data for Errors.srt 4.57KB
2. What If Clients Do Not Pay on Time.mp4 24.36MB
2. What If Clients Do Not Pay on Time.srt 5.47KB
2. What is Accounting and Why Do You Need It.mp4 45.80MB
2. What is Accounting and Why Do You Need It.srt 8.68KB
2. What Is the Difference Between Accounts Payable and Notes Payable.mp4 9.60MB
2. What Is the Difference Between Accounts Payable and Notes Payable.srt 2.26KB
2. What You Will See Next.mp4 9.73MB
2. What You Will See Next.srt 1.49KB
2. When Do We Use Capital Budgeting.mp4 19.21MB
2. When Do We Use Capital Budgeting.srt 3.48KB
2. Working with an SAP Data Extraction.mp4 36.99MB
2. Working with an SAP Data Extraction.srt 4.48KB
20.1 15a. Balance sheet forecasting - liabilities_after.xlsx 1.55MB
20.1 29. Microsoft-Excel-Keyboard-Shortcuts.pdf 1.26MB
20.1 51. Choose-Exercise - Unsolved.xlsx 11.32KB
20.2 15a. Balance sheet forecasting - liabilities_before.xlsx 1.55MB
20.2 29. Microsoft-Excel-Shortcuts-for-MAC.pdf 769.21KB
20.2 51. Choose-Exercise-Solved.xlsx 11.73KB
20.3 51. Choose-Lecture - Solved.xlsx 9.69KB
20.3 Useful-Tips-Tools.pdf 3.31MB
20.4 51. Choose-Lecture - Unsolved.xlsx 9.33KB
20.5 Excel-Functions.pdf 3.18MB
20. Create Flexible Financial Models with CHOOSE.mp4 32.00MB
20. Create Flexible Financial Models with CHOOSE.srt 2.76KB
20. Forecasting Other Liabilities.mp4 20.11MB
20. Forecasting Other Liabilities.srt 2.97KB
20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 41.91MB
20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt 5.03KB
21.1 16. Complete UFCF_after.xlsx 1.55MB
21.1 30. Multiply-by-1-Lecture-after.xlsx 17.21KB
21.1 57. Goal-Seek-Exercise - Unsolved.xlsx 16.09KB
21.2 16. Complete UFCF_before.xlsx 1.55MB
21.2 30.+Multiply-by-1-Lecture_before.xlsx 16.48KB
21.2 57. Goal-Seek-Exercise-Solved.xlsx 16.21KB
21.3 57. Goal-Seek-Lecture - Solved.xlsx 9.17KB
21.4 57. Goal-Seek-Lecture - Unsolved.xlsx 9.15KB
21.5 Excel-Functions.pdf 3.18MB
21. Completing Unlevered Free Cash Flow.mp4 66.81MB
21. Completing Unlevered Free Cash Flow.srt 8.12KB
21. Goal Seek Will Help You Find the Result You Are Looking For.mp4 25.39MB
21. Goal Seek Will Help You Find the Result You Are Looking For.srt 2.73KB
21. Multiply by 1.mp4 13.73MB
21. Multiply by 1.srt 2.35KB
22.1 17. Financing_after.xlsx 1.55MB
22.1 31. Find-and-Replace-references-Lecture-after.xlsx 37.91KB
22.2 17. Financing_before.xlsx 1.55MB
22.2 31. Find-and-Replace-references-Lecture-before.xlsx 38.79KB
22. Find and Replace - References.mp4 21.94MB
22. Find and Replace - References.srt 4.53KB
22. Goal Seek Will Help You Find the Result You Are Looking For.html 147B
22. Modeling Tesla's Financing Needs in the Forecast Period.mp4 38.83MB
22. Modeling Tesla's Financing Needs in the Forecast Period.srt 6.71KB
23.1 18. P&L complete_after.xlsx 1.55MB
23.1 58. Sensitivity analysis - Lecture - Solved.xlsm 897.30KB
23.2 18. P&L complete_before.xlsx 1.55MB
23.2 58. Sensitivity analysis - Lecture - Unsolved.xlsm 897.09KB
23.3 58.Sensitivity-analysis-Exercise_Unsolved.xlsx 61.90KB
23.4 58.Sensitivity-analysis-Exercise-Solved.xlsx 62.28KB
23. Calculating Net Income.mp4 13.81MB
23. Calculating Net Income.srt 1.79KB
23. FAQ Why Do We Replace External References and How Does This Help Us.html 702B
23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 41.74MB
23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.srt 5.23KB
24.1 19. Net cash flow_after.xlsx 1.56MB
24.1 32. Find-replace-Lecture-after.xlsx 17.19KB
24.2 19. Net cash flow_before.xlsx 1.55MB
24.2 32. Find-replace-Lecture-before.xlsx 17.19KB
24. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 40.56MB
24. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt 5.02KB
24. Find and Replace - Formatting.mp4 12.55MB
24. Find and Replace - Formatting.srt 2.41KB
24. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html 147B
25.1 20. Complete the BS_after.xlsx 1.56MB
25.1 33. Green-references-Lecture.xlsx 12.00KB
25.2 20. Complete the BS_before.xlsx 1.56MB
25. Balancing the Balance Sheet.mp4 11.92MB
25. Balancing the Balance Sheet.srt 1.49KB
25. Green References.mp4 11.50MB
25. Green References.srt 2.25KB
25. Quiz Number 2.html 147B
26.1 34. Beauty-saving-Lecture-after.xlsx 17.05KB
26.2 34. Beauty-saving-Lecture-before.xlsx 17.17KB
26. Beauty Saving - The Professional Way of Saving Files.mp4 12.95MB
26. Beauty Saving - The Professional Way of Saving Files.srt 3.18KB
27.1 43. F2-Lecture.xlsm 49.90KB
27. The Power of F2.mp4 16.72MB
27. The Power of F2.srt 2.95KB
28.1 41. Conditional formatting - Lecture.xlsx 41.73KB
28. Conditional Formatting.mp4 52.02MB
28. Conditional Formatting.srt 7.25KB
29. Quiz Number 1.html 147B
3.1 1. Exercise - Build an FMCG Model_Mapping_after.xlsx 14.90MB
3.1 108. Exercise - after.xlsx 41.48KB
3.1 116. Exercise - after.xlsx 55.12KB
3.1 121. Exercise - after.xlsx 69.54KB
3.1 19. Another-file.xlsx 8.81KB
3.1 1a. Deliveries development_after.xlsx 1.44MB
3.1 2. Course Challenge.xlsx 627.60KB
3.1 2. Data-Entry - Lecture.xlsx 8.07KB
3.1 2. Savings Forecast_unsolved.xlsx 14.74KB
3.1 3.3_output.xlsx 8.15KB
3.1 3. Course Challenge.xlsx 537.67KB
3.1 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx 14.84KB
3.1 4.3_output.xlsx 6.55KB
3.1 5.3_output.xlsx 8.26KB
3.1 56. Loan Schedule-Lecture.xlsx 20.17KB
3.1 6.3_source.xlsx 18.29KB
3.1 60. Get to know the data source - Lecture.xlsm 43.03KB
3.1 7.3_output.xlsx 14.47KB
3.1 76. Formatting-a-Chart-Lecture.xlsm 11.45MB
3.1 83. Doughnut chart-Lecture-after.xlsm 11.52MB
3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx 1.43MB
3.1 Connectors.pptx 1.22MB
3.1 Exercise - Part Three.xlsx 19.29KB
3.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
3.1 Spacing within PowerPoint.pptx 1.86MB
3.1 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx 1.08MB
3.2 1. Exercise - Build an FMCG Model_Mapping_before.xlsx 13.27MB
3.2 108. Exercise - before.xlsx 32.36KB
3.2 116. Exercise - before.xlsx 53.08KB
3.2 121. Exercise - before.xlsx 58.90KB
3.2 19. How-to-save-macros-Lecture-after.xlsm 12.59KB
3.2 1a. Deliveries development_before.xlsx 1.44MB
3.2 2. Data-Entry- Exercise -Solved.xlsx 32.76KB
3.2 2. Savings Forecast.xlsx 16.58KB
3.2 3.3_source.xlsx 16.66KB
3.2 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx 14.46KB
3.2 4.3_source.xlsx 15.60KB
3.2 5.3_source.xlsx 17.36KB
3.2 7.3_source.xlsx 14.04KB
3.2 83. Doughnut chart-Lecture-before.xlsm 11.51MB
3.2 Practical Exercise - List of transactions.pdf 182.53KB
3.2 Spacing-within-PowerPoint-chart.xlsx 57.28KB
3.2 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx 1.08MB
3.3 19. How-to-save-macros-Lecture-before.xlsx 6.02KB
3.3 2. Data-Entry-Exercise - Unsolved.xlsx 10.97KB
3.3 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx 13.01KB
3.4 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx 12.93KB
3.5 Excel-Functions.pdf 3.18MB
3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4 32.62MB
3. Building a Flexible Model with VLOOKUP & COLUMNS.srt 3.63KB
3. Building an Equity Schedule.mp4 32.88MB
3. Building an Equity Schedule.srt 4.73KB
3. Building an Output P&L Sheet.mp4 26.76MB
3. Building an Output P&L Sheet.srt 4.32KB
3. Calculating and Analyzing Growth and Profitability Ratios.mp4 106.55MB
3. Calculating and Analyzing Growth and Profitability Ratios.srt 15.57KB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 46.88MB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt 10.20KB
3. Cash Flow Computations - The Direct Method.mp4 18.48MB
3. Cash Flow Computations - The Direct Method.srt 3.37KB
3. Comparative analysis - theory.html 2.65KB
3. Comparing Delivery Figures with the Ones of industry Peers.mp4 19.77MB
3. Comparing Delivery Figures with the Ones of industry Peers.srt 4.73KB
3. Cost Flow Methods.mp4 24.30MB
3. Cost Flow Methods.srt 7.62KB
3. COURSE CHALLENGE - Part 2.mp4 30.59MB
3. COURSE CHALLENGE - Part 2.srt 2.12KB
3. COURSE CHALLENGE - Part 3.mp4 22.43MB
3. COURSE CHALLENGE - Part 3.srt 1.64KB
3. Data Entry Techniques in Excel.mp4 26.76MB
3. Data Entry Techniques in Excel.srt 4.03KB
3. Data Ranking.mp4 24.50MB
3. Data Ranking.srt 3.56KB
3. Debt Covenants.mp4 23.27MB
3. Debt Covenants.srt 5.47KB
3. Design the Layout and Format of Your Pivot Tables.mp4 15.56MB
3. Design the Layout and Format of Your Pivot Tables.srt 2.63KB
3. Do More with Your Sales Data with Excel's Text to Columns Feature.html 147B
3. Doughnut Chart.mp4 34.48MB
3. Doughnut Chart.srt 6.88KB
3. Effective Data Classification.mp4 14.18MB
3. Effective Data Classification.srt 2.68KB
3. Eliminating Duplicate Rows.mp4 12.40MB
3. Eliminating Duplicate Rows.srt 1.80KB
3. Fair Value Accounting.mp4 41.18MB
3. Fair Value Accounting.srt 4.15KB
3. General Considerations About Slide Structure.mp4 26.37MB
3. General Considerations About Slide Structure.srt 5.97KB
3. Historical Cost vs. Fair Value Accounting.mp4 20.37MB
3. Historical Cost vs. Fair Value Accounting.srt 4.04KB
3. Horizontal vs. Vertical Financial Statement Analysis.mp4 27.28MB
3. Horizontal vs. Vertical Financial Statement Analysis.srt 5.64KB
3. How Interest Rates Play an Important Role in the Economy.mp4 21.54MB
3. How Interest Rates Play an Important Role in the Economy.srt 1.99KB
3. How to Handle Non-paying Customers A Case-study.mp4 22.80MB
3. How to Handle Non-paying Customers A Case-study.srt 4.29KB
3. How to Use the Same Macro On Multiple Workbooks.mp4 10.68MB
3. How to Use the Same Macro On Multiple Workbooks.srt 2.11KB
3. Identifying Outliers.mp4 18.07MB
3. Identifying Outliers.srt 3.69KB
3. Join Shapes Together By Using Connector Lines.mp4 23.83MB
3. Join Shapes Together By Using Connector Lines.srt 6.33KB
3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4 27.42MB
3. Key Excel Functions SUM, SUMIF, SUMIFS.srt 5.15KB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4 32.08MB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt 5.35KB
3. Modifying Excel Charts - The Easy Way.mp4 42.11MB
3. Modifying Excel Charts - The Easy Way.srt 3.22KB
3. Obtaining Age in Years, Months, Days.mp4 9.14MB
3. Obtaining Age in Years, Months, Days.srt 2.12KB
3. Overtrading vs. Excessive Investment.mp4 30.14MB
3. Overtrading vs. Excessive Investment.srt 5.24KB
3. Potential Conflicts of Interest When Recognizing Revenue.mp4 16.31MB
3. Potential Conflicts of Interest When Recognizing Revenue.srt 3.37KB
3. Preliminary Mapping of the Data Extraction.mp4 30.22MB
3. Preliminary Mapping of the Data Extraction.srt 2.78KB
3. Preprocessing the 'Free plan users' Sheet (22).mp4 35.66MB
3. Preprocessing the 'Free plan users' Sheet (22).srt 4.54KB
3. Standardizing Letter Capitalization.mp4 15.70MB
3. Standardizing Letter Capitalization.srt 2.83KB
3. T-Accounts The Best Way to Understand Debits and Credits.mp4 29.43MB
3. T-Accounts The Best Way to Understand Debits and Credits.srt 7.30KB
3. The Best Way to Take This Course.mp4 31.14MB
3. The Best Way to Take This Course.srt 4.44KB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 29.14MB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.srt 4.25KB
3. The Time Value of Money in a Capital Budgeting Setting.mp4 16.90MB
3. The Time Value of Money in a Capital Budgeting Setting.srt 3.49KB
3. The Types of Dividends Companies Pay to Shareholders.mp4 42.30MB
3. The Types of Dividends Companies Pay to Shareholders.srt 5.64KB
3. Timing of Expenses Principles of Cost Recognition.mp4 23.21MB
3. Timing of Expenses Principles of Cost Recognition.srt 5.19KB
3. Types of Revenues.mp4 52.18MB
3. Types of Revenues.srt 10.92KB
3. Understand Your Data Source Before You Start Working on It.mp4 25.50MB
3. Understand Your Data Source Before You Start Working on It.srt 4.08KB
3. Using the PMT Function to Create a Complete Loan Schedule.mp4 35.28MB
3. Using the PMT Function to Create a Complete Loan Schedule.srt 6.79KB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 26.34MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.srt 4.25KB
3. Why Use E-invoicing.mp4 22.71MB
3. Why Use E-invoicing.srt 4.72KB
4.1 109. Exersice - after.xlsx 41.26KB
4.1 11. Set-Print-Area-Lecture - Solved.xlsx 11.22KB
4.1 117. Exercise -after.xlsx 56.60KB
4.1 122. Exercise - after.xlsx 70.35KB
4.1 2. Average of price models_after.xlsx 1.44MB
4.1 2. Comparative analysis_after.xlsx 43.96KB
4.1 2. Exercise - Build an FMCG Model_Layout_after.xlsx 14.91MB
4.1 3.4_output.xlsx 8.90KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx 18.54KB
4.1 3. Formatting - Lecture - Solved.xlsx 9.85KB
4.1 4.4_output.xlsx 5.59KB
4.1 5.4_output.xlsx 6.10KB
4.1 57. Date Functions-Lecture.xlsx 12.25KB
4.1 6.4_source.xlsx 12.98KB
4.1 61. Order a worksheet_after.xlsm 41.01KB
4.1 7.4_output.xlsx 18.17KB
4.1 77. Modifying-a-Chart-Lecture.xlsm 11.40MB
4.1 84. Area chart-Lecture-after.xlsm 11.53MB
4.1 89. Working-with-Pivot-Tables-Lecture.xlsx 1.88MB
4.1 Download all resources - Dropbox.html 134B
4.1 Edit Points.pptx 1.21MB
4.1 Exercise - Part Four.xlsx 20.70KB
4.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
4.1 Insert objects.pptx 1.64MB
4.1 Inventory Cost Flow Methods_solved.xlsx 12.38KB
4.1 Tesla - Financial Statement Analysis - Liquidity_after.xlsx 1.08MB
4.1 Working Capital Days.pdf 340.78KB
4.2 109. Exersice - before.xlsx 37.63KB
4.2 11. Set-Print-Area-Lecture - Unsolved.xlsx 11.42KB
4.2 117. Exercise before.xlsx 53.56KB
4.2 122. Exercise - before.xlsx 65.60KB
4.2 2. Average of price models_before.xlsx 1.44MB
4.2 2. Comparative analysis_before.xlsx 43.49KB
4.2 2. Exercise - Build an FMCG Model_Layout_before.xlsx 14.90MB
4.2 3.4_source.xlsx 16.98KB
4.2 3. Fixed Asset Rollforward.xlsx 19.66KB
4.2 3. Formatting- Exercise - Solved.xlsx 11.59KB
4.2 4.4_source.xlsx 17.94KB
4.2 5.4_source.xlsx 14.41KB
4.2 61. Order a worksheet_before.xlsm 43.08KB
4.2 7.4_source.xlsx 392.28KB
4.2 84. Area chart-Lecture-before.xlsm 11.51MB
4.2 Interest rate components.pdf 807.55KB
4.2 Inventory Cost Flow Methods_unsolved.xlsx 11.53KB
4.2 Kinemax Data.xlsx 36.41KB
4.2 Practical Exercise - List of transactions.pdf 182.53KB
4.2 Tesla - Financial Statement Analysis - Liquidity_before.xlsx 1.08MB
4.3 3. Formatting- Lecture - Unsolved.xlsx 8.91KB
4.3 Course notes - Building a financial model.pdf 575.23KB
4.3 Inventory Cost Flow Methods.pptx 168.54KB
4.3 Useful-Tips-Tools.pdf 3.31MB
4.4 3. Formatting-Exercise - Unsolved.xlsx 11.61KB
4.4 Inventory-Cost-Flow-Methods-with-solutions.pptx 175.11KB
4.4 Working Capital Days.pdf 340.78KB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 35.86MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.srt 5.90KB
4. Addressing Unit Discrepancies in Data.mp4 19.01MB
4. Addressing Unit Discrepancies in Data.srt 2.56KB
4. A Helpful Consideration.html 1.41KB
4. An Introduction to Financial Accounting.mp4 22.26MB
4. An Introduction to Financial Accounting.srt 4.61KB
4. A Practical Example.mp4 50.23MB
4. A Practical Example.srt 8.73KB
4. Area Chart.mp4 25.38MB
4. Area Chart.srt 4.59KB
4. A Technique to Collect Trade Receivables Sooner.mp4 13.80MB
4. A Technique to Collect Trade Receivables Sooner.srt 2.98KB
4. Calculating and Analyzing Liquidity Ratios.mp4 71.62MB
4. Calculating and Analyzing Liquidity Ratios.srt 8.75KB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 18.00MB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt 3.06KB
4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 39.43MB
4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt 5.71KB
4. Calculating Present and Future Value.mp4 31.56MB
4. Calculating Present and Future Value.srt 8.21KB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 51.97MB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt 9.72KB
4. Cash Flow Computations - The Indirect Method.mp4 25.81MB
4. Cash Flow Computations - The Indirect Method.srt 5.79KB
4. Comparative analysis.mp4 32.34MB
4. Comparative analysis.srt 6.20KB
4. Correlation Analysis Hypothesis Formulation and Feature Ideas.mp4 19.23MB
4. Correlation Analysis Hypothesis Formulation and Feature Ideas.srt 2.78KB
4. Cost Flow Methods - a Practical Exercise.mp4 6.46MB
4. Cost Flow Methods - a Practical Exercise.srt 1.75KB
4. Create Easily Printable Excel Documents.mp4 8.37MB
4. Create Easily Printable Excel Documents.srt 1.51KB
4. Creating an Output Structure of the FMCG Model.mp4 19.71MB
4. Creating an Output Structure of the FMCG Model.srt 3.19KB
4. Date Functions in Excel.mp4 27.47MB
4. Date Functions in Excel.srt 7.25KB
4. Debt Covenants - A Practical Example.mp4 12.24MB
4. Debt Covenants - A Practical Example.srt 2.78KB
4. Dividend Payments - a Timeline.mp4 33.52MB
4. Dividend Payments - a Timeline.srt 4.85KB
4. Download All Course Materials and FAQ.html 5.14KB
4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4 8.28MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.srt 2.89KB
4. Estimating an Average Selling Price of Tesla Vehicles.mp4 45.99MB
4. Estimating an Average Selling Price of Tesla Vehicles.srt 7.00KB
4. Filling in the Output P&L Sheet with Historical Financials.mp4 20.62MB
4. Filling in the Output P&L Sheet with Historical Financials.srt 3.05KB
4. Fill Until Non-blank Values.mp4 22.56MB
4. Fill Until Non-blank Values.srt 4.19KB
4. Handling Multi-lingual Text Data.mp4 35.89MB
4. Handling Multi-lingual Text Data.srt 4.42KB
4. How to Make Your Spreadsheets Look Professional.mp4 35.90MB
4. How to Make Your Spreadsheets Look Professional.srt 7.16KB
4. Indispensable Tools for Financial Statement Analysis.mp4 14.27MB
4. Indispensable Tools for Financial Statement Analysis.srt 3.49KB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4 32.23MB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.srt 6.57KB
4. Learn How to Insert Objects in PowerPoint.mp4 31.97MB
4. Learn How to Insert Objects in PowerPoint.srt 5.89KB
4. Macros Are a Great Timesaver! Here's Why..html 147B
4. Making Your Excel Charts Sexier - Proven Tips.mp4 53.34MB
4. Making Your Excel Charts Sexier - Proven Tips.srt 3.83KB
4. Order Data with ChatGPT.mp4 18.11MB
4. Order Data with ChatGPT.srt 2.81KB
4. Order Dates Chronologically.mp4 12.52MB
4. Order Dates Chronologically.srt 2.07KB
4. Ordering the Source Worksheet.mp4 24.75MB
4. Ordering the Source Worksheet.srt 3.22KB
4. P&L T-Accounts.mp4 21.72MB
4. P&L T-Accounts.srt 4.39KB
4. Preparing a Cash Flow Structure.mp4 12.54MB
4. Preparing a Cash Flow Structure.srt 2.41KB
4. Preparing a Fixed Asset Rollforward Schedule.mp4 44.52MB
4. Preparing a Fixed Asset Rollforward Schedule.srt 6.70KB
4. Quiz Number 6.html 147B
4. The Components Forming Interest Rates in Real Life.mp4 25.99MB
4. The Components Forming Interest Rates in Real Life.srt 3.74KB
4. Trade Receivables Management.mp4 68.72MB
4. Trade Receivables Management.srt 12.87KB
4. Types of Revenues - Exercise.mp4 15.70MB
4. Types of Revenues - Exercise.srt 3.09KB
4. Working on the 'Transactions' Sheet.mp4 78.82MB
4. Working on the 'Transactions' Sheet.srt 6.94KB
5.1 05 38 Counts Exercise & Text.xlsx 15.66KB
5.1 110. Exercise - after.xlsx 51.73KB
5.1 118. Exercise - after.xlsx 57.67KB
5.1 12. Wrap-Text-Exercise - Solved.xlsx 10.20KB
5.1 123. Exercise - after.xlsx 72.59KB
5.1 25. Fast-Scrolling - Lecture.xlsx 642.82KB
5.1 3.5_source.xlsx 16.75KB
5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx 14.92MB
5.1 3. Revenue calculation_after.xlsx 1.45MB
5.1 4. Working Capital_unsolved.xlsx 21.19KB
5.1 5.5_output.xlsx 14.44KB
5.1 6.5_source.xlsx 17.97KB
5.1 62. Creating a code_after.xlsm 41.73KB
5.1 78. Bridge-Charts-Lecture.xlsx 13.10KB
5.1 85. Bridge chart-Lecture-after.xlsm 11.53MB
5.1 90. GetPivotData-Lecture.xlsx 1.88MB
5.1 Cash Flow Statement_after.xlsx 16.20KB
5.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
5.1 Group.pptx 1.22MB
5.1 Power-Point-Master-Class-Shortcuts-For-Mac.pdf 532.42KB
5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx 1.08MB
5.2 05 38 Counts Solved.xlsx 16.05KB
5.2 110. Exercise - before.xlsx 39.27KB
5.2 118. Exercise - before.xlsx 54.64KB
5.2 12. Wrap-Text-Exercise - Unsolved.xlsx 10.17KB
5.2 123. Exercise - before.xlsx 67.69KB
5.2 25. Fast-Scrolling-Exercise - Solved.xlsx 44.35KB
5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx 14.92MB
5.2 3. Revenue calculation_before.xlsx 1.45MB
5.2 4. Working Capital.xlsx 21.93KB
5.2 5.5_source.xlsx 13.99KB
5.2 62. Creating a code_before.xlsm 41.01KB
5.2 85.Bridge-chart-Lecture-before.xlsm 11.48MB
5.2 Cash Flow Statement_pre-solution.xlsx 15.86KB
5.2 PowerPoint Master Class - Shortcuts.pdf 440.40KB
5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx 1.08MB
5.3 12. Wrap-text-Lecture - Solved.xlsx 9.61KB
5.3 25. Fast-Scrolling-Exercise - Unsolved.xlsx 43.90KB
5.3 Excel-Functions.pdf 3.19MB
5.4 12. Wrap-text-Lecture - Unsolved.xlsx 9.61KB
5.4 Lecture-Count-Countif-Countifs-Solved.xlsx 11.68KB
5.4 Useful-Tips-Tools.pdf 3.30MB
5.5 Lecture-Count-Countif-Countifs-Unsolved.xlsx 11.29KB
5. Bridge Chart.mp4 46.57MB
5. Bridge Chart.srt 9.34KB
5. Calculating and Analyzing Solvency Ratios.mp4 24.50MB
5. Calculating and Analyzing Solvency Ratios.srt 3.37KB
5. Calculating Automotive Revenue.mp4 40.52MB
5. Calculating Automotive Revenue.srt 6.31KB
5. Calculating Cash Flow in Practice A Complete Example.mp4 52.51MB
5. Calculating Cash Flow in Practice A Complete Example.srt 11.98KB
5. Calculating Cash Flows and Completing the Model.mp4 51.03MB
5. Calculating Cash Flows and Completing the Model.srt 7.55KB
5. Calculating Percentage Variances and Applying Conditional Formatting.mp4 23.89MB
5. Calculating Percentage Variances and Applying Conditional Formatting.srt 3.44KB
5. Calculating the Cash Impact of Extra Working Capital Required.mp4 16.31MB
5. Calculating the Cash Impact of Extra Working Capital Required.srt 3.81KB
5. Cost of Equity.mp4 51.47MB
5. Cost of Equity.srt 10.22KB
5. Crafting a Comprehensive EDA Prompt.mp4 93.11MB
5. Crafting a Comprehensive EDA Prompt.srt 10.98KB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 21.42MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.srt 1.37KB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 22.92MB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.srt 2.82KB
5. Data Entry Techniques in Excel.html 147B
5. Dealing with the Country Mapping Issue.mp4 23.26MB
5. Dealing with the Country Mapping Issue.srt 3.81KB
5. Dividing Cell Content into Multiple Cells.mp4 46.27MB
5. Dividing Cell Content into Multiple Cells.srt 5.61KB
5. FAQ Doubts Regarding Calculation.html 683B
5. FAQ How to Apply the Weighted Average Cost Method.html 916B
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 26.98MB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt 3.50KB
5. Group or Ungroup Shapes, Pictures or Other Objects.mp4 14.66MB
5. Group or Ungroup Shapes, Pictures or Other Objects.srt 3.05KB
5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 3.16MB
5. How to Wrap Text in Excel and Adjust a Cell's Size.srt 933B
5. Improving the Layout and Appearance of the FMCG Report.mp4 23.89MB
5. Improving the Layout and Appearance of the FMCG Report.srt 4.93KB
5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 49.87MB
5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt 4.54KB
5. Multiple Find and Replace at the Same Time with ChatGPT.mp4 23.96MB
5. Multiple Find and Replace at the Same Time with ChatGPT.srt 3.47KB
5. One of the Most Useful Excel Functions - GETPIVOTDATA.mp4 27.42MB
5. One of the Most Useful Excel Functions - GETPIVOTDATA.srt 5.02KB
5. Quiz Number 3.html 147B
5. Quiz Number 7.html 147B
5. Re-order Level.mp4 28.37MB
5. Re-order Level.srt 5.24KB
5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 16.65MB
5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt 3.78KB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 40.56MB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.srt 7.89KB
5. The Revaluation Model.mp4 35.15MB
5. The Revaluation Model.srt 7.64KB
5. The Secret to Faster Scrolling in Excel.mp4 19.52MB
5. The Secret to Faster Scrolling in Excel.srt 1.84KB
5. Translating Logic into Excel Formulas with ChatGPT.mp4 11.78MB
5. Translating Logic into Excel Formulas with ChatGPT.srt 3.09KB
5. Types of Expenses.mp4 43.29MB
5. Types of Expenses.srt 9.07KB
5. Using Accounting Ratios to Assess Business Performance.mp4 62.28MB
5. Using Accounting Ratios to Assess Business Performance.srt 13.87KB
5. Value-based analysis - theory.html 3.70KB
5. What Are Share Repurchases and Why Companies Do Them.mp4 42.42MB
5. What Are Share Repurchases and Why Companies Do Them.srt 5.02KB
5. What Is Libor and What Purpose Does It Serve.mp4 27.66MB
5. What Is Libor and What Purpose Does It Serve.srt 1.34KB
6.1 111. Exercise - after.xlsx 54.43KB
6.1 13. Hyperlinks-Exercise - Solved.xlsx 137.06KB
6.1 21. F5-go-to - Lecture.xlsm 50.76KB
6.1 3. Value-based analysis_after.xlsx 47.26KB
6.1 4. Basic-Manipulations - Exercise - Solved.xlsx 32.43KB
6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx 14.91MB
6.1 4. Gross profit automotive_after.xlsx 1.46MB
6.1 41. Average-Averageif- Lecture - Solved.xlsx 9.40KB
6.1 5. Financing_unsolved.xlsx 29.99KB
6.1 6.6_source.xlsx 14.53KB
6.1 63. Creating a database_after.xlsm 39.39KB
6.1 79. Treemap-Charts-Lecture.xlsx 12.62KB
6.1 91. Slicers-Lecture.xlsx 1.88MB
6.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
6.1 Internal Margins.pptx 1.22MB
6.1 Quick Access Toolbar buttons.pptx 1.24MB
6.2 111. Exercise - before.xlsx 47.50KB
6.2 13. Hyperlinks-Exercise - Unsolved.xlsx 136.89KB
6.2 3. Value-based analysis_before.xlsx 46.76KB
6.2 4. Basic-Manipulations - Exercise - Unsolved.xlsx 11.06KB
6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx 14.92MB
6.2 4. Gross profit automotive_before.xlsx 1.46MB
6.2 41. Average-Averageif- Lecture - Unsolved.xlsx 9.03KB
6.2 5. Financing.xlsx 30.97KB
6.2 63. Creating a database_before.xlsm 35.32KB
6.3 4. Data Entry - Lecture.xlsx 8.07KB
6.3 41. Average-AverageIF-Exercise - Solved.xlsx 15.02KB
6.3 Useful-Tips-Tools.pdf 3.31MB
6.4 41. Average-AverageIF-Exercise - Unsolved.xlsx 14.60KB
6.5 Excel-Functions.pdf 3.19MB
6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 21.36MB
6. Add Frequently Used Buttons to the Quick Access Toolbar.srt 4.74KB
6. Be even quicker F5 + Enter.mp4 19.12MB
6. Be even quicker F5 + Enter.srt 2.73KB
6. Building an Output Balance Sheet.mp4 26.23MB
6. Building an Output Balance Sheet.srt 4.01KB
6. Criteria-based Duplicate Removal.mp4 14.44MB
6. Criteria-based Duplicate Removal.srt 3.22KB
6. Debt Repayment and Interest Expenses Calculation.mp4 19.95MB
6. Debt Repayment and Interest Expenses Calculation.srt 4.46KB
6. Economic Order Quantity (EOQ).mp4 28.16MB
6. Economic Order Quantity (EOQ).srt 6.32KB
6. FAQ Why D&A Has Been Added in Capex.html 2.22KB
6. Income Taxes.mp4 15.43MB
6. Income Taxes.srt 3.16KB
6. Insert Hyperlinks into Excel Spreadsheets.mp4 7.20MB
6. Insert Hyperlinks into Excel Spreadsheets.srt 1.40KB
6. Inserting, Deleting, and Modifying Rows & Columns.mp4 9.45MB
6. Inserting, Deleting, and Modifying Rows & Columns.srt 2.32KB
6. Inserting Formulas and Automating Calculations.mp4 16.15MB
6. Inserting Formulas and Automating Calculations.srt 2.89KB
6. Key Excel Functions AVERAGE & AVERAGEIF.mp4 24.15MB
6. Key Excel Functions AVERAGE & AVERAGEIF.srt 2.39KB
6. Learn How to Create a Database.mp4 18.80MB
6. Learn How to Create a Database.srt 2.67KB
6. New Ways to Visualize Your Data - Treemap Charts.mp4 18.33MB
6. New Ways to Visualize Your Data - Treemap Charts.srt 1.75KB
6. Peer Comparison Gross Profit %.mp4 35.72MB
6. Peer Comparison Gross Profit %.srt 7.24KB
6. Project-specific Beta.mp4 24.78MB
6. Project-specific Beta.srt 4.68KB
6. Quiz Number 5.html 147B
6. Quiz Number 8.html 147B
6. The Difference Between Fixed and Variable Interest Rates.mp4 26.42MB
6. The Difference Between Fixed and Variable Interest Rates.srt 2.43KB
6. The Idea Behind Stock Splits.mp4 34.26MB
6. The Idea Behind Stock Splits.srt 4.64KB
6. The Revaluation Model - Practical Exercise.mp4 34.09MB
6. The Revaluation Model - Practical Exercise.srt 6.56KB
6. This is How You Can Fit Text When It Is Larger Than a Shape.mp4 13.79MB
6. This is How You Can Fit Text When It Is Larger Than a Shape.srt 3.26KB
6. Value-based analysis.mp4 37.53MB
6. Value-based analysis.srt 6.88KB
6. Welcome to the Future - Pivot Table Slicers.mp4 36.19MB
6. Welcome to the Future - Pivot Table Slicers.srt 5.49KB
7.1 112. Exersice - before.xlsx 49.80KB
7.1 14. Freeze-Panes-Lecture - Solved.xlsx 643.94KB
7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx 20.81MB
7.1 5. Gross profit and cost of sales_after.xlsx 1.48MB
7.1 6.7_source.xlsx 14.96KB
7.1 6. P&L_unsolved.xlsx 29.70KB
7.1 64. Vlookup_after.xlsm 44.45KB
7.1 80. Sparklines-Lecture.xlsx 9.59KB
7.1 Align and Distribute objects in Ppt.pptx 1.25MB
7.1 Default risk.pdf 880.84KB
7.1 Nudge objects.pptx 1.22MB
7.2 112. Exersise - after.xlsx 57.11KB
7.2 14. Freeze-Panes-Lecture - Unsolved.xlsx 643.87KB
7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx 14.91MB
7.2 5. Gross profit and cost of sales_before.xlsx 1.46MB
7.2 6. P&L.xlsx 31.03KB
7.2 64. Vlookup_before.xlsm 39.50KB
7.2 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
7.3 Useful-Tips-Tools.pdf 3.31MB
7. Calculating Automotive Gross Profit.mp4 22.27MB
7. Calculating Automotive Gross Profit.srt 3.76KB
7. Correlation analysis - theory.html 3.90KB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 20.14MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt 2.45KB
7. Depreciation & Amortization.mp4 37.45MB
7. Depreciation & Amortization.srt 7.18KB
7. FAQ F5 + Enter didn't work for me.html 402B
7. How to Easily Align Objects in PowerPoint.mp4 20.49MB
7. How to Easily Align Objects in PowerPoint.srt 6.26KB
7. How to Represent Trends with Sparklines.mp4 42.94MB
7. How to Represent Trends with Sparklines.srt 4.51KB
7. Inserting, Deleting, and Modifying Rows & Columns.html 147B
7. Intangible Assets Created Internally.mp4 16.26MB
7. Intangible Assets Created Internally.srt 3.48KB
7. Introduction to the Course Challenge.mp4 12.29MB
7. Introduction to the Course Challenge.srt 1.49KB
7. Inventory Optimization Techniques.mp4 45.16MB
7. Inventory Optimization Techniques.srt 8.14KB
7. Key Excel Functions Average & Averageif.html 147B
7. Nudge Objects.mp4 4.38MB
7. Nudge Objects.srt 1.76KB
7. Removing Duplicates Across Multiple Columns.mp4 14.62MB
7. Removing Duplicates Across Multiple Columns.srt 2.73KB
7. The Project's P&L Sheet.mp4 12.90MB
7. The Project's P&L Sheet.srt 2.72KB
7. The Weighted Average Cost of Capital (WACC).mp4 14.01MB
7. The Weighted Average Cost of Capital (WACC).srt 3.02KB
7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 14.50MB
7. Using Excel's Freeze Panes to Handle Large Datasets.srt 1.46KB
7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4 37.71MB
7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.srt 5.62KB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 56.93MB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.srt 7.04KB
7. What Is Default Risk and How Does a Bank Account For It.mp4 47.78MB
7. What Is Default Risk and How Does a Bank Account For It.srt 9.07KB
8.1 113. Exersice - after.xlsx 54.95KB
8.1 4. Correlation_after.xlsx 55.54KB
8.1 47. Text functions - Exercise - Solved.xlsx 12.24KB
8.1 5. Formulas - Exercise - Unsolved.xlsx 11.72KB
8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx 20.82MB
8.1 65. Sumif_after.xlsm 49.53KB
8.1 7. Cash flow_unsolved.xlsx 29.64KB
8.1 93. Course-challenge-before-solutions.xlsx 505.94KB
8.1 Finance 101 - Introduction to the World of Finance.pdf 689.77KB
8.1 Format Shape Menu.pptx 634.21KB
8.1 Smart Art.pptx 1.22MB
8.1 Useful Tips & Tools.pdf 3.30MB
8.2 113. Exersice - before.xlsx 50.28KB
8.2 4. Correlation_before.xlsx 50.85KB
8.2 47. Text functions - Exercise - Unsolved.xlsx 11.71KB
8.2 5. Formulas- Exercise - Solved.xlsx 80.13KB
8.2 65. Sumif_before.xlsm 44.45KB
8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx 20.81MB
8.2 7. Cash flow.xlsx 31.36KB
8.3 47. Text-Functions- Lecture - Solved.xlsx 11.10KB
8.3 5. Formulas- Lecture - Solved.xlsx 9.36KB
8.4 47. Text-Functions- Lecture - Unsolved.xlsx 10.60KB
8.4 5. Formulas- Lecture - Unsolved.xlsx 9.30KB
8.5 Introduction-to-Excels-basic-features.pdf 2.26MB
8. Adding the Forecast Period.mp4 27.98MB
8. Adding the Forecast Period.srt 4.08KB
8. Calculating Automotive Cost of Sales.mp4 12.71MB
8. Calculating Automotive Cost of Sales.srt 2.56KB
8. Corporate Loan Specifics.mp4 40.85MB
8. Corporate Loan Specifics.srt 2.11KB
8. Correlation analysis.mp4 36.31MB
8. Correlation analysis.srt 4.81KB
8. COURSE CHALLENGE - Part 1.mp4 23.25MB
8. COURSE CHALLENGE - Part 1.srt 1.80KB
8. Excel Formulas for Beginners.mp4 12.11MB
8. Excel Formulas for Beginners.srt 3.49KB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 15.06MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.srt 1.03KB
8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 49.95MB
8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.srt 7.71KB
8. How to Edit Shapes in Your Presentation.mp4 26.32MB
8. How to Edit Shapes in Your Presentation.srt 7.14KB
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 48.96MB
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.srt 4.91KB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 20.97MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt 5.42KB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 21.84MB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt 5.07KB
8. The Project's Cash Flow Calculation.mp4 29.05MB
8. The Project's Cash Flow Calculation.srt 4.99KB
8. The Secret to Faster Scrolling in Excel.html 147B
8. The Two Types of Income Statement Formats.mp4 10.83MB
8. The Two Types of Income Statement Formats.srt 1.99KB
8. Trade Payables Management.mp4 17.35MB
8. Trade Payables Management.srt 3.27KB
8. Using SUMIF to Complete the Database Sheet.mp4 44.77MB
8. Using SUMIF to Complete the Database Sheet.srt 5.52KB
9.1 21. Pivot Tables - Exercise - Solved.xlsx 190.47KB
9.1 22. Fixing-Cells-Exercise - Solved.xlsx 10.82KB
9.1 6. Energy and Other revenue_after.xlsx 1.48MB
9.1 8. WACC_unsolved.xlsx 35.93KB
9.1 Text effects.pptx 1.22MB
9.1 Working with text.pptx 772.99KB
9.2 21. Pivot Tables - Exercise - Unsolved.xlsx 152.17KB
9.2 22. Fixing-Cells-Exercise - Unsolved.xlsx 10.67KB
9.2 6. Energy and Other revenue_before.xlsx 1.48MB
9.2 8. WACC.xlsx 38.03KB
9.3 21. Pivot tables - Lecture - Solved.xlsm 897.26KB
9.3 22. Fixing-references-Lecture - Solved.xlsx 645.17KB
9.4 21. Pivot tables - Lecture - Unsolved.xlsm 687.83KB
9.4 22. Fixing-references-Lecture - Unsolved.xlsx 643.98KB
9.5 Useful-Tips-Tools.pdf 3.31MB
9.5 Useful-Tips-Tools.pdf 3.30MB
9. A Quick Introduction to Excel's Pivot Tables.mp4 40.10MB
9. A Quick Introduction to Excel's Pivot Tables.srt 2.67KB
9. Balance Sheet Items.mp4 35.35MB
9. Balance Sheet Items.srt 6.84KB
9. Calculating WACC (Weighted Average Cost of Capital).mp4 16.33MB
9. Calculating WACC (Weighted Average Cost of Capital).srt 3.98KB
9. Creating Eye-Catching Text Effects in PowerPoint.mp4 12.49MB
9. Creating Eye-Catching Text Effects in PowerPoint.srt 3.29KB
9. Excel Formulas for Beginners.html 147B
9. FAQ Why Net income should be 0.html 1.28KB
9. Forecasting 'Energy' and 'Services' Revenue.mp4 19.10MB
9. Forecasting 'Energy' and 'Services' Revenue.srt 3.43KB
9. GETPIVOTDATA Fix.mp4 11.92MB
9. GETPIVOTDATA Fix.srt 1.99KB
9. How to Format Text Boxes in a PowerPoint Presentation.mp4 19.91MB
9. How to Format Text Boxes in a PowerPoint Presentation.srt 5.55KB
9. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html 147B
9. Modeling Future Cash Flows.mp4 50.47MB
9. Modeling Future Cash Flows.srt 8.87KB
9. Time series analysis - theory.html 2.02KB
9. Using Absolute and Relative Cell References.mp4 43.47MB
9. Using Absolute and Relative Cell References.srt 2.71KB
9. Working Capital Optimization - a Roadmap.mp4 43.46MB
9. Working Capital Optimization - a Roadmap.srt 8.62KB