Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,620Discussadd_shopping_cart
free
by Andrei Okhlopkov
Search results: array formulas
by Andrei Okhlopkov
Tool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel228Discusslibrary_addfree
by consultants
Analysing data in Excel
A set of techniques for working with data in Excel2,865Discussadd_shopping_cartfree
by Andrei Okhlopkov
Excel Leave Tracker Template
Excel Leave Tracker Template can be used to record and monitor employee leaves for a year.1,734Discussadd_shopping_cartHow to use 5G Dates Library
Learn how to use 5G functions. 5G increases productivity by 50% and decrease errors by 50%. Easy enough for even Excel novices.352Discussadd_shopping_cart$9.99
by Craig Hatmaker
Electric Vehicle (EV) Charging Infrastructure EPC (Engineering, Procurement & Construction) Financial Forecast Model
EV charging infrastructure EPC providing design, procurement, and installation services for residential, commercial, fleet, and public fast-charging projects.84Discussadd_shopping_cart$139.00
by ExcelFinModels
Battery Energy Storage System (BESS) EPC (Engineering, Procurement & Construction) - Financial Forecast Model
BESS EPC (Engineering, Procurement & Construction) financial model with 5-year forecasts covering project revenue, costs, margins, and cash flows.183Discussadd_shopping_cart$139.00
by ExcelFinModels
Solar Photovoltaic (PV) EPC (Engineering, Procurement & Construction) – Financial Forecast Model
Financial forecast model for Solar PV EPC businesses, covering project-based revenue, costs, cash flows, working capital, and integrated financial statements.92Discussadd_shopping_cart$139.00
by ExcelFinModels
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.763Discussadd_shopping_cartfree
by Big4WallStreet
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.551Discussadd_shopping_cart$129.00
by Big4WallStreet
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,0071add_shopping_cartfree
by Craig Hatmaker
Powerful Dynamic Arrays Model with Monte Carlo Simulation
Newly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!1,7411add_shopping_cart$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.305Discussadd_shopping_cart$50.00
by Karlheinz Weyh
Excel Cheat Sheet: 100+ Formulas, Shortcuts, Advanced Charts + Google Sheets Cheat Sheet
Whether you're a beginner or an experienced Excel user, this Excel Cheat Sheet 100+ Formulas is the perfect tool to help you master Excel and save time.133Discussadd_shopping_cart$8.00$6.40
by Adnan Harysatria
Calculating Annual Churn Rate in SaaS and Subscription Businesses: Methods, Formulas, and Forecasting Framework
Discover essential methodologies and formulas for calculating annual churn rates in SaaS and subscription businesses with recurring contracts.186Discussadd_shopping_cart$40.00
by Jason Varner
Automated Stock Two-Pager w/ Historical Valuation Charts (Bloomberg Formulas)
A fully automated equity tear-sheet w/ BBG formulas designed for hedge fund analysts and institutional investors.240Discussadd_shopping_cart$199.00
by Hedge Fund Tools
- Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing
Last downloaded
- 3 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.8,3772add_shopping_cart - 4 hours ago
SaaS Five Year Financial Projection Excel Template
Save valuable time and use this pre-made Excel Five-Year Financial Projection template for your SaaS business.4,093Discussadd_shopping_cartfree
by Ben Murray
- 7 hours ago
To Model or not to Model
A REFERENCE SHEET on why and how Finance Models are constructed878Discussadd_shopping_cartfree
by David Hubbard
- 7 hours ago
IFRS 9 Stage 1 ECL Estimation
This model estimates the probability of defaults on financial instruments, for financing reporting purpose.3,4981add_shopping_cart - 9 hours ago
IB & PE Standards Comparable Companies Analysis
Comparable Companies Analysis Excel Template- IB & PE Standards472Discussadd_shopping_cart$15.00
by Alex Lcs
- 9 hours ago
Trading Multiples / Comparables Template
A Trading Multiples/Comparables excel file with detailed company and industry margin analysis, growth analysis, and valuations analysis template.235Discussadd_shopping_cartfree
by Autolyst.io
- 9 hours ago
TMX Group Limited DCF and Comparables Model
DCF and Comparables Valuation Model (Capital IQ Plug-in) for TMX Group Limited.1,2601add_shopping_cartfree
by Justin Ho
- 10 hours ago
Simple Bookkeeping Excel Spreadsheet
Free Simple Excel bookkeeping spreadsheet7,4022add_shopping_cart - 10 hours ago
Bus Bar Size and Voltage Drop Calculation Tool
This tool can be used for calculating the size and voltage drop for bus bar.4,931Discussadd_shopping_cartfree
by Jignesh Parmar
- 11 hours ago
Fault Current Calculation Spreadsheet
MS Excel Spreadsheet helping you to easily calculate fault current.6,7522add_shopping_cartfree
by John Sokolik
- 11 hours ago
Monte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros6,1226add_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Sensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model2,9411add_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Dates and Timelines in Excel Financial Models
Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions2,557Discussadd_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Guiding principles of Financial Modelling
The publication explains the general principles of building financial models with practical examples6,703Discussadd_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Startup Cap Table
Multiple round cap table with investor returns1,832Discussadd_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Analysing data in Excel
A set of techniques for working with data in Excel2,865Discussadd_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Cost-Volume-Profit (Breakeven) Analysis
A template to perform cost-volume-profit (CVP, or breakeven) analysis1,657Discussadd_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Form Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.3,2112add_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Unlocking Full Potential of Excel Data Tables (Part 1)
This publication explains advanced methods of using data tables for sensitivity analysis in financial models9,018Discussadd_shopping_cartfree
by Andrei Okhlopkov
- 11 hours ago
Descriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data2,038Discussadd_shopping_cartfree
by Andrei Okhlopkov
