I love spreadsheets, all things Excel and excel automation. Are you using Excels power tools? (power query, power pivot and power view)
I have extensive knowledge of this, not long ago I did a video on connecting Excel to coinmarket cap for both live and historic data. you might find the video useful