Excel automation: Which tool to use?

This session will identify all the types of automation within Excel (Power Query / Pivot, LAMBDA, VBA, Office Scripts) and scenarios where it is better to use one vs. the other. Is it online? Do you need to share the script? Are your users in older versions of Excel? These are all important considerations that every Excel user should think about!