2024-12-25T11:52:30+0800

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 https://bit.ly/2QCjwXg 👍 Like 😀 Support me with your Amazon purchases https://amzn.to/2SJ0P5c 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 - https://www.youtube.com/watch?v=7CqWwbcOxk4 [Article] Microsoft, Using structured references with Excel tables - https://bit.ly/3Modt1t [Video] Kevin Stratvert, How To Build Interactive Dashboards - https://www.youtube.com/watch?v=MTlQvyNQ3PM [Article] The Spreadsheet Guru, How To Pull Cryptocurrency Prices In Excel - https://www.thespreadsheetguru.com/blog/cryptocurrency-prices-excel