Hey list is huge, if you go step by step you will learn all,

First have command over vlookup..

https://office.microsoft.com/en-in/excel-help/vlookup-HP005209335.aspx

https://This one is quiet informative: https://chandoo.org/wp/tag/vlookup/

For macro you should be having basic programin knowledge:

https://www.xlpert.com/toc.htm#.UN6xtG-yCvw

https://www.excel-vba-easy.com/

Excel Dashboard : https://chandoo.org/wp/excel-dashboards/

Hope i am able to help you.

Thanks!!