Catherine France, Author at XLCubed Blog

Member Searching To Create A Product Details Page

Catherine France/ 27th March 201911th April 2019/ Dashboard Design, Reporting & Analytics

XLCubed is a great tool when it comes to member searching: it allows you to quickly and easily find members as well as dynamically update a report based on search parameters. Take a read of our last post to get started with this functionality.

The example in this post uses these searching methods to create a product search page. The left side provides search functionality for all the products contained in the cube, with a link to select the product which displays the full details on the right side.

Continue reading “Member Searching To Create A Product Details Page”

Common Row Highlighting

Catherine France/ 20th February 201931st May 2019/ Grid & Report Formatting

Last week’s post looked at the fundamentals of formatting XLCubed grids. A lot can be done with these techniques but sometimes more interactive formatting is desired. Within an XLCubed grid you can set Interaction Options to track which cell has been selected and output the selection and/or format it. In this post, we will look at how to apply this to highlight a row across multiple grids.

Continue reading “Common Row Highlighting”

Dashboard Designs: Dynamic Cards

Catherine France/ 31st January 201920th February 2019/ Dashboard Design

Dashboard cards are a great way to group related data and make key information more accessible. The flexibility of Excel and XLCubed means there are a number of ways you might choose the incorporate a card-based design into your dashboards. In this blog we will consider one way to do this using XLCubed dashboard sheets and paged viewports.

Continue reading “Dashboard Designs: Dynamic Cards”

Christmas Dashboard

Catherine France/ 18th December 201820th February 2019/ Dashboard Design

Ever wondered how Santa Claus keeps track of the North Pole’s toy production all year round? He uses XLCubed of course! Continue reading “Christmas Dashboard”

Dashboard Designs: Responsive Navigation Bars

Catherine France/ 6th December 201822nd February 2019/ Dashboard Design

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.

Continue reading “Dashboard Designs: Responsive Navigation Bars”