Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,673Discussadd_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,0711add_shopping_cartfree
by Craig Hatmaker
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.834Discussadd_shopping_cartfree
by Big4WallStreet
Excel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array544Discussadd_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.343Discussadd_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,8671add_shopping_cart$299.00
by Lance Rubin
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.610Discussadd_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,8291add_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.195Discusslibrary_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.163Discussadd_shopping_cart$50.00
by Karlheinz Weyh
Call Center Descriptive Analytical Dashboard in Microsoft Excel 365
Call Center Descriptive Analytical Dashboard (Dynamic) in Microsoft Excel 365 with Dynamic Array Fromulas474Discusslibrary_addTool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel270Discusslibrary_addfree
by consultants
Pakistan Salary Tax Calculator Using LAMBDA (2025-2026)
Pakistan Salary Tax Calculator (Tax Year 2025-2026) Using Excel LAMBDA & LET Functions242Discusslibrary_addfree
by Excel Quirks
Automated 5g Function Testing
How to automate testing 5g functions382Discussadd_shopping_cartfree
by Craig Hatmaker
Introduction to LAMBDA course
Create LAMBDA functions with Dynamic Arrays!333Discussadd_shopping_cart$49.99
by Craig Hatmaker
Site Staff Movement Report
Site Staff Movement Tracker using Dynamic Arrays554Discusslibrary_addfree
by Excel Quirks
- Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing
Last downloaded
- 31 minutes ago
Public SaaS / Software Company Operating & Valuation Model Template
Comprehensive Public Company SaaS Operating & Valuation Model5,5561add_shopping_cartfree
by AJ Ross
- 1 hour ago
2016 Round 1, Section 3: Roll the Dice
Excel training/competition model from the 2016 Financial Modeling World Championships2,274Discussadd_shopping_cart - 5 hours ago
Financial Model: Various Rounds of Investment Affecting Ownership, Waterfall Analysis, and IRR/Return Multiple Analysis
Excel Financial model for entrepreneurs looking to raise capital2,182Discussadd_shopping_cart - 5 hours ago
Excel for Financial Modeling - Functions & Formulas Practice Workbook
The Excel functions every financial modeler needs, in one interactive workbook.299Discussadd_shopping_cartfree
by FinExMod
- 5 hours ago
Financial Modeling Best Practices
This is a guide on financial modeling best practices, brought to you by FinancialModeling.org.1,504Discussadd_shopping_cart - 6 hours ago
Leveraged Buyout LBO Model Template
A full Leveraged Buyout LBO model template for a project to understand its different components and work with your own.11,4673add_shopping_cartfree
by John P. Burns
- 6 hours ago
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.834Discussadd_shopping_cartfree
by Big4WallStreet
- 6 hours ago
How to Compile a Comprehensive Financial Database
These models and accompanying PDF and YouTube guides are exhaustive tools for downloading a comprehensive database.1,001Discussadd_shopping_cartfree
by Prof. Ed Bodmer
- 7 hours ago
Financial Model Version Tracker
Financial model tracker is a tool enables you to keep a track of the changes through multiple versions1,728Discussadd_shopping_cartfree
by FinExMod
- 9 hours ago
IT Project ROI (Return on Investment) Tool
Legacy documents that credibly assess/quantify the costs and benefits (ROI / TCO) of a variety of IT investments2,726Discussadd_shopping_cartfree
by Andrew Hall
- 11 hours ago
Private Equity (PE) Distribution Waterfall - Excel Model Template
This is a ready-to-use distribution waterfall made for those in private equity.7,055Discussadd_shopping_cartfree
by Wall Street Oasis
- 11 hours ago
Excel Revolving Credit Calculator for annual models
An automatic excel algebraic approach for revolving loan facility in annual financial models (no macro & circular links)8,427Discussadd_shopping_cartfree
by Ivan Klykov
- 11 hours ago
Optimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.7,028Discussadd_shopping_cart - 11 hours ago
Combination Model
A 22 section excel model to assess the impact on the financials of the combination of companies10,7336add_shopping_cartfree
by John P. Burns
- 12 hours ago
Abacus Solar & Wind Debt Sculpting Financial Model
Free, debt sculpting financial model for solar, wind, and other renewable energy and PPP transactions.3,5062add_shopping_cartfree
by AbacusPF
- 21 hours ago
SaaS Cohort Analysis Model
A simple cohort analysis spreadsheet to understand how you are doing on your KPIs (Churn, Customer Lifetime etc.)5,896Discussadd_shopping_cartfree
by Christoph Janz
- 21 hours ago
Customer Lifetime Value Excel Template
This Excel template helps you to calculate the revenue you receive from a customer over their lifetime.4,353Discussadd_shopping_cartfree
by Ben Murray
- 21 hours ago
SaaS Modeling Revenue Growth and Value Creation Excel Model
60 month ready-to-use Revenue Growth and Value Creation model to help plan for growth, including instructions.1,803Discussadd_shopping_cartfree
by Brian Parks
- 21 hours ago
SaaS Metrics Excel Template
A standard SaaS reporting excel template for entrepreneurs to customize.9,770Discussadd_shopping_cartfree
by Amit Karp
- 21 hours ago
SaaS Churn Excel Model Template
This is a ready-to-use Churn template to help record the churn and retention rates for your SaaS business.2,613Discussadd_shopping_cartfree
by Ben Murray
