How to Create Interactive Settings Menu in Excel | Ultimate Excel Dashboard Ep. 7

56,186
0
Published 2020-03-12
✅ GET CODE here ► excelfind.com/tutorials/ultimate-excel-dashboard-i…
📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft

▬▬▬▬▬▬▬▬▬▬

🔥BIG NEWS ► Launch of excelfind.com/ 🔥

I just launched my new Excel Resource Website and kindly invite you to check it out.
I put a lot of work and research into it to provide you with the biggest possible value!

Main Website ► excelfind.com/
Recommended Courses ► excelfind.com/courses
Tutorials ► excelfind.com/tutorials
Most Powerful Excel Add-ins ► excelfind.com/add-ins

And even better, I integrated the most up-to-date databases about all relevant functions, formulas, and shortcuts. You can use our advanced filtering system to filter by Relevance, Category and even minimum required Microsoft Office Version. That means you can learn about all new functions in Microsoft Office 365 with only one click!

Excel Functions ► excelfind.com/excel-functions
Excel Shortcuts ► excelfind.com/excel-shortcuts

If you like that website and want to help me grow, please consider to share it online and with everyone you know.
Thanks for your support!

▬▬▬▬▬▬▬▬▬▬

How to Create Interactive Settings Menu in Excel | Ultimate Excel Dashboard Ep. 7

In this Excel Tutorial you will learn how to create custom collapsable and interactive settings menu in Excel that can be perfectly used to control the visual appearance and behaviour of a dashboard. The settings menu includes fully functional and custom radio buttons to control the theme color of the dashboard with only one click. On top, it includes modern-design toggle buttons that allow to control the visibility and availability of certain dashboard features.

******** FULL TUTORIAL SERIES PLAYLIST ********
[Ep. 1] Basic Dashboard ►    • How to Create Impressive Interactive ...  
[Ep. 2] Background & Tile Design ►    • How to Create Beautiful Dashboard Bac...  
[Ep. 3] Modern Slicer Design ►    • How to Create A Modern Pivot Slicer D...  
[Ep. 4] Auto-Refresh Pivot Charts ►    • Auto-Refresh Pivot Tables and Pivot C...  
[Ep. 5] Interactive Info Button ►    • How to Create an Interactive Info But...  
[Ep. 6] Interactive Dashboard Tabs ►    • How to Create Interactive Dashboard T...  
[Ep. 7] Interactive Settings Menu ► You are here…


If you want to build this dashboard yourself, we recommend to upgrade your Excel Version to the latest one which is included in the Microsoft Office 365 Subscription. Find the link for current offers in the Microsoft Store below. ↓

▬▬▬▬▬▬▬▬▬▬

You want to become a master in Excel and learn all modern and relevant Excel techniques?
Then definitely have a look at the following links.

🚀 OUR EXCEL RESOURCE WEBSITE ► excelfind.com

💎 RECOMMENDED ONLINE EXCEL COURSES
GoSkills is our favourite & it’s not even close. Have a look ► bit.ly/30PWMnQ

📌 EXCEL VERSION IN THIS VIDEO
We use the latest version of Excel via the Microsoft Office 365 subscription. This allows us to have all the latest features like new chart types, a huge integrated icon library, improved functions, and much more!
If you want to upgrade your version as well, we recommend to get it from the
Office 365 (subscription based) ► geni.us/Office365_Microsoft
Office 2019 (standalone version) ► geni.us/Office2019_Microsoft

▬▬▬▬▬▬▬▬▬▬

You want to show your support and help me grow?
Here is what you can do.

🚀 SHARE MY NEW EXCEL WEBSITE ► excelfind.com

☕ WANT TO MAKE MY DAY?
Buy me a Coffee ► bit.ly/2Oqg6Cu

🔥 MORE AWESOME EXCEL AND POWERPOINT CONTENT
Subscribe ► bit.ly/37bcvAB


Note: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we will earn a commission if you click through and make a purchase. This supports the channel and allows us to continue to produce videos like this. Thank you for your support!

#interactive #excel #dashboard

All Comments (21)
  • This is awesome! I have learned so much from you in this series. I appreciate how well you communicate and simplify your explanations. Thank you so much for putting out such great content.
  • @jimfitch
    This is so good! Thank you. Can’t wait to put them into use, especially the settings menu.
  • @yellowlynx
    This is so breathtaking. I have to say the part is the cherry on top a cake.
  • @amitmittal2453
    Impressive work :) You demonstrated how we neglect the power of Excel and there so much we can do in it. Thanks for sharing it with us.
  • @rumblex118
    Thanks for these wonderful tutorials! All of this helps me tremendously when designing our reservation system. Thank you!
  • @adriaandj28
    This is so good! I learned a lot from the seven series. I programmed step by step and everything worked (after a few typos). I have now adjusted everything after my own data and everything works fine. keep doing The good work
  • @theofficelab
    Check out my new website excelfind.com/ for the Free Version of the Dashboard 🚀 ⬇ FULL TUTORIAL SERIES PLAYLIST [Ep. 1] Basic Dashboard ► https://youtu.be/cKkXtyjleX4 [Ep. 2] Background & Tile Design ► https://youtu.be/NfEqCdfl23k [Ep. 3] Modern Slicer Design ► https://youtu.be/CbDTFfoePZY [Ep. 4] Auto-Refresh Pivot Charts ► https://youtu.be/Xdq7SE-z-Aw [Ep. 5] Interactive Info Button ► https://youtu.be/RZW-vQRr0nY [Ep. 6] Interactive Dashboard Tabs ► https://youtu.be/2qN5jUiJWMY [Ep. 7] Interactive Settings Menu ► youtu.be/fCFGqj4QcJU
  • @coolkyle10101
    👏👏👏 This whole series was extremely helpful and very well done. Thank you!
  • 6 Views, 14 likes..! You have crashed YouTube my friend! Much awaited video post! 🤗
  • @premravii
    I have learned so so much in this series. Great skills!
  • @felipe4181
    I watched and did of this topics tutorials and they are simply amazing the way you describe every single step in detail!!! I also have mac and it was very difficult for me to set and work in excel in the mac version, it feels it is not the same but you have made me change that view. Can you make a video of the main differences between Mac and Windows versions?
  • @jntb3000
    Very good tutorial. Thanks for your work!
  • @MCSEknight
    Dude, this series is AWESOME! I learned so much and even created a dashboard for my organization to track authentication to my companies Domain Controllers. The Boss Loved It!!! We were quickly able to visualize which DC's were getting the most authentication traffic, and this gave us very clear ideas on where to add authentication traffic weight values to our domain in AD Sights and Services, where to load balance, etc. One thing I've been wondering: With as many excel slicers as is required for these complex dashboards - is there a way to clear all filters without having to click on each slicer filter icon? Just a quality of life question. Thanks for sharing these amazing tutorials!
  • @jithuiv
    Really Ultimate. Loved it. Thank you so much for sharing your knowledge. 😍😍😍💕
  • @A.K._47
    Just pure perfection !!!!! The best, you are simply the best!!!!!!
  • This series was absolutely perfect, thank you. These are perfect in my line of work and already created my own. What would the macro code be if I had 2 information icons? I've been trying for days and still can't get to the right code.
  • @peligrosini091
    You are an amazing inspiration for thousand of us. Really apareciate your work. Quick Q, can I replicate this un Office 2013?
  • @BezUmiaru
    Than was like watching a top rated movie! Awesome!