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