When is an Access database not a database?
In the right hands, a screwdriver is a multi-use tool, right? Well so is Microsoft Access!
Find out how to use Access without using it as a database!
Rich Powers Jr
VBA to Treat Tech Anxiety?
The PC Help Desk can handle those unexpected changes that can make your finely-tuned systems crumble!
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…
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.
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.
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.
Dare to Wish for the Impossible
Don't hire more people, put your COMPUTERS to work!