Using Excel Dashboards like a Pro

Listen to this article
From the Excel Toolkit:

Yes, that’s really Excel. It’s made using standard Excel features, no fancy draw- sways or custom coding. And you presumably formerly have 90 of the chops to do it.

A many times ago I started playing around with design functionality that people tend to overlook in the most popular spreadsheet tools Excel & Google wastes.

People tend to be trained to use spreadsheets in a way that only focuses on the grid layout. You learn to make tables and reports that look a bit like this

But Excel has nearly all the same design tools as a tool like PowerPoint. We’ve the option to use shapes, layers, custom textbook and indeed images for some reason we just do n’t do it.

If you just take the time to get creative and suppose through your design( just like you would when you make a PPT slide) you can make reports that are far more visually engaging and more perceptive.

People’s first response is generally “ Wow is that really Excel? I could noway do that, I ’m not advanced enough. ”

But the funny thing is that this is much easier than you would anticipate. You presumably formerly know how to use 90 of the features. You just need to try using them in a new way.

These exemplifications are made by layering shapes( under Insert> Shapes in Excel) and also layering on pivot maps and criteria .

This does n’t just make effects look great. It also allows us to make dynamic and filterable reports.

It opens up an entire realm of possibilities for spreadsheets that people generally would n’t indeed consider.

But why not just use a BI tool like Tableau or QlikSense? Well, it can be unexpectedly delicate to borrow a new tool if you work in a large association( due to compliance, cost, training, etc). But 99 of people have access to Excel and a introductory understanding of how it works. occasionally you need to work with what’s available to you. Excel is the perfect place to make out a prototype or v1 of a design.

From the Excel Toolkit:

till, also start by chancing a sample train and deconstructing it, If you want to start learning how to make this stuff. You ’ll snappily see how people have concentrated their shapes, made up their layouts and nominated theirvisualizations.However, also it wo n’t be hard to get up to speed on the design features, If you ’ve ever made up a donation slide.

Get started to receive free newsletters:

Buy Me a Coffee