Dashboards Archives - Excel TV
Excel TV
Share The LOVE

Category Archives for Dashboards

Sorting in Excel Dashboards

We all aware of harnessing the power of VBA to dynamically sort dashboards based on user input. But is there a simpler, more elegant solution? Yes, there is. And Excel MVP Jordan Goldmeier is here to solve this mystery for us. Let’s dive in! 1 – The Excel Dashboard Data The image below shows an […]

Continue reading

How To Fix Ugly Political Dashboards

It’s time to be brutal! And political-themed dashboards will take the brunt of it. With Szilvia facilitating the session, Jordan, Rick and our special guest Brad Edgar discuss the merits of various dashboard designs. Let’s get started! 1 – Readability Issues It’s easy to get carried away when it comes to designing dashboards. And this […]

Continue reading

Dynamic Labels – Excel Dashboards Tips

Many a times we want to include chart titles in our dashboards, but we don’t since they are not dynamic. If your user changes some filters, you would want your pivot chart titles to update automatically. Well, there is a way to actually do that, to make these chart labels truly dynamic. And Excel MVP […]

Continue reading

Excel Prevent Buttons, Shapes and Objects from Resizing – Excel Tricks

Are you fond of using Dashboards in Excel? I know you would say “Yes” and why not everyone likes it. It is one of the beautiful things that can be done using Excel. So, we would have many objects to make Dashboard looks pretty. In that, we would want to insert a header, new rows […]

Continue reading

Excel Requirements Gathering Process – Excel Dashboards

Excel consultants know that requirements gathering exercises can look deceptively simple. Whether that be for creating a dashboard for the client or an Excel application, there is always something in hindsight that one could have done better. Let’s not depend solely on our own mistakes to become better Excel consultants. Our in-house team of Excel […]

Continue reading

Michael Alexander – Bacon Bits Blog – Excel Expert Interviews

Excel MVP Michael Alexander of the Bacon Bits Blog at http://www.datapigtechnologies.com/blog/ discusses how his blog began and his work with Szilvia on the Excel themed cocktail book.   DataPig Blog Rick: Talk about DataPigTechnologies and your blog? Michael: Bacon Bits Blog is my blog I started in 2009 as a way to sell Boot Camp. […]

Continue reading

Auto Resizing an Excel Spreadsheet For Your Dashboard

Do you know that Excel allows us to zoom to a specified area in your work sheet? Yes, you heard it right. Suppose, you have an Excel sheet and while doing demo or so, you want to zoom to specified area, it can be done easily. Our very own Excel MVP Jordan Goldmeier lets us […]

Continue reading

Fixing Excel Dashboard Blunders – with Excel MVP Mynda Treacy

Mynda Treacy runs a successful online Excel Training program (at http://myonlinetraininghub.com ) with course topics ranging from Power Pivot to Excel Dashboard development. Mynda joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Microsoft Excel MVP Jordan Goldmeier to discuss Excel Dashboard Blunders and WWMD???  (What Would Mynda Do?) First, Excel […]

Continue reading

Dynamically Select Different Chart Types – Excel Dashboard Tips

Most of us employ Excel to analyze data in search of some insights. For us, this is an enjoyable step. The not-so-pleasing step is the one that follows data exploration: presenting our findings. It is not an easy job to decide which chart-type will depict our analysis in the best possible way to the end […]

Continue reading

Interactive Excel Dashboard Tips Using Slicers and Pivot Charts

We, as data analysts and Excel experts, are always trying to hunt down new and better techniques to create dashboards. Be it in terms of either design or interactivity, there is always something out there which will appeal to us. In the same vein, Excel MVP Mynda Treacy is here to show us some cool […]

Continue reading

Dashboard Rescue with Excel MVP Michael Alexander

  In this episode, Excel TV guest Excel MVP Michael Alexander joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Excel MVP Jordan Goldmeier in discussing the DO’s and DON’T’s of data visualization…..avoiding the dreaded ice cream sandwich syndrome! Data visualization can enhance the message you want your metrics to display […]

Continue reading

Using White Space In Excel Dashboards – Excel Tips

Whoever has been tasked with making a dashboard ever knows that there are three aspects to it: Business acumen: choosing which metrics are relevant to the problem at hand, amongst other things. Technical capability: working out the macros and complex functions to make sure the dashboard is user-friendly. Design element: ensuring that the numbers and […]

Continue reading

Dashboards For Excel Book – Jordan Goldmeier & Chandoo

Dashboards for Excel, written by two Excel MVPs, is all about teaching you how to build interactive and fast dashboards and data visualizations with Microsoft Excel! But more than that, the book is a journey into thinking about and using Excel differently to create robust data applications rivaling those of the big vendors. At a […]

Continue reading

How to Build Sparkline Charts in Excel – MS Excel Tutorials

Sparklines allow quick and easy visualization of data. These charts do not require you to go through the hassle of formatting chart axes. As shown in the picture on the right, Sparkline charts fit in a single cell. This allows for easy treatment and formatting, as will be explained below. They are also a cool […]

Continue reading

Guidelines for Creating Effective Dashboards – My First Presentation from PASS BA Conference 2015

First off, the PASS Business Analytics Conference 2015 was a blast.  Met a lot of great people.  I will dig into that further in another post. Beyond just being there, having a great time, and my Excel TV duties, I was also a speaker.  I spoke about larger strategic issues. I had two presentations. Here […]

Continue reading