Related Posts
How is SAP projects in IBM?
Can anyone please please refer me Gartner

Additional Posts in Data & Analytics Consultants
What is a data lake in basic terms?
today I choose violence

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




Use R or Python!
And use AI to generate the code for you - - ChatGPT and Github Copilot. It will have bugs but be better than you starting out. Get a proof of concept fast
Power query
Use a coding language. Build a template .py or .R file.
Python
If you’re stuck using excel for any particular reason, even upgrading to basic VBA would help.
If that’s the case I’m guessing you likely have significant efficiencies that could be gained by writing better code.
For example, are you:
-Avoiding using cell formulas via code
-Turning off screen calculations
-Ensuring automatic calculations are off
-Disabling events, animations, page breaks
-Turning on option explicit
-Using “for each” in place of indexed “for”
-Optimizing large memory tasks (e.g., bypassing the clipboard for copy paste, leveraging arrays)
-Minimizing the use of “select”
-Leveraging “with” when performing multiple actions on the same range
Some of these, particularly the first couple, can immediately cut your processing time by half or more.