Macro Tutorial in Excel

Question

Programming

Colleagues, please tell me some books/manuals/websites that you should start studying in order to learn how to write macros for data processing in Excel?

Answer 1

I sort of figured this out. way:
1. Set the macro recording.
2. Did a set of actions that were of interest to me (for example, draw a chart according to the data on the sheet).
3. I looked at the source code of the macro that excel generated.
I just had to write macros in the APL language, but there was no literature and this method worked fine.

Answer 2

There are a bunch of books about finance and Excel - there are formulas, macros, usually daughters - Excel is a mega-fat thing for analytics.