this post was submitted on 18 Jan 2025
380 points (98.5% liked)

Technology

60567 readers
3783 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] UnderpantsWeevil@lemmy.world 7 points 9 hours ago (1 children)

It's hard to believe, but I work at a Fortune 100 company that's still heavily reliant on Excel.

Sure, we have specific software as System of Record (Oracle suite, mainly). But for all the day to day estimating and calculating and reporting and other noodling, people routinely export to Excel and play with numbers from there.

[–] someguy3@lemmy.world 3 points 9 hours ago* (last edited 9 hours ago) (1 children)

The point is you can use google docs or Libreoffice for day to day mundane things.

It's only the huge power features that you need Excel for, maybe in engineering. For accounting when you get to that power feature point I'm surprised there isn't dedicated software.

[–] toddestan@lemmy.world 2 points 5 hours ago (1 children)

Excel is a spreadsheet, and spreadsheets like Excel are first and foremost aimed at accounting sort of tasks. Whether they actually need Excel versus something like Google Docs or Libreoffice is another thing. The big thing with Excel is that it gets used (and abused) to do things that it's not really intended for doing such as those spreadsheets that are full of macros trying to be an application, or those spreadsheets that are trying to be a database, and so forth.

From an engineering perspective, I find Excel to be annoying because it's clearly first and foremost an accounting tool, and some of its behaviors like the way it rounds numbers and tries to turn everything into a date is downright obnoxious. I still use it from time to time for quick and dirty things like whipping up a couple of plots quickly (and this doesn't really need Excel... but at work all the computers have Excel), but otherwise for anything more complicated I'd probably switch to something else.

[–] someguy3@lemmy.world 1 points 4 hours ago

Like it's a fun number cruncher, but for serious accounting that's tied into point of sale, accounts receivable, accounts payable, etc you really should be running something dedicated. That's why there are all these software companies making bank when from the outside you can't quite figure out what they do.

Protip on excel, when you start a new sheet ctrl+a, ctrl+1, change to number.