MS Excel complete roadmap with free resources

See there lot of content available on excel but few thing is missing in those content which really matter to as aspirant who want to be power bi developer or data analyst

1) what is require or what not in excel

2) How much excel should knowledge required

3) what is automation in excel

4) Dynamic Dashboard

5) How actually excel used in Corporate world for report/dashboard.

Lot of Point are still in my mind.. So if you really want to learn excel which help you to become data analyst... Lets connect