- 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: 1659 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,0361
free
by Craig Hatmaker
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.
excelfreeexamplesdynamic arraysarray
796Discuss
free
by Big4WallStreet
Excel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array
modern_exceldynamic arrayreport automation
502Discuss
$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,7861
$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
325Discuss
$50.00
by Karlheinz Weyh
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.
modelvaluationcash flowdcfwacc
571Discuss
$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,7101
$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
170Discuss
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
142Discuss
$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
345Discuss
free
by Rahim Zulfiqar Ali
Introduction to LAMBDA course
Create LAMBDA functions with Dynamic Arrays!
financial modelingfinancial modellingbeyond excelbxldynamic arrays
298Discuss
$49.99
by Craig Hatmaker
Site Staff Movement Report
Site Staff Movement Tracker using Dynamic Arrays
exceldynamic arraysexcel quirks
494Discuss
free
by Excel Quirks
Automated 5g Function Testing
How to automate testing 5g functions
financial modeltestingfinancial modelingfinancial modellingdynamic array
355Discuss
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
200Discuss
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
368Discuss
$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
29Discuss
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

1 hour ago
Financial Modeling of Major Maintenance Reserve Account with Manual and Excel Template
Financial Modeling of Major Maintenance Reserve Account
project financefinancialmodellingfinancialmodelproject finance modelmajor maintenance
1,573Discuss
free
by FinExMod
2 hours ago
EMF Pro - Advanced Model Review Utility
The Complete Financial Modelling Utilities for Modellers (Trial)
financial modeladd-inexcel addinreview toolemf pro
227Discuss
free
by emodelfactory.com
2 hours ago
Pitch Deck / Investment Presentation Template
Lengthy set of slides covering various aspects of a typical investment presentation, along with the excel source file.
presentationventure capitalinvestingpitch deckcim
8,5842
free
by DW Financial Services
3 hours ago
Due Diligence Excel Checklist
Checklist helping you to be prepared for an upcoming due diligence process.
acquisitioncompanychecklistdue diligencelegal
19,191Discuss
free
by Firmex
4 hours ago
Financial Projections Excel Template
Our financial projections template provides everything needed to create 5 year startup financial projections.
income statementbusiness planbalance sheetstartupfinancial projections
8,5473
free
by Plan Projections
4 hours ago
Porter's Generic Strategies Matrix Template
Position your company on a Matrix to determine your competitive focus with Porter's Generic Strategies Template.
differentiationmarketing strategycompetitive advantagefocusmichael porter
4,2423
free
by Tim Demoures
4 hours ago
Travel Agency Excel Budgeting Template Demo
Travel Agency Budget Template - take control of your business' financials
projectionsplanningbudgetingtraveltravel agency
997Discuss
free
by Andrew Grigolyunovich, CFA, CFM, FMVA
4 hours ago
Travel Agency Business Plan Example
If you are planning to start a new tour and travel agency business, the first thing you will need is a business plan. Use our Travel Agency Business Plan.
business planbusiness plan templatetravel agencytourismbusiness plan example
169Discuss
free
by Upmetrics.co
12 hours ago
Pricing Your Product: Product Costing Excel Template
Excel spreadsheet to calculate how much it costs to produce your product.
productmarketingpricingcoststemplate
67,481Discuss
free
by Craft Northern Ireland
13 hours ago
Management Data Entry
Excel Data Entry User Form made with Visual Basic.
managementexceltablevbadata entry
2,7202
free
by Rilinda Abazi
13 hours ago
Segmental P&L (Profit & Loss)
Business segment reporting breaks out a company's financial data by company divisions
income statementprofit/losssegmental p&l
3,466Discuss
free
by ECF Consultancy
14 hours ago
Costing Studio Lite – Excel-Based CAPEX, COGS & Project Economics Software
ChemDesign Costing Studio Lite is a 64-bit Excel-based engineering costing application for estimating CAPEX, COGM, COGS and project financial returns.
chemical engineeringcogs costing plant
New!Discuss
free
by Deon de Wet-Roos
14 hours ago
2014 Round 1: Precise Debt Modeling
Excel training/competition model from the 2014 Financial Modeling World Championships
financial modelingloan amortizationloan scheduleexcel skillsexcel training
1,499Discuss
free
by Full Stack Modeller
16 hours ago
Product Pricing Strategy Insights
Mastering the Art of Pricing: What the Textbooks Don't Teach You
strategyproductmarketingpricingstartups
2,421Discuss
free
by Bing Gordon
20 hours ago
Discounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives
acquisitionfinancecash flownpvirr
18,1502
free
by Norm Miller PhD
20 hours ago
Discounted Cash Flow (DCF) Model (Academic Quality)
A simple DCF model serving as an academic exercise to understand how financial modeling works.
financevaluationcorporate financedcfdiscounted cash flow
3,698Discuss
free
by Joshua Wong
21 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.
capital structuredcfscenariosstartupcashflow
13,720Discuss
free
by Jacek Polewski
22 hours ago
Abacus Solar & Wind Debt Sculpting Financial Model
Free, debt sculpting financial model for solar, wind, and other renewable energy and PPP transactions.
sensitivity analysisfinancial modelfinancial modellingproject financesolar
3,4282
free
by AbacusPF
23 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.
financial modelingtoolsproductivityfinancial modelersfinancial model audit
9,1496
free
by FinExMod
23 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 Hall
excelspreadsheetengineeringworkbookheat exchangers
2,712Discuss
free
by Stephen Hall

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.217.173