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.
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.
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.
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.