@jim2007,
In my workplace, when I joined the team like 13 years ago, colleagues from backoffice/accounting were using excel extensively and were double-checking certain calculations by hand on calculator. It took me some time to convince them that most of the tedious work they were doing manually in excel and then check some of the calculations can be automated with VBA macros. Then they become best friends with macros and started to ask to automate more and more of their workflow. Then I started to replace VBA macros with python, big part of the information that was in Excel spreadsheets moved to database, link different databases we are using (e.g. report using information from both the accounting software and the software for the portfolio and also information from Bloomberg). Some of macros are still in use but most of them are migrated to python. Overall the workflow runs smooth, faster and the productivity is increased. This is not to say that excel/spreadsheets are obsolete or due to extinction, but their role is diminishing. The speed of the process will depend on many factors, but there is clear trend that programming skills (not only basic computer literacy like working with Office package) are part of the job requirements and listed in the job announcements. Of course I don't mean front-office clerks/tellers, servicing the clients.
Not to mention that (even without python) accounting is no longer dependent on excel that much - with the use of specialised accounting software, ERP systems, etc. Like the excel replaced the accounting calculators or financial calculators used for financial calculations it will be replaced sooner or later.
Because I also work as freelancer, my observations confirm that many projects/task that in the past would have been implemented/had a requirement to be implemented in excel, now require python or require to be implemented as web applications.
Like the old saying in the markets/invetsments goes - 'The trend is your friend', adapt, don't resist :-)
In my workplace, when I joined the team like 13 years ago, colleagues from backoffice/accounting were using excel extensively and were double-checking certain calculations by hand on calculator. It took me some time to convince them that most of the tedious work they were doing manually in excel and then check some of the calculations can be automated with VBA macros. Then they become best friends with macros and started to ask to automate more and more of their workflow. Then I started to replace VBA macros with python, big part of the information that was in Excel spreadsheets moved to database, link different databases we are using (e.g. report using information from both the accounting software and the software for the portfolio and also information from Bloomberg). Some of macros are still in use but most of them are migrated to python. Overall the workflow runs smooth, faster and the productivity is increased. This is not to say that excel/spreadsheets are obsolete or due to extinction, but their role is diminishing. The speed of the process will depend on many factors, but there is clear trend that programming skills (not only basic computer literacy like working with Office package) are part of the job requirements and listed in the job announcements. Of course I don't mean front-office clerks/tellers, servicing the clients.
Not to mention that (even without python) accounting is no longer dependent on excel that much - with the use of specialised accounting software, ERP systems, etc. Like the excel replaced the accounting calculators or financial calculators used for financial calculations it will be replaced sooner or later.
Because I also work as freelancer, my observations confirm that many projects/task that in the past would have been implemented/had a requirement to be implemented in excel, now require python or require to be implemented as web applications.
Like the old saying in the markets/invetsments goes - 'The trend is your friend', adapt, don't resist :-)
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs