I currently can do some script wrtiting in google sheets to automate some processes and am looking to get into the same in excel. However, I am unsure where to get started for this as there seems to be more than one way.

I have tried searching but since there appears to be several different methods, which has confused me slightly I am just wondering if anyone can point me in the correct direction to begin. Preferably a method similar to the scripts for google sheets, but open to whatever may come.