Excel For Freelancers

Your Power Query skill now stops and asks what you actually want before it touches a single file. In the original training, we pointed Claude at a pile of messy Excel files and got back one big M code export, whether or not that was what you needed. When a client sends you a hundred broken files, yo

You can fix a Power Query folder import that refuses to work, even if you've only opened Power Query a handful of times. You point Excel at a folder, click Combine, and get "The key didn't match any rows in the table." Then you open the Advanced Editor, stare at a wall of M code, and close it again.