Dynamic Arrays & your New Favourite Function: FILTER!

ONLINE EVENT:
Please RSVP HERE on Meetup and also
REGISTER WITH YORKDALE's MICROSOFT STORE to receive the link to access the event.

Register here: https://www.microsoft.com/store/event_registration/?eid=1954982480&locid=94991

After registration, you will get the link to access the session.
Thank you! :)

On the 17th of January 2020, Dynamic Arrays were released to users of Office 365. This incredible feature changes the way you write and think about formulas. Six new functions and a change to the formula engine – Microsoft presents a new and powerful Excel. Come and explore what you can do with Dynamic Array formulas and your new favourite function – FILTER.
– Unmask everything you need to know about Dynamic Arrays
– Automate reports with the FILTER function – no more PivotTables 😮
– Make advanced drop-down list tasks easy with FILTER
– Fully automated dynamic charts

Alan Murray will be our guest speaker for this session.
Alan is an Excel trainer, YouTuber and freelance writer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making people's working lives easier.

Alan runs his own blog, Computergaga (https://www.computergaga.com/blog/category/excel/,) and also writes for the HowTo Geek and GoSkills websites.

He runs a monthly Excel meetup in London (https://www.meetup.com/London-Excel-Meetup-Group/) where 'Excel people' can go, share and help each other.

Alan also has a YouTube channel (https://www.youtube.com/user/Computergaga) with over 500 videos and over 20 million views. Alan contributes to his channel regularly to share the latest Excel developments and techniques that he stumbles upon.
.............................................
AGENDA: (Eastern Time)

5:00 PM - 6:15 PM - "Dynamic Arrays & your New Favourite Function: FILTER!" by Alan Murray:

6:15 PM - 6:30 PM - Closing by Celia Alves

We are looking forward to meeting you there!