Power Query – Excel-ing

Create a Dynamic Filepath for Power Query Connections

In this post, I am going to discuss an option for creating a dynamic filepath for use as a Source in an Excel to Power Query connection.

In this post, I am going to show you how to prepare a data set for a mail-merge using Power Query.

In this post, I am going to show you how I created a custom period calendar table using Power Query.