In the last decade, Microsoft has seen the introduction of several new tools – not just individual buttons, but entire systems for working. If you haven’t gone on a deep-dive with these features, you’re being left behind. This session will cover tools like Power Query and Power Pivot, as well as many of the fifty-plus new functions introduced this decade.
Topics include:
- Automating data imports and cleaning with Power Query
- Building Pivot Tables from multiple data tables with Power Pivot
- Leveraging new dynamic array functions to solve complex data issues
- Creating online scripts for automation in cloud-based spreadsheets
($) Additional Registration is Required