(A) Introduction to Customizing Your Complete Cryptocurrency Excel Dashboard

Chris Haroun
A free video tutorial from Chris Haroun
Award Winning MBA Professor, Venture Capitalist and Author.
4.5 instructor rating • 54 courses • 1,099,348 students

Learn more from the full course

The Complete Cryptocurrency Course: More than 5 Courses in 1

Learn everything you need to know about cryptocurrency and blockchain, including investing, mining and much more!

23:53:08 of on-demand video • Updated July 2021

  • Upon completion of this course, students will be able to invest, mine, trade and thoroughly understand cryptocurrencies
  • Understand what makes a great cryptocurrency as a great long term investment
  • Understand what are the biggest mistakes new investors make in cryptocurrencies?
  • Know how to watch out for scams and managing risk
  • Learn tools to be able to identify the next great cryptocurrency (what to look for & watch out for)
  • Learn how to read charts
  • How to buy Bitcoin
  • How to mine Bitcoin
  • Understand the pros and cons of Bitcoin
  • How to buy Ethereum
  • How to mine Ethereum
  • Understand the pros and cons of Ethereum
  • How to buy Ripple
  • Understand the pros and cons of Ripple
  • How to buy Litecoin
  • How to mine Litecoin
  • Understand the pros and cons of Litecoin
  • How to buy Monero
  • How to mine Monero
  • Understand the pros and cons of Monero
  • How to buy Zcash
  • How to mine Zcash
  • Understand the pros and cons of Zcash
  • How to buy Dash
  • How to mine Dash
  • Understand the pros and cons of Dash
  • How to buy NEO
  • How to mine NEO
  • Understand the pros and cons of NEO
  • How to buy Cardano
  • Understand the pros and cons of Cardano
  • How to buy Stellar
  • Understand the pros and cons of Stellar
  • Know what makes a great cryptocurrency wallet
  • How to get QR Code Wallets + how to use them +how to transfer money out of them
  • Understand the pros and cons of QR Code Wallets
  • How to get USB Wallets + how to use them (Trezor, Ledger Nano S, DigitalBitBox & KeepKey) +how to transfer money out of them
  • Understand the pros and cons of USB Wallets (Trezor, Ledger Nano S, DigitalBitBox & KeepKey)
  • How to get a Coinbase wallet + how to use it +how to transfer money out of this wallet
  • Understand the pros and cons of Coinbase Wallets
  • How to get an Electrum Wallet + how to use it +how to transfer money out of this wallet
  • Understand the pros and cons of Electrum Wallets
  • How to get a Blockchain Wallet + how to use it +how to transfer money out of this wallet
  • Understand the pros and cons of Blockchain Wallets
  • Know what makes a great cryptocurrency exchange (what to look for from researching an exchange)
  • How to use GDAX ("Coinbase Pro")
  • Understand the pros and cons of GDAX ("Coinbase Pro")
  • How to use Poloniex
  • Understand the pros and cons of Poloniex
  • How to use Kraken
  • Understand the pros and cons of Kraken
  • How to use Bittrex
  • Understand the pros and cons of Bittrex
  • How to use Gemini
  • Understand the pros and cons of Gemini
  • How to use Binance
  • Understand the pros and cons of Binance
  • What makes a great ICO...meaning Initial Currency Offering (what to look for from researching an ICO)
  • What are many great cryptocurrency online resources and how to use them (if applicable)
  • How to create a diversified cryptocurrency portfolio
  • Understand what % of your net worth should you consider investing in cryptocurrencies?
  • ....and much much more....
English [Auto] We covered a lot of material from the basics of security to Wallace to exchanges, to our thorough forty nine step research process, to ISO's, to mining, as well as many other great resources. And then we finished up with an awesome portfolio management overview of the course. Now, the rest of the course is optional, but if you want to take this course to the next level and customize the entire Excel dashboard to fit your needs, then just please take these following lectures here. Thanks again. In the next few lessons, I'm going to show you how I created this complete cryptocurrency course dashboard, I made it work with the Mac version as well as the Windows version of Excel. And I use a product called VMware Fusion to test out over here in in the Windows version. I found that when you use boot camp, it's a pain in the neck with went with Mac because you got to restart and parallelize, which is another product is not as good, in my humble opinion, as using VMware Fusion. OK, so what I'll do in the next bunch of lessons is I'll go through every single tab. So you understand how I created this entire framework and I did it in a very simplistic way. So the space was quite small. I use very small images and I'll show you later how I did that and what you see here. These are not real buttons. This is just text or images with with hyperlinks installed. So I just right. Click and I said and edit or insert hyperlink, that sort of thing. And so before I wrap up this introductory lecture, what I want to do is show you some of the hidden tabs here, which I'll discuss throughout this this section here. So I've got one called Master Menu, which is where I threw in all of the hyperlinks. And a lot of the the logic behind some of the buttons in some of the 49 steps, then there's another one that was called unhide here. Research data array, and this was a massive document of just information that I used in the different cryptocurrency investment framework right up. So this one's for Bitcoin. This one's for a theory. And I had all of these road titles here. Here's the data and I color coded just so I remember what I did and did not complete. And then what I did was I imported the data using array formulas. If you look up, which I'll show you how to do soon. And the other one that's hidden is, is I just used it to get some other information or miscellaneous stuff in the course. So what I'll do is in the next couple of lessons, I'll go over how I created this entire document from scratch. And I'm doing this so that if you want to customize it for your own needs, for your own portfolio management or the way you approach analyzing crypto currencies, it's quite easy for you to do. And as you know, a future proof this by adding these buttons here so that if I want to add more cryptocurrency, their wallets are exchanged in the future based on student demand. I could add them here. And you also notice that these were all hyperlink enabled. So whenever I had a quote, you can click this and go directly to the Wikipedia page for that person. And then lastly, I'll talk about here quickly is. I created this button here to get more space because a lot of people, when they open up the dashboard for the first time, it could be very small, are way too big on their screen. And I found that using 75 or 100 percent was probably the best way to go and then also showed how to hide this little guy here. It works the same in windows and windows. The buttons a little bit lower down. I'll show you right now. So windows, you have to penetrate and then, yeah, the little button there collapsed ribbons a little bit lower down, but I tested this completely on both operating systems. And for those that didn't have Excel and they took the course, I included this here. And this is just a link to one PDF or one HTML page on my website. And I just did a print to a PDF for each one of these items here. So, for example, if I click here, you'll see that this is just the dashboard that you've seen before for Dash. OK, and I'm going to wrap this up now in this introduction lesson and in the next couple of lessons, I'll explain exactly how all this as always, if you have questions, please let me know. Thank you.