Pivot tables are quick. If used properly you can summarize data much quicker than any excel formula. When I use them it pretty much always takes under 30 seconds to get what I want. Imo, there are 2 things every user of excel should learn to use. Vlookup (edit: or xlookup, see below) and pivot tables. Once you learn to use both, you will use them all the time.
Anyone else constantly looking up tactics with AI? This game is so difficult, you have to memorize a lot of combos and the strategy to use them really takes time to click. I’m getting into this one again after a long hiatus
Pivot tables.
Excel is one of my favourite games, but I’ve never been able to completely grok those things.
They seem like a waste of time when it’s much easier to use formulas to construct indirect ranges and work on those.
Excel is like grind, grind, grind. You can level up a little and then it’s even more work. One column after another, then, row, row, row.
I like the sql better.
SQL is nice, but it gets a bit tricky once you get into recursive queries, especially when you’re trying to beat your fastest time record…
Pivot tables are quick. If used properly you can summarize data much quicker than any excel formula. When I use them it pretty much always takes under 30 seconds to get what I want. Imo, there are 2 things every user of excel should learn to use. Vlookup (edit: or xlookup, see below) and pivot tables. Once you learn to use both, you will use them all the time.
Anyone else constantly looking up tactics with AI? This game is so difficult, you have to memorize a lot of combos and the strategy to use them really takes time to click. I’m getting into this one again after a long hiatus