> Anything important should not be done in Excel.
Hold on a second while I go shut down the global economy for two years so we can teach everyone finance person how to program.
Hold on a second while I go shut down the global economy for two years so we can teach everyone finance person how to program.
"The 7 Biggest Excel Mistakes of All Time"
https://www.teampay.co/insights/biggest-excel-mistakes-of-al...
"The financial fails and business risks of spreadsheets"
https://www.webexpenses.com/2020/10/financial-fails-business...
"Nightmare on spreadsheet: take Excel use seriously"
https://www.icaew.com/insights/viewpoints-on-the-news/2020/o...
"Excel – The Dirty Secret"
https://tax.thomsonreuters.co.uk/blog/excel-the-dirty-secret...
"8 Challenges When Using Excel For Accounting"
https://www.senacea.co.uk/post/excel-for-accounting-challeng...
https://theconversation.com/economists-an-excel-error-and-th...
Not that this is Excel's fault, but researchers should definitely either seriously learn how to use computer stuff, or just don't.
A person can't drive on the highway without a license, the same rigor should be applied here, especially in academic circles.
Regarding the graphing ability , R may have more power but plotting the graphs in Excel is so much more WYSIWYG.
Excel is the closest we’ve come as an industry to building a tool that enables non-programmers to program. If it disappeared tomorrow, as some arrogant posters apparently wish it would, tremendous value would be destroyed. Not just in terms of existing workflows but in terms of new workflows that would not be done in R but instead would be done by hand or not at all.