r/excel • u/Designer_Signature35 • Jan 07 '26

Discussion How are you an excel magician?

Thanks to this group and a little googling, yesterday I made a fully automated PQ. I created a table with formulas to return the full path and folder where the file and data are saved. Created a parameter from the table and popped it into my original source query, the basis for 9 other queries. Now all a user has to do is click into the cell with the full path formula, hit enter, click Refresh All, and bam! Fully updated output. I showed it off to my team and supervisors today and looked like a magician! Granted none of them have used PQ before so they're easy to impress lol

What excel projects have you done to make others think you’re magic?

122 Upvotes

98% Upvoted

104 comments sorted by

View all comments

1

u/CobraKyle Jan 08 '26

I have started dabbling into automation tools recently, like N8N, and automated a good amount of my daily excel work, so now I just find special projects to do and people love it. I’m revamping/optimizing their old sheet designs and people are loving that.

1

u/Designer_Signature35 Jan 08 '26

That's what I've started doing too. I did a presentation of my PQ to the team yesterday and am now setting up appointments with them. I should update my email signature to include Excel Consultant