I convert cell equations to visual basic so that I don't screw up the cells and so I can share my results without giving away all my code.

There are also methods to animate simple graphics for the purpose of providing high level presentations.

I 'learnt to code' by recording macros and then reworking the syntax to suit my needs. After a while it becomes much less difficult than it appears at first. And I will admit my code isn't a model of perfection, but it gets the job done.