Details

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.


Ken Puls
Excel Guru, Excelguru Consulting Inc.

Ken Puls is a Certified Management Accountant, author, and trainer. With 20 years of experience as a corporate controller and business owner, he has been exposed to many business systems, databases,... View More