How did you guys learn everything?

[Initial E]

I want to become very very knowledgeable in excel formulas and macros. I think I am very capable of calculating and performing most of the day to day type functions. However, I am weak when it comes to very complex and specific calculations. How did you guys become experts in everything that excel can do? What about macros?

Some advice would be appreciated to get me started.

 

[whitoulias]

I'm far from being an expert but besides reading which you must start immediately try making an excel with several basic codes

I have one with at least 30 basic-for me- codes such as
1.find last populated cell
2.find next empty column
3.Select specific range
4.Copy from to
and so on

Next thing i did was experiment on my own