Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,624Discussadd_shopping_cart
free
by Andrei Okhlopkov
Search results: array
by Andrei Okhlopkov
BXL DAN - FREE: Create dynamic array names and more
Easily name dynamic arrays. Add pseudo "Structured References" to 2 dimensional arrays w/headers making them Power Query up-loadable. Extend formatting.1,0131add_shopping_cartfree
by Craig Hatmaker
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.769Discussadd_shopping_cartfree
by Big4WallStreet
Excel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array469Discussadd_shopping_cart$40.00
by Folorunso Lala
Usage of new functions Filter and Sort with Dynamic Arrays in Excel; using FMWC Dominoes case for example data
Demo Solution to Level 5 in FMWC case "Dominate the Dominoes" with Dynamic Arrays, SORT, FILTER and LET function.313Discussadd_shopping_cart$50.00
by Karlheinz Weyh
Powerful Dynamic Arrays Model with Monte Carlo Simulation
Newly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!1,7521add_shopping_cart$299.00
by Lance Rubin
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.553Discussadd_shopping_cart$129.00
by Big4WallStreet
Financial Starter Pack
Easily create dynamic array financial models using 5g. 5g is a standard for converting Excel formulas into Excel functions anyone can use on any workbook.2,6651add_shopping_cart$49.99
by Craig Hatmaker
Human Resource Example: Hires & Terminations in a Month
Forget Excel PivotTables. Get summary of hires & terminations in a month from staff master sheet using Dynamic Array (DA) Excel functions.156Discusslibrary_addfree
by Excel Quirks
Filter, Sort and Restrict Lists from Dynamic Arrays for Profit maximization (based on FMWC case Lumberjack)
Demo for profit maximization with varying sales prices and limitations for goods to sell.133Discussadd_shopping_cart$50.00
by Karlheinz Weyh
Tool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel230Discusslibrary_addfree
by consultants
Pakistan Salary Tax Calculator Using LAMBDA (2025-2026)
Pakistan Salary Tax Calculator (Tax Year 2025-2026) Using Excel LAMBDA & LET Functions165Discusslibrary_addfree
by Excel Quirks
Automated 5g Function Testing
How to automate testing 5g functions334Discussadd_shopping_cartfree
by Craig Hatmaker
Introduction to LAMBDA course
Create LAMBDA functions with Dynamic Arrays!282Discussadd_shopping_cart$49.99
by Craig Hatmaker
Site Staff Movement Report
Site Staff Movement Tracker using Dynamic Arrays466Discusslibrary_addfree
by Excel Quirks
Expense insights and analysis for SME businesses using Excel and Power BI
Overview of the building blocks of a financial model for expense insights and forecasting using dynamic arrays and other hidden gems inside Excel and Power BI.345Discussadd_shopping_cart$299.00
by Lance Rubin
- Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing
Last downloaded
- 2 hours ago
Working Capital - Excel Model Template
This is WSO's free Excel template for a Working Capital Schedule7,635Discussadd_shopping_cartfree
by Wall Street Oasis
- 2 hours ago
a16z’s Investment Decision Making Framework in a Time of Change - Template
An efficient a16z Investment Decision Framework Template to invest in the appropriate opportunities in times of change.2,775Discussadd_shopping_cartfree
by Tim Demoures
- 2 hours ago
Startup Valuation VC Method + excel Spreadsheet
Excel template made to understand how VCs value the money that will be used to invest in a startup29,809Discussadd_shopping_cartfree
by Serious Funding
- 2 hours ago
Integrated Financial Statements
5-Year Forecast with Integrated Financial Statements and Schedules3,1702library_addfree
by ExcelFinModels
- 2 hours ago
Timing Flags and Master sheet in a Project Finance Model
Contains necessary flags, counters and switches to build in flexibility in your project finance models2,334Discussadd_shopping_cartfree
by FinExMod
- 2 hours ago
Typical Cash Flow Waterfall (Excel Template and PDF manual)
Contains a typical cash flow waterfall and covers the concept of cash flow waterfall5,6111add_shopping_cartfree
by FinExMod
- 2 hours ago
Cash Flow Excel Model with Monthly P&L, Balance Sheet, CF Statement, Scenarios, DCF, Capital and Debt Structure
An extended Excel version of a Cash Flow financial model with a free video tutorial.13,409Discussadd_shopping_cartfree
by Jacek Polewski
- 2 hours ago
Revenue and Expenses Dashboard
A succinct Excel Dashboard report which focuses acutely on organisation's revenue and expenses in the outputs.33,1934add_shopping_cartfree
by Marcus Small
- 2 hours ago
Sensitivity & Scenario Analysis Excel Template
How to use an excel data table for sensitivity and scenario analysis for you financial model.14,293Discussadd_shopping_cartfree
by Michael Shane
- 2 hours ago
3 Statement Financial Model - Advanced
3 Statement Financial Model - Advanced2,601Discusslibrary_add - 2 hours ago
Financial Model audit check list - spreadsheet
This is an audit or productivity tool that you can use while reviewing someone else’s models.9,0646add_shopping_cartfree
by FinExMod
- 2 hours ago
Startup Pro-forma Profit and Loss statement (P&L) Template
Made to help you construct a high level operation plan for your startup.38,7651add_shopping_cartfree
by Charlie Tillett
- 2 hours ago
NPV, IRR & Payback Calculator
The template allows the user to calculate the net present value (NPV), internal rate of return (IRR) and payback period.3,449Discussadd_shopping_cartfree
by ECF Consultancy
- 2 hours ago
Financial Model Assumption Book
Financial model assumption and reference sheet template to be linked to the model5,871Discussadd_shopping_cartfree
by FinExMod
- 4 hours ago
5-Year 3-Statement Financial Projection Model
User-friendly three-statement Excel projection model across 5 year period1,584Discussadd_shopping_cartfree
by Projectify
- 5 hours ago
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.769Discussadd_shopping_cartfree
by Big4WallStreet
- 6 hours ago
Heat Exchangers Excel Workbook
Heat Exchangers Excel Workbook made to align with Chapter 12 of textbook "Rules of Thumb for Engineers" by Stephen Hall2,662Discussadd_shopping_cartfree
by Stephen Hall
- 6 hours ago
Hospital Budgeting Template Demo
Hospital Budget Template - take control of your business' financials.1,383Discussadd_shopping_cart - 13 hours ago
Alibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company2,548Discussadd_shopping_cart - 13 hours ago
Company Valuation Excel Model
Valuation of a company based to its Business Plan 2015-20181,648Discussadd_shopping_cartfree
by Pérez
