(A) Introduction to Customizing Your Complete Cryptocurrency Excel Dashboard

A free video tutorial from Chris Haroun
CEO of Haroun MBA Degree Program®
Rating: 4.5 out of 5Instructor rating
69 courses
1,258,623 students
(A) Introduction to Customizing Your Complete Cryptocurrency Excel Dashboard

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:57:51 of on-demand video • Updated August 2022

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 wallet to exchanges to our thorough 49 step research process, to ICOs 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 used 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 with the Mac because you got to restart and parallels which is another product is not as good in my humble opinion as using VMware Fusion. Okay, 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 that 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 edit editor, 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 Let me just unhide it 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 Ethereum. And I had all of these road titles here. Here's the data and I color coded it just so I remember what I did and did not complete. And then what I did was I imported the data using array formulas and VLOOKUP, 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 cryptocurrencies, it's quite easy for you to do. And as you know, I futureproof this by adding these buttons here so that if I wanted to add more cryptocurrencies or wallets or exchanges in the future based on student demand, I could add them here. And you also notice that these were all hyperlinked enabled. So whenever I had a quote, you can click this and just go directly to the Wikipedia page for that person. And then the last thing 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 can be very small or way too big on their screen. And I found that using 75 or 100% was probably the best way to go. And then also, I showed how to hide this little guy here. It works the same on windows and windows. The buttons a little bit lower down. I'll show you right now. So windows you have to pin it and then yeah, the little button there claps, ribbons a little bit lower down. But I tested this completely on both operating systems and for those that didn't have Excel when I 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. Okay. And I'm going to wrap this up now, this introduction lesson and in the next couple of lessons, I'll explain exactly how I did all this. As always, if you have questions, please let me know. Thank you.