Search results: dynamic arrays

• 

  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,7391add_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.

  financial modelingexceldynamic arraysfmwcfinancial modeling world cup

  305Discussadd_shopping_cart

  $50.00

  by Karlheinz Weyh
• 

  Dynamic Arrays Financial Model

  Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.

  modelvaluationcash flowdcfwacc

  551Discussadd_shopping_cart

  $129.00

  by Big4WallStreet
• 

  Dynamic Arrays in Excel

  Dynamic Array Examples that make working with multiple values at the same time easy.

  excelfreeexamplesdynamic arraysarray

  761Discussadd_shopping_cart

  free

  by Big4WallStreet
• 

  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

  131Discussadd_shopping_cart

  $50.00

  by Karlheinz Weyh
• 

  Introduction to LAMBDA course

  Create LAMBDA functions with Dynamic Arrays!

  financial modelingfinancial modellingbeyond excelbxldynamic arrays

  278Discussadd_shopping_cart

  $49.99

  by Craig Hatmaker
• 

  Site Staff Movement Report

  Site Staff Movement Tracker using Dynamic Arrays

  exceldynamic arraysexcel quirks

  454Discusslibrary_add

  free

  by Excel Quirks
• 

  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,0071add_shopping_cart

  free

  by Craig Hatmaker
• 

  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

  336Discussadd_shopping_cart

  $299.00

  by Lance Rubin
• 

  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,6381add_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.

  exceldynamic arrayshuman resource

  154Discusslibrary_add

  free

  by Excel Quirks
• 

  Automated 5g Function Testing

  How to automate testing 5g functions

  financial modeltestingfinancial modelingfinancial modellingdynamic array

  329Discussadd_shopping_cart

  free

  by Craig Hatmaker
• 

  Small Multiple of Bar Graphs or Line Charts in Excel (Trellis / Coplot)

  Excel template to build a Small Multiple of Bar Graphs or Line Charts—in one chart—for ease of analysis and formatting.

  data visualizationanalyticsexcelstatisticsdata science

  1,092Discussadd_shopping_cart

  $20.00

  by Hicham Bou Habib
• 

  Future of Finance Lab: Modern Excel & AI Essentials (Free Starter Kit)

  Get a practical introduction to the latest Future of Finance Lab session, focused on the intersection of Modern Excel and AI for finance professionals.

  financial modelingfinancial modellingexcelfuture of financial modelingfuture of financial modelling

  261Discussadd_shopping_cart

  free

  by Lance Rubin
• 

  3-way Excel and Power BI Modelling with Xero Combo

  Become a data-driven financial modelling expert with this combination of 3-way Modern Excel modelling and Analytics with Power BI. All in 1 powerful package!

  financial modellingpower bimodern_excelway modellingxero modelling

  2904add_shopping_cart

  $499.00

  by Lance Rubin
• 

  One-dimensional Scatterplot with Jitter in Excel

  Excel/PowerPoint template to build 1-dimensional scatterplots—with jitter—to show distributions for several categories.

  data visualizationgraphsanalyticsexcelstatistics

  1,105Discussadd_shopping_cart

  $10.00

  by Hicham Bou Habib
• Your Best Practice

  Have a Best Practice to share?

  Publish your Best Practice
  Learn more about digital publishing

keyboard_arrow_downShow more