种子简介

种子名称： Beginner to pro in excel financial modeling and valuation by Udemy
文件类型： 视频
文件数目： 134个文件
文件大小： 1.95 GB
收录时间： 2020-6-4 02:35
已经下载： 3次
资源热度： 259
最近下载： 2024-12-26 22:08

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:dcb1c95299015d27af918b683b029792295d5a39&dn=Beginner to pro in excel financial modeling and valuation by Udemy 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Beginner to pro in excel financial modeling and valuation by Udemy.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/010 Introduction to Formatting.mp424.75MB

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

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

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

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

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

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

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

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

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

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/032 Fix the top row of your table with Freeze Panes.mp417.67MB

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

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/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/033 Filter by color - an excellent tool.mp49.87MB

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/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/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/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/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/023 Create easily printable documents in Excel by using Set Print Area.mp44.73MB

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/022 Learn how to Use the Wrap Text Button.mp42.14MB

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

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

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/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp434.59MB

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/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp416.79MB

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

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/047 A great Excel technique Index Match Match.mp411.76MB

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/041 Key Excel Functions Average and Averageif.mp47.85MB

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/048 Using Excels Iferror function to trap spreadsheet errors.mp47.51MB

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/037 Excels Key Functions - Welcome Lecture.mp42.31MB

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

07 Financial Modeling Part 3 of 4 Case Study Building a Model for LinkedIn/027 What is the Total Addressable Market for LinkedIn and Why is this Important.mp430.1MB

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/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp422.16MB

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

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/057 Give Your Excel Pivot Tables a Makeover.mp411.27MB

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

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/067 Use Vlookup in order to fill the Database sheet.mp448.85MB

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/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/071 Mapping of the rows in the Database sheet.mp429.75MB

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/080 Learn how to build an Area Chart in Excel.mp422.89MB

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/079 Learn how to build effective Doughnut Charts in Excel.mp420.77MB

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/074 Populate the PL sheet with Sumif.mp418.78MB

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/064 Order the source worksheets.mp418.36MB

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/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/072 Building the structure of the PL sheet.mp410.45MB

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

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/068 50 Completed.mp44.3MB

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/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp43.13MB

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/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/093 This is how the report can be used in practice by high-level executives.mp419.8MB

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/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/087 Improving the layout and appearance of the FMCG report.mp413.5MB

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/086 Creating an output structure of the FMCG model.mp411.65MB

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

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/103 Modeling the Income statement.mp413.33MB

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

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

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

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/104 Modeling the Balance sheet - Part 1.mp46.14MB

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

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

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/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/136 Sensitivity analysis for WACC and perpetuity growth.mp428.94MB

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/126 Completing the output BS sheet for the historical period.mp426MB

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/130 Calculating Net Cash Flow.mp423.56MB

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/139 You Made It.mp420.07MB

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/124 Populating the output PL sheet.mp418.49MB

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/113 Modeling the top line.mp414.26MB

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/121 Forecasting DSO DPO and DOI.mp411.99MB

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/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/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/137 A possible application of Goal Seek.mp410.61MB

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/125 Populating the output BS sheet.mp410.32MB

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/114 Introducing scenarios to the model with Choose.mp49.64MB

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/135 Calculating Equity Value.mp48.33MB

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/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp47.12MB

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/112 A glimpse at the company we are valuing - Cheeseco.mp44.5MB

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/140 Congratulations.mp42.3MB

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

4. Let's Build a Solid Foundation Core Accounting Principles That You Should Learn/3. General & Subsidiary Ledgers - This Is How a Firm Organizes Its Accounts.mp45.65MB