- Log in
- Sign up
Homepage
Browse
Explore Categories
How it works
Cart 0
Bookmarks 0
- Publish

0
0
0
Log in
Sign up
Publish a Best Practice

Finance
Strategy
Startups
Legal
Marketing
Leadership & HR
Technology
Student
Other
All

Search results: dynamic array

Total results: 1674 has-more!

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.
excelbeyond excelbxldynamic arraydynamic named range
1,0621
free
by Craig Hatmaker
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.
excelfreeexamplesdynamic arraysarray
820Discuss
free
by Big4WallStreet
Excel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array
modern_exceldynamic arrayreport automation
532Discuss
$40.00
by Folorunso Lala
Powerful Dynamic Arrays Model with Monte Carlo Simulation
Newly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!
financial modellingpowerbidynamic arraysfuture of financial modellinganalytics & modelling
1,8331
$299.00
by Lance Rubin
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.
financial modelingexceldynamic arraysfmwcfinancial modeling world cup
339Discuss
$50.00
by Karlheinz Weyh
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.
modelvaluationcash flowdcfwacc
603Discuss
$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.
financial modelingfinancial modellingamortizationdepreciationbeyond excel
2,7781
$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.
exceldynamic arrayshuman resource
189Discuss
free
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.
dynamic arraysfmwc
157Discuss
$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 Fromulas
analysisanalyticsdashboardexcelformulas
463Discuss
free
by Rahim Zulfiqar Ali
Introduction to LAMBDA course
Create LAMBDA functions with Dynamic Arrays!
financial modelingfinancial modellingbeyond excelbxldynamic arrays
324Discuss
$49.99
by Craig Hatmaker
Site Staff Movement Report
Site Staff Movement Tracker using Dynamic Arrays
exceldynamic arraysexcel quirks
540Discuss
free
by Excel Quirks
Automated 5g Function Testing
How to automate testing 5g functions
financial modeltestingfinancial modelingfinancial modellingdynamic array
375Discuss
free
by Craig Hatmaker
Pakistan Salary Tax Calculator Using LAMBDA (2025-2026)
Pakistan Salary Tax Calculator (Tax Year 2025-2026) Using Excel LAMBDA & LET Functions
calculatordynamic arraylambdasalary tax
234Discuss
free
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.
forecastingfinancial modellingexcelpower bipower query
391Discuss
$299.00
by Lance Rubin
Salary Tax Calculator using Microsoft Excel's LAMBDA & LET Functions for Financial Year 2026-2027 (Tax Year 2027)
LAMBDA lets us write a custom function once, give it a name (via the Name Manager), and call it anywhere.
calculatorexcelsalaryincome taxdynamic arrays
71Discuss
free
by Excel Quirks
Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing

eloqoon share idea

Have a ready-to-use Best Practice you would like to share?

Publish a Best Practice

Learn more about digital publishing

Can't find what you are looking for?

Or browse through the Catalog

eloqoon search someone

Think of someone who could publish?

Suggest an author

Learn more about digital publishing

Last downloaded

10 minutes ago
Public SaaS / Software Company Operating & Valuation Model Template
Comprehensive Public Company SaaS Operating & Valuation Model
valuationdcfwaccfinancial modelsaas
5,5291
free
by AJ Ross
1 hour ago
High Growth Firms Valuation Model
Value tough-to-value firms, with negative earnings, high growth in revenues and few comparables
financevaluationfcffpresent valuehigh growth
1,208Discuss
free
by Aswath Damodaran
1 hour ago
Financial Model Detective Book: Hints and Tricks on how to Review Project Finance models
This book describes how to carry out a financial model review in a systematic and methodical way.
financial modelproject financeauditfinancial model review
2,218Discuss
$9.50
by FinExMod
2 hours ago
Network Optimization: How to perform a Greenfield Analysis
This document and toolkit work to enable accurate Greenfield Scenarios, customizable and quick.
optimizationgreenfieldgreenfield analysissite selectioncustomer demand
420Discuss
free
by Ben Unpingco
2 hours ago
Free Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)
financefree cash flow for the firmfcffebitebitda
1,331Discuss
free
by Dheeraj Vaidya CFA FRM
2 hours ago
Combination Model
A 22 section excel model to assess the impact on the financials of the combination of companies
combinationimpactfinancemergersm&a
10,6836
free
by John P. Burns
2 hours ago
Excel for Financial Modeling - Functions & Formulas Practice Workbook
The Excel functions every financial modeler needs, in one interactive workbook.
financial modelingexcelexcel skillsexcel functions
268Discuss
free
by FinExMod
2 hours ago
McKinsey's Strategic Control Map Framework Model Template
An editable PowerPoint Template Slide of McKinsey's Strategic Control Map Framework Model, to help organisations maximise their market capitalization.
strategic planningm&amarket capitalizationmergers & acquisitionsmckinsey & company
2,450Discuss
free
by Tim Demoures
2 hours ago
Acquisition Schedule - Excel Model Template
This is an Excel Template of the Acquisition Schedule
acquisitionacquisition schedulecapital acquisition
2,841Discuss
free
by Wall Street Oasis
2 hours ago
How to use history in making an acquisition analysis
An extensive excel tool for acquisition analysis, and how to use history when making an acquisition analysis.
acquisitionhistoryanalysism&aacquisition analysis
1,285Discuss
free
by Prof. Ed Bodmer
4 hours ago
KISS Debt Version
KISS stands for Keep It Simple Security: Debt Version legal document template.
documentlegaldebt versioncustomizable
547Discuss
free
by 500 Startups
4 hours ago
KISS Equity Version
KISS: Keep it Simple Security; Downloadable Equity Version Template.
financinginvestorslegalequity versionkiss
1,178Discuss
free
by 500 Startups
13 hours ago
Investment Thesis - Powerpoint Template
Powerpoint template guiding the user to create an investment strategy presentation
investmentpresentationstructurepowerpointlayout
4,303Discuss
free
by Wall Street Oasis
17 hours ago
Employee Overtime Tracker
Time tracking spreadsheet template, to track employee worked hours, and overtime work, weekly employee time tracking report
overtimehr dashboardhr metricsemployee kpisemployee attendance
481Discuss
free
by Nisrine LAHRECHE
19 hours ago
TOWS Matrix Excel Template Free Download
The model has build to helps the user to form a SWOT analysis and TOWS matrix as a strategic roadmap for the business in excel template
swottows
3,546Discuss
free
by ECF Consultancy
20 hours ago
YouTube Investment Memo - Analysis
Overview and analysis of an Investment Memo made for YouTube
investmentventure capitalyoutubeinvestment memoinvestment memorandum
1,424Discuss
free
by Miles Grimshaw
20 hours ago
Absorbers Excel Workbook
Absorbers Excel Workbook created to align with Chapter 4: 'Absorbers' of textbook "Rules of Thumb for Engineers."
excelspreadsheetengineeringabsorbershenrys law
1,229Discuss
free
by Stephen Hall
22 hours ago
Chart of Accounts Excel Template for ERP
A structured, ready-to-use chart of accounts covering 4 major classes (Assets, Liabilities, Expenses, Revenues)
accountingbalance sheeterpcoachart of accounts
57Discuss
free
by model based
23 hours ago
Rent vs Mortgage Excel Template
Rent vs Mortgage is an excel tool that calculates the payments to a house mortgage loan and compares it to renting.
financecash flowinterestcapitalmortgage
1,041Discuss
free
by Big4WallStreet
23 hours ago
Sensitivity and Scenario Analysis Excel Template with VBA
This workbook and this manual are designed to help you build a sensitivity analysis into your models using VBA.
sensitivity analysisfinancial modelingscenario analysisvba
7,5253
free
by FinExMod

About Eloquens
Home
How it Works
Publishing Best Practices
Finding Best Practices
About Us
Blog
 
Imprint
Terms of Service
FAQ
Contact Us
Categories
Finance
Strategy
Startups
Legal
Marketing
Leadership & HR
Technology
Student
Other
Browse Catalog
Sign-Up
Log In

Our Teams Work on

© 2026 Eloquens

%product_add_cart_title%

Contribute: $USD%product_add_cart_label%

No thanks, I just want to %product_skip_link%

Login

eloqoon computer

View all Eloqoons

Email

Password

Forgot your password?

New to Eloquens? Create an Account

Create an account

eloquens mascot

View all Eloqoons

Why should I sign up with LinkedIn?

sign up with email

I have read and agree to the Eloquens Terms of Service and Privacy Policy.

Why should I sign up with LinkedIn?

sign up with email

I have read and agree to the Eloquens Terms of Service and Privacy Policy.

Have an account? Login

Are you using this Best Practice for...

Business
Consulting
Student / Non-Profit

Read detailed licenses

Message

OK

please wait...

216.73.216.5