142
What's that video game boss you've never been able to beat, or took you the longest to beat? (sh.itjust.works)
submitted 4 months ago by to c/asklemmy@lemmy.world
232 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 21 points 4 months ago (9 children)

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.

  • permalink
  • fedilink
  • source
  • hideshow 9 child comments
    •
  • [–] 8 points 4 months ago* (1 child)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 3 points 4 months ago* (last edited 4 months ago) (4 children)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] 2 points 4 months ago (3 children)

    Vlookup

    Please use xlookup instead.

    Forget about lookup, vlookup, hlook-up or index(match()).

    Only use xlookup.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 3 child comments
    •
  • [–] 1 point 4 months ago* (2 children)

    No place I have ever worked has had a version of excel with xlookup, so I can't really comment on it. Im not on 365 or a newer desktop version. We are on Office 2019, as I suspect many offices still are.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 2 points 4 months ago

    Pivot tables are great because they force people to put their data into tables.

    Formulas suck. You only need sum. Everything is a sum, if you enter your data correctly in a table.

    Want to substract? yes, that is a sum in which one of the numbers are negative. Multiply? Yes that is more sums.

    What about IF statements then? No, no, no. Conditions are simply factors in a sumproduct.

    Learn the keyboard shortcut for sum. It's the straight edge and compass of excel math.

  • permalink
  • fedilink
  • source
  • parent
  • [–] -1 points 4 months ago

    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

  • permalink
  • fedilink
  • source
  • parent