Login to online classes

Video Tutorial on Interactive Dashboard using Hyperlinks

  • Last updated on July 26, 2011
Picture of Chandoo

Chandoo

Share

Facebook
Twitter
LinkedIn

Few days ago, we published an article on how to create interactive dashboards using hyperlinks. Many of you loved this tutorial. But quite a few of you also said, this tutorial is a bit complex to follow.

So, I made a short video explaining how the UDF and interactive hyperlinks work and how our dashboard is weaved together.

Watch Video Tutorial on Interactive Dashboard in Excel


Click here to watch the video on our YouTube Channel.

Download Example File used in the Video

Click here to download the example file & play with it. It contains additional example on hyperlinks to help you understand this better.

More Excel Video Tutorials

Every now and then, we post some videos explaining a topic / feature of Excel. Watch some of the recent videos by clicking thru below links:

Want more? Join Excel School

If you want more video tutorials and detailed explanation on Excel & its practical uses, then please consider joining my Excel School program. Click here to learn more about the program.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Want an AWESOME
Excel Class?

advanced-excel-dashboards-course-chandoo
Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst

FREE Goodies for you...

Excel formula list - 100+ examples and howto guide for you
100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks
13 Advanced Pivot Table Skills

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Get started with Power BI

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Related Tips

7 Responses to “CP014: How to create awesome dashboards – 10 step process for you”

  1. Paul says:
    July 20, 2014 at 2:37 pm

    Very interested in topic unfortunately I get no sound when I play it.

    Reply
  2. Budala Ebnezer says:
    July 25, 2014 at 4:42 am

    Where can I get add ins for excel 2007

    Reply
  3. Andy Serna says:
    July 25, 2014 at 7:48 pm

    I would like to join your email newsletter.

    Reply
  4. Shashank Verma says:
    February 25, 2015 at 5:53 am

    Hello Chandoo,
    i am one of the great fan of your. i am one MIS executive in realstate company.And i try make dash board for CRM(Client Relation Management) Dept formance and anlysis process.Its get created not so effective according to can u suggest me .what i hve to give or take for makeing it for effective and attractive?.

    regards,
    Shashak verma

    Reply
  5. Amit Kulkarni says:
    June 7, 2016 at 8:27 pm

    Hi,

    I want to create an interactive dashboard in excel (Google Drive) which should have multiple data along with beautiful charts..

    I handle two teams in IT Tech support so were preparing 2 different dashboards.. however need to club and want to create single report, can anyone help something like

    Reply

Leave a Reply