I watched one of these a few months ago - VBA was allowed, but the whole thing was very clearly about Excel specifically and all of the competitors came from the finance world. Honestly, I saw way less cool use of formulas than I was expecting - a ton of competitors had an approach of "make a big data table and use Goal Seek". Maybe the All-Star is different?
I work in finance, big spreadsheets. These guys are doing more puzzles that are easy to score. Its interesting but the guys who maintain very large dynamic models i find more impressive. Can your model survive the abuse of a 9 month m&a transaction?