This step by step tutorial shows you how to create a crypto portfolio dashboard in Excel. First, we enter your crypto purchase history. Then, we get price data for a portfolio of cryptocurrencies like bitcoin and ethereum. Then we apply formatting to increase the dashboard aesthetic and finish with how easy it is to refresh the crypto portfolio dashboard with the latest data and add new crypto currencies.
⌚️Timestamps
0:00 Intro
0:30 Crypto tickers
1:04 Purchase history
1:38 Excel table
2:00 Crypto prices
3:30 Sparklines (this section contains an error)
3:52 Dashboard formatting
6:02 New tickers
🔔 Subscribe [ Ссылка ]
👍 Like
😀 Support me with your Amazon purchases [ Ссылка ]
Purchasing through this affiliate link gives me a small commission to support my channel -- the price to you is the same.
📚 Content that influenced this video:
[Video]
Leila Gharani, Get Latest Stock Data in Excel & Create Your Own Stock Portfolio
- [ Ссылка ]
[Article] Microsoft, Using structured references with Excel tables - [ Ссылка ]
[Video] Kevin Stratvert, How To Build Interactive Dashboards - [ Ссылка ]
[Article] The Spreadsheet Guru, How To Pull Cryptocurrency Prices In Excel - [ Ссылка ]
