• fartsparkles@lemmy.world
      70·
      2 months ago

      We need a /c/MuseumOfLemmy to preserve this treasure in so that it may be cherished and studied by our children and our children’s children and many generations beyond.

    • snooggums@lemmy.worldEnglish
      26·
      2 months ago

      Year 7: Your team leader is gone after you pointed out he fucked up one of your sheets that run the business by merging a cell.

      I am laughing about how after 7 years nobody has locked the sheets that run the business to avoid this specific thing.

      Or maybe they were kocked and the team leader unlocked it so they could break it without saving a backup.

    • feannag@sh.itjust.worksEnglish
      17·
      2 months ago

      There’s no way they’re using xlookup at year 7. You can pry my index match from my cold dead hands.

      • xpinchx@lemmy.world
        7·
        2 months ago

        Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works 😫

        • feannag@sh.itjust.worksEnglish
          6·
          2 months ago

          I should probably learn how BI works, but I’m mostly torturing excel to do things it was never intended to do.

          Also I do a lot of lookups and xlookup will slow my sheet down.

          • xpinchx@lemmy.world
            3·
            2 months ago

            Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)

    • mmddmm@lemm.ee
      16·
      2 months ago

      Why isn’t that “Merge Cells” button hidden behind 3 levels of menus up to this day?

    • BrowseMan@sh.itjust.works
      4·
      2 months ago

      Damn as somebody with very little coding or IT background whatsoever but had to learn excel on my last 5 year of work, I understood it all.

      Especially the cell merging… Spawn of the devil itself…

      Still power query is quite addictive, the main reason why moving to OpenOffice is hard.

    • ink1ing@lemmy.world
      2·
      2 months ago

      Just started a new job two weeks ago, all they use is Excel and Access. Now you’ve got me scared, first job out of uni and feels like a lot of pressure.

    • admin@sh.itjust.works
      5·
      2 months ago

      Generate localization strings in all requested languages with the “translate” macro without proof checking because you don’t speak Finnish or Japanese?

      • HexesofVexes@lemmy.world
        14·
        2 months ago

        Worse - pulling data from a web page, then using the power of pure jank to parse this input, and then invoking a sheet of reference string builders to construct formulae and execute them using too damn many @indirects nested into vlookups before finally adding in date aware data reveals, because no excel abomination is complete without trying to parse dates.

    • Anomalocaris@lemm.ee
      2·
      2 months ago

      i once used an excel sheet to emulated a von Newman architecture ALU+RAM

      fun and useless, but very (un)efficient way to calculate Fibonacci numbers

  • setVeryLoud(true);@lemmy.ca
    51·
    2 months ago

    Excel is a hammer.

    When holding a hammer, everything looks like a nail.

    Stop using Excel for anything more than simple data extraction and pivot tables, get a custom solution tailored to your needs rather than a monstrous Excel document that consumes 14 GB of RAM to run.

    • bfg9k@lemmy.world
      39·
      2 months ago

      We support a financial institution that uses ~30MB Excel sheets with thousands of calculations and they wonder why they can’t send it via email or why it has issues when 10 people edit it at once

      Just use a goddamn database

    • Randelung@lemmy.world
      10·
      2 months ago

      The bad thing is, they’ve attached a mediocre screwdriver to the hammer because everybody keeps using the hammer as a screwdriver. But now, everybody STILL uses the hammer as a screwdriver. The screwdriver part used to be a separate tool, but people didn’t know how to use it, and now they still don’t, even though it comes with instructions.

      They really should have kept things separate.

  • Deathray5@lemmynsfw.com
    22·
    2 months ago

    When I did first line IT support I really loved how it stopped automatically calculating formulas for everyone in HR at the same time

    • Onomatopoeia@lemmy.cafeEnglish
      10·
      2 months ago

      Create a table in Libre Office, I’ll wait…

      (Hint,the devs have flat out stated they will never add tables to Calc, as it’s wrong to do).

      99% of Excel usage includes a table in the first, or second, sheet. Without tables a spreadsheet app is useless, in my opinion, regardless of how “wrong” it is (and I agree that it’s wrong).

    • wise_pancake@lemmy.ca
      4·
      2 months ago

      It’s been a while since I’ve used it, how good is it compared to office and Google sheets now?

        • wise_pancake@lemmy.ca
          8·
          2 months ago

          I don’t know if that’s good or bad

          The only two innovations in spreadsheets in 20 years that I’ve liked are connecting them to databases directly (which still sucks) and being able to collaboratively edit them.

            • wise_pancake@lemmy.ca
              8·
              2 months ago

              100%.

              what the hell is going on with “Tables” vs filter views vs slices vs named ranges.

              That should all be one properly thought out feature. And tables are so fragile. Nobody knows how to use filters because they default to global. The row groupings feature is entirely broken and forgotten about… they recently updated the filter views UI to be fragile all e s as f throw error messages about whether you’ve saved the change or not (nobody ever cared about this, we’re just trying to filter without breaking the sheet)

              The little pills you get for validated entries are nice though, but even that has like 3 different versions and ways to do it.

              Then there’s things like checkboxes, I know there’s an option for it somewhere, but I have never once found the menu it lives in.

              Oh and the paste style menu item that tells you the shortcut but doesn’t copy stole for you. That is the most written by an engineer feature I’ve ever seen. “You’re doing it wrong, do it my way now or don’t do it all”.

    • Rhaedas@fedia.io
      32·
      2 months ago

      Not at all. You just haven’t gotten deep enough into the beast to see the horror.

      • PixelProf@lemmy.ca
        6·
        2 months ago

        But what about those of us in R1C1 mode using lambdas to do recursive cell operations across data pulled from multiple sheets? Am I anywhere near the kinda of Eldritch horrors discussed? I’ve also written indirect references based on Sheet name to populate filters from web scraped tables. I just don’t know how deep the pit goes at this point.

        • Rhaedas@fedia.io
          4·
          2 months ago

          I will give it to you, when it works, it does some magical stuff. But try designing such complex things that are miracles in coding and then it have to run on a half-ass computer. I want to say terminal, it’s not that, but it’s those small fake computers that companies seem to think are better to get than an actual desktop because they’re cheap. I know that’s hardware, not Excel, but Excel does not run well on that, so…

          Or worse, you get moved to 365 which doesn’t do most scripting and breaks all that was working. That cloud shit is a problem.

          • PixelProf@lemmy.ca
            2·
            2 months ago

            Oh yeah, the 365 version is terrible. And post of the time, it could have been a Python Gradio interface or similar simple implementation without having to fight so much to make basic things work. Most of what I want Excel to do it just isn’t efficient enough for; particularly with lets and lambdas, it’s gotten quite powerful as a programming paradigm where you can visualize and manipulate your data spatially in a kind of Logo / NetLogo style way which is really interesting, but the second you reference a few thousand cells a few times even a solid CPU starts screaming.

            I use Excel for a decent number of tasks and can do some magic with it, but only ever really for work where it’s easier to share a weird Excel sheet than it is to pass around a Python script (which given I teach Python, isn’t actually as often as most people experience).

    • AreaSIX @lemm.ee
      4·
      2 months ago

      I think it’s one of my all time favorites. I think people here live in the tech literate bubble who know how to use specialized software for the different things excel does, albeit clunkily. But average people are intimidated by those more advanced tools, and there are a lot of average people in decision making positions who benefit greatly from being able to use excel.

  • Bappity@lemmy.worldEnglish
    6·
    2 months ago

    I did a GCSE course on Excel, I learned to get irrationally angry every time a class was scheduled

  • qaz@lemmy.worldEnglish
    4·
    2 months ago

    I have been using Grist a lot and it has been working quite well. I don’t like Python that much, but it’s a lot better than the functions in Excell.

  • thatchemguy@sh.itjust.works
    3·
    2 months ago

    I got a job recently and they asked me if I know excel. I said yes, but I dont even know how to use formulas

    Pray for me 😭

    • lightnsfw@reddthat.com
      2·
      2 months ago

      Excel is one of the few things copilot has actually been able to help me with. Apparantly microsofts shitty programs understand each other.

      • freebee@sh.itjust.works
        1·
        2 months ago

        It’s a niche where AI helps because there’s just decades of so many forums and videos full of how to do stuff in excel and with AI you get the right answer quicker with less noise around it. I use ai assistance for excel formulas all the time, works pretty good for that.