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 science4151add_shopping_cart free by 365 Data Science
Usefulness and example of using Index and Match functions on excel - UnlockedSimple example for using Index-Match function and comparison to Offset function.indexexcelexcel tipsoffsetmatch300Discusslibrary_add free by consultants
Tool solving multiple indices on excelSolves the problem of repeat hits in a VLOOKUP in excelmultiple indexexcel vlookup indexsolving for multiple matchesmultiple match excelarray formula260Discusslibrary_add free by consultants
Excel IndexMatch Vs IndirectThis is to demonstrate the difference between INDEXMATCH vs INDIRECTexceladvanced excelindirect functionexcel tutorialindexmatch2,974Discusslibrary_add free by consultants
In-depth Microsoft Excel and Data Analysis TrainingAn in-depth training on Excel and data analysis for busy professionals.exceldata analysis288Discussadd_shopping_cart $49.00 by Michael Olafusi
PCAF Scope 3 Category 15 Financed Emissions Master Calculator (1,600+ Factor Database)Audit-ready PCAF Scope 3 Category 15 financed emissions Excel model.reportbankingscopepcaffinanced emission41Discussadd_shopping_cart $89.00 by Models
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 validation886Discussadd_shopping_cart free by Wall Street Prep
Future Value of Inflation Indexed Savings Plan Excel ModelCalculates the future value of an inflation indexed savings plan.savings plancompoundinginflation indexedfuture value332Discussadd_shopping_cart $10.00 by Satish Ramanathan
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 compsbenchmarkingmatching212Discussadd_shopping_cart $40.00 by Finance Model Hub
Valuation Services - Comparable Companies (Peer Group) Database & Matching Tool - Industrial Industry EditionAn Excel-based Comparable Companies (Peer Group) Database & Matching Tool with 100+ curated peer group cases built over ~15 years of professional analysis.valuationcorporate financecomparablescomparable companiestrading comps223Discussadd_shopping_cart $19.99 by Finance Model Hub
COVID-19 vs Index Return Excel ModelAnalysis on index return in relation to Covid-19 cases.analysisinvestmentfinancialriskfinance241Discussadd_shopping_cart $25.00 by Sara AlSaidan
Overview of the Team Maturity IndexThe Team Maturity Index (TMI) is an OrgCMF™; Team Reference Model, Body of Knowledge & Capability Maturity Assessments, which guide Individuals and Teams.teamteam developmentremote workteam effectivenessteam dynamics893Discussadd_shopping_cart free by Declan Kavanagh
B2B Match Making Pitch Deck TemplateThe B2B Match Making Pitch Deck Template is designed in a way that shows the passion for your business.pptpowerpointpitch deckslidesb2b98Discussadd_shopping_cart $15.00 by Oak Business Consultant
Datenraumindex - Data Room Index - bilingual in German and English | M&A document - Excel templateDies ist eine einfache, saubere und einfach zu bedienende Vorlage für eine Datenraumindex im Rahmen eines M&A-Prozesses.m&atemplateexceldue diligencemergers & acquisitions204Discussadd_shopping_cart $19.99 by Christian Kessels
Match Items from Overlapping ListsAlign items from lists which have overlapping populations.fastreconciliationmatchingaligningoverlapping lists6471add_shopping_cart $20.00 by Matterwise
Compare Two Excel Worksheets and Find Matches and DifferencesCompare Two Excel Worksheets and Find Matches and Differences, this could be the ultimate tool you are looking!excel vbacompare datasets in excelfind variancescompare sheetscompare excel data1,459Discussadd_shopping_cart $24.00 by FinDataPro
Your Best PracticeHave a Best Practice to share?Publish your Best PracticeLearn more about digital publishing
40 minutes agoModel Articles of AssociationModel Articles of Association Template (62 pages)legaldocumentsarticles of association486Discussadd_shopping_cart free by BVCA
40 minutes agoCanadian Safe Term SheetCanadian Simple Agreement for Future Equity Template with Educational Notes attached to help you.equityshareholdersterm sheetcanadian safecanada1,445Discussadd_shopping_cart free by Naco Canada
3 hours agoPublic SaaS / Software Company Operating & Valuation Model TemplateComprehensive Public Company SaaS Operating & Valuation Modelvaluationdcfwaccfinancial modelsaas5,5301add_shopping_cart free by AJ Ross
4 hours agoHigh Growth Firms Valuation ModelValue tough-to-value firms, with negative earnings, high growth in revenues and few comparablesfinancevaluationfcffpresent valuehigh growth1,210Discussadd_shopping_cart free by Aswath Damodaran
4 hours agoFinancial Model Detective Book: Hints and Tricks on how to Review Project Finance modelsThis book describes how to carry out a financial model review in a systematic and methodical way.financial modelproject financeauditfinancial model review2,218Discussadd_shopping_cart $9.50 by FinExMod
5 hours agoCombination ModelA 22 section excel model to assess the impact on the financials of the combination of companiescombinationimpactfinancemergersm&a10,6836add_shopping_cart free by John P. Burns
5 hours agoExcel for Financial Modeling - Functions & Formulas Practice WorkbookThe Excel functions every financial modeler needs, in one interactive workbook.financial modelingexcelexcel skillsexcel functions269Discussadd_shopping_cart free by FinExMod
5 hours agoMcKinsey's Strategic Control Map Framework Model TemplateAn editable PowerPoint Template Slide of McKinsey's Strategic Control Map Framework Model, to help organisations maximise their market capitalization.strategic planningm&amarket capitalizationmergers & acquisitionsmckinsey & company2,450Discussadd_shopping_cart free by Tim Demoures
5 hours agoAcquisition Schedule - Excel Model TemplateThis is an Excel Template of the Acquisition Scheduleacquisitionacquisition schedulecapital acquisition2,841Discussadd_shopping_cart free by Wall Street Oasis
5 hours agoHow to use history in making an acquisition analysisAn extensive excel tool for acquisition analysis, and how to use history when making an acquisition analysis.acquisitionhistoryanalysism&aacquisition analysis1,286Discussadd_shopping_cart free by Prof. Ed Bodmer
5 hours agoNetwork Optimization: How to perform a Greenfield AnalysisThis document and toolkit work to enable accurate Greenfield Scenarios, customizable and quick.optimizationgreenfieldgreenfield analysissite selectioncustomer demand421Discussadd_shopping_cart free by Ben Unpingco
5 hours agoFree Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)financefree cash flow for the firmfcffebitebitda1,331Discussadd_shopping_cart free by Dheeraj Vaidya CFA FRM
7 hours agoKISS Debt VersionKISS stands for Keep It Simple Security: Debt Version legal document template.documentlegaldebt versioncustomizable548Discussadd_shopping_cart free by 500 Startups
7 hours agoKISS Equity VersionKISS: Keep it Simple Security; Downloadable Equity Version Template.financinginvestorslegalequity versionkiss1,179Discussadd_shopping_cart free by 500 Startups
16 hours agoInvestment Thesis - Powerpoint TemplatePowerpoint template guiding the user to create an investment strategy presentationinvestmentpresentationstructurepowerpointlayout4,303Discussadd_shopping_cart free by Wall Street Oasis
21 hours agoEmployee Overtime TrackerTime tracking spreadsheet template, to track employee worked hours, and overtime work, weekly employee time tracking reportovertimehr dashboardhr metricsemployee kpisemployee attendance481Discussadd_shopping_cart free by Nisrine LAHRECHE
23 hours agoTOWS Matrix Excel Template Free DownloadThe model has build to helps the user to form a SWOT analysis and TOWS matrix as a strategic roadmap for the business in excel templateswottows3,546Discussadd_shopping_cart free by ECF Consultancy
23 hours agoYouTube Investment Memo - AnalysisOverview and analysis of an Investment Memo made for YouTubeinvestmentventure capitalyoutubeinvestment memoinvestment memorandum1,425Discussadd_shopping_cart free by Miles Grimshaw
23 hours agoAbsorbers Excel WorkbookAbsorbers Excel Workbook created to align with Chapter 4: 'Absorbers' of textbook "Rules of Thumb for Engineers."excelspreadsheetengineeringabsorbershenrys law1,229Discussadd_shopping_cart free by Stephen Hall
1 day agoChart of Accounts Excel Template for ERPA structured, ready-to-use chart of accounts covering 4 major classes (Assets, Liabilities, Expenses, Revenues)accountingbalance sheeterpcoachart of accounts57Discussadd_shopping_cart free by model based