• leftzero@lemmy.dbzer0.com
    link
    fedilink
    arrow-up
    5
    ·
    3 hours ago

    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.

    • NewNewAugustEast@lemmy.zip
      link
      fedilink
      arrow-up
      1
      ·
      3 minutes ago

      Excel is like grind, grind, grind. You can level up a little and then it’s even more work.

      I like the sql better.