种子简介

种子名称： [FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation
文件类型： 视频
文件数目： 132个文件
文件大小： 1.92 GB
收录时间： 2017-10-31 14:59
已经下载： 3次
资源热度： 188
最近下载： 2024-4-17 15:17

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:2fa64dd36bd59f74bf155668e707d04551b5b264&dn=[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation.torrent

01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp48.94MB

01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp47.82MB

02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp41.99MB

02 Introduction to Excel/006 Overview of Excel.mp413.95MB

02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp46.9MB

02 Introduction to Excel/008 The Excel Ribbon.mp48.8MB

02 Introduction to Excel/009 Data Entry in Excel.mp410.39MB

02 Introduction to Excel/010 Introduction to Formatting.mp424.75MB

02 Introduction to Excel/011 Introduction to Excel Formulas.mp48.69MB

02 Introduction to Excel/012 Introduction to Excel Functions.mp412.05MB

02 Introduction to Excel/013 Cut Copy Paste.mp47.56MB

02 Introduction to Excel/014 Paste Special.mp46.69MB

03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp42.13MB

03 Useful tips and tools for your work in Excel/017 Initial formatting of an Excel sheet in order to render it professional.mp47.98MB

03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp422.16MB

03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp420.37MB

03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp43.33MB

03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp412.53MB

03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp42.14MB

03 Useful tips and tools for your work in Excel/023 Create easily printable documents in Excel by using Set Print Area.mp44.73MB

03 Useful tips and tools for your work in Excel/024 Find and select special types of cells with Select Special F5.mp49.78MB

03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp47.31MB

03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp45.42MB

03 Useful tips and tools for your work in Excel/027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp45.41MB

03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp411.1MB

03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp410.58MB

03 Useful tips and tools for your work in Excel/030 Using Custom-sort in order to sort multiple columns within a table.mp49.14MB

03 Useful tips and tools for your work in Excel/031 Create a great Index page at the beginning of your models - Hyperlinks.mp45.35MB

03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp417.67MB

03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp49.87MB

03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp415.08MB

04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp430.43MB

05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp42.31MB

05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp419.32MB

05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp416.98MB

05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp47.85MB

05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp416.79MB

05 Excels key functions and functionalities made easy/043 Find the minimum or maximum value in a range of cells in Excel.mp45.91MB

05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp43.12MB

05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp434.59MB

05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp438.95MB

05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp411.76MB

05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp47.51MB

05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp48.98MB

05 Excels key functions and functionalities made easy/050 Use Goal Seek in order to find the result that you are looking for.mp47.85MB

05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp414.28MB

05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp416.58MB

06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp435.31MB

07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp46MB

07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp419.37MB

07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp411.27MB

07 Microsoft Excels Pivot Tables in Depth/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp423MB

07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp418.06MB

07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp422.16MB

08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp43.13MB

08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp46.8MB

08 Case Study - Building a Complete PL from scratch in Excel/063 Understand your data source before you start working on It.mp421.24MB

08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp418.36MB

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.mp418.7MB

08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp418.11MB

08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp448.85MB

08 Case Study - Building a Complete PL from scratch in Excel/068 50 Completed.mp44.3MB

08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp444.48MB

08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp442.14MB

08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp429.75MB

08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp410.45MB

08 Case Study - Building a Complete PL from scratch in Excel/073 Formatting sets You apart from the competition in Excel - A Practical Example.mp415.24MB

08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp418.78MB

08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp423.74MB

08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp420.75MB

08 Case Study - Building a Complete PL from scratch in Excel/077 Create professional and good-looking charts - Introduction.mp43.6MB

08 Case Study - Building a Complete PL from scratch in Excel/078 Build a Column Stacked Chart with a secondary line axis in Excel.mp432.72MB

08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp420.77MB

08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp422.89MB

08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp456.48MB

08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp47.91MB

09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp412.05MB

09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp422.6MB

09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp421.95MB

09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp411.65MB

09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp413.5MB

09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp48.83MB

09 Case Study - Building an FMCG Model from Scratch/089 Creating a Master Pivot Table The main data source for the FMCG report.mp413.82MB

09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp431.04MB

09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp417.83MB

09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp417.11MB

09 Case Study - Building an FMCG Model from Scratch/093 This is how the report can be used in practice by high-level executives.mp419.8MB

10 Financial Modeling Fundamentals/094 Financial Modeling Basics - Welcome Lecture.mp42.09MB

10 Financial Modeling Fundamentals/095 What is a Financial model.mp45.48MB

10 Financial Modeling Fundamentals/096 Why use Financial models.mp410.03MB

10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp419.91MB

10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp417.22MB

10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp414.26MB

10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp47.29MB

10 Financial Modeling Fundamentals/101 Financial modeling Forecasting guidelines.mp47.11MB

10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp48.44MB

10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp413.33MB

10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp46.14MB

10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp410.6MB

13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp41.78MB

13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp411.61MB

13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp422.89MB

13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp412.53MB

13 Learn how to build a Discounted Cash Flow model in Excel/112 A glimpse at the company we are valuing - Cheeseco.mp44.5MB

13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp414.26MB

13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp49.64MB

13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp427.14MB

13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp419.58MB

13 Learn how to build a Discounted Cash Flow model in Excel/117 Modeling other items Interest expenses Extraordinary items and Taxes.mp418.85MB

13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp42.57MB

13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp45.63MB

13 Learn how to build a Discounted Cash Flow model in Excel/120 Calculation of DSO DPO and DOI for the historical period.mp48.36MB

13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp411.99MB

13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp415.99MB

13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp410.45MB

13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp418.49MB

13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp410.32MB

13 Learn how to build a Discounted Cash Flow model in Excel/126 Completing the output BS sheet for the historical period.mp426MB

13 Learn how to build a Discounted Cash Flow model in Excel/127 Creating a structure for the calculation of Unlevered Free Cash Flows.mp410.79MB

13 Learn how to build a Discounted Cash Flow model in Excel/128 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp47.64MB

13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp434.24MB

13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp423.56MB

13 Learn how to build a Discounted Cash Flow model in Excel/131 Obtaining the rest of the Cash Flows through Find and Replace.mp432.33MB

13 Learn how to build a Discounted Cash Flow model in Excel/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp47.12MB

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.mp410.66MB

13 Learn how to build a Discounted Cash Flow model in Excel/134 Calculating Continuing Value and Enterprise Value of the business.mp49.67MB

13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp48.33MB

13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp428.94MB

13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp410.61MB

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.mp425.44MB

13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp420.07MB

13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp42.3MB