Build a Financial Model using Dynamic Array Functions
Access Analytic
View ChannelAbout
Amazing Excel and Power BI Solutions. Perth, Western Australia. Our aim is to help you make decisions with confidence. Let us know if there's topics you'd like to cover and please subscribe and click the notification item to keep informed when we release new videos. About Us... Jeff Robson, Wyn Hopkins are the directors of Access Analytic Jeff is the founding Director and Principal Business Analyst at Access Analytic Solutions. He has over 20 years’ experience in chartered accounting, business management and consulting. Wyn is a Microsoft MVP and was once upon a time a Chartered Accountant with PricewaterhouseCoopers in the UK. He published the book Power BI for the Excel Analyst (a beginners guide to Power BI) in July 2022: https://pbi.guide Find out more about us and the team here https://accessanalytic.com.au/about-us-2-2/ Both Jeff and Wyn would love to connect up with you on LinkedIn https://www.linkedin.com/in/wynhopkins/ https://www.linkedin.com/in/jeffrobson/
Latest Posts
Video Description
See how to apply Excel's dynamic array functions to create a financial model without copying & pasting a single formula! Example file available for download from https://accessanalytic.com.au/financial-modelling-dynamic-array-functions/
Essential Travel Photo Gear
AI-recommended products based on this video

ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More

Anker iPhone 16 Charger, 2-Pack 20W Fast USB C Charger Block, for iPhone 16/16 Pro Max/15 Series/iPad Pro and More (White, 2 Pack & 2 Cable)

Anker Power Bank(PowerCore 10K),Compact Travel-Ready 10,000mAh Battery Pack with PowerIQ Charging Technology,5V/3A High-Speed Charging for iPhone,iPad,and More (USB-C Input and Output(Black),1pack) ClimatePartner certified

VEEKTOMX Portable Charger with Built in Cables 10000mAh, Power Bank for iPhone with Wall Plug, Travel Essential Fast Charging USB C Slim External Battery Pack for iPhone16/15/14, Samsung, iPad, etc

ROVE R2-4K DUAL Dash Cam Front and Rear, STARVIS 2 Sensor, FREE 128GB Card Included, 5G WiFi - up to 20MB/s Fastest Download Speed with App, 4K 2160P/FHD Dash Camera for Cars, 3" IPS, 24H Parking Mode

COOWPS Switch Case for Nintendo Switch and Switch OLED Model, Portable Full Protection Carrying Travel Bag with 18 Game Cards Storage for Switch Console Pro Controller Accessories Black

UGREEN Revodok Pro 210 Docking Station 10 in 1 USB C Dock Dual HDMI 4K@60Hz Single 8K@30Hz 100W PD 5Gbps USB C and USB A Data Ports Gigabit Ethernet, SD/TF Card Reader USB Hub Compatible for HP, Dell

EMEET C960 Webcam with Tripod, 1080P Webcam with Microphone, Adjustable Height Mini Tripod, C960 Web Camera with Privacy Cover, Plug & Play with Stand for Zoom/Skype/YouTube/FaceTime

DJI Mic Mini (2 TX + 1 RX + Charging Case), Wireless Lavalier Microphone for iPhone/Camera/Android, Ultralight, Detail-Rich Audio, 48h Use, Noise Cancelling, Automatic Limiting, Vlog, Streaming


















