Dynamic Array Functions: a Must-Know in Excel | Celia Alves - VanPUG Excel Edition-Feb 2023

SESSION OUTLINE:
Dynamic array functions are a game-changer in Excel. Many problems can be solved in a much easier, simpler, and faster way if we can use dynamic array functions than without them.

The Microsoft Excel team released several dynamic array functions in the past couple of years. Working with them requires a change in our thought process in Excel. However, once you start getting the hang of it, it is tough to go back to working without dynamic array functions and dynamic array capabilities in Excel.

In this session, we will look at some business cases where dynamic array functions shine in making our life so much easier. A zip folder with Celia's files to go along with the presentation can be downloaded here: https://1drv.ms/u/s!AuhhLgCXSCKKgYRB7zafd8CanQ0mrQ?e=WACo6q

SPEAKER PROFILE:
Celia Alves is an Excel Business Solutions Developer certified by Microsoft as Excel Expert. She loves to design and build solutions combining Excel, VBA, Power Query and Power Pivot to automate tasks, analyze data and model business processes.

With an academic background in Mathematics and Education and 20 years of experience as a high school Mathematics teacher, Celia combined her passion for teaching with her experience as Excel Consultant to offer free tutorials on YouTube and a Training Program to help professionals automate their Excel recurring tasks.

She firmly believes that automating routine Excel reporting procedures saves money and resources for companies, improves their workflows and promotes a happier work environment by offering their staff the opportunity to contribute more valuable and meaningful work to their organizations.

Celia is also a speaker and the founder and leader of the MS Excel Toronto Meetup Group. For her contribution to the community, she was awarded MVP by Microsoft in 2020 and every year after that.

Connect with and follow Celia online at:
Her website: https://solveandexcel.ca/
LinkedIn: http://www.linkedin.com/in/celiajordaoalves
YouTube: https://www.youtube.com/channel/UCzWFp4hOnIBHHCJi_SEWV7g
Facebook: https://www.facebook.com/solveandexcel/
Instagram: https://instagram.com/solveandexcel

Тэги:

#Dynamic_Arrays #Excel

Скачать видео