EXCEL: Introduction to Dynamic Array Formulas with Office 365. 1 pm Toronto, 10 am Vancouver, 11 am Calgary
Course No: ZDATW-08
Format: HANDS-ON ONLINE WORKSHOP. This is a Live Workshop with an Instructor. Participants will work hands-on on practice data, and interact with an instructor online.
Duration: 2 Hours
PRICE & BOOKING: Individual Registrations @ $90 per person. Organizational or Group booking of 3 or more participants will receive 20% off. Contact Us
What will be covered
- A brief revision of Range Names and their use in formula building
- Understanding the behaviour of Array Formulas.
- Exploring differences between Array Formulas in Office 365 and prior versions
- Working with various Array Constants in formulas
- An introduction to the world of “Dynamic” Arrays – what do they mean?
- How Office 365 uses Dynamic Array formulas in Excel
- Introducing Functions with Dynamic Array Formulas – UNIQUE, SORT, XLOOKUP, and more
What’s Included
- Live instruction, interaction and course instruction during the workshop
- One or more files filled with practice data and examples
- One or more PDF files with course notes
- Links to view the recording for one month after the workshop
Special Note: Dynamic Array formulas are ONLY available in updated installs of Office 365. If you have a prior version of Excel, you are welcome to attend, but you will not be able to try out many of the examples.
Important Instructions:
• Office 365 will be used in the workshop demonstration. Participants are welcome to use older versions, but significant differences may exist and where possible the instructor will mention suitable workarounds. Microsoft Office Starter Edition will not be adequate.