SAP, Oracle, & Microsoft. Every ERP have one thing in common - tables. Tables are easy to interpret and manipulable.
VBA allows automation across Microsoft Office applications even to run at specified times. Instead of bloated softwares and subscriptions, create just what is needed.
Most automation of Excel tasks are layers of simple functions (also known as nesting) following algebraic expressions.
All tasks should be copy & paste.
Use Hot Keys instead of moving arm between mouse and keyboard then clicking through options. Feels like gaming or playing piano on Excel.