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

Creation Time	Sept. 22, 2024, 2:14 p.m.
Last Access Time	Oct. 7, 2025, 3:49 a.m.
File Size	2.4 GB
Keywords	Us FreeTutorials beginner-to-pro-in-excel-financial-modeling-and-valuation
Total Requests	18
Total Files	406
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp4 56.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp4 48.8 MB
08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp4 44.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp4 42.1 MB
05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp4 39.0 MB
06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp4 35.3 MB
05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 34.6 MB
13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp4 34.2 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.7 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.3 MB
09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp4 31.0 MB
04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp4 30.4 MB
08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp4 29.7 MB
13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp4 28.9 MB
13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp4 27.1 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.0 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.4 MB
02 Introduction to Excel/010 Introduction to Formatting.mp4 24.7 MB
08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp4 23.7 MB
13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp4 23.6 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.0 MB
13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp4 22.9 MB
08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp4 22.9 MB
09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp4 22.6 MB
07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp4 22.2 MB
03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp4 22.2 MB
09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp4 22.0 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.2 MB
08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp4 20.8 MB
08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp4 20.8 MB
03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp4 20.4 MB
13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp4 20.1 MB
10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp4 19.9 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
13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp4 19.6 MB
07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp4 19.4 MB
05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp4 19.3 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.8 MB
08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp4 18.8 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
13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp4 18.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp4 18.4 MB
08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp4 18.1 MB
07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp4 18.1 MB
09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp4 17.8 MB
03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp4 17.7 MB
10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp4 17.2 MB
09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.1 MB
05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp4 17.0 MB
05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp4 16.8 MB
05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp4 16.6 MB
13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 16.0 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.2 MB
03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp4 15.1 MB
09 Case Study - Building an FMCG Model from Scratch/attached_files/088 Inserting formulas and automating calculations/4.Exercise-Build-an-FMCG-Model-Adding-Calculations.xlsx 14.9 MB
09 Case Study - Building an FMCG Model from Scratch/attached_files/087 Improving the layout and appearance of the FMCG report/2.Exercise-Build-an-FMCG-Model-Layout.xlsx 14.9 MB
09 Case Study - Building an FMCG Model from Scratch/attached_files/086 Creating an output structure of the FMCG model/2.Exercise-Build-an-FMCG-Model-Structure.xlsx 14.9 MB
09 Case Study - Building an FMCG Model from Scratch/attached_files/084 Preliminary mapping of the data extraction/1.Exercise-Build-an-FMCG-Model-Mapping.xlsx 14.9 MB
05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp4 14.3 MB
13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp4 14.3 MB
10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp4 14.3 MB
02 Introduction to Excel/006 Overview of Excel.mp4 14.0 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.8 MB
09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp4 13.5 MB
10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp4 13.3 MB
09 Case Study - Building an FMCG Model from Scratch/attached_files/083 Introduction to the Case Study/0.Exercise-Build-an-FMCG-Model-before.xlsx 13.3 MB
13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp4 12.5 MB
03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp4 12.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Case-Study-Building-A-P-L-From-Scratch-Complete.xlsx 12.2 MB
09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp4 12.1 MB
02 Introduction to Excel/012 Introduction to Excel Functions.mp4 12.0 MB
13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp4 12.0 MB
05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp4 11.8 MB
09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp4 11.7 MB
13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp4 11.6 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/079 Learn how to build effective Doughnut Charts in Excel/Doughnut-Chart-Solved.xlsm 11.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/079 Learn how to build effective Doughnut Charts in Excel/Doughnut-Chart-Unsolved.xlsm 11.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/080 Learn how to build an Area Chart in Excel/Area-Chart-Solved.xlsm 11.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Solved.xlsm 11.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/080 Learn how to build an Area Chart in Excel/Area-Chart-Unsolved.xlsm 11.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Unsolved.xlsm 11.5 MB
07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp4 11.3 MB
03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp4 11.1 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.8 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.7 MB
13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp4 10.6 MB
10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp4 10.6 MB
03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp4 10.6 MB
13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp4 10.5 MB
08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp4 10.5 MB
02 Introduction to Excel/009 Data Entry in Excel.mp4 10.4 MB
13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp4 10.3 MB
10 Financial Modeling Fundamentals/096 Why use Financial models.mp4 10.0 MB
03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp4 9.9 MB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Key-Functions-In-Excel.pdf 9.8 MB
05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Key-Functions-In-Excel.pdf 9.8 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.8 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.7 MB
13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp4 9.6 MB
03 Useful tips and tools for your work in Excel/attached_files/017 Initial formatting of an Excel sheet in order to render it professional/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/023 Create easily printable documents in Excel by using Set Print Area/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/Useful-Tips-Tools-PDF-Version.pdf 9.4 MB
03 Useful tips and tools for your work in Excel/attached_files/032 Fix the top row of your table with Freeze Panes/Useful-Tips-Tools-PDF-Version.pdf 9.4 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.1 MB
05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp4 9.0 MB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp4 8.9 MB
09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp4 8.8 MB
02 Introduction to Excel/008 The Excel Ribbon.mp4 8.8 MB
02 Introduction to Excel/011 Introduction to Excel Formulas.mp4 8.7 MB
10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp4 8.4 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.4 MB
13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp4 8.3 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 8.0 MB
08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp4 7.9 MB
05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp4 7.9 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.9 MB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp4 7.8 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.6 MB
02 Introduction to Excel/013 Cut Copy Paste.mp4 7.6 MB
05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp4 7.5 MB
03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp4 7.3 MB
10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp4 7.3 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.1 MB
10 Financial Modeling Fundamentals/101 Financial modeling Forecasting guidelines.mp4 7.1 MB
02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp4 6.9 MB
08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp4 6.8 MB
02 Introduction to Excel/014 Paste Special.mp4 6.7 MB
10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp4 6.1 MB
07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp4 6.0 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.9 MB
13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp4 5.6 MB
10 Financial Modeling Fundamentals/095 What is a Financial model.mp4 5.5 MB
03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp4 5.4 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.4 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.4 MB
02 Introduction to Excel/015 Basic operations in Excel - 38 pages.pdf 5.0 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.7 MB
02 Introduction to Excel/attached_files/015 Basic operations in Excel - 38 pages/Introduction-to-Excels-basic-features.pdf 4.7 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
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/077 Create professional and good-looking charts - Introduction.mp4 3.6 MB
03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp4 3.3 MB
08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp4 3.1 MB
05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp4 3.1 MB
13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp4 2.6 MB
05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp4 2.3 MB
13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp4 2.3 MB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/Useful-tips-and-tools-Excel-file.xlsx 2.2 MB
03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/Useful-Tips-And-Tools-Excel-File.xlsx 2.2 MB
03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp4 2.1 MB
03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp4 2.1 MB
10 Financial Modeling Fundamentals/094 Financial Modeling Basics - Welcome Lecture.mp4 2.1 MB
02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp4 2.0 MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need/4.Working-with-Pivot-Tables.xlsx 1.9 MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/6.Slicers.xlsx 1.9 MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/059 Learn More About GetPivotData - A Very Important Excel Function/5.GetPivotData.xlsx 1.9 MB
13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp4 1.8 MB
04 Keyboard shortcuts in Excel/036 Keyboard shortcuts in Excel.pdf 1.6 MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/056 Creating Pivot Tables is easy/2.Creating-a-Pivot-Table.xlsx 1.4 MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/057 Give Your Excel Pivot Tables a Makeover/3.Formatting-a-Pivot-Table.xlsx 1.4 MB
06 Update 15 December - Exercise/attached_files/054 Exercise - Excels Sumifs function - explained solved/Exercise-Sumifs-With-Solutions.xlsx 1.3 MB
06 Update 15 December - Exercise/attached_files/053 Exercise - Excels Sumifs function - unsolved/Exercise-Sumifs-Without-Solutions.xlsx 1.3 MB
04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts.pdf 1.3 MB
12 Introduction to Mergers Acquisitions/107 Introduction to Mergers Acquisitions.pdf 1.0 MB
12 Introduction to Mergers Acquisitions/attached_files/107 Introduction to Mergers Acquisitions/Introduction-to-M-A.pdf 1.0 MB
05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/Excel-Functions.xlsx 971.0 KB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Excel-Functions.xlsx 971.0 KB
05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Excel-Functions.xlsx 971.0 KB
11 Introduction to Company Valuation/106 The core theory behind Company Valuation.pdf 865.4 KB
07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/Database-Pivot-Slicers.xlsm 851.2 KB
04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts-for-MAC.pdf 769.2 KB
11 Introduction to Company Valuation/attached_files/106 The core theory behind Company Valuation/Company-valuation.pdf 765.2 KB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Solved.xlsx 645.2 KB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Unsolved.xlsx 644.0 KB
03 Useful tips and tools for your work in Excel/attached_files/032 Fix the top row of your table with Freeze Panes/Freeze-Panes-Solved.xlsx 643.9 KB
03 Useful tips and tools for your work in Excel/attached_files/032 Fix the top row of your table with Freeze Panes/Freeze-Panes-Unsolved.xlsx 643.9 KB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/2.Fast-Scrolling-Solved.xlsx 642.5 KB
05 Excels key functions and functionalities made easy/038 Key Functions in Excel If.pdf 565.9 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/082 Course Challenge - Apply Your Skills in Practice/1.SOULUTIONS-Course-Challenge.xlsx 544.5 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/082 Course Challenge - Apply Your Skills in Practice/1.Course-Challenge.xlsx 505.5 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/110 The various stages of a complete DCF Valuation/Valuation-exercise.pdf 411.8 KB
02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Solved.xlsx 402.8 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/111 Description of the structure of the DCF model/DCF-Model-structure.pdf 240.8 KB
06 Update 15 December - Exercise/053 Exercise - Excels Sumifs function - unsolved.pdf 204.4 KB
05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/05-49-Pivot-Tables-Intro-Solved.xlsx 190.1 KB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/002 Bonus Welcome gift.pdf 171.2 KB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/003 Welcome gift number 2.pdf 161.7 KB
03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Solution-Filter-by-Color.xlsx 153.5 KB
05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/05-49-Pivot-Tables-Intro-Exercise-Text.xlsx 152.2 KB
03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/Sort-data-Solved.xlsx 145.6 KB
03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/Sort-data-Unsolved.xlsx 145.3 KB
03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/03-28-Macros-Solved.xlsx 145.0 KB
03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/03-31-Hyperlinks-Solved.xlsx 137.1 KB
03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/03-31-Hyperlinks-Exercise-Text.xlsx 136.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/119 An introduction to the Days methodology/Working-Capital-Days.pptx 121.5 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/138 Using charts in order to summarize the results of the DCF Model/30.Charts-Solved.xlsm 97.1 KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Solved.xlsx 81.1 KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Solved.xlsx 80.1 KB
03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/03-29-Drop-down-List-Solved.xlsx 77.0 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/138 Using charts in order to summarize the results of the DCF Model/30.Charts-Unsolved.xlsm 63.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/137 A possible application of Goal Seek/29.Goal-seek-Solved.xlsm 63.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/28.Sensitivity-analysis-Solved.xlsm 63.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/137 A possible application of Goal Seek/29.Goal-Seek-Unsolved.xlsm 63.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Solved.xlsm 62.6 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/28.Sensitivity-analysis-Unsolved.xlsm 62.6 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Unsolved.xlsm 62.3 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/22.From-UFCF-to-Net-Cash-Flow-Solved.xlsm 61.3 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/Sensitivity-Analysis.xlsx 60.8 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/128 Bridging Unlevered Free Cash Flow to Net Cash Flow/20.From-UFCF-to-Net-Cash-Flow-Solved.xlsm 60.4 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/126 Completing the output BS sheet for the historical period/18.Completing-the-BS-items-Solved.xlsm 60.0 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/129 Calculating Unlevered Free Cash Flow/21.Calculating-UFCF-Unsolved.xlsm 59.5 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/074 Populate the PL sheet with Sumif/13.Populating-the-P-L-sheet-Solved.xlsm 59.0 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/125 Populating the output BS sheet/17.Populating-the-BS-sheet-Solved.xlsm 58.8 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/129 Calculating Unlevered Free Cash Flow/21.Calculating-UFCF-Solved.xlsm 58.0 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/22.From-UFCF-to-Net-Cash-Flow-Unsolved.xlsm 57.9 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/075 Learn how to find mistakes with Countif/14.Countif-Solved.xlsx 57.3 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/124 Populating the output PL sheet/16.Populating-the-P-L-sheet-Solved.xlsm 57.2 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/128 Bridging Unlevered Free Cash Flow to Net Cash Flow/20.From-UFCF-to-Net-Cash-Flow-Unsolved.xlsm 56.8 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/076 Calculating year-on-year percentage variations the proper way/15.Adding-variations-Solved.xlsx 56.5 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/Cash-Flow-Classification-By-Activities.xlsx 55.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/123 Creating an output PL sheet/15.P-L-structure-Solved.xlsm 55.4 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/125 Populating the output BS sheet/17.Populating-the-Balance-sheet-Unsolved.xlsm 54.8 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/075 Learn how to find mistakes with Countif/14.Countif-Unsolved.xlsm 54.0 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/072 Building the structure of the PL sheet/11-Building-A-P-L.xlsx 53.8 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/072 Building the structure of the PL sheet/11.Building-a-P-L-Solved.xlsx 53.8 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/121 Forecasting DSO DPO and DOI/13.Forecasting-DSO-DPO-and-DIO-Solved.xlsm 53.7 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/124 Populating the output PL sheet/16.Populating-the-P-L-sheet-Unsolved.xlsm 52.7 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/118 Forecasting Balance Sheet items/10.Project-BS-items-Solved.xlsm 52.7 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/118 Forecasting Balance Sheet items/10.Project-BS-items-Unsolved.xlsm 52.7 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/116 Modeling other items Operating expenses and DA/8.Opex-and-D-A-Solved.xlsm 52.3 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/115 Modeling other items Other revenues and Cogs/7.Modeling-Cogs-Solved.xlsm 51.9 KB
03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Solution-Conditional-Formatting.xlsx 51.5 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/123 Creating an output PL sheet/15.P-L-structure-Unsolved.xlsm 50.3 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/121 Forecasting DSO DPO and DOI/13.Forecasting-DSO-DPO-and-DIO-Unsolved.xlsm 50.1 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/114 Introducing scenarios to the model with Choose/6.Choose-Solved.xlsm 49.5 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Solved.xlsm 49.3 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/074 Populate the PL sheet with Sumif/13.Populating-the-P-L-sheet-Unsolved.xlsx 49.2 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/116 Modeling other items Operating expenses and DA/8.Opex-and-D-A-Unsolved.xlsm 49.0 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/111 Description of the structure of the DCF model/3.Beginning-of-exercise.xlsm 48.8 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/115 Modeling other items Other revenues and Cogs/7.Modeling-Cogs-Unsolved.xlsm 48.7 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Unsolved.xlsm 48.6 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/071 Mapping of the rows in the Database sheet/10.Mapping-Solved.xlsx 47.5 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/069 Use Sumif in order to complete the Database sheet/8.Sumif-Solved.xlsx 47.2 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/114 Introducing scenarios to the model with Choose/6.Choose-Unsolved.xlsm 46.4 KB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Solved.xlsx 44.4 KB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Exercise-Text.xlsx 43.9 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/070 Use Index Match as a substitute of Vlookup/9.Index-Match-Solved.xlsx 42.9 KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/112 A glimpse at the company we are valuing - Cheeseco/Beginning-Of-Exercise.xlsx 42.4 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/067 Use Vlookup in order to fill the Database sheet/7-Vlookup.xlsx 40.7 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/071 Mapping of the rows in the Database sheet/10.Mapping-Unsolved.xlsx 39.0 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/070 Use Index Match as a substitute of Vlookup/9.Index-Match-Unsolved.xlsx 38.4 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/067 Use Vlookup in order to fill the Database sheet/7.Vlookup-Solved.xlsx 37.4 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/069 Use Sumif in order to complete the Database sheet/8.Sumif-Unsolved.xlsx 37.4 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Solved.xlsm 36.6 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/066 Learn how to create a Database/6.Creating-a-database-Solved.xlsx 35.4 KB
02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Solved.xlsx 32.8 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/067 Use Vlookup in order to fill the Database sheet/7.Vlookup-Unsolved.xlsx 32.5 KB
02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Solved.xlsx 32.4 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/066 Learn how to create a Database/6.Creating-a-database-Unsolved.xlsx 30.7 KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Unsolved.xlsx 28.6 KB
03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/03-24-Select-Special-F5-Solved.xlsx 22.3 KB
03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/03-24-Select-Special-F5-Exercise-Text.xlsx 21.6 KB
03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Exercise-Filter-by-Color.xlsx 20.5 KB
05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/05-47-Goal-Seek-Solved.xlsx 16.2 KB
05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/05-47-Goal-Seek-Exercise-Text.xlsx 16.1 KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Solved.xlsx 15.7 KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/05-45-IFERROR-Solved.xlsx 15.4 KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Exercise-Text.xlsx 15.3 KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Solution.xlsx 15.0 KB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/05-37-Sum-Sumif-Sumifs-Solved.xlsx 14.8 KB
05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/05-41-MIN-MAX-Solved.xlsx 14.8 KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Exercise-Text.xlsx 14.6 KB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/05-37-Sum-Sumif-Sumifs-Exercise-Text.xlsx 14.5 KB
05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/05-41-MIN-MAX-Exercise-Text.xlsx 14.4 KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/05-45-IFERROR-Exercise-Text.xlsx 14.3 KB
03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/Dynamic-Naming-Solved.xlsx 13.8 KB
05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/05-43-Vlookup-Hlookup-Solved.xlsx 13.7 KB
03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/Dynamic-Naming-Unsolved.xlsx 13.5 KB
02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Exercise-Text.xlsx 13.5 KB
02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Solved.xlsx 13.5 KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Exercise-Text.xlsx 13.3 KB
05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/05-48-Sensitivity-Analysis-Solved.xlsx 13.1 KB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Solved.xlsx 13.0 KB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Unsolved.xlsx 12.9 KB
03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Exercise-Conditional-Formatting.xlsx 12.9 KB
02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Solved.xlsx 12.6 KB
05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Solution-Index-Match-Match.xlsx 12.2 KB
02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Exercise-Text.xlsx 12.1 KB
05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/05-44-Index-Match-Solved.xlsx 12.1 KB
03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/03-25-Assigning-Dynamic-Names-Solved.xlsx 11.7 KB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/05-46-Choose-Solved.xlsx 11.7 KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Exercise-Text.xlsx 11.7 KB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Solved.xlsx 11.7 KB
05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Index-Match-Solved.xlsx 11.7 KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Solved.xlsx 11.7 KB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/03-26-Defining-a-Named-Range-Solved.xlsx 11.7 KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Exercise-Text.xlsx 11.6 KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Solved.xlsx 11.6 KB
05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Exercise-Index-Match-Match.xlsx 11.6 KB
03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/03-30-Custom-Sort-Solved.xlsx 11.5 KB
03 Useful tips and tools for your work in Excel/attached_files/023 Create easily printable documents in Excel by using Set Print Area/Set-Print-Area-Unsolved.xlsx 11.4 KB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/03-20-Alt-Enter-Solved.xlsx 11.4 KB
03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/03-30-Custom-Sort-Exercise-Text.xlsx 11.4 KB
02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Exercise-Text.xlsx 11.3 KB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Exercise-Text.xlsx 11.3 KB
03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/03-29-Drop-down-List-Exercise-Text.xlsx 11.3 KB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/05-46-Choose-Exercise-Text.xlsx 11.3 KB
03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/03-21-Text-to-Columns-Solved.xlsx 11.3 KB
05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Index-Match-Unsolved.xlsx 11.3 KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Unsolved.xlsx 11.3 KB
03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/03-25-Assigning-Dynamic-Names-Exercise-Text.xlsx 11.2 KB
03 Useful tips and tools for your work in Excel/attached_files/023 Create easily printable documents in Excel by using Set Print Area/Set-Print-Area-Solved.xlsx 11.2 KB
03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/Creating-a-Macro-Solved.xlsx 11.2 KB
05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/Vlookup-Hlookup-Solved.xlsx 11.1 KB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/03-20-Alt-Enter-Exercise-Text.xlsx 11.1 KB
05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Solved.xlsx 11.1 KB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/03-26-Defining-a-Named-Range-Exercise-Text.xlsx 11.1 KB
02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Exercise-Text.xlsx 11.1 KB
02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Exercise-Text.xlsx 11.0 KB
02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Solved.xlsx 10.9 KB
03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/Data-Validation-Solved.xlsx 10.8 KB
03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/Data-Validation-Unsolved.xlsx 10.8 KB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/03-19-Fixing-Cells-Solved.xlsx 10.8 KB
05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/Vlookup-Hlookup-Unsolved.xlsx 10.7 KB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/03-19-Fixing-Cells-Exercise-Text.xlsx 10.7 KB
05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Unsolved.xlsx 10.6 KB
03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/03-21-Text-to-Columns-Exercise-Text.xlsx 10.6 KB
03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/Select-Special.xlsx 10.6 KB
02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Exercise-Text.xlsx 10.5 KB
03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/03-28-Macros-Exercise-Text.xlsx 10.3 KB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Solved.xlsx 10.3 KB
03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/03-22-Wrap-Text-Solved.xlsx 10.2 KB
03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/03-22-Wrap-Text-Exercise-Text.xlsx 10.2 KB
03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/Text-to-columns-Solved.xlsx 9.9 KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Solved.xlsx 9.8 KB
03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/Text-to-columns-Unsolved.xlsx 9.8 KB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Solved.xlsx 9.7 KB
03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/Creating-a-Macro-Unsolved.xlsx 9.7 KB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Solved.xlsx 9.6 KB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Unsolved.xlsx 9.6 KB
03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/Wrap-text-Unsolved.xlsx 9.6 KB
03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/Wrap-text-Solved.xlsx 9.6 KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror.xlsx 9.6 KB
03 Useful tips and tools for your work in Excel/attached_files/017 Initial formatting of an Excel sheet in order to render it professional/Formatting-a-worksheet-Solved.xlsx 9.6 KB
05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Solved.xlsx 9.5 KB
05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Solved.xlsx 9.4 KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror-Unsolved.xlsx 9.4 KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Solved.xlsx 9.4 KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Solved.xlsx 9.4 KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Solved.xlsx 9.3 KB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Unsolved.xlsx 9.3 KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Unsolved.xlsx 9.3 KB
05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Unsolved.xlsx 9.3 KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Unsolved.xlsx 9.2 KB
05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/Max-min-Solved.xlsx 9.2 KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Unsolved.xlsx 9.0 KB
05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Unsolved.xlsx 9.0 KB
03 Useful tips and tools for your work in Excel/attached_files/017 Initial formatting of an Excel sheet in order to render it professional/Formatting-a-worksheet-Unsolved.xlsx 9.0 KB
05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/Max-min-Unsolved.xlsx 8.9 KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Unsolved.xlsx 8.9 KB
05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/Goal-Seek-Solved.xlsx 8.9 KB
05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/Goal-Seek-Unsolved.xlsx 8.8 KB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Unsolved.xlsx 8.8 KB
10 Financial Modeling Fundamentals/quizzes/019 Financial Modeling - Quiz.html 7.0 KB
10 Financial Modeling Fundamentals/quizzes/020 Forecasting financials - Quiz.html 7.0 KB
10 Financial Modeling Fundamentals/quizzes/021 Building a financial model - Quiz.html 6.7 KB
05 Excels key functions and functionalities made easy/quizzes/017 Excels key functions and functionalities made easy.html 6.3 KB
03 Useful tips and tools for your work in Excel/quizzes/011 Useful tips and tools for your work in Excel - Quiz.html 6.2 KB
08 Case Study - Building a Complete PL from scratch in Excel/quizzes/018 Case Study - Building a Complete PL from scratch in Excel.html 5.8 KB
05 Excels key functions and functionalities made easy/quizzes/016 Include sensitivity analysis in your models through Data Tables.html 3.1 KB
02 Introduction to Excel/quizzes/002 Rows Columns.html 3.0 KB
05 Excels key functions and functionalities made easy/quizzes/015 Use Goal Seek in order to find the result that you are looking for.html 2.9 KB
03 Useful tips and tools for your work in Excel/quizzes/006 Introduction to fixing of cell references.html 2.9 KB
03 Useful tips and tools for your work in Excel/quizzes/009 Assigning dynamic names.html 2.9 KB
03 Useful tips and tools for your work in Excel/quizzes/005 Fast scrolling through Excel sheets.html 2.8 KB
02 Introduction to Excel/quizzes/004 Cut Copy Paste.html 2.8 KB
03 Useful tips and tools for your work in Excel/quizzes/010 Excel Macros - Quiz.html 2.7 KB
03 Useful tips and tools for your work in Excel/quizzes/008 Select Special.html 2.7 KB
05 Excels key functions and functionalities made easy/quizzes/012 Key Excel Functions Average and Averageif.html 2.7 KB
05 Excels key functions and functionalities made easy/quizzes/013 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.html 2.7 KB
02 Introduction to Excel/quizzes/003 Introduction to Excel Formulas.html 2.6 KB
03 Useful tips and tools for your work in Excel/quizzes/007 Learn how to organize your data with Text to Columns.html 2.6 KB
05 Excels key functions and functionalities made easy/quizzes/014 Index Match and their combination - the perfect substitute of Vlookup.html 2.5 KB
02 Introduction to Excel/quizzes/001 Overview of Excel.html 2.4 KB
Freetutorials.us.url 119 bytes
[FreeTutorials.us].txt 75 bytes

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

File List

Download Torrent

Related Resources

Copyright Infringement