From Data to Dynamic Dashboard. Complete Course with Form Controls

In this Complete Course I create a powerful dynamic dashboard using Form Controls: Scroll Bar, Spin Buttons, Combo box.
You can Download the Exercise File by clicking on the link here below:

I start by creating a beautiful combination chart that shows few countries at a time
Population in column Chart and Density / Km2 as a line chart

With a scroll bar, I select different countries from a source list.

With a Spin Button I control the number of countries represented: I can show more or less

For the countries displayed I can get all information about a specific country by selecting an option from a combo box

That's only part of the magic
Because for any country I select I get a map and much more information below it and to add to the magic: the country' s flag.

Everything is totally dynamic
From Data to insights … All In One Dashboard with form controls
In Part one of this project we build a combination chart and switch the source data with a scroll bar and spin button.
You can download the exercise file and follow along by clicking on the link below the video.
You can read my Step by Step blog article with screenshots. It's a reference book for you to keep. I provided a link in the description below

In Part two
I extract information for any country on the chart using a combo box and a set of Functions

In Part Three
I create a dynamic Map and link it to the combo box and get additional information and the flag of the selected country.
Here is the Time Stamp to jump directly for a specific topic so you can resume your learning at any time:
Creating a Combo Chart 03:50
Creating The Scroll Bar 10:33
Creating the Spin Button 14:20
Creating Dynamic Text Boxes 18:40
Extracting the Records 25:00
Linking Controls To Chart 36:00
Creating The Combo Box 43:40
Creating a Dynamic record 45:40
Creating the Filled Map 51:04
Creating a Dynamic Chart Title 53:15
Extracting More Country Information 59:30
Getting the country's Flag 1:06:45

Let's build it from ground up in Excel

If you want to learn more Excel Tricks and become a Power User of Excel, subscribe to my blogs site

Follow me on Facebook:

Follow me on Twitter:
Subscribe to my YouTube Channel:

Find me on LinkedIn:
Finally, if you find value in this tutorial, give it a Thumbs Up, share the video and subscribe to be notified when new posts are released because
“The BEST is Yet To Come”

[hankgrimes]

ANOTHER homerun, Nabil! I can't wait to replicate this dashboard AND to create one of my own from personal data. You've given me SO many insights on how to accomplish a plethora of tasks! Thanks again.

[Normambo]

Great presentation and teachings Nabil! I'm an avid user of Excel and admit that you did a great job. I liked the non stop style of presentation. I'll be watching your other vids.
Normand from Montreal, Canada

[Luciano_mp]

Thank you for the excellent work you have done in teaching us Nabil! They are valuable teachings. Much Health, Peace and Thank You!

[SolomonKinyanjui_sk]

Wonderful tutorial. I have watched it for 1 hour 13 min and 32 seconds. I have gained a lot of knowledge, keep it up Professor Nabil.

[michelehlifestyle]

I am learning so much. Keep it up. You help a lot of people like me. Thank you.

[simplevlogs]

This is superb👏👏👏👏👏👏makes me clear on this topic

[samyraad]

That is very interesting, definitely will watch it again after work tonight.

[SyedMuzammilMahasanShahi]

An excellent work done. Thanks for share.

[venugopal]

Fabulous and attractive video Nabil sir.

[manishpanwar]

Thank sir for teaching us on interesting topic.🤝👍

[musariololade]

super interesting. Thanks for the knowledge sharing. I am an avid fan of you

[gaylonpeterson]

Enjoyed the course so much I created my own version of it. It does have one flaw though. In the flags portion the Name Manager changed the names of all the names of countries with two parts by inserting an under score _ in place of a space. Therefore the flags for two name countries display incorrect flags. I corrected my version of the course by changing all of the countries names to reflect an under score rather than a space and it worked great. Also the documentation has some incorrect cell references and is a little difficult to follow. Thanks for a wonderful program which is so informative.

[shajupaul]

Any tutorial from Mr. Nabeel M. will be EXCELLENT.

[felixmwinyella]

I tried to download the excel file but the link is not working. Can you please assist me with a link? Thank you.

[nadermounir]

Thank you Nabil for this amazing tutorial. It is very detailed and well explained; I used the Form control at work and was very helpful. Just one question: if new data are added, is there a way to make the scroll bar maximum limit dynamic?

[alexwilliams]

Hi there this looks amazing! Would it work on a MAC?

[saurabhsharma]

Very Nice Sir
Sir This one can be run on 2007 excel version ?
please reply

[hozkaras]

Thanks for works. Flag of Saudi Arabia did not work. Other flags are fine.