Thanks a lot for this guide. It was very helpful for me.
One note:
I noticed that coinmarketcap switched from API version 1 to API version 2. Therefore, the prices are not automatically displayed in Excel Power Querry. You need to manually disyplay them in the "quotes" column.