This Week’s Tip : Microsoft Excel – Creating ARRAY Formulas
Microsoft Excel – Creating ARRAY Formulas
DID YOU KNOW … that Array formulas can perform multiple calculations on one or more items in a dataset (an array) rather than just a single cell? There are big advantages – here are just three of them:
- Spills automatically – so results fill the needed cells without copying formulas
- Dynamically updates – when the source data changes, the array updates instantly
- Cleaner formulas – one formula replaces multiple copied formulas
Go on give it a try and save heaps of time. Need to know more? Click the play button below to get started.
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.
Fall in Love with Learning this February
Bite Size – Microsoft 365 Training Solutions
On demand e-Learning Library – Try our three month taster for your Business – start anytime. >>Learn more
Your Place or Ours? – Deliver our CPD courses on your own Learning System. >>Learn more
Virtual Classes – Tailored for your organisation. >>Learn more
