• Jo Miran@lemmy.ml
    link
    fedilink
    English
    arrow-up
    67
    ·
    1 year ago

    I will always appreciate a true Excel power user. I’ve seen some black magic shit.

    • deweydecibel@lemmy.world
      link
      fedilink
      English
      arrow-up
      28
      ·
      edit-2
      1 year ago

      When you know Excel really well, it’s like Legos for data. If you’ve got the imagination, intuition, and patience, you can make some incredible stuff.

    • Followupquestion@lemm.ee
      link
      fedilink
      English
      arrow-up
      14
      ·
      1 year ago

      Good Excel users think themselves better than a beginner. Great Excel users think themselves somewhere between Intermediate and Advanced. Excel Masters, and I know one who placed in that Excel data modeling competition, know they’re somewhere in the Intermediate to Advanced range.

    • jubilationtcornpone@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      Used for the right purposes, Excel is an extremely versatile and powerful piece of software. Is use it all the time for analyzing complex financial data and turning pivot tables into really nice looking reports. I can use VBA behind the scenes to change report scenarios while preserving the formatting. Excel is great for things like that.

      It’s easy to get Into trouble though because eventually someone decides to keep a bunch of auxiliary – yet somehow very important – data in a spreadsheet. Before you know it, multiple people are being asked to maintain said data and then POOF! You now have a spreadsheet functioning as a database. It’s all downhill from there.