Usefulness and example of using Index and Match functions on excel - UnlockedSimple example for using Index-Match function and comparison to Offset function.indexexcelexcel tipsoffsetmatch279Discusslibrary_add free by consultants
Excel Index Match Vs IndirectThis is to demonstrate the difference between INDEX MATCH vs INDIRECTexceladvanced excelindirect functionexcel tutorialindex match2,929Discusslibrary_add free by consultants
Women Volleyball Teams...This template covers information about Women Volleyball Teams of 16 Countries...sportcevvolleyballwomenvolleyball332Discussadd_shopping_cart $7.00 by Ilgar Zarbaliyev
OFFSET MATCH and Data Validation Excel Model TemplateQuick and easy to use 2-tab Excel template for OFFSET MATCH and data validation.excel skillsfinancial modeling skillsoffsetmatchdata validation861Discussadd_shopping_cart free by Wall Street Prep
INFOGRAPHICS - Find Milestone Matches of BABAR AZAM in T20i Using MS Excel Functions and Power Query - CricketInfographics are graphic visual representations of information, data, or knowledge intended to present information quickly and clearly.excelformulainfographicinfographicscricket527Discusslibrary_add free by Rahim Zulfiqar Ali
How to Apply INDEX and MATCH Separately and Combined | Advanced ExcelLearn how to apply both functions, INDEX and MATCH, separately and combined on Excel.exceldata sciencemicrosoft excelexcel functions365 data science3861add_shopping_cart free by 365 Data Science
How to Use VLOOKUP and MATCH in ExcelWe’ve seen several function combinations so far. In this lesson, we’ll present another one that can be useful.dataexcelstatisticsdata sciencematch3011add_shopping_cart free by 365 Data Science
Excel for Financial Modeling - Functions & Formulas Practice WorkbookThe Excel functions every financial modeler needs, in one interactive workbook.financial modelingexcelexcel skillsexcel functions144Discussadd_shopping_cart free by FinExMod
How to use and implement the Interpolate-Lookup functionThis is a detailed guide on how to use and implement the Interpolate-Lookup function.excelinterpolate lookup functioninterpolation1,070Discussadd_shopping_cart free by Prof. Ed Bodmer
Leadership - 5 dysfunctions of a team PowerPoint TemplateIntroduction and Workshop PowerPoint Template to Patrick Lencioni's 5 dysfunctions of a teamleadershiphuman resourcesteamworkteam managementorganizational culture1,069Discussadd_shopping_cart $6.90 by StrategyPunk
Automated 5g Function TestingHow to automate testing 5g functionsfinancial modeltestingfinancial modelingfinancial modellingdynamic array352Discussadd_shopping_cart free by Craig Hatmaker
Intro to Excel Financial Present Value FunctionsThis video goes over basic excel financial function.financeexcelspreadsheetfinancialsbasics281Discuss free by Norm Miller PhD
Excel Crash Course and Most Used FunctionsMost commonly used excel functions and tools in Microsoft Excelnpvirrmodelingpivot tableexcel135Discussadd_shopping_cart $15.00 by Futuro
Learn Microsoft Excel - THE POWER USER FUNCTIONSLearn Microsoft Excel - THE POWER USER FUNCTIONSexcelformulasfunctionsmicrosoft125Discussadd_shopping_cart $15.00 by Rahim Zulfiqar Ali
Mastering Dax Functions: Unlock the Power of Data Analysis in Power BIThis comprehensive guide provides a step-by-step approach to understanding and utilizing Dax functions, empowering you to transform and analyze data effectivelydata visualizationdata analysisdata extractiondax functionsdata transformation283Discussadd_shopping_cart $5.00 by Data Analyst
Valuation Services - Comparable Companies (Peer Group) Database & Matching Tool | 300 Case LibraryAn Excel-based Comparable Companies (Peer Group) Database & Matching Tool with 300 curated peer group cases built over ~15 years of professional analysis.corporate financecomparable companiestrading compsbenchmarkingmatching187Discussadd_shopping_cart $40.00 by Finance Model Hub
Your Best PracticeHave a Best Practice to share?Publish your Best PracticeLearn more about digital publishing
2 seconds agoHow to write a Confidential Information Memorandum (CIM)This is a Confidential Information Memorandum template, with accompanying methodology.cim2,3691add_shopping_cart free by financialmodeling.org
6 hours agoManagement Consulting Presentations Template (Selected Slides)You will find a selected number of most useful slides used during consulting projects to create a great presentation.strategybcgstrategy consultingslidesmckinsey4,417Discussadd_shopping_cart free by Asen Gyczew
6 hours agoPitch Deck / Investment Presentation TemplateLengthy set of slides covering various aspects of a typical investment presentation, along with the excel source file.presentationventure capitalinvestingpitch deckcim8,5542add_shopping_cart free by DW Financial Services
10 hours agoCapital Budgeting Analysis Excel ModelThis Excel Model allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROIanalysiscorporate financecapital budgetingprojectequity21,5893add_shopping_cart free by Aswath Damodaran
10 hours agoTheoretical Portfolio Optimisation CalculatorExcel tool for the calculation of the theoretical optimal portfolio weights for up to 25 securitiesstandard deviationexcelportfoliooptimisationmoden porfolio theory1,965Discussadd_shopping_cart free by Projectify
10 hours agoFinancial Planning Calculator - What IF AnalysisFinancial Planning Calculator - What IF Analysis | CREDIT CARD INSTALLMENTS | CAR LOAN | PERSONAL LOANfinanceexcel3,504Discusslibrary_add free by Rahim Zulfiqar Ali
10 hours agoPersonal Finance Template Microsoft ExcelPersonal Finance Template - Monthly Budget - Microsoft Excelbudgetfinanceexcel4,912Discusslibrary_add free by Rahim Zulfiqar Ali
10 hours agoPrivate Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or indexfinancestockprivate equityprice to earningsindex1,596Discussadd_shopping_cart free by Dheeraj Vaidya CFA FRM
10 hours agoDue Diligence Report (FREE)Gain Financial Insights & Mitigate Investment Risksstrategyinvestmentsfinanceprivate equitym&a1,029Discusslibrary_add free by P
11 hours agoMergers & Acquisitions ValuationThis module explores all details of M&A that investment bankers need to know, from a valuation perspective.modelvaluationmergersm&aacquisitions1,562Discussadd_shopping_cart free by Street Of Walls
11 hours agoMerger & Acquisition OS (FREE)An investment-grade operating systemcorporate financeinvestment bankingm&aacquisitionsmergers & acquisitions16Discusslibrary_add free by P
11 hours agoFinancial Model audit check list - spreadsheetThis is an audit or productivity tool that you can use while reviewing someone else’s models.financial modelingtoolsproductivityfinancial modelersfinancial model audit9,1386add_shopping_cart free by FinExMod
11 hours agoFinancial Model Assumption BookFinancial model assumption and reference sheet template to be linked to the modelfinancial modelproject financeauditassumption bookdata book5,920Discussadd_shopping_cart free by FinExMod
11 hours agoCall Center Descriptive Analytical Dashboard in Microsoft Excel 365Call Center Descriptive Analytical Dashboard (Dynamic) in Microsoft Excel 365 with Dynamic Array Fromulasanalysisanalyticsdashboardexcelformulas288Discusslibrary_add free by Rahim Zulfiqar Ali
11 hours agoDiscounted Cashflow (DCF) with Scenario AnalysisThe discounted cash flow valuation is an intrinsic valuation methodology.corporate financecapmsensitivity analysisfinancial modelingscenario analysis57Discusslibrary_add free by Dennis Onyango
11 hours agoSensitivity and Scenario Analysis Excel Template with VBAThis workbook and this manual are designed to help you build a sensitivity analysis into your models using VBA.sensitivity analysisfinancial modelingscenario analysisvba7,4063add_shopping_cart free by FinExMod
11 hours agoDue Diligence Checklist for Commercial Real Estate AcquisitionsA due diligence checklist tailored for commercial real estate acquisitions.acquisitionreal estatedue diligencedue diligence checklistcommercial real estate2,259Discussadd_shopping_cart free by Justin Newman
11 hours agoAcquisition Schedule - Excel Model TemplateThis is an Excel Template of the Acquisition Scheduleacquisitionacquisition schedulecapital acquisition2,772Discussadd_shopping_cart free by Wall Street Oasis
11 hours agoInterest Payments - Excel Model TemplateThis is an Interest Payments model Excel templateinterest paymentsinterest expensewsodebt servicing721Discussadd_shopping_cart free by Wall Street Oasis
11 hours agoA Dynamic Cash-Flow and Liquidity Dashboard (corporate)Using dynamic, scenario-driven charts, this template visualizes key components of corporate cash flow and liquidity positions under various scenarios.financescenariosdashboardfinancial modelingtemplate650Discussadd_shopping_cart free by P MBA