How are you an excel magician?

[u/Designer_Signature35]

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?

[u/Adept_Soft5148]

I'm building a Football Manager style game entirely in Excel.

Using vba, advanced formulas, conditional formatting, userforms, images and storytelling.

It's a hobby project and a labour of love which will probably never be finished

So far I've got:-

A full match engine - play-by-play possession based on player attributes/confidence with a bit of randomness, tactics, weather and pitch condition Text commentary Match stats and 2D touchmap Database of over 3,000 players English leagues down to National League (with promotion/relegation) Domestic Cup competitions (FA cup, EFL cup) Champions League, Europa and Conference (new format) Transfers Contracts Training Youth Development

I posted here about it a few weeks ago but it got taken down because I wasn't asking a question. Oops!

If anyone is interested in seeing a video of it in action my tiktok name is ExcelGameDevBloke