08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp4 56MB
08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp4 49MB
08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp4 44MB
08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp4 42MB
05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp4 39MB
06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp4 35MB
05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 35MB
13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp4 34MB
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 33MB
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 32MB
09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp4 31MB
04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp4 30MB
08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp4 30MB
13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp4 29MB
13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp4 27MB
13 Learn how to build a Discounted Cash Flow model in Excel/126 Completing the output BS sheet for the historical period.mp4 26MB
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 25MB
02 Introduction to Excel/010 Introduction to Formatting.mp4 25MB
08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp4 24MB
13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp4 24MB
07 Microsoft Excels Pivot Tables in Depth/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp4 23MB
13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp4 23MB
08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp4 23MB
09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp4 23MB
07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp4 22MB
03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp4 22MB
09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp4 22MB
08 Case Study - Building a Complete PL from scratch in Excel/063 Understand your data source before you start working on It.mp4 21MB
08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp4 21MB
08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp4 21MB
03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp4 20MB
13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp4 20MB
10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp4 20MB
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 20MB
13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp4 20MB
07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp4 19MB
05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp4 19MB
13 Learn how to build a Discounted Cash Flow model in Excel/117 Modeling other items Interest expenses Extraordinary items and Taxes.mp4 19MB
08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp4 19MB
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 19MB
13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp4 18MB
08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp4 18MB
08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp4 18MB
07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp4 18MB
09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp4 18MB
03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp4 18MB
10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp4 17MB
09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17MB
05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp4 17MB
05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp4 17MB
05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp4 17MB
13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 16MB
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 15MB
03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp4 15MB
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 15MB
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 15MB
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 15MB
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 15MB
05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp4 14MB
13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp4 14MB
10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp4 14MB
02 Introduction to Excel/006 Overview of Excel.mp4 14MB
09 Case Study - Building an FMCG Model from Scratch/089 Creating a Master Pivot Table The main data source for the FMCG report.mp4 14MB
09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp4 13MB
10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp4 13MB
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 13MB
13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp4 13MB
03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp4 13MB
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 12MB
09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp4 12MB
02 Introduction to Excel/012 Introduction to Excel Functions.mp4 12MB
13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp4 12MB
05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp4 12MB
09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp4 12MB
13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp4 12MB
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 12MB
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 12MB
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 12MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Solved.xlsm 12MB
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 12MB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Unsolved.xlsm 12MB
07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp4 11MB
03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp4 11MB
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 11MB
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 11MB
13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp4 11MB
10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp4 11MB
03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp4 11MB
13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp4 10MB
08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp4 10MB
02 Introduction to Excel/009 Data Entry in Excel.mp4 10MB
13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp4 10MB
10 Financial Modeling Fundamentals/096 Why use Financial models.mp4 10MB
03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp4 10MB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Key-Functions-In-Excel.pdf 10MB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Key-Functions-In-Excel.pdf 10MB
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 10MB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Key-Functions-In-Excel.pdf 10MB
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 10MB
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 10MB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Key-Functions-In-Excel.pdf 10MB
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 10MB
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 10MB
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 10MB
05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Key-Functions-In-Excel.pdf 10MB
03 Useful tips and tools for your work in Excel/024 Find and select special types of cells with Select Special F5.mp4 10MB
13 Learn how to build a Discounted Cash Flow model in Excel/134 Calculating Continuing Value and Enterprise Value of the business.mp4 10MB
13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp4 10MB
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 9MB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/Useful-Tips-Tools-PDF-Version.pdf 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
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 9MB
03 Useful tips and tools for your work in Excel/030 Using Custom-sort in order to sort multiple columns within a table.mp4 9MB
05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp4 9MB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp4 9MB
09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp4 9MB
02 Introduction to Excel/008 The Excel Ribbon.mp4 9MB
02 Introduction to Excel/011 Introduction to Excel Formulas.mp4 9MB
10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp4 8MB
13 Learn how to build a Discounted Cash Flow model in Excel/120 Calculation of DSO DPO and DOI for the historical period.mp4 8MB
13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp4 8MB
03 Useful tips and tools for your work in Excel/017 Initial formatting of an Excel sheet in order to render it professional.mp4 8MB
08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp4 8MB
05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp4 8MB
05 Excels key functions and functionalities made easy/050 Use Goal Seek in order to find the result that you are looking for.mp4 8MB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp4 8MB
13 Learn how to build a Discounted Cash Flow model in Excel/128 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 8MB
02 Introduction to Excel/013 Cut Copy Paste.mp4 8MB
05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp4 8MB
03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp4 7MB
10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp4 7MB
13 Learn how to build a Discounted Cash Flow model in Excel/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 7MB
02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp4 7MB
08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp4 7MB
02 Introduction to Excel/014 Paste Special.mp4 7MB
10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp4 6MB
07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp4 6MB
05 Excels key functions and functionalities made easy/043 Find the minimum or maximum value in a range of cells in Excel.mp4 6MB
13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp4 6MB
10 Financial Modeling Fundamentals/095 What is a Financial model.mp4 5MB
03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp4 5MB
03 Useful tips and tools for your work in Excel/027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp4 5MB
03 Useful tips and tools for your work in Excel/031 Create a great Index page at the beginning of your models - Hyperlinks.mp4 5MB
02 Introduction to Excel/015 Basic operations in Excel - 38 pages.pdf 5MB
03 Useful tips and tools for your work in Excel/023 Create easily printable documents in Excel by using Set Print Area.mp4 5MB
02 Introduction to Excel/attached_files/015 Basic operations in Excel - 38 pages/Introduction-to-Excels-basic-features.pdf 5MB
13 Learn how to build a Discounted Cash Flow model in Excel/112 A glimpse at the company we are valuing - Cheeseco.mp4 5MB
08 Case Study - Building a Complete PL from scratch in Excel/068 50 Completed.mp4 4MB
08 Case Study - Building a Complete PL from scratch in Excel/077 Create professional and good-looking charts - Introduction.mp4 4MB
03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp4 3MB
08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp4 3MB
05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp4 3MB
13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp4 3MB
05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp4 2MB
13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp4 2MB
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 2MB
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 2MB
03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp4 2MB
03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp4 2MB
02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp4 2MB
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 2MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/6.Slicers.xlsx 2MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/059 Learn More About GetPivotData - A Very Important Excel Function/5.GetPivotData.xlsx 2MB
13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp4 2MB
04 Keyboard shortcuts in Excel/036 Keyboard shortcuts in Excel.pdf 2MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/056 Creating Pivot Tables is easy/2.Creating-a-Pivot-Table.xlsx 1MB
07 Microsoft Excels Pivot Tables in Depth/attached_files/057 Give Your Excel Pivot Tables a Makeover/3.Formatting-a-Pivot-Table.xlsx 1MB
06 Update 15 December - Exercise/attached_files/054 Exercise - Excels Sumifs function - explained solved/Exercise-Sumifs-With-Solutions.xlsx 1MB
06 Update 15 December - Exercise/attached_files/053 Exercise - Excels Sumifs function - unsolved/Exercise-Sumifs-Without-Solutions.xlsx 1MB
04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts.pdf 1MB
12 Introduction to Mergers Acquisitions/107 Introduction to Mergers Acquisitions.pdf 1MB
12 Introduction to Mergers Acquisitions/attached_files/107 Introduction to Mergers Acquisitions/Introduction-to-M-A.pdf 1MB
05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/Excel-Functions.xlsx 971KB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Excel-Functions.xlsx 971KB
05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Excel-Functions.xlsx 971KB
11 Introduction to Company Valuation/106 The core theory behind Company Valuation.pdf 865KB
07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/Database-Pivot-Slicers.xlsm 851KB
04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts-for-MAC.pdf 769KB
11 Introduction to Company Valuation/attached_files/106 The core theory behind Company Valuation/Company-valuation.pdf 765KB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Solved.xlsx 645KB
03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Unsolved.xlsx 644KB
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 644KB
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 644KB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/2.Fast-Scrolling-Solved.xlsx 643KB
05 Excels key functions and functionalities made easy/038 Key Functions in Excel If.pdf 566KB
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 544KB
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 505KB
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 412KB
02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Solved.xlsx 403KB
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 241KB
06 Update 15 December - Exercise/053 Exercise - Excels Sumifs function - unsolved.pdf 204KB
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 190KB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/002 Bonus Welcome gift.pdf 171KB
01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/003 Welcome gift number 2.pdf 162KB
03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Solution-Filter-by-Color.xlsx 153KB
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 152KB
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 146KB
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 145KB
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 145KB
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 137KB
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 137KB
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 122KB
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 97KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Solved.xlsx 81KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Solved.xlsx 80KB
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 77KB
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 64KB
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 64KB
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 64KB
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 64KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Solved.xlsm 63KB
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 63KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Unsolved.xlsm 62KB
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 61KB
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 61KB
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 60KB
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 60KB
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 60KB
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 59KB
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 59KB
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 58KB
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 58KB
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 57KB
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 57KB
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 57KB
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 57KB
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 56KB
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 55KB
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 55KB
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 54KB
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 54KB
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 54KB
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 54KB
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 53KB
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 53KB
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 53KB
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 52KB
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 52KB
03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Solution-Conditional-Formatting.xlsx 52KB
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 50KB
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 50KB
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 50KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Solved.xlsm 49KB
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 49KB
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 49KB
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 49KB
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 49KB
13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Unsolved.xlsm 49KB
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 47KB
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 47KB
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 46KB
03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Solved.xlsx 44KB
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 44KB
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 43KB
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 42KB
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 41KB
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 39KB
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 38KB
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 37KB
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 37KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Solved.xlsm 37KB
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 35KB
02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Solved.xlsx 33KB
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 32KB
02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Solved.xlsx 32KB
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 31KB
08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Unsolved.xlsx 29KB
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 22KB
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 22KB
03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Exercise-Filter-by-Color.xlsx 20KB
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 16KB
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 16KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Solved.xlsx 16KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/05-45-IFERROR-Solved.xlsx 15KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Exercise-Text.xlsx 15KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Solution.xlsx 15KB
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 15KB
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 15KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Exercise-Text.xlsx 15KB
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 14KB
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 14KB
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 14KB
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 14KB
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 14KB
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 14KB
02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Exercise-Text.xlsx 13KB
02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Solved.xlsx 13KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Exercise-Text.xlsx 13KB
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 13KB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Solved.xlsx 13KB
05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Unsolved.xlsx 13KB
03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Exercise-Conditional-Formatting.xlsx 13KB
02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Solved.xlsx 13KB
05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Solution-Index-Match-Match.xlsx 12KB
02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Exercise-Text.xlsx 12KB
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 12KB
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 12KB
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 12KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Exercise-Text.xlsx 12KB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Solved.xlsx 12KB
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 12KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Solved.xlsx 12KB
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 12KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Exercise-Text.xlsx 12KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Solved.xlsx 12KB
05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Exercise-Index-Match-Match.xlsx 12KB
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 11KB
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 11KB
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 11KB
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 11KB
02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Exercise-Text.xlsx 11KB
05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Exercise-Text.xlsx 11KB
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 11KB
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 11KB
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 11KB
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 11KB
05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Unsolved.xlsx 11KB
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 11KB
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 11KB
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 11KB
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 11KB
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 11KB
05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Solved.xlsx 11KB
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 11KB
02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Exercise-Text.xlsx 11KB
02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Exercise-Text.xlsx 11KB
02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Solved.xlsx 11KB
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 11KB
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 11KB
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 11KB
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 11KB
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 11KB
05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Unsolved.xlsx 11KB
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 11KB
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 11KB
02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Exercise-Text.xlsx 10KB
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 10KB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Solved.xlsx 10KB
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 10KB
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 10KB
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 10KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Solved.xlsx 10KB
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 10KB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Solved.xlsx 10KB
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 10KB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Solved.xlsx 10KB
03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Unsolved.xlsx 10KB
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 10KB
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 10KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror.xlsx 10KB
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 10KB
05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Solved.xlsx 9KB
05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Solved.xlsx 9KB
05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror-Unsolved.xlsx 9KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Solved.xlsx 9KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Solved.xlsx 9KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Solved.xlsx 9KB
05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Unsolved.xlsx 9KB
02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Unsolved.xlsx 9KB
05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Unsolved.xlsx 9KB
02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Unsolved.xlsx 9KB
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 9KB
05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Unsolved.xlsx 9KB
05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Unsolved.xlsx 9KB
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 9KB
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 9KB
02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Unsolved.xlsx 9KB
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 9KB
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 9KB
03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Unsolved.xlsx 9KB
