zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation
magnet:?xt=urn:btih:2fa64dd36bd59f74bf155668e707d04551b5b264&dn=[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation
磁力链接详情
Hash值:
2fa64dd36bd59f74bf155668e707d04551b5b264
点击数:
198
文件大小:
1.92 GB
文件数量:
132
创建日期:
2017-10-31 14:59
最后访问:
2024-6-26 12:08
访问标签:
FreeTutorials
Us
beginner-to-pro-in-excel-financial-modeling-and-valuation
文件列表详情
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp4 8.94 MB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp4 7.82 MB
02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp4 1.99 MB
02 Introduction to Excel/006 Overview of Excel.mp4 13.95 MB
02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp4 6.9 MB
02 Introduction to Excel/008 The Excel Ribbon.mp4 8.8 MB
02 Introduction to Excel/009 Data Entry in Excel.mp4 10.39 MB
02 Introduction to Excel/010 Introduction to Formatting.mp4 24.75 MB
02 Introduction to Excel/011 Introduction to Excel Formulas.mp4 8.69 MB
02 Introduction to Excel/012 Introduction to Excel Functions.mp4 12.05 MB
02 Introduction to Excel/013 Cut Copy Paste.mp4 7.56 MB
02 Introduction to Excel/014 Paste Special.mp4 6.69 MB
03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp4 2.13 MB
03 Useful tips and tools for your work in Excel/017 Initial formatting of an Excel sheet in order to render it professional.mp4 7.98 MB
03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp4 22.16 MB
03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp4 20.37 MB
03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp4 3.33 MB
03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp4 12.53 MB
03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp4 2.14 MB
03 Useful tips and tools for your work in Excel/023 Create easily printable documents in Excel by using Set Print Area.mp4 4.73 MB
03 Useful tips and tools for your work in Excel/024 Find and select special types of cells with Select Special F5.mp4 9.78 MB
03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp4 7.31 MB
03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp4 5.42 MB
03 Useful tips and tools for your work in Excel/027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp4 5.41 MB
03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp4 11.1 MB
03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp4 10.58 MB
03 Useful tips and tools for your work in Excel/030 Using Custom-sort in order to sort multiple columns within a table.mp4 9.14 MB
03 Useful tips and tools for your work in Excel/031 Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.35 MB
03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp4 17.67 MB
03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp4 9.87 MB
03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp4 15.08 MB
04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp4 30.43 MB
05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp4 2.31 MB
05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp4 19.32 MB
05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp4 16.98 MB
05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp4 7.85 MB
05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp4 16.79 MB
05 Excels key functions and functionalities made easy/043 Find the minimum or maximum value in a range of cells in Excel.mp4 5.91 MB
05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp4 3.12 MB
05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 34.59 MB
05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp4 38.95 MB
05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp4 11.76 MB
05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp4 7.51 MB
05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp4 8.98 MB
05 Excels key functions and functionalities made easy/050 Use Goal Seek in order to find the result that you are looking for.mp4 7.85 MB
05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp4 14.28 MB
05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp4 16.58 MB
06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp4 35.31 MB
07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp4 6 MB
07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp4 19.37 MB
07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp4 11.27 MB
07 Microsoft Excels Pivot Tables in Depth/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp4 23 MB
07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp4 18.06 MB
07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp4 22.16 MB
08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp4 3.13 MB
08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp4 6.8 MB
08 Case Study - Building a Complete PL from scratch in Excel/063 Understand your data source before you start working on It.mp4 21.24 MB
08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp4 18.36 MB
08 Case Study - Building a Complete PL from scratch in Excel/065 Create a code the best way to organize your data and work efficiently with It.mp4 18.7 MB
08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp4 18.11 MB
08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp4 48.85 MB
08 Case Study - Building a Complete PL from scratch in Excel/068 50 Completed.mp4 4.3 MB
08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp4 44.48 MB
08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp4 42.14 MB
08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp4 29.75 MB
08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp4 10.45 MB
08 Case Study - Building a Complete PL from scratch in Excel/073 Formatting sets You apart from the competition in Excel - A Practical Example.mp4 15.24 MB
08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp4 18.78 MB
08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp4 23.74 MB
08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp4 20.75 MB
08 Case Study - Building a Complete PL from scratch in Excel/077 Create professional and good-looking charts - Introduction.mp4 3.6 MB
08 Case Study - Building a Complete PL from scratch in Excel/078 Build a Column Stacked Chart with a secondary line axis in Excel.mp4 32.72 MB
08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp4 20.77 MB
08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp4 22.89 MB
08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp4 56.48 MB
08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp4 7.91 MB
09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp4 12.05 MB
09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp4 22.6 MB
09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp4 21.95 MB
09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp4 11.65 MB
09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp4 13.5 MB
09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp4 8.83 MB
09 Case Study - Building an FMCG Model from Scratch/089 Creating a Master Pivot Table The main data source for the FMCG report.mp4 13.82 MB
09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp4 31.04 MB
09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp4 17.83 MB
09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.11 MB
09 Case Study - Building an FMCG Model from Scratch/093 This is how the report can be used in practice by high-level executives.mp4 19.8 MB
10 Financial Modeling Fundamentals/094 Financial Modeling Basics - Welcome Lecture.mp4 2.09 MB
10 Financial Modeling Fundamentals/095 What is a Financial model.mp4 5.48 MB
10 Financial Modeling Fundamentals/096 Why use Financial models.mp4 10.03 MB
10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp4 19.91 MB
10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp4 17.22 MB
10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp4 14.26 MB
10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp4 7.29 MB
10 Financial Modeling Fundamentals/101 Financial modeling Forecasting guidelines.mp4 7.11 MB
10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp4 8.44 MB
10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp4 13.33 MB
10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp4 6.14 MB
10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp4 10.6 MB
13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp4 1.78 MB
13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp4 11.61 MB
13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp4 22.89 MB
13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp4 12.53 MB
13 Learn how to build a Discounted Cash Flow model in Excel/112 A glimpse at the company we are valuing - Cheeseco.mp4 4.5 MB
13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp4 14.26 MB
13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp4 9.64 MB
13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp4 27.14 MB
13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp4 19.58 MB
13 Learn how to build a Discounted Cash Flow model in Excel/117 Modeling other items Interest expenses Extraordinary items and Taxes.mp4 18.85 MB
13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp4 2.57 MB
13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp4 5.63 MB
13 Learn how to build a Discounted Cash Flow model in Excel/120 Calculation of DSO DPO and DOI for the historical period.mp4 8.36 MB
13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp4 11.99 MB
13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 15.99 MB
13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp4 10.45 MB
13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp4 18.49 MB
13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp4 10.32 MB
13 Learn how to build a Discounted Cash Flow model in Excel/126 Completing the output BS sheet for the historical period.mp4 26 MB
13 Learn how to build a Discounted Cash Flow model in Excel/127 Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 10.79 MB
13 Learn how to build a Discounted Cash Flow model in Excel/128 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 7.64 MB
13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp4 34.24 MB
13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp4 23.56 MB
13 Learn how to build a Discounted Cash Flow model in Excel/131 Obtaining the rest of the Cash Flows through Find and Replace.mp4 32.33 MB
13 Learn how to build a Discounted Cash Flow model in Excel/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 7.12 MB
13 Learn how to build a Discounted Cash Flow model in Excel/133 Discounting Unlevered Free Cash Flows in order to obtain their Present Value.mp4 10.66 MB
13 Learn how to build a Discounted Cash Flow model in Excel/134 Calculating Continuing Value and Enterprise Value of the business.mp4 9.67 MB
13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp4 8.33 MB
13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp4 28.94 MB
13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp4 10.61 MB
13 Learn how to build a Discounted Cash Flow model in Excel/138 Using charts in order to summarize the results of the DCF Model.mp4 25.44 MB
13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp4 20.07 MB
13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp4 2.3 MB
其他位置