Why Include Dynamic Links in Dashboards When I create dashboards, I like to add as many resources as possible for stakeholders who want more information. And it’s important to make your dashboards as self-sustaining as possible. If you have to be there to walk viewers through your dashboard, you’re going to run into issues because […]
Search Results for: excel
How To Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]
Measuring year-over-year growth in your analytics data is oftentimes much more important than month-over-month traffic trends, especially if your business is seasonal. But even for non-seasonal sites like yours truly’s, it’s good to get the 100-foot view of how your site is performing compared to the same time last year. Here’s an example of how […]
How To Create A Scrolling Table In Excel [VIDEO]
In today’s video I demonstrate how to create a scrolling table in Excel using the scrollbar option in your format controls. This is a great way to allow more data in a small space, such as a dashboard. You can see how this will look in the animated gif below: I use the INDEX function […]