How to build an outstanding Excel dashboard

[@tanofreeborn994]

This Guy is spitting knowledge for free, I have learnt so much from just one video. Plus your explanantions are very easy to understand. Thank you so much.😘😘😘😘😘

[@b326yr]

Where's the completed workbook?

[@Zilole111]

Amazing tutorial, I badly needed this and I have never built a dashboard before. You are a life saver dude!

[@AnalyticsExtra]

Glad I could help!

[@harissiddiqui5857]

God bless you.. your explanation is very simple and easy.

[@rerrirukevwe3623]

The tutorial is so helpful and amazing

[@dwisdomwarrior]

sir, the excel am using dosnt have option to paste custome colors in it. so i had to select different color just to follow up your steps and i must say you re really a genius data analysis.

[@aishattola9068]

Thanks a lot for sharing this. You did a lot in the video starting from the ear soothing background music which made me enjoy every second of learning to the way you pointed out the littlest mistake one could make while replicating this. Learning to make to a dashboard was enjoyable thanks to you 👍

[@AnalyticsExtra]

Thanks you Aishat.

[@nuratbashiru815]

I can't even lie; this is the first time I'll complete a long yt video at once.

[@Ghost-qv4ev]

HI, I don't have (different from ) option here as to What I should do. ( 16:45) I am using Mac 2021 version.

[@aneruhassan8225]

God bless you, boss. I have created a dashboard using these datasets and the following procedures.

[@AnalyticsExtra]

Great 👍

[@stellaalonge7766]

Thank you for this video. Please, how do you select more than one box at a time?

[@juliusolasunkanmi]

Hold your control key

[@venkatsandeepsr]

How beautifully you have created it sir. It's really useful and looks attractive.

[@AnalyticsExtra]

Thank you! Cheers!

[@shahidhabib88]

Thank you. You did provide Dataset for this video. It would be very kind of you if you provide datasets for your other videos as well. It would be very helpful for learning and practice.

[@Uday_hada]

Thanks a lot. Respect🌷

[@mohammedalkaff7768]

Thank you very much. You did fantastic and helpful dashboard.

[@peace-is-happy7046]

Bro...Keep Going we always get caught up in different avenues and the MIND can't think and this really put a curve in the Market on these YT Videos....Preciate it....

[@AnalyticsExtra]

Thank you

[@akoladeolawale266]

Really Appreciate this breakdown, This was an Enjoyable Experience.

[@AnalyticsExtra]

Glad you enjoyed it!

[@sorosfox3801]

Great job! Keep them coming but please use a more calming background music so we can focus better on what you're saying. Thanks

[@bamisayebukola3613]

I really love this video..Very well understood! I learnt alot already Thank you so Much.God bless you for this💯

[@AnalyticsExtra]

Glad it was helpful!

[@sadiqrazaq6349]

Thank you for this insightful video. It is really helpful. God bless brother

[@njattemauricet4536]

God bless you, really insightful.... Thanks

[@AnalyticsExtra]

You are very welcome

[@dwisdomwarrior]

am having a little challenge after following the whole steps, i highted to save as picture but it didnt bring the option, if i may ask i thing you re using another version of excel, could you plese advise to install. am using 2019 version and some of the features you re using is not in it but i had to use itlike that and i got the whole steps right. thank you sir for the kowledge sharing.

[@akinwaleidayat4083]

Thanks a lot for this. Please, when I wanted to save the dashboard as a picture, after right clicking as you did, there is no 'save as picture' option from the drop down , please how else can I save it as picture? Thanks

[@phandongexcel]

I like this video ❤❤❤❤

[@aminullahIbrahim-hz9tu]

You can screenshot using your laptop

[@TophKhris]

there's no save as picture on my excel 😢😢

[@allikbdy467]

Thanks man! I learned a lot! Hope i will be able to my report like this.

[@AnalyticsExtra]

You can do it!

[@kardiiobi321]

Please how do I upload on LinkedIn please my dashboard

[@utsabsarkar4462]

Thank You so much😍

[@michaelinah6869]

God bless you for these insightful video Sir..Please i'll like you to suggest a site where we can have access to more data sets like dis for our personal practice.. Thank you Sir.

[@AnalyticsExtra]

You can try Kaggle

[@onifadeseun8698]

Pls sir is there a way I can import colors the way you did in this video,...on Excel version 2013

[@solomonikhuoria1526]

One way to go about it is to look at the colour ranges after he's pasted the colour codes. That way you can get the ranges for the three colours. This means that you have to pause the video at the point where he pastes the code. Umm... How about you update your Excel?

[@tastetemptations5193]

1;18 im not able to delete sum of profit option while making an chart at left side, Column Labels 2014 2015 2016 2017 Grand Total Sum of Profit 49,544 61,619 81,795 93,439 286,397

[@Elegance_26]

Hello, Thanks so much for your video. I just finished designing my dashboard and suddenly seeing “reference isn’t valid”😢 and I am submitting it for my assignment. pls help…

[@tosinilesanmi3778]

Has this been sorted now.

[@Elegance_26]

@@tosinilesanmi3778 yes, it has. I struggled it out through google. Thank you.

[@KeziaSpeaksHerMind]

Your dashboard is awesome, infact I learned a lot, however the color coding is not consistent and can be confusing. What I mean is that Sales and Profit bar colors shouldnt have the same color as the segment colors. It would make it confusing.

[@AyodeleOyerinde]

Someone should please help with 'preventing deletion of imputed data in excel sheet' (I want the user to impute data into excel sheet but shouldn't be able to delete or modify imputes

[@oluwapelumiolanrewaju]

you are invariably talking about data protection, right???

[@unsolve_writer1245]

Bro please create multiple pages power bi dashboard

[@abatanadeyinka1073]

Awesome, can't wait to do mine

[@NahidK.A-ff8yc]

Thanks🙏 it's very helpful

[@AnalyticsExtra]

Most welcome 😊

[@marryannenahuet4449]

Thanks Kevin that very helpfull

[@edwardditamey5879]

I love this i will try it

[@datalab365]

Good work.

[@vishwassehgal4758]

Amazing...Thank you so much... you saved my ass

[@adepojuadewale1550]

Thanks for this video. I tried it out. Please Sir, the point to safe the page as picture is not working on my excel 2016

[@AnalyticsExtra]

Yh, 2016 does not have the features. You can do a screenshot

[@adepojuadewale1550]

Thank you very much boss. I want to know the year of excel you use, so i can upgrade to such Sir.@@AnalyticsExtra

[@tiberiu3412]

Hey. What Microsoft Office do you use? I use 2019 version and I cannot insert the color code. I do not have the Hex option. Can you advise me what can I do? Thanks

[@AnalyticsExtra]

Please convert the Hex to RGB with google and use the RGB instead. I am currently using M365

[@boorayyan9]

Fantastic video

[@joyogingo7620]

the background music is very distracting just feedback

[@dwisdomwarrior]

it look like some of us re using different excel. i bearly get it

[@CelestinaRichard]

Thank you very much

[@VVM3388]

Thank you 🙏

[@emmavpgh]

this is super cool

[@epiemabricenjume3860]

This is wonderful. I will like a chat with you to discuss something nice for my company.

[@AnalyticsExtra]

You can reach out to me on LinkedIn

[@jadeamy6022]

thanks

[@chinuzoejima8971]

This was really helpful i was able to complete it but couldn’t save it didn’t see it on my excel I would really appreciate if you anybody can help me out

[@MEMELANDIA400]

awesome!

[@aimeenatya]

amazing!!

[@AnalyticsExtra]

Thanks!!

[@JúlioCésarNascimento-b3s]

outstanding hahahah thats great bro

[@kardiiobi321]

Secondly please next time reduce the background music please it's distracting

[@AlwinRoman]

Tyuo

[@keylanoslokj1806]

300ΜΒ file😂