 | |
| How to Create an Interactive Info Button - Ultimate Excel Dashboard Ep. 5 |
How to Create A Custom Interactive Info Button - Ultimate Excel Dashboard Ep. 5
In this Excel Tutorial you will learn how to create a custom interactive Info Button for our interactive Excel dashboard that allows us to display additional information without requiring any additional space in the dashboard.
You will not only learn how to create the required shapes and the necessary VBA code, but also learn about three different ways to this, going from ‘simple but not so scalable’ to ‘advanced and really scalable’. The previous four episodes we covered how to build the basic interactive Excel dashboard and had a detailed look into advanced background, gradient tile and pivot slicer designs. We also solved the challenge of automatically updating pivot tables and pivot charts when the source data changes.
The following Episodes will go deeper into the creation and integration of truly advanced features like fully functional dashboard tab functionality and a collapsable settings area with state-of-the-art radio buttons for dashboard color theme selection and modern toggle buttons to control the visibility of specific dashboard elements. 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.
Download Free:
Post a Comment