Interactive Dashboards in Excel

Using the pioneer data analytics software

Jake Teo
Towards Data Science

This is a departure from the more development-centric posts I usually write. However, I had a recent privilege to team up with a family to up-skill their digital literacy & one of the topics we decided on is Excel.

I worked as a full-time data analyst for several years. This title has somewhat been diluted in recent years as many varying roles are required to process, obtain insights and present data. Even as a DevSecOps engineer today, I still have to do that to ensure all the systems I manage are working effectively & efficiently.

Excel is in my opinion, the pioneer, and most widely used data engineering & analytics software in the “non-tech” world. The data analytics & visualisation skills learnt here can easily translated to any domain, and any software as long as we develop strong fundamentals.

image from Unsplash, by Lukas Blazek

This tutorial was created using Mac Excel v16.77.1. There might be some small difference in functionalities & appearances from earlier or later versions.

Outcome

The outcome of this exercise is to produce an interactive dashboard identical to the one below. Cool, right?

Create an account to read the full story.

The author made this story available to Medium members only.
If you’re new to Medium, create a new account to read this story on us.

Or, continue in mobile web

Already have an account? Sign in

Responses (7)

Congrats, Jake, on being a TDS writer within your first month in Medium!

--

Very nice dashboard, thanks for sharing!

--

A comprehensive and well-structured tutorial on creating interactive dashboards in Excel. The step-by-step instructions, visuals, and explanations make it accessible for learners of varying skill levels. A valuable resource for anyone looking to enhance their data visualization skills. 📊📈👩‍💼

--