Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,642Discussadd_shopping_cart
free
by Andrei Okhlopkov
Search results: array formulas
by Andrei Okhlopkov
Call Center Descriptive Analytical Dashboard in Microsoft Excel 365
Call Center Descriptive Analytical Dashboard (Dynamic) in Microsoft Excel 365 with Dynamic Array Fromulas380Discusslibrary_addTool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel244Discusslibrary_addfree
by consultants
Analysing data in Excel
A set of techniques for working with data in Excel2,884Discussadd_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,792Discussadd_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.373Discussadd_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.111Discussadd_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.204Discussadd_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.111Discussadd_shopping_cart$139.00
by ExcelFinModels
HSE Observation Dashboard Professional
A premium, zero-maintenance safety observation management system. Log your field data and instantly generate executive KPIs, high-potential (HI-PO) tracking13Discussadd_shopping_cart$12.00
by Ahmed Mousa
PTW ASSURANCE CONTROL CENTER
Advanced Permit to Work (PTW) Assurance & Audit Dashboard17Discussadd_shopping_cart$12.00
by Ahmed Mousa
3-Statement Financial Model with DCF, Comparables, & LBO Returns – Excel & Google Sheets
An integrated three-statement operating model valued three ways: discounted cash flow (DCF), trading comparables, and precedent transactions with an acquisition361add_shopping_cart$189.00
by Curtis Whelan
Professional Project Risk Register & Executive Dashboard (5x5 Inherent & Residual Matrix)
A tried & tested Excel tool for tracking inherent vs. residual project risks, featuring a dynamic executive RAG dashboard51Discussadd_shopping_cart$7.50
by James Stammers
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.798Discussadd_shopping_cartfree
by Big4WallStreet
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.572Discussadd_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,0391add_shopping_cartfree
by Craig Hatmaker
- Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing
Last downloaded
- 5 hours ago
Employee Onboarding Tracker – Power BI
Download this Onboarding Tracker in Power BI for an effective onboarding process of all your new employees.1,172Discussadd_shopping_cartfree
by Indzara
- 13 hours ago
Discounted Cash Flow (DCF) Model Template + Instructions
Learn how to build a simple DCF Model aligned with Investment Banking best practices.4,1801add_shopping_cartfree
by Wall Street Prep
- 13 hours ago
CAPEX and Depreciation Projections Excel Model Template
Get control of future capital expenditure with this CAPEX and Depreciation Projections Model.10,479Discussadd_shopping_cart - 13 hours ago
Canadian Safe Term Sheet
Canadian Simple Agreement for Future Equity Template with Educational Notes attached to help you.1,396Discussadd_shopping_cartfree
by Naco Canada
- 13 hours ago
Sample Due Diligence Checklist
Sample checklist for conducting due diligence.2,626Discussadd_shopping_cartfree
by Meritus Ventures
- 16 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 Hall2,720Discussadd_shopping_cartfree
by Stephen Hall
- 17 hours ago
Income and Expenses Excel Dashboard
The Monthly Income and Expenses spreadsheet provides a comprehensive insight into your organization's financial management.3,070Discussadd_shopping_cart$21.00$10.50
by Improve Your Excel
- 18 hours ago
Complete Three-Statement Quarterly Budget
A fundamental and professional budget / business plan291Discussadd_shopping_cart$79.00
by Andrei Okhlopkov
- 18 hours ago
Complete Three-Statement Quarterly Budget with Scenarios
A fundamental and professional budget / business plan360Discussadd_shopping_cart$89.00
by Andrei Okhlopkov
- 19 hours ago
Fault Current Calculation Spreadsheet
MS Excel Spreadsheet helping you to easily calculate fault current.6,8342add_shopping_cartfree
by John Sokolik
- 19 hours ago
EasePro: 13 Week Cashflow Template
13-Week Cash Flow Forecast Template in Excel.25Discussadd_shopping_cart - 21 hours ago
Startup Business Financial Model & Plan - 10 Year Three Statement Analysis (Any Type of Business)
This Startup Business Financial Model includes a Business Plan Template - 10 years, Three Statement analyses, plus a Dashboard - Product by Product Analysis311Discussadd_shopping_cart$45.00
by Anthony Van Rensburg
- 22 hours ago
Value Added Tax in a Project Finance model (Guide and Excel Template)
A guide and excel template explaining how to model Value Added Tax refund mechanism in a Project Finance Model.3,3401add_shopping_cartfree
by FinExMod
- 1 day ago
Manufacturing project model
Comprehensive learning tool for those interested in project modelling977Discussadd_shopping_cartfree
by A. Emmanuel
- 1 day ago
Founders Shareholder Agreement Template
This founders shareholder agreement is what you need progress your startup from idea to reality.8,517Discussadd_shopping_cartfree
by Startup Commons
- 1 day ago
Abacus Solar & Wind Debt Sculpting Financial Model
Free, debt sculpting financial model for solar, wind, and other renewable energy and PPP transactions.3,4402add_shopping_cartfree
by AbacusPF
- 1 day ago
Multiple Equity Stocks Trading FIFO Gain Excel Calculator
Easy-to-use Excel calculator for calculation of profits in equity stock trading using FIFO method for multiple stocks with Carry Over Option and Yearly Summary.8,00719add_shopping_cart$39.00
by Soni Excel Solutions
- 1 day ago
LCOE Calculator — Solar PV · Wind · Offshore · BESS | Free Tool
Free Excel LCOE calculator for renewable energy projects. 4 technologies, 10 markets.396Discusslibrary_addfree
by Piero Farenti
- 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,4351add_shopping_cart - 1 day ago
Therapist session tracker
Therapist session tracker - therapy client tracker - therapist tracker - session tracker - therapist organizer - therapist planner - therapy37Discussadd_shopping_cart$5.00
by Aman Khan
