magnet:?xt=urn:btih:DCB1C95299015D27AF918B683B029792295D5A39
08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp4 59.2 MB08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp4 51.2 MB08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp4 46.6 MB08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp4 44.2 MB05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp4 40.8 MB06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp4 37.0 MB05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 36.3 MB13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp4 35.9 MB08 Case Study - Building a Complete PL from scratch in Excel/078 Build a Column Stacked Chart with a secondary line axis in Excel.mp4 34.3 MB13 Learn how to build a Discounted Cash Flow model in Excel/131 Obtaining the rest of the Cash Flows through Find and Replace.mp4 33.9 MB09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp4 32.5 MB04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp4 31.9 MB07 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.mp4 31.6 MB08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp4 31.2 MB13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp4 30.3 MB13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp4 28.5 MB13 Learn how to build a Discounted Cash Flow model in Excel/126 Completing the output BS sheet for the historical period.mp4 27.3 MB13 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 26.7 MB02 Introduction to Excel/010 Introduction to Formatting.mp4 25.9 MB08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp4 24.9 MB13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp4 24.7 MB07 Microsoft Excels Pivot Tables in Depth/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp4 24.1 MB13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp4 24.0 MB08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp4 24.0 MB09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp4 23.7 MB07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp4 23.2 MB03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp4 23.2 MB09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp4 23.0 MB08 Case Study - Building a Complete PL from scratch in Excel/063 Understand your data source before you start working on It.mp4 22.3 MB08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp4 21.8 MB08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp4 21.8 MB03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp4 21.4 MB13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp4 21.0 MB10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp4 20.9 MB09 Case Study - Building an FMCG Model from Scratch/093 This is how the report can be used in practice by high-level executives.mp4 20.8 MB13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp4 20.5 MB07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp4 20.3 MB05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp4 20.3 MB13 Learn how to build a Discounted Cash Flow model in Excel/117 Modeling other items Interest expenses Extraordinary items and Taxes.mp4 19.8 MB08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp4 19.7 MB08 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 19.6 MB13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp4 19.4 MB08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp4 19.3 MB08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp4 19.0 MB07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp4 18.9 MB09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp4 18.7 MB03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp4 18.5 MB10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp4 18.1 MB09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.9 MB05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp4 17.8 MB05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp4 17.6 MB05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp4 17.4 MB13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 16.8 MB08 Case Study - Building a Complete PL from scratch in Excel/073 Formatting sets You apart from the competition in Excel - A Practical Example.mp4 16.0 MB03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp4 15.8 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 15.6 MB09 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 15.6 MB09 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 15.6 MB09 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 15.6 MB05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp4 15.0 MB13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp4 15.0 MB10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp4 15.0 MB02 Introduction to Excel/006 Overview of Excel.mp4 14.6 MB09 Case Study - Building an FMCG Model from Scratch/089 Creating a Master Pivot Table The main data source for the FMCG report.mp4 14.5 MB09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp4 14.2 MB10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp4 14.0 MB09 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.9 MB13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp4 13.1 MB03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp4 13.1 MB08 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.8 MB09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp4 12.6 MB02 Introduction to Excel/012 Introduction to Excel Functions.mp4 12.6 MB13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp4 12.6 MB05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp4 12.3 MB09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp4 12.2 MB13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp4 12.2 MB08 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 12.1 MB08 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 12.1 MB08 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 12.1 MB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Solved.xlsm 12.1 MB08 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 12.1 MB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Unsolved.xlsm 12.1 MB07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp4 11.8 MB03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp4 11.6 MB13 Learn how to build a Discounted Cash Flow model in Excel/127 Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 11.3 MB13 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 11.2 MB13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp4 11.1 MB10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp4 11.1 MB03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp4 11.1 MB13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp4 11.0 MB08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp4 11.0 MB02 Introduction to Excel/009 Data Entry in Excel.mp4 10.9 MB13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp4 10.8 MB10 Financial Modeling Fundamentals/096 Why use Financial models.mp4 10.5 MB03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp4 10.4 MB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Key-Functions-In-Excel.pdf 10.3 MB05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Key-Functions-In-Excel.pdf 10.3 MB05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Key-Functions-In-Excel.pdf 10.3 MB05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Key-Functions-In-Excel.pdf 10.3 MB05 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 10.3 MB05 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 10.3 MB05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Key-Functions-In-Excel.pdf 10.3 MB05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Key-Functions-In-Excel.pdf 10.3 MB05 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 10.3 MB05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Key-Functions-In-Excel.pdf 10.3 MB05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Key-Functions-In-Excel.pdf 10.3 MB03 Useful tips and tools for your work in Excel/024 Find and select special types of cells with Select Special F5.mp4 10.3 MB13 Learn how to build a Discounted Cash Flow model in Excel/134 Calculating Continuing Value and Enterprise Value of the business.mp4 10.1 MB13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp4 10.1 MB03 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.9 MB03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/Useful-Tips-Tools-PDF-Version.pdf 9.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 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.9 MB03 Useful tips and tools for your work in Excel/030 Using Custom-sort in order to sort multiple columns within a table.mp4 9.6 MB05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp4 9.4 MB01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp4 9.4 MB09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp4 9.3 MB02 Introduction to Excel/008 The Excel Ribbon.mp4 9.2 MB02 Introduction to Excel/011 Introduction to Excel Formulas.mp4 9.1 MB10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp4 8.8 MB13 Learn how to build a Discounted Cash Flow model in Excel/120 Calculation of DSO DPO and DOI for the historical period.mp4 8.8 MB13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp4 8.7 MB03 Useful tips and tools for your work in Excel/017 Initial formatting of an Excel sheet in order to render it professional.mp4 8.4 MB08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp4 8.3 MB05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp4 8.2 MB05 Excels key functions and functionalities made easy/050 Use Goal Seek in order to find the result that you are looking for.mp4 8.2 MB01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp4 8.2 MB13 Learn how to build a Discounted Cash Flow model in Excel/128 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 8.0 MB02 Introduction to Excel/013 Cut Copy Paste.mp4 7.9 MB05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp4 7.9 MB03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp4 7.7 MB10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp4 7.6 MB13 Learn how to build a Discounted Cash Flow model in Excel/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 7.5 MB10 Financial Modeling Fundamentals/101 Financial modeling Forecasting guidelines.mp4 7.5 MB02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp4 7.2 MB08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp4 7.1 MB02 Introduction to Excel/014 Paste Special.mp4 7.0 MB10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp4 6.4 MB07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp4 6.3 MB05 Excels key functions and functionalities made easy/043 Find the minimum or maximum value in a range of cells in Excel.mp4 6.2 MB4. 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.mp4 5.9 MB13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp4 5.9 MB10 Financial Modeling Fundamentals/095 What is a Financial model.mp4 5.7 MB03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp4 5.7 MB03 Useful tips and tools for your work in Excel/027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp4 5.7 MB03 Useful tips and tools for your work in Excel/031 Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.6 MB02 Introduction to Excel/015 Basic operations in Excel - 38 pages.pdf 5.3 MB03 Useful tips and tools for your work in Excel/023 Create easily printable documents in Excel by using Set Print Area.mp4 5.0 MB02 Introduction to Excel/attached_files/015 Basic operations in Excel - 38 pages/Introduction-to-Excels-basic-features.pdf 4.9 MB13 Learn how to build a Discounted Cash Flow model in Excel/112 A glimpse at the company we are valuing - Cheeseco.mp4 4.7 MB08 Case Study - Building a Complete PL from scratch in Excel/068 50 Completed.mp4 4.5 MB08 Case Study - Building a Complete PL from scratch in Excel/077 Create professional and good-looking charts - Introduction.mp4 3.8 MB03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp4 3.5 MB08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp4 3.3 MB05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp4 3.3 MB13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp4 2.7 MB05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp4 2.4 MB13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp4 2.4 MB03 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.3 MB03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp4 2.2 MB03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp4 2.2 MB10 Financial Modeling Fundamentals/094 Financial Modeling Basics - Welcome Lecture.mp4 2.2 MB02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp4 2.1 MB07 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 2.0 MB07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/6.Slicers.xlsx 2.0 MB07 Microsoft Excels Pivot Tables in Depth/attached_files/059 Learn More About GetPivotData - A Very Important Excel Function/5.GetPivotData.xlsx 2.0 MB13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp4 1.9 MB04 Keyboard shortcuts in Excel/036 Keyboard shortcuts in Excel.pdf 1.7 MB05 Financial Modeling Part 1 of 4 Introduction and Best Practices/attached_files/019 Financial Modeling Best Practices/25-Modeling-and-Valuation-Best-Practices.pdf 1.5 MB09 Valuation Part 1 of 6 Introduction and Best Practices/attached_files/036 25 Valuation and Modeling Best Practices/25-Modeling-and-Valuation-Best-Practices.pdf 1.5 MB07 Microsoft Excels Pivot Tables in Depth/attached_files/056 Creating Pivot Tables is easy/2.Creating-a-Pivot-Table.xlsx 1.5 MB07 Microsoft Excels Pivot Tables in Depth/attached_files/057 Give Your Excel Pivot Tables a Makeover/3.Formatting-a-Pivot-Table.xlsx 1.5 MB06 Update 15 December - Exercise/attached_files/054 Exercise - Excels Sumifs function - explained solved/Exercise-Sumifs-With-Solutions.xlsx 1.4 MB06 Update 15 December - Exercise/attached_files/053 Exercise - Excels Sumifs function - unsolved/Exercise-Sumifs-Without-Solutions.xlsx 1.3 MB04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts.pdf 1.3 MB12 Introduction to Mergers Acquisitions/attached_files/107 Introduction to Mergers Acquisitions/Introduction-to-M-A.pdf 1.1 MB12 Introduction to Mergers Acquisitions/107 Introduction to Mergers Acquisitions.pdf 1.1 MB05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/Excel-Functions.xlsx 994.3 kB05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Excel-Functions.xlsx 994.3 kB05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Excel-Functions.xlsx 994.3 kB11 Introduction to Company Valuation/106 The core theory behind Company Valuation.pdf 886.2 kB07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/Database-Pivot-Slicers.xlsm 871.7 kB04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts-for-MAC.pdf 787.7 kB11 Introduction to Company Valuation/attached_files/106 The core theory behind Company Valuation/Company-valuation.pdf 783.5 kB03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Solved.xlsx 660.7 kB03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Unsolved.xlsx 659.4 kB03 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 659.4 kB03 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 659.3 kB03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/2.Fast-Scrolling-Solved.xlsx 657.9 kB05 Excels key functions and functionalities made easy/038 Key Functions in Excel If.pdf 579.5 kB08 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 557.6 kB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/082 Course Challenge - Apply Your Skills in Practice/1.Course-Challenge.xlsx 517.6 kB13 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 421.6 kB02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Solved.xlsx 412.5 kB13 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 246.6 kB06 Update 15 December - Exercise/053 Exercise - Excels Sumifs function - unsolved.pdf 209.3 kB05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/05-49-Pivot-Tables-Intro-Solved.xlsx 194.6 kB01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/002 Bonus Welcome gift.pdf 175.3 kB01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/003 Welcome gift number 2.pdf 165.6 kB03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Solution-Filter-by-Color.xlsx 157.2 kB05 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 155.8 kB03 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 149.1 kB03 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 148.8 kB03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/03-28-Macros-Solved.xlsx 148.5 kB03 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 140.4 kB03 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 140.2 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/119 An introduction to the Days methodology/Working-Capital-Days.pptx 124.5 kB13 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 99.4 kB02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Solved.xlsx 83.0 kB02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Solved.xlsx 82.1 kB03 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 78.9 kB13 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 65.4 kB13 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 65.4 kB13 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 65.4 kB13 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 65.4 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Solved.xlsm 64.1 kB13 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 64.1 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Unsolved.xlsm 63.8 kB13 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 62.8 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/Sensitivity-Analysis.xlsx 62.3 kB13 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 61.8 kB13 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 61.5 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/129 Calculating Unlevered Free Cash Flow/21.Calculating-UFCF-Unsolved.xlsm 60.9 kB08 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 60.4 kB13 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 60.2 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/129 Calculating Unlevered Free Cash Flow/21.Calculating-UFCF-Solved.xlsm 59.3 kB13 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 59.3 kB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/075 Learn how to find mistakes with Countif/14.Countif-Solved.xlsx 58.7 kB13 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 58.5 kB13 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 58.2 kB08 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 57.9 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/Cash-Flow-Classification-By-Activities.xlsx 57.3 kB13 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 56.7 kB13 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 56.1 kB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/075 Learn how to find mistakes with Countif/14.Countif-Unsolved.xlsm 55.3 kB08 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 55.1 kB08 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 55.1 kB13 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 54.9 kB13 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 54.0 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/118 Forecasting Balance Sheet items/10.Project-BS-items-Unsolved.xlsm 54.0 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/118 Forecasting Balance Sheet items/10.Project-BS-items-Solved.xlsm 54.0 kB13 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 53.6 kB13 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 53.1 kB03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Solution-Conditional-Formatting.xlsx 52.8 kB13 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 51.6 kB13 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 51.3 kB13 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 50.7 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Solved.xlsm 50.5 kB08 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 50.4 kB13 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 50.1 kB13 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 50.0 kB13 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 49.9 kB13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Unsolved.xlsm 49.8 kB08 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 48.6 kB08 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 48.4 kB13 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 47.6 kB03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Solved.xlsx 45.4 kB03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Exercise-Text.xlsx 45.0 kB08 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 43.9 kB13 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 43.4 kB08 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 41.7 kB08 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 40.0 kB08 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 39.4 kB08 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 38.3 kB08 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 38.3 kB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Solved.xlsm 37.5 kB08 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 36.3 kB02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Solved.xlsx 33.5 kB08 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 33.3 kB02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Solved.xlsx 33.2 kB08 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 31.4 kB08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Unsolved.xlsx 29.3 kB03 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.8 kB03 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 22.1 kB03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Exercise-Filter-by-Color.xlsx 21.0 kB05 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.6 kB05 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.5 kB05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Solved.xlsx 16.0 kB05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/05-45-IFERROR-Solved.xlsx 15.7 kB05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Exercise-Text.xlsx 15.6 kB05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Solution.xlsx 15.4 kB05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/05-37-Sum-Sumif-Sumifs-Solved.xlsx 15.2 kB05 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 15.2 kB05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Exercise-Text.xlsx 14.9 kB05 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.8 kB05 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.7 kB05 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.6 kB03 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 14.2 kB05 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 14.0 kB03 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.9 kB02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Exercise-Text.xlsx 13.8 kB02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Solved.xlsx 13.8 kB02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Exercise-Text.xlsx 13.6 kB05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Solved.xlsx 13.3 kB05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Unsolved.xlsx 13.2 kB03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Exercise-Conditional-Formatting.xlsx 13.2 kB02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Solved.xlsx 12.9 kB05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Solution-Index-Match-Match.xlsx 12.5 kB02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Exercise-Text.xlsx 12.4 kB05 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.4 kB03 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 12.0 kB05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/05-46-Choose-Solved.xlsx 12.0 kB02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Exercise-Text.xlsx 12.0 kB05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Solved.xlsx 12.0 kB05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Index-Match-Solved.xlsx 12.0 kB05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Solved.xlsx 12.0 kB03 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.9 kB02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Exercise-Text.xlsx 11.9 kB02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Solved.xlsx 11.9 kB05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Exercise-Index-Match-Match.xlsx 11.9 kB03 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.7 kB03 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.7 kB03 Useful tips and tools for your work in Excel/Working with conditional formating.xlsx 11.7 kB03 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.7 kB03 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.6 kB02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Exercise-Text.xlsx 11.6 kB05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Exercise-Text.xlsx 11.6 kB03 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.6 kB05 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.6 kB03 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.6 kB05 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.6 kB05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Unsolved.xlsx 11.6 kB03 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.5 kB03 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.5 kB03 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.4 kB05 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.4 kB03 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.4 kB05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Solved.xlsx 11.4 kB03 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.3 kB02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Exercise-Text.xlsx 11.3 kB02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Exercise-Text.xlsx 11.2 kB02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Solved.xlsx 11.1 kB03 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 11.1 kB03 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 11.1 kB03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/03-19-Fixing-Cells-Solved.xlsx 11.1 kB05 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 11.0 kB03 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.9 kB05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Unsolved.xlsx 10.9 kB03 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.8 kB03 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.8 kB02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Exercise-Text.xlsx 10.7 kB03 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.6 kB03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Solved.xlsx 10.6 kB03 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.4 kB03 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.4 kB03 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 10.1 kB02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Solved.xlsx 10.1 kB03 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 10.0 kB05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Solved.xlsx 9.9 kB03 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.9 kB03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Solved.xlsx 9.9 kB03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Unsolved.xlsx 9.9 kB03 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.8 kB03 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.8 kB05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror.xlsx 9.8 kB03 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.8 kB05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Solved.xlsx 9.7 kB05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Solved.xlsx 9.7 kB05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror-Unsolved.xlsx 9.6 kB05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Solved.xlsx 9.6 kB02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Solved.xlsx 9.6 kB02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Solved.xlsx 9.6 kB05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Unsolved.xlsx 9.6 kB02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Unsolved.xlsx 9.5 kB05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Unsolved.xlsx 9.5 kB02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Unsolved.xlsx 9.5 kB05 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.4 kB05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Unsolved.xlsx 9.2 kB05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Unsolved.xlsx 9.2 kB05 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 9.2 kB02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Unsolved.xlsx 9.1 kB05 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 9.1 kB05 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 9.1 kB03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Unsolved.xlsx 9.0 kB
10 Financial Modeling Fundamentals/quizzes/019 Financial Modeling - Quiz.html 7.2 kB10 Financial Modeling Fundamentals/quizzes/020 Forecasting financials - Quiz.html 7.1 kB10 Financial Modeling Fundamentals/quizzes/021 Building a financial model - Quiz.html 6.9 kB05 Excels key functions and functionalities made easy/quizzes/017 Excels key functions and functionalities made easy.html 6.4 kB03 Useful tips and tools for your work in Excel/quizzes/011 Useful tips and tools for your work in Excel - Quiz.html 6.3 kB08 Case Study - Building a Complete PL from scratch in Excel/quizzes/018 Case Study - Building a Complete PL from scratch in Excel.html 6.0 kB05 Excels key functions and functionalities made easy/quizzes/016 Include sensitivity analysis in your models through Data Tables.html 3.2 kB02 Introduction to Excel/quizzes/002 Rows Columns.html 3.0 kB05 Excels key functions and functionalities made easy/quizzes/015 Use Goal Seek in order to find the result that you are looking for.html 3.0 kB03 Useful tips and tools for your work in Excel/quizzes/006 Introduction to fixing of cell references.html 3.0 kB03 Useful tips and tools for your work in Excel/quizzes/009 Assigning dynamic names.html 2.9 kB03 Useful tips and tools for your work in Excel/quizzes/005 Fast scrolling through Excel sheets.html 2.9 kB02 Introduction to Excel/quizzes/004 Cut Copy Paste.html 2.9 kB03 Useful tips and tools for your work in Excel/quizzes/010 Excel Macros - Quiz.html 2.8 kB03 Useful tips and tools for your work in Excel/quizzes/008 Select Special.html 2.8 kB05 Excels key functions and functionalities made easy/quizzes/012 Key Excel Functions Average and Averageif.html 2.7 kB05 Excels key functions and functionalities made easy/quizzes/013 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.html 2.7 kB02 Introduction to Excel/quizzes/003 Introduction to Excel Formulas.html 2.7 kB03 Useful tips and tools for your work in Excel/quizzes/007 Learn how to organize your data with Text to Columns.html 2.7 kB05 Excels key functions and functionalities made easy/quizzes/014 Index Match and their combination - the perfect substitute of Vlookup.html 2.6 kB02 Introduction to Excel/quizzes/001 Overview of Excel.html 2.5 kB4. 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.vtt 2.3 kB
Freetutorials.us.url 119 Bytes
[FreeTutorials.us].txt 75 Bytes Financial Literacy Reading Financial Reports 248.2 MB
TTC - Financial Literacy - Finding Your Way in the... 675.9 MB Financial Literacy - Finding Your Way in the Financial Markets 1.6 GB TTC - Financial Literacy - Finding Your Way in the... 6.3 GB
TTC - Financial Literacy - Finding Your Way in the... 1.7 GB
ACCA Courses - Financial Reporting, Financial... 11.8 GB Financial Literacy: Reading Financial Reports 183.9 MB [ FreeCourseWeb.com ] Lynda - Financial Modeling and... 698.2 MB TTC - Financial Literacy - Finding Your Way in the... 6.3 GB [ FreeCourseWeb.com ] Financial Modelling, Financial... 3.0 GB