Building Power Query templates in Excel 2016 [DI-LAB-HD]
Speaker(s):
Ken Puls
Duration: 120 minutes
Track: Discover & Integrate
This is a 2-hour lab session.
If you've used Power Query for any length of time, you'll have some queries you just can't live without… like that one you use to build a 4-4-5 calendar table for every data model you build. Rather than going through the painful process of copying and pasting the required Excel tables and Power Queries, wouldn't it be nice if you could just click a button in a template workbook to deploy them into your file? That's exactly what this session is about… making you more efficient. From calendar tables to parameter functions, come learn how easy it is to inject new Power Queries into your existing solutions in Excel 2016.