• themeatbridge@lemmy.world
    link
    fedilink
    English
    arrow-up
    31
    arrow-down
    18
    ·
    1 year ago

    “Real analytical work” shouldn’t be done in spreadsheets at all. You should use a database. Basic spreadsheet features are all you should ever use spreadsheet software to do anyway.

    • kaitco@lemmy.world
      link
      fedilink
      English
      arrow-up
      39
      ·
      1 year ago

      While you will commonly hear that you shouldn’t use Excel as a database, it happens all the time.

      Excel is generally more accessible than something like Access or other proprietary database applications, and given that a lot of initial data originally lives in a spreadsheet, it’s the simplest solution that doesn’t require something like SQL coding knowledge to access.

      Basic spreadsheet features are all you should ever use spreadsheet software to do anyway.

      It depends on what you mean when you say “basic”. A spreadsheet with filters or maybe some pivot tables? A spreadsheet connecting to 12 others with refreshes created using VBA code so that end users just need to click a button and see their data? A spreadsheet that connects to a database, runs several queries, and spits out data in an easy to read form? There are folks who consider pivot tables and the use of any code to be “advanced” use of Excel. There are also folks who have made full-on applications with Excel and consider those to be made with only “intermediate” grade knowledge.

      I’ve found that the more you know about an application like Excel, the more you realize what you don’t know.

      • radix@lemmy.world
        link
        fedilink
        English
        arrow-up
        18
        arrow-down
        1
        ·
        1 year ago

        Excel does 1000 different things, and for 998 of them, there’s at least one better option.

        The two things Excel does best: 1) be accessible to everyone from the greenest high schooler to the most senior IT admin. 2) do those 1000 different things at least somewhat competently.

        • captainlezbian@lemmy.world
          link
          fedilink
          English
          arrow-up
          8
          ·
          1 year ago

          Exactly. Like personally I’d rather do libreoffice for data entry, spit out a csv, and slap that into an R based analyzer, that’s because I have an irrational hate for excel’s graphs compared to ggplot2. I do use excel a lot though in my job because fuck it it just works for basically everything

    • gcheliotis@lemmy.world
      link
      fedilink
      English
      arrow-up
      15
      ·
      1 year ago

      “Real analytical work” (I will take that to mean work people actually care about and may even pay good money for), is done with whatever does the job, on the given timeframe, and the analyst, researcher, or team are comfortable with. That may well be Excel. Or not. Depending on the task and people. But your audience will always care more for the appropriateness of your analytical approach for the given audience and task, and of course your results, rather than the tools you used to get there. Of course spreadsheets have limitations and one will do well to know them.

      • LogarithmicCamel@feddit.uk
        link
        fedilink
        English
        arrow-up
        2
        arrow-down
        1
        ·
        1 year ago

        I have already seen data having to be thrown away because the researcher copied and pasted it incorrectly from multiple spreadsheets and no one could tell what the correct data was anymore. No one should be doing this if they are responsibly doing “real analytical work”.

    • stifle867@programming.dev
      link
      fedilink
      English
      arrow-up
      6
      ·
      1 year ago

      As a user you don’t always have access to the database. It’s much easier to work out of Excel than to find the right person to ask in the corporate hierarchy just for them to say no.