Category Power Query

Excel, Power Query

Power Query Examples – Downloaded Statement – Part 4

This is the 4th post in a series featuring examples of how to use Power Query to transform the data in a typical downloaded account statement file into something that can easily be analyzed in an Excel workbook. In Part…

Rich Powers Jr
March 8, 2024

Excel, Power Query

Power Query Examples – Downloaded Statement – Part 3

Converting blocks of code into nested queries is easy to do and offers benefits like Modularity and Reusability, Improved Readability, Enhanced Flexibility and Scalability and possible Performance Optimizations.

Rich Powers Jr
January 30, 2024

Excel, Power Query

Power Query Examples – Downloaded Statement – Part 2

Power Query Example using the Advanced Editor to make your code easier to follow and 'smarter' with dynamic references.

Rich Powers Jr
January 16, 2024

Excel, Power Query, Series

Power Query Examples – Downloaded Statement – Part 1

This Power Query example demonstrates how to take a poorly formatted file and transform it into useful DATA for analysis.

Rich Powers Jr
January 2, 2024