Skills & Tools required to Create Elegant Dashboards using Microsoft Excel

Skills & Tools required to Create Elegant Dashboards using Microsoft Excel

One of the most important skills that you need to learn to create an impact is to learn the art of developing appealing dashboards.

In a world, where automation is the main focus of every organization, Excel is still a valuable tool, particularly when it comes to taking the raw data, transforming it into useful and impactful information.

An Excel dashboard is made up of tables, charts, numbers, shapes and can be used in almost any industry depending upon its purpose. It keeps track of all the KPIs, metrics, and other data points and gives you a high level of work, helping you to make quick decisions and keeping everyone up to date.

Before building the dashboard, you need to keep a few things in mind and answer the following questions before even starting to open the excel sheet.

1-?????Why are you creating the dashboard?

2-?????What is the main purpose of the dashboard?

3-?????What KPI will it track?

4-?????Who will be the audience or who needs to see this dashboard?

5-?????Where will the data come from?

6-?????How up to date this dashboard needs to be? (weekly, monthly or real-time)

7-?????What will be the format of this dashboard? (static or dynamic)

Now there are a few tools to consider while designing dashboards:

1-?????Tables

2-?????Pivot Tables

3-?????Pivot Charts

4-?????Slicers

5-?????Vlookup Formula

6-?????Sparklines

7-?????Shapes

8-?????Textboxes

9-?????Text & Background Color

Now if you want to learn how to create amazing dashboards in Excel then here are a few youtube channel recommendations for you.

https://www.youtube.com/watch?v=K74_FNnlIF8

https://www.youtube.com/watch?v=cKkXtyjleX4

https://www.youtube.com/watch?v=2btS31AU3Iw

https://www.youtube.com/watch?v=psvtzudUO7s

https://www.youtube.com/watch?v=rsx43g7TBBs

https://www.youtube.com/watch?v=SwDZhhplaF4

https://www.youtube.com/watch?v=NZJXNw_rzTQ

https://www.youtube.com/watch?v=cObyWhe2wMw

https://www.youtube.com/watch?v=HjE4C4p7U2w

https://www.youtube.com/watch?v=djB1st-RnbQ

https://www.youtube.com/watch?v=kLN6nqt1b3Q

?Subscribe to?Career Tribe?Newsletter here if you want to learn the art of exploring your Dream Career, Digital Visibility, Grow Faster & Sell your Skills & Expertise using LinkedIn.

Click?here?to become part of the Career Growth Community & Get Access to 10+ Hours of LinkedIn Mastery courses & other resources.

Subscribe to my Youtube Channel:?Career Tribe by Ishtiaq Khan

Follow my hashtag:?#CareerTribe?(16 followers?+1 from You??) for more!!!

?

?

?

?

Faiza Tasneem(Associate CIPD)

Founder WIHP (Women in HR-Pakistan)| ClusterHead HRM OB| PhD Survivor??UPM| CIPD graduate | Conference Speaker| YouTuber | lets talk about Organization's Culture & Transformation| Connect with me for AI in HR discussions

3 å¹´
Bahader Iqbal

Driving Business Growth, Managing & Optimizing Portfolio Performance | Uni. of Southampton Alumni & E-Mentor | x-DHL | x-Careem

3 å¹´

Love this, shows how important soft skill development is.

Zahmoul El Mays

Attorney At Law at CIVIL COURT CASES

3 å¹´

Great

Ramisha Mujahid

Student Officer at Strathclyde Union | Co-Founder Holsol —Helped 50+ Professionals Build Authority with Personal Branding

3 å¹´

Thanks for sharing Muhammad Ishtiaq Khan

要查看或添加评论,请登录

Muhammad Ishtiaq Khan的更多文章

社区洞察

其他会员也浏览了