Re:How to win at the world championships of financial modeling
by r00f on Saturday January 08, 2022 @04:55AM
(#29850155)
Not sure what exactly you mean by scripting support. I used to know a girl who was working in big consultancy, and her team was making sales predictions for huge global brands, in Excel. She was writing some frightening amounts of code in Visual Basic, up to the point when I thought they used Excel just like a fancy IDE for their VB, which was the actual work. Who needs Excel formulas when you have VB, right?
It was very philosophical for me to hang out with her sometimes, because we liked to discuss our jobs and all that time she denied when I told her she was a programmer.
[ Parent
| on HN ]
Re:How to win at the world championships of financial modeling
by aspenmayer on Saturday January 08, 2022 @07:26AM
(#29851029)
Excel on the web has different scripting features and functionality than the desktop version, called Office Scripts, and Power Automate integrations. It also has something called Action Recorder, which seems like a native built-in AutoHotKey type deal.
https://docs.microsoft.com/en-us/office/dev/scripts/overview...