In this Excel tutorial you will teach yourself how to load DeFi cryptocurrencies data into your spreadsheet. Also you will create pie of pie defi market share chart.
Defi in Excel
DeFi cryptocurrencies and decentralized finances become more and more popular. Let's analyze them with Excel then.
To load DeFi cryptocurrencies into your spreadsheet first you need data source. Find data under this link.
Go to ribbon Power Query tab and click From Web button.
Paste the url and click ok.
Defi spreadsheet
In the Navigator window choose what exactly needs to be loaded into your spreadsheet and click Load.
DeFi data has been pulled into your sheet. You may use it.
You may need to create a chart. I will prepare pie of pie chart based on loaded defi data. It will be DeFi market share chart.
To create DeFi chart highlight data you need and go to Insert tab and choose chart you like.
Chart needs some formatting which I prepared.
Here is how defi market capitalization pie of pie chart looks like. You can download it from here.
Further reading: Ethereum Network Difficulty Chart Bitcoin mining calculator Exploding out slices of a Pie Chart