• kaitco@lemmy.world
    link
    fedilink
    English
    arrow-up
    38
    ·
    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