Create advanced Excel Charts in a single click with Pine BI

Pine BI is a premium Excel Add-In, which allows users to create advanced charts in a single click and to turn a standard workbook into a modern Dashboard.

Powerful. Dynamic. Beautiful.

Learn how to create dynamic controls for amazing Excel Dashboards 

In this video, we are going to show how to create and use dynamic controls, in order to make your Excel dashboards more flexible and engaging for your viewers, customers and colleagues. Dashboard controls are key, when it comes to creating a smart user interface. They should be simple, easy to use and understandable and should allow users to go through the different data, without having to scroll through larger worksheets and navigate through complex workbooks. 

 

The following controls are going to be used:

  • Pivot Table Slicers

  • Table Slicers

  • Dropdown Menu

  • Combo Box

  • List Box

  • Scroll Bar

  • Spin Button

  • Option Button

  • Check Box

All with dynamic conditional formatting. It is important to understand that these controls can be used without any coding, and that they are a standard Microsoft Excel feature. Although they may first seem intimidating to use, you will learn, that these controls are rather easy to understand, set up and use. When used correctly, they bring flexibility and engagement and will help improve your Excel reports and Dashboards.

You are welcome to follow along! No Macros or VBA are going to be needed, just Microsoft Excel 2010 or newer.

If you found this video useful, make sure to like it, share it and subscribe to our YouTube Channel! There, you'll find more free video tutorials.

Also, make sure to check out our Excel add-in Pine BI, which allows users to create advanced charts in seconds and help create dynamic Dashboards.

You can also review our Premium Templates, which are already set up and ready to use - all you need to do is just add your data!

The file used in the video above is available for free download. Just click on the button below:

Dashboard Tutorials

Chart Tutorials

Create Amazing Excel Dashboards with Pine BI

Pine BI is a premium Excel Add-In, which allows users to create advanced charts in a single click and to turn a standard workbook into a modern Dashboard.

Powerful. Dynamic. Beautiful.

Check out our Premium Templates

Copyright © 2018 - 2020 PINEXL Ltd.