Blog

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!

August 2, 2024

VBA to Treat Tech Anxiety?

The PC Help Desk can handle those unexpected changes that can make your finely-tuned systems crumble!

July 21, 2024

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…

March 8, 2024

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.

January 30, 2024

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.

January 16, 2024

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.

January 2, 2024

Dare to Wish for the Impossible

Don't hire more people, put your COMPUTERS to work!

December 3, 2023