Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,603Discussadd_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.9831add_shopping_cartfree
by Craig Hatmaker
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.741Discussadd_shopping_cartfree
by Big4WallStreet
Excel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array421Discussadd_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.284Discussadd_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,6851add_shopping_cart$299.00
by Lance Rubin
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.540Discussadd_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,5811add_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.143Discusslibrary_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.114Discussadd_shopping_cart$50.00
by Karlheinz Weyh
Tool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel211Discusslibrary_addfree
by consultants
Pakistan Salary Tax Calculator Using LAMBDA (2025-2026)
Pakistan Salary Tax Calculator (Tax Year 2025-2026) Using Excel LAMBDA & LET Functions114Discusslibrary_addfree
by Excel Quirks
Automated 5g Function Testing
How to automate testing 5g functions309Discussadd_shopping_cartfree
by Craig Hatmaker
Introduction to LAMBDA course
Create LAMBDA functions with Dynamic Arrays!259Discussadd_shopping_cart$49.99
by Craig Hatmaker
Site Staff Movement Report
Site Staff Movement Tracker using Dynamic Arrays407Discussadd_shopping_cart$15.00$0.75
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.314Discussadd_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
Financial Model audit check list - spreadsheet
This is an audit or productivity tool that you can use while reviewing someone else’s models.8,9386add_shopping_cartfree
by FinExMod
- 2 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.7,1383add_shopping_cartfree
by FinExMod
- 2 hours ago
Delay sensitivity, Overrun and Liquidated Damages (Manual and Excel Template)
This manual and Excel template provide a clear way to model a delay in construction, cost overrun and Liquidated damages3,088Discussadd_shopping_cartfree
by FinExMod
- 3 hours ago
DCF Valuation
Discounted cash flow (DCF) valuation is a type of financial model that determines whether an investment is worthwhile based on future cash flows. A DCF model is160Discussadd_shopping_cartfree
by Invexic Official
- 5 hours ago
SaaS Financial Plan
A financial plan template for SaaS startups based on a model created for Zendesk11,210Discussadd_shopping_cartfree
by Christoph Janz
- 6 hours ago
Workplace Inspection Dashboard Excel Template
SHEQXEL Workplace Inspection Dashboard Template is a simple template for recording number of inspections with graphical5,2002add_shopping_cartfree
by SHEQXEL
- 6 hours ago
Safety Induction Tracker - Excel Template
Keep your workforce compliant and your safety records audit-ready with this fully automated Safety Induction Tracker in Excel.335Discussadd_shopping_cartfree
by John Peter R
- 6 hours ago
Toolbox Talk Attendance Tracker Template (Excel/Spreadsheet)
Keep your team safe and compliant with our professional and easy-to-use Toolbox Talk Attendance Tracker.259Discussadd_shopping_cartfree
by John Peter R
- 6 hours ago
Toolbox Talk Statistics PPT
Toolbox Talk Dashboard is Live!281Discussadd_shopping_cartfree
by John Peter R
- 6 hours ago
Workplace Safety Performance Dashboard - Excel Template
Boost workplace safety and compliance with our Safety Performance Dashboard Template.683Discussadd_shopping_cartfree
by John Peter R
- 6 hours ago
FREE EHS Observation Dashboard - Excel Template
EHS Observation Dashboard - Excel Template1,111Discussadd_shopping_cartfree
by John Peter R
- 7 hours ago
JIRA Cheat Sheet
This is a brief introduction to using JIRA for project management in the IT and software development environments.10,155Discussadd_shopping_cart - 7 hours ago
Home Electrical Bill / Energy Consumption / Load Calculator
Calculation tool for working out home electrical bill, energy consumption, and load.1,0631add_shopping_cartfree
by Jignesh Parmar
- 8 hours ago
Cable Size Calculation Spreadsheet
Cable size calculations based on Motor Horse Power HP and Specified Current.17,0082add_shopping_cartfree
by Jim Nash
- 8 hours ago
Residential Load Calculation Spreadsheet
Spreadsheet in Excel to help you calculate residential load.22,0803add_shopping_cartfree
by John Sokolik
- 8 hours ago
Electrical Load and Energy Consumption Calculator
This tool allows you to calculate the energy consumption and electrical load of panel.6,829Discussadd_shopping_cartfree
by Jignesh Parmar
- 8 hours ago
Free Multi-purpose Excel Modelling Tool (Add-in)
Free Microsoft Excel modelling add-in containing a wide range of tools for navigation, formatting and excel modelling.8,6511add_shopping_cartfree
by Kevin Yassine
- 9 hours ago
Audit Substantive Procedures
Substantive Audit Procedures to download in PDF format.295Discussadd_shopping_cartfree
by Mo ModelPro
- 9 hours ago
HR (Human Resources) Best Practices Survey Template
Human Resource Best Practices Survey Template in Microsoft Excel951Discusslibrary_add - 11 hours ago
Building Integrity Checks in Project Finance Models (Manual & Template)
This is a spreadsheet that can be integrated in any project finance model. It contains most common integrity checks.2,5644add_shopping_cartfree
by FinExMod
