As announced earlier, here is the first one of our Master Classes. In this one, you will learn how to create advanced interactive charts in Excel by blending pivot tables, slicers, timelines, VBA, conditional formatting and charts. The final outcome is BEAUTIFUL!!!
Monthly Master Class – Episode 1 – Trailer
Check out a quick trailer of the Master Class episode 1.
Topics covered in this Master Class
- Inspiration for the interactive chart
- Calculation Engine
- User Interactivity thru Slicers, Timelines & VBA
- Design & formatting guidelines
- Cherries on top – Conditional formatting, additional info.
- What else can be done?
This Master Class use Excel 2013 features.
Purchase this Master Class
If you are ready to get the master class, use one of the below links to purchase. This episode is US $10.
Questions?
If you have any questions, please post a comment or email me at chandoo.d@gmail.com so that I can help you.
Enjoy the class.
36 Responses to “Advanced Interactive Charts using Excel [Master Class]”
Hi Chandoo, Beautiful chart there! I drew a similar Dashboard few days back, about a running challenge that took for 30 days.
http://www.goodly.co.in/30-day-challenge-dashboard/
Awesome as always!
What is the value of this above mentioned course in Indian currency. Please reply.
Hi Shantanu.
Thanks for your interest in this. There is no separate INR pricing for this program. When you pay for the class, your credit card / bank will charge you based on latest exchange rate for US $10.
Regarding your master classes, can a person pick and choose which topic(s) he would like to cover? I assume each of them will be $10. Thanks, Ed
Chandoo,
I purchased the video re All Versions of Truth, Interactive Charts in Excel, but I don't see the Excel files. How do I get access to the files?
Thanks,
George
I found the link. It's contained in the video.
Hi, I tried buying the first masterclass, however was not able to.
Hi Soni,
Have you used the other link?
https://gum.co/ZhdERn
Chandoo,
I suggest that you do not move the mouse around so much. It is distracting when trying to keep up with it.
Thank you for all that you do.
Bob
Thanks for the feedback. I will keep this in mind for future recordings 🙂
Is this class still of value if we are on Excel 2010? It's a corporate PC, so I have no control over what version I am given to use.
Yes it is, I'm using 2010. Only problem you cannot get that sexy timeline.
Yes, timelines are a new feature in 2013. I will cover techniques for implementing calendar / timeline selection in earlier versions of Excel in a future blog post (or master class).
Do you have alternate payment links for Indian customers ?
See my comments above. No, there is no alternative payment option (as yet). I am trying to get this added to YouTube paid content as well. If that happens, you can pay to YouTube (in INR, using standard Google Play store account).
Use this link to watch it thru YouTube Paid Content - https://youtu.be/DzaLKF_ObFo
(You can pay in INR)
Hi Chandoo,
Firstly, congratulations on commencing a very well needed series of classes which successfully summarises, and brings bang up to date, all that you have taught over the years.
Secondly, please can I say what a fantastic idea I think it is that you have serialised the training in such a way for USD10 each lesson with workbooks to generate a revenue stream. I sincerely hope it is successful and a model that you can replicate for intermediate levels also. The more successful you become, the more you give back by re-investing into Chandoo.org. I was asked only yesterday for EXCEL/VBA training resources. On recommending Chandoo.org paid courses I was told that 'formal', certified training was required! I fear it is a sign of 20th century management approaches within business that are holding progress back as 21 century training resources as professional and high quality as yours are not recognised as valid pathways to increased productivity and staff development. I should know, I started here in 2011 with nothing and am now a successful BI Developer on above market rate salary having only ever used Chandoo and Wiseowl(SQL) to train and develop core skills and concepts which I could then apply to professional BI products like SAP, Microstrategy, Sql Server Management Studio, etc.
I look forward to future lessons.
Kindest regards,
Leon-K
Incidentally, I am repeatedly asked at interviews how I maintain my market knowledge and BI modelling skillset. I reply with 'The Economist' subscription and Chandoo.org. I have enjoyed great success in my career thus far.
Thank you Leon for all your love and appreciation. Thank you so much for being awesome and learning 🙂
I am glad you like this new format. I am experimenting with this and will surely share my thoughts and stats at the end of Season 1.
Hi Chandoo
I purchased your first master class and just downloaded the video. However, the excel workbook is not available. Can you pls share the same on my mail id or send the download link
Thanks
Please watch the video. At the end of first few minutes, you will notice a link to the downloadable material.
had to uncheck the "Notify me of new post by email." Chandoo is so popular that my email box was flooded first thing this morning. Sorry buddy.
Chandoo Im from Brasil and im following your courses since chandoo site's had an other name and you had to change. Long time ago. My problema is the English. I have to go back the vídeos a lot of time to understand well. Do you think in put some legend in others language ? Thks a lot.
Hi Chandoo,
what an amazing piece of content.
The one thing that needs to be improved when purchasing via Vimeo is the download link from my POV. To show in a video is somewhat difficult to find. I skimmed through the video first and was not able to determine where the download files were.
Next time I will try Gumroad, maybe it's different there...
Keep rocking Excel (as always)!
best,
Phil
Thanks Phil for the love. I am glad you liked it. I will certainly make the download experience better in Episode 02 with a clear footer for first 5 minutes highlighting the download link.
is there subtitle in the vedio? I can't catch your english at all, sorry
Hi Liu.. Thanks for your interest in this. Sorry, but no sub-titles as yet. Depending on the volume of people purchasing the class, I may add transcript for the video during a later date.
It would be great that captions can be added to each class, just like the podcasts. It's a fantastic idea so anybody who does not speak English as a first language can follow all the content without getting lost.
Once I purchase a course, can i save the video on my pc as an mp4?
Hi Cele, Yes, you can save the download file as MP4.
Awesome as always Chandoo, I'm loving this new format of pay on demand. Have watched the first video, really well structured and informative ????
Hi Chandoo, this was a super course, 10/10 on awesomeness,
Can`t wait for other Masterly Classes goodies in the series.
Though we would have also appreciated , if you would have created the original dashboard "Global house prices interactive chart " from the Economist website with some mock up or source data.
Hi Chandoo;
Love your idea of this master classes. we don't all have the same needs!! 🙂
I'm in..
***********
Hi,
I have a excel report (mis) which I generate for my customer. I want this report to be made in such a manner that at a click of button any requirement is served and multiple parameters is served. How can I resolve my issue. If you are located in Mumbai I can come down with data or if something can be suggested.
Amit Gupta
9820027031
Is this still available? I bought episode one (the interactive charts with slider video) several years ago and absolutely loved it. Of course it was so long ago that I lost the video and all the files, but I want to buy it again. But it looks like the vimeo link is a 404 error.