Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,646Discussadd_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,0421add_shopping_cartfree
by Craig Hatmaker
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.801Discussadd_shopping_cartfree
by Big4WallStreet
Excel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array513Discussadd_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.330Discussadd_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,7941add_shopping_cart$299.00
by Lance Rubin
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.576Discussadd_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,7181add_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.177Discusslibrary_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.145Discussadd_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 Fromulas409Discusslibrary_addTool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel246Discusslibrary_addfree
by consultants
Pakistan Salary Tax Calculator Using LAMBDA (2025-2026)
Pakistan Salary Tax Calculator (Tax Year 2025-2026) Using Excel LAMBDA & LET Functions207Discusslibrary_addfree
by Excel Quirks
Automated 5g Function Testing
How to automate testing 5g functions362Discussadd_shopping_cartfree
by Craig Hatmaker
Introduction to LAMBDA course
Create LAMBDA functions with Dynamic Arrays!303Discussadd_shopping_cart$49.99
by Craig Hatmaker
Site Staff Movement Report
Site Staff Movement Tracker using Dynamic Arrays505Discusslibrary_addfree
by Excel Quirks
- Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing
Last downloaded
- 10 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 perspectives18,1632add_shopping_cartfree
by Norm Miller PhD
- 10 hours ago
Progress Chart Widgets
A set of 5 simple chart widgets designed for recording KPIs and visualizing progress made toward set targets2,063Discussadd_shopping_cartfree
by SHEQXEL
- 15 hours ago
Product Lifecycle Analysis Excel Template
Too to define the maturity of an industry in which a company is competing or the maturity of the products that it sells.2,232Discussadd_shopping_cartfree
by Alberto Scappini
- 15 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 template3,502Discussadd_shopping_cartfree
by ECF Consultancy
- 15 hours ago
Financial Model Assumption Book
Financial model assumption and reference sheet template to be linked to the model5,938Discussadd_shopping_cartfree
by FinExMod
- 16 hours ago
How to Create an Enchanting Pitch
This is to help you make great Pitches with PowerPoint for your business.1,141Discussadd_shopping_cartfree
by Guy Kawasaki
- 17 hours ago
ProfitQube and Company Presentation
BROCHURE - ProfitQube and Company Overview. Please go to Youtube link for Demo: https://youtu.be/JtBbZAivh7k439Discussadd_shopping_cartfree
by Gian Paolo Avanzo
- 17 hours ago
Charts & Figures - Powerpoint Template
Charts and Figures template will assist in the presentation of raw data/information and key business metrics359Discussadd_shopping_cartfree
by Wall Street Oasis
- 17 hours ago
Company Drivers - Powerpoint Template
Company drivers describe the key contributors to revenue and consequently profit for the company375Discussadd_shopping_cartfree
by Wall Street Oasis
- 21 hours ago
Future of Finance Lab: Best Practices for AI-Powered Accountants & AI-Driven Financial Modeling - Session #1
Designed for finance professionals, accountants, and analysts seeking to leverage AI and automation in their workflows as AI-Powered Accountants (Session #1)381Discussadd_shopping_cartfree
by Lance Rubin
- 1 day ago
Growth Deck
This growth deck shares insights into how to build a growth team.509Discussadd_shopping_cartfree
by Andrew Chen
- 1 day ago
Startup Financial Plan Template
Ongoing document made to guide you in running your business, when in need of funding or financing.3,4892add_shopping_cartfree
by Serious Funding
- 1 day ago
2014 Round 1: Snakes and Ladders
Excel training/competition model from the 2014 Financial Modeling World Championships1,198Discussadd_shopping_cart - 1 day ago
Equity & Investment Cap Table Model Template
An Excel spreadsheet to model out cap table equity and dilution through your financing rounds3,839Discussadd_shopping_cartfree
by Giff Constable
- 1 day ago
Stock Transfer Form Template
A pre-made, ready to fill in template that is used to transfer shares to a new shareholder from an existing shareholder2,009Discussadd_shopping_cartfree
by Jonathan Lea
- 1 day ago
E-Commerce Financial Model for Startups
An extremely detailed, methodical package for entrepreneurs on how to build a financial model for an e-commerce startup.26,5821add_shopping_cartfree
by Matt Carroll
- 1 day ago
Fault Current Calculation Spreadsheet
MS Excel Spreadsheet helping you to easily calculate fault current.6,8442add_shopping_cartfree
by John Sokolik
- 1 day ago
Inventory valuation calculator (LIFO, FIFO, Average Cost)
Calculate the value of inventory (goods or even financial instruments available for sale), using LIFO-FIFO-WAC, with this simple excel model template.4,4521add_shopping_cart - 1 day ago
Project Finance Debt Metrics (Manual and Template)
This manual and workbook are designed to help you build metrics required by lenders for project finance transactions.1,629Discussadd_shopping_cartfree
by FinExMod
- 1 day 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,1666add_shopping_cartfree
by FinExMod
