Navigation – XLCubed Blog ../../../ XLCubed Blog Tue, 07 Jun 2022 12:36:09 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Navigation – XLCubed Blog ../../../ 32 32 Dynamic Dashboards In Excel – Tutorial ../../../2019/06/dynamic-dashboards-in-excel-tutorial/ ../../../2019/06/dynamic-dashboards-in-excel-tutorial/#respond Thu, 06 Jun 2019 07:57:50 +0000 https://blog.xlcubed.com/?p=5204 In this post we will walk through how to use XLCubed’s dashboard sheets to create a responsive dashboard within Excel, that will work on any device! You can access the report here: Live web version Excel file (no data connection needed, but you will need XLCubed v9.2 installed) Create a dashboard sheet Add a dashboard sheet […]

The post Dynamic Dashboards In Excel – Tutorial appeared first on XLCubed Blog.

]]> ../../../2019/06/dynamic-dashboards-in-excel-tutorial/feed/ 0 Dashboard Designs: Responsive Navigation Bars ../../../2018/12/dashboard-designs-responsive-navigation-bars/ ../../../2018/12/dashboard-designs-responsive-navigation-bars/#comments Thu, 06 Dec 2018 08:56:10 +0000 https://blog.xlcubed.com/?p=4646 Many would believe that Excel is a static environment and not suited for making responsive mobile reports. XLCubed users know better. With XLCubed’s Dashboard Designer, it is possible to create dashboards that are not only interactive and data-connected, but also responsive to fit any device. If you are new to XLCubed Dashboards, read this article […]

The post Dashboard Designs: Responsive Navigation Bars appeared first on XLCubed Blog.

]]> ../../../2018/12/dashboard-designs-responsive-navigation-bars/feed/ 2 Using Slicers for Sheet Navigation ../../../2018/07/using-slicers-for-sheet-navigation/ ../../../2018/07/using-slicers-for-sheet-navigation/#respond Mon, 02 Jul 2018 14:03:03 +0000 https://blog.xlcubed.com/?p=4474 Slicers are normally used to change filter selections in a report, but a less well-known use is for report navigation, to allow users to jump to another location in the workbook. Here I have a report with several sheets. I would like to hide all the tabs at the bottom upon publishing and just have […]

The post Using Slicers for Sheet Navigation appeared first on XLCubed Blog.

]]> ../../../2018/07/using-slicers-for-sheet-navigation/feed/ 0 Icon-based Navigation and Filtering in XLCubed ../../../2017/08/icon-based-navigation-and-filtering-in-xlcubed/ ../../../2017/08/icon-based-navigation-and-filtering-in-xlcubed/#respond Tue, 01 Aug 2017 12:01:38 +0000 https://blog.xlcubed.com/?p=4365 Version 9 introduced an embedded icon library and XL3PictureLink, which together make the creation of icon-led navigation and filtering simple. XL3PictureLink provides the same parameterised navigation capabilities which the XL3Link() formula has done for years, but with an added visual aspect. Users can choose from one of the thousands of icons provided, in any colour, […]

The post Icon-based Navigation and Filtering in XLCubed appeared first on XLCubed Blog.

]]> ../../../2017/08/icon-based-navigation-and-filtering-in-xlcubed/feed/ 0