FreeTutorials Us beginner to pro in excel financial modeling and valuation |
||
|
Name |
[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation |
DOWNLOAD Copy Link |
|
Total Size |
2.5 GB |
|
|
Total Files |
406 |
|
|
Hash |
2FA64DD36BD59F74BF155668E707D04551B5B264 |
|
/01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/ |
|
|
|
9.4 MB |
|
|
175.3 KB |
|
|
165.6 KB |
|
|
8.2 MB |
|
/02 Introduction to Excel/ |
|
|
|
2.1 MB |
|
|
14.6 MB |
|
|
7.2 MB |
|
|
9.2 MB |
|
|
10.9 MB |
|
|
25.9 MB |
|
|
9.1 MB |
|
|
12.6 MB |
|
|
7.9 MB |
|
|
7.0 MB |
|
|
5.3 MB |
|
/.../006 Overview of Excel/ |
|
|
|
10.7 KB |
|
|
11.1 KB |
|
/.../007 Basic Manipulations with Rows Columns/ |
|
|
|
11.3 KB |
|
|
33.2 KB |
|
/.../008 The Excel Ribbon/ |
|
|
|
12.4 KB |
|
|
412.5 KB |
|
/.../009 Data Entry in Excel/ |
|
|
|
11.2 KB |
|
|
33.5 KB |
|
/.../010 Introduction to Formatting/ |
|
|
|
11.9 KB |
|
|
11.9 KB |
|
|
10.1 KB |
|
|
9.1 KB |
|
/.../011 Introduction to Excel Formulas/ |
|
|
|
12.0 KB |
|
|
82.1 KB |
|
|
9.6 KB |
|
|
9.5 KB |
|
/.../012 Introduction to Excel Functions/ |
|
|
|
13.6 KB |
|
|
83.0 KB |
|
|
9.6 KB |
|
|
9.5 KB |
|
/.../013 Cut Copy Paste/ |
|
|
|
11.6 KB |
|
|
12.9 KB |
|
/.../014 Paste Special/ |
|
|
|
13.8 KB |
|
|
13.8 KB |
|
/.../015 Basic operations in Excel - 38 pages/ |
|
|
|
4.9 MB |
|
/quizzes/ |
|
|
|
2.5 KB |
|
|
3.0 KB |
|
|
2.7 KB |
|
|
2.9 KB |
|
/03 Useful tips and tools for your work in Excel/ |
|
|
|
2.2 MB |
|
017 Initial formatting of an Excel sheet in order to render it professional.mp4 |
8.4 MB |
|
|
23.2 MB |
|
|
21.4 MB |
|
|
3.5 MB |
|
021 Learn how to organize your data with Text to Columns.mp4 |
13.1 MB |
|
|
2.2 MB |
|
023 Create easily printable documents in Excel by using Set Print Area.mp4 |
5.0 MB |
|
024 Find and select special types of cells with Select Special F5.mp4 |
10.3 MB |
|
025 Learn how to assign dynamic names within a Financial Model.mp4 |
7.7 MB |
|
|
5.7 MB |
|
027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp4 |
5.7 MB |
|
|
11.6 MB |
|
|
11.1 MB |
|
030 Using Custom-sort in order to sort multiple columns within a table.mp4 |
9.6 MB |
|
031 Create a great Index page at the beginning of your models - Hyperlinks.mp4 |
5.6 MB |
|
|
18.5 MB |
|
|
10.4 MB |
|
|
15.8 MB |
|
/.../017 Initial formatting of an Excel sheet in order to render it professional/ |
|
|
|
9.8 KB |
|
|
9.2 KB |
|
|
9.9 MB |
|
/.../018 Fast scrolling through Excel sheets/ |
|
|
|
45.0 KB |
|
|
45.4 KB |
|
|
657.9 KB |
|
|
9.9 MB |
|
|
2.3 MB |
|
/.../019 Introduction to fixing of cell references/ |
|
|
|
10.9 KB |
|
|
11.1 KB |
|
|
660.7 KB |
|
|
659.4 KB |
|
|
9.9 MB |
|
/.../020 Using the Alt plus Enter combination/ |
|
|
|
11.4 KB |
|
|
11.7 KB |
|
|
9.9 KB |
|
|
9.9 KB |
|
|
9.9 MB |
|
/.../021 Learn how to organize your data with Text to Columns/ |
|
|
|
10.8 KB |
|
|
11.6 KB |
|
|
10.1 KB |
|
|
10.0 KB |
|
|
9.9 MB |
|
/.../022 Learn how to Use the Wrap Text Button/ |
|
|
|
10.4 KB |
|
|
10.4 KB |
|
|
9.9 MB |
|
|
9.8 KB |
|
|
9.8 KB |
|
/.../023 Create easily printable documents in Excel by using Set Print Area/ |
|
|
|
11.5 KB |
|
|
11.7 KB |
|
|
9.9 MB |
|
/.../024 Find and select special types of cells with Select Special F5/ |
|
|
|
22.1 KB |
|
|
22.8 KB |
|
|
10.8 KB |
|
|
9.9 MB |
|
/.../025 Learn how to assign dynamic names within a Financial Model/ |
|
|
|
11.5 KB |
|
|
12.0 KB |
|
|
14.2 KB |
|
|
13.9 KB |
|
|
9.9 MB |
|
/.../026 Define a named range in Excel/ |
|
|
|
11.3 KB |
|
|
11.9 KB |
|
|
10.6 KB |
|
|
9.0 KB |
|
|
9.9 MB |
|
/.../028 Macros are a great timesaver Heres why/ |
|
|
|
10.6 KB |
|
|
148.5 KB |
|
|
11.4 KB |
|
|
9.9 KB |
|
|
9.9 MB |
|
/.../029 Create a drop-down list by using Data Validation/ |
|
|
|
11.6 KB |
|
|
78.9 KB |
|
|
11.1 KB |
|
|
11.1 KB |
|
|
9.9 MB |
|
/.../030 Using Custom-sort in order to sort multiple columns within a table/ |
|
|
|
11.6 KB |
|
|
11.7 KB |
|
|
149.1 KB |
|
|
148.8 KB |
|
|
9.9 MB |
|
/.../031 Create a great Index page at the beginning of your models - Hyperlinks/ |
|
|
|
140.2 KB |
|
|
140.4 KB |
|
|
2.3 MB |
|
|
9.9 MB |
|
/.../032 Fix the top row of your table with Freeze Panes/ |
|
|
|
659.4 KB |
|
|
659.3 KB |
|
|
9.9 MB |
|
/.../033 Filter by color - an excellent tool/ |
|
|
|
21.0 KB |
|
|
157.2 KB |
|
/.../034 Working with conditional formatting/ |
|
|
|
13.2 KB |
|
|
52.8 KB |
|
/quizzes/ |
|
|
|
2.9 KB |
|
|
3.0 KB |
|
007 Learn how to organize your data with Text to Columns.html |
2.7 KB |
|
|
2.8 KB |
|
|
2.9 KB |
|
|
2.8 KB |
|
011 Useful tips and tools for your work in Excel - Quiz.html |
6.3 KB |
|
/04 Keyboard shortcuts in Excel/ |
|
|
|
31.9 MB |
|
|
1.7 MB |
|
/.../036 Keyboard shortcuts in Excel/ |
|
|
|
787.7 KB |
|
|
1.3 MB |
|
/05 Excels key functions and functionalities made easy/ |
|
|
|
2.4 MB |
|
|
579.5 KB |
|
|
20.3 MB |
|
|
17.8 MB |
|
|
8.2 MB |
|
042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp4 |
17.6 MB |
|
043 Find the minimum or maximum value in a range of cells in Excel.mp4 |
6.2 MB |
|
|
3.3 MB |
|
045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 |
36.3 MB |
|
046 Index Match and their combination - the perfect substitute of Vlookup.mp4 |
40.8 MB |
|
|
12.3 MB |
|
048 Using Excels Iferror function to trap spreadsheet errors.mp4 |
7.9 MB |
|
049 Learn how to render your models flexible with Choose.mp4 |
9.4 MB |
|
050 Use Goal Seek in order to find the result that you are looking for.mp4 |
8.2 MB |
|
051 Include sensitivity analysis in your models through Data Tables.mp4 |
15.0 MB |
|
|
17.4 MB |
|
/.../038 Key Functions in Excel If/ |
|
|
|
994.3 KB |
|
|
9.7 KB |
|
|
9.2 KB |
|
/.../039 Key Excel Functions Sum Sumif and Sumifs/ |
|
|
|
14.8 KB |
|
|
15.2 KB |
|
|
10.3 MB |
|
|
13.3 KB |
|
|
13.2 KB |
|
/.../040 Key Excel Functions Count Counta Countif Countifs/ |
|
|
|
15.6 KB |
|
|
16.0 KB |
|
|
12.0 KB |
|
|
11.6 KB |
|
|
10.3 MB |
|
/.../041 Key Excel Functions Average and Averageif/ |
|
|
|
15.0 KB |
|
|
15.4 KB |
|
|
9.6 KB |
|
|
9.2 KB |
|
/.../042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/ |
|
|
|
10.3 MB |
|
|
11.4 KB |
|
|
10.9 KB |
|
/.../043 Find the minimum or maximum value in a range of cells in Excel/ |
|
|
|
14.7 KB |
|
|
15.2 KB |
|
|
9.4 KB |
|
|
9.2 KB |
|
/.../044 Include Round in your Financial Models/ |
|
|
|
11.6 KB |
|
|
12.0 KB |
|
|
994.3 KB |
|
|
10.3 MB |
|
/.../045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/ |
|
|
|
14.0 KB |
|
|
10.3 MB |
|
|
11.4 KB |
|
|
11.0 KB |
|
/.../046 Index Match and their combination - the perfect substitute of Vlookup/ |
|
|
|
12.4 KB |
|
|
12.0 KB |
|
|
11.6 KB |
|
|
10.3 MB |
|
/.../047 A great Excel technique Index Match Match/ |
|
|
|
11.9 KB |
|
|
12.5 KB |
|
/.../048 Using Excels Iferror function to trap spreadsheet errors/ |
|
|
|
14.6 KB |
|
|
15.7 KB |
|
|
9.6 KB |
|
|
9.8 KB |
|
|
10.3 MB |
|
/.../049 Learn how to render your models flexible with Choose/ |
|
|
|
11.6 KB |
|
|
12.0 KB |
|
|
9.9 KB |
|
|
9.6 KB |
|
|
10.3 MB |
|
/.../050 Use Goal Seek in order to find the result that you are looking for/ |
|
|
|
16.5 KB |
|
|
16.6 KB |
|
|
9.1 KB |
|
|
9.1 KB |
|
|
10.3 MB |
|
/.../051 Include sensitivity analysis in your models through Data Tables/ |
|
|
|
13.4 KB |
|
|
9.7 KB |
|
|
9.5 KB |
|
|
10.3 MB |
|
/.../052 Excels dynamic and interactive tables Pivot tables/ |
|
|
|
155.8 KB |
|
|
194.6 KB |
|
|
994.3 KB |
|
|
10.3 MB |
|
/quizzes/ |
|
|
|
2.7 KB |
|
013 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.html |
2.7 KB |
|
014 Index Match and their combination - the perfect substitute of Vlookup.html |
2.6 KB |
|
015 Use Goal Seek in order to find the result that you are looking for.html |
3.0 KB |
|
016 Include sensitivity analysis in your models through Data Tables.html |
3.2 KB |
|
|
6.4 KB |
|
/06 Update 15 December - Exercise/ |
|
|
|
209.3 KB |
|
054 Exercise - Excels Sumifs function - explained solved.mp4 |
37.0 MB |
|
/.../053 Exercise - Excels Sumifs function - unsolved/ |
|
|
|
1.3 MB |
|
/.../054 Exercise - Excels Sumifs function - explained solved/ |
|
|
|
1.4 MB |
|
/07 Microsoft Excels Pivot Tables in Depth/ |
|
|
|
6.3 MB |
|
|
20.3 MB |
|
|
11.8 MB |
|
058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp4 |
24.1 MB |
|
059 Learn More About GetPivotData - A Very Important Excel Function.mp4 |
18.9 MB |
|
060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp4 |
23.2 MB |
|
/.../056 Creating Pivot Tables is easy/ |
|
|
|
1.5 MB |
|
/.../057 Give Your Excel Pivot Tables a Makeover/ |
|
|
|
1.5 MB |
|
/.../058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need/ |
|
|
|
2.0 MB |
|
/.../059 Learn More About GetPivotData - A Very Important Excel Function/ |
|
|
|
2.0 MB |
|
/.../060 An Introduction to Slicers - The Moden Day Pivot Table Filters/ |
|
|
|
2.0 MB |
|
|
871.7 KB |
|
/08 Case Study - Building a Complete PL from scratch in Excel/ |
|
|
061 Case Study - Build a PL From Scratch - Welcome Lecture.mp4 |
3.3 MB |
|
|
7.1 MB |
|
063 Understand your data source before you start working on It.mp4 |
22.3 MB |
|
|
19.3 MB |
|
065 Create a code the best way to organize your data and work efficiently with It.mp4 |
19.6 MB |
|
|
19.0 MB |
|
|
51.2 MB |
|
|
4.5 MB |
|
|
46.6 MB |
|
|
44.2 MB |
|
|
31.2 MB |
|
|
11.0 MB |
|
073 Formatting sets You apart from the competition in Excel - A Practical Example.mp4 |
16.0 MB |
|
|
19.7 MB |
|
|
24.9 MB |
|
076 Calculating year-on-year percentage variations the proper way.mp4 |
21.8 MB |
|
077 Create professional and good-looking charts - Introduction.mp4 |
3.8 MB |
|
078 Build a Column Stacked Chart with a secondary line axis in Excel.mp4 |
34.3 MB |
|
079 Learn how to build effective Doughnut Charts in Excel.mp4 |
21.8 MB |
|
|
24.0 MB |
|
|
59.2 MB |
|
|
8.3 MB |
|
/.../064 Order the source worksheets/ |
|
|
|
37.5 KB |
|
|
29.3 KB |
|
/.../066 Learn how to create a Database/ |
|
|
|
36.3 KB |
|
|
31.4 KB |
|
/.../067 Use Vlookup in order to fill the Database sheet/ |
|
|
|
41.7 KB |
|
|
38.3 KB |
|
|
33.3 KB |
|
/.../069 Use Sumif in order to complete the Database sheet/ |
|
|
|
48.4 KB |
|
|
38.3 KB |
|
/.../070 Use Index Match as a substitute of Vlookup/ |
|
|
|
43.9 KB |
|
|
39.4 KB |
|
/.../071 Mapping of the rows in the Database sheet/ |
|
|
|
48.6 KB |
|
|
40.0 KB |
|
/.../072 Building the structure of the PL sheet/ |
|
|
|
55.1 KB |
|
|
55.1 KB |
|
/.../074 Populate the PL sheet with Sumif/ |
|
|
|
60.4 KB |
|
|
50.4 KB |
|
/.../075 Learn how to find mistakes with Countif/ |
|
|
|
58.7 KB |
|
|
55.3 KB |
|
/.../076 Calculating year-on-year percentage variations the proper way/ |
|
|
|
57.9 KB |
|
/.../079 Learn how to build effective Doughnut Charts in Excel/ |
|
|
|
12.1 MB |
|
|
12.1 MB |
|
/.../080 Learn how to build an Area Chart in Excel/ |
|
|
|
12.1 MB |
|
|
12.1 MB |
|
/.../081 Learn how to create Bridge Charts/ |
|
|
|
12.1 MB |
|
|
12.1 MB |
|
|
12.8 MB |
|
/.../082 Course Challenge - Apply Your Skills in Practice/ |
|
|
|
517.6 KB |
|
|
557.6 KB |
|
/quizzes/ |
|
|
018 Case Study - Building a Complete PL from scratch in Excel.html |
6.0 KB |
|
/09 Case Study - Building an FMCG Model from Scratch/ |
|
|
|
12.6 MB |
|
|
23.7 MB |
|
|
23.0 MB |
|
|
12.2 MB |
|
087 Improving the layout and appearance of the FMCG report.mp4 |
14.2 MB |
|
|
9.3 MB |
|
089 Creating a Master Pivot Table The main data source for the FMCG report.mp4 |
14.5 MB |
|
090 GetPivotData is great Extracting data from the Master Pivot Table.mp4 |
32.5 MB |
|
091 Combining Slicers and GetPivotData The key to our success.mp4 |
18.7 MB |
|
092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 |
17.9 MB |
|
093 This is how the report can be used in practice by high-level executives.mp4 |
20.8 MB |
|
/.../083 Introduction to the Case Study/ |
|
|
|
13.9 MB |
|
/.../084 Preliminary mapping of the data extraction/ |
|
|
|
15.6 MB |
|
/.../086 Creating an output structure of the FMCG model/ |
|
|
|
15.6 MB |
|
/.../087 Improving the layout and appearance of the FMCG report/ |
|
|
|
15.6 MB |
|
/.../088 Inserting formulas and automating calculations/ |
|
|
|
15.6 MB |
|
/10 Financial Modeling Fundamentals/ |
|
|
|
2.2 MB |
|
|
5.7 MB |
|
|
10.5 MB |
|
097 Financial modeling Worst Practices - Things you should avoid.mp4 |
20.9 MB |
|
|
18.1 MB |
|
099 Financial modeling The types of models that are built in practice.mp4 |
15.0 MB |
|
100 Financial modeling The right level of detail in a model.mp4 |
7.6 MB |
|
|
7.5 MB |
|
102 Building a complete model - Important considerations.mp4 |
8.8 MB |
|
|
14.0 MB |
|
|
6.4 MB |
|
|
11.1 MB |
|
/quizzes/ |
|
|
|
7.2 KB |
|
|
7.1 KB |
|
|
6.9 KB |
|
/11 Introduction to Company Valuation/ |
|
|
|
886.2 KB |
|
/.../106 The core theory behind Company Valuation/ |
|
|
|
783.5 KB |
|
/12 Introduction to Mergers Acquisitions/ |
|
|
|
1.1 MB |
|
/.../107 Introduction to Mergers Acquisitions/ |
|
|
|
1.1 MB |
|
/13 Learn how to build a Discounted Cash Flow model in Excel/ |
|
|
|
1.9 MB |
|
|
12.2 MB |
|
|
24.0 MB |
|
|
13.1 MB |
|
|
4.7 MB |
|
|
15.0 MB |
|
|
10.1 MB |
|
|
28.5 MB |
|
|
20.5 MB |
|
117 Modeling other items Interest expenses Extraordinary items and Taxes.mp4 |
19.8 MB |
|
|
2.7 MB |
|
|
5.9 MB |
|
120 Calculation of DSO DPO and DOI for the historical period.mp4 |
8.8 MB |
|
|
12.6 MB |
|
122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 |
16.8 MB |
|
|
11.0 MB |
|
|
19.4 MB |
|
|
10.8 MB |
|
126 Completing the output BS sheet for the historical period.mp4 |
27.3 MB |
|
127 Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 |
11.3 MB |
|
|
8.0 MB |
|
|
35.9 MB |
|
|
24.7 MB |
|
131 Obtaining the rest of the Cash Flows through Find and Replace.mp4 |
33.9 MB |
|
132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 |
7.5 MB |
|
133 Discounting Unlevered Free Cash Flows in order to obtain their Present Value.mp4 |
11.2 MB |
|
134 Calculating Continuing Value and Enterprise Value of the business.mp4 |
10.1 MB |
|
|
8.7 MB |
|
|
30.3 MB |
|
|
11.1 MB |
|
138 Using charts in order to summarize the results of the DCF Model.mp4 |
26.7 MB |
|
|
21.0 MB |
|
|
2.4 MB |
|
/.../110 The various stages of a complete DCF Valuation/ |
|
|
|
421.6 KB |
|
/.../111 Description of the structure of the DCF model/ |
|
|
|
50.0 KB |
|
|
246.6 KB |
|
/.../112 A glimpse at the company we are valuing - Cheeseco/ |
|
|
|
43.4 KB |
|
/.../113 Modeling the top line/ |
|
|
|
50.5 KB |
|
|
49.8 KB |
|
/.../114 Introducing scenarios to the model with Choose/ |
|
|
|
50.7 KB |
|
|
47.6 KB |
|
/.../115 Modeling other items Other revenues and Cogs/ |
|
|
|
53.1 KB |
|
|
49.9 KB |
|
/.../116 Modeling other items Operating expenses and DA/ |
|
|
|
53.6 KB |
|
|
50.1 KB |
|
/.../118 Forecasting Balance Sheet items/ |
|
|
|
54.0 KB |
|
|
54.0 KB |
|
/.../119 An introduction to the Days methodology/ |
|
|
|
124.5 KB |
|
/.../121 Forecasting DSO DPO and DOI/ |
|
|
|
54.9 KB |
|
|
51.3 KB |
|
/.../123 Creating an output PL sheet/ |
|
|
|
56.7 KB |
|
|
51.6 KB |
|
/.../124 Populating the output PL sheet/ |
|
|
|
58.5 KB |
|
|
54.0 KB |
|
/.../125 Populating the output BS sheet/ |
|
|
|
60.2 KB |
|
|
56.1 KB |
|
/.../126 Completing the output BS sheet for the historical period/ |
|
|
|
61.5 KB |
|
/.../128 Bridging Unlevered Free Cash Flow to Net Cash Flow/ |
|
|
|
61.8 KB |
|
|
58.2 KB |
|
/.../129 Calculating Unlevered Free Cash Flow/ |
|
|
|
59.3 KB |
|
|
60.9 KB |
|
/.../130 Calculating Net Cash Flow/ |
|
|
|
62.8 KB |
|
|
59.3 KB |
|
|
57.3 KB |
|
/.../135 Calculating Equity Value/ |
|
|
|
64.1 KB |
|
|
63.8 KB |
|
/.../136 Sensitivity analysis for WACC and perpetuity growth/ |
|
|
|
65.4 KB |
|
|
64.1 KB |
|
|
62.3 KB |
|
/.../137 A possible application of Goal Seek/ |
|
|
|
65.4 KB |
|
|
65.4 KB |
|
/.../138 Using charts in order to summarize the results of the DCF Model/ |
|
|
|
99.4 KB |
|
|
65.4 KB |
|
/ |
|
|
|
0.1 KB |
|
|
0.1 KB |
|
Total files 406 |
|
Copyright © 2025 FileMood.com