Microsoft Excel 365 – Understanding Dynamic Arrays
Microsoft Excel 365 – Understanding Dynamic Arrays
DID YOU KNOW … that Dynamic arrays allow Excel formulas to automatically ‘spill’ results into multiple cells? Instead of writing a formula and copying it down or across, you enter one formula and Excel outputs the full list, table, or range for you. And what’s really great is that they update automatically when your source data changes – growing or shrinking as needed – making your work faster, cleaner and more flexible.
Take 10 minutes to learn more. Click the play button below to get started.
This lesson is part of our CPD Accredited Excel 365 – Expert Course.
Our Weekly Tips are delivered via email every Tuesday. Learn something new every week – in Bite Size bites of learning. To sign up to our Weekly Tip Newsletters – sign up here
Take a look at our Microsoft Office Courses – available within our E-Learning Library and as Virtual Classes.
Spring into Action – with our Microsoft 365 Training
On demand e-Learning Library – Try our three month taster for your Business – start anytime. >>Learn more
Your Place or Ours? – Deliver our SCORM Compliant CPD courses on your own Learning System. >>Learn more
Virtual Classes – 2-hour or full days delivered on Microsoft Teams, tailored for your organisation. >>Learn more
