Rapid change, increased demands for what-if modelling, and not enough hours in the day? Dynamic arrays can simplify, accelerate and transform your analysis work. No more Control, Shift, Enter! No more implicit intersection! Arrays are now dynamic; they can spill into adjacent cells and be used with multiple formulas.
Join Excel guru, Dianne Auld, for this introduction to the new dynamic array functionality introduced to Office 365/Microsoft 365 Excel users in 2020. Dianne will reveal the power of Excel right at your fingertips. Learn how to transform your dashboard with FILTER, SORT, SORTBY and UNIQUE. Discover how the new XLOOKUP is a real gamechanger and helps you avoid common VLOOKUP errors. Together, we will explore how to leverage these features to help you work easier and smarter.
This class will feature many astonishing applications of these new formulas to transform your rewards work resiliently.
PLUS, all attendees will receive the Excel spreadsheets and detailed instructions for replication of the functions demonstrated after the presentation. You should have a computer with Office 365/Microsoft 365 Excel for this class.
What You Will Learn:
Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules.
877-951-9191 (United States and Canada)
+1 480-951-9191 (other countries)
Monday-Friday: 8:00 a.m. - 7:00 p.m. EST
Email our Customer Experience Team: email@example.com