How to create a Simple Dashboard Report in Microsoft Excel

Подписаться 150 тыс.

Просмотров 171 тыс.

50% 1

How to create a Sales Dashboard Report in Microsoft Excel.
Download Sales data for creating the Dashboard report and the completed Dashboard itself.
rzp.io/l/MRBDh7yLF8
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#dashboard #exceldashboard #advancedexceltraining

Опубликовано:

7 ноя 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 84

@mabob12 16 дней назад

One of the best tutorials in excel dashboard so far in RU-vid...

@Ajay.Joshua Месяц назад

Wow Crisp and clear 🎉

@jyotirmayadash2359 17 часов назад

Just fantastic

@emanuelmichael5295 5 месяцев назад

Many thanks Ajay for your simple elaboration on how to make dashboard 😊👏🤛

@jayabakshi4034 7 месяцев назад

This ine was really simple to understand. The dashboard looks beautiful too. Thank you . I am gonna try this one now😊

@BharadwajGiridhar Год назад

Very informative, thank you.

@nitinparkar Год назад

Very nice and simple presentation

@krunalzode5481 Месяц назад

Thank you Very easy to understand

@MohammadEkram-hm9ug Год назад

Thanks For Giving a demo for Practice

@Silent_2880 21 день назад

It is my first time, I found making dashboard so easy!☺️

@monaabdli7321 5 месяцев назад

thank you so much , it was great following your instructions

@SharonSmith 7 месяцев назад

So many helpful tips and techniques in this tutorial, Ajay! Thanks for sharing it 😉

@AjayAnandXLnCAD 7 месяцев назад

Glad to hear that Sharon :)

@maajiumarmustapha 5 месяцев назад

Great work, making work look easy. Thanks.

@suckymidicky123 Год назад

Very Nice presentation simple and easy to understand! Thank you so much Anand!

@user-nq2bg7xi3k 3 месяца назад

Very Easy and precise. Thanks a lot Sir

@simonlukwago8179 6 месяцев назад

Thanks for the great work, this was really helpful

@aparnakrishna5551 28 дней назад

Thank you so much sir!!! excellent and well simplified presentation sir !!!!

@abdiwaliyakub8396 29 дней назад

Great work, you made things easy for everyone to understand keep the good work.

@praveenbhojan5022 9 дней назад

This video made me think creating dashboards is very easy 😉 Thanks for Ajay 👏👏

@mariamagandi3777 5 месяцев назад

You're one of the best RU-vid tutors I have encountered. Very precise, you make it look simple. Thank you

@netsanetregassa7193 7 месяцев назад

Thank you so much its very helpful and easy to understand!! Thank again!!

@AjayAnandXLnCAD 7 месяцев назад

My pleasure :)

@DL12able 5 месяцев назад

Thank you Ajay, you don't know how it is helpfull a lot for me🙏

@Vijay-1694 Месяц назад

Useful and Thanks Ajay!

@jsandeep01 23 дня назад

Thanks a ton Ajay 😊

@ravindharm3760 Год назад

Great videos bro impressed

@prasuncdas Месяц назад

Excellent job 👍👍👍

@rickcambayajr4332 2 месяца назад

Thank you!

@santoshpoloju8003 Год назад

it is helping me in excel knowledge, thank you.

@rajput7452 21 день назад

THANK YOU VERY MUCH..

@pratikshahegde7248 2 месяца назад

Thankyou, grateful to have come across your video!

@MohammedKhaleel-ln9dq 2 месяца назад

Thanks Bro. ,You are the best

@gunjan4004 5 месяцев назад

Thanks a ton for such a brief and simple explanation

@AnkitRathore-et4py 11 дней назад

Awesome.. Very easy and helpfull

@deepakannan1988 3 месяца назад

Thanks a lot it was well explained

@rutendomunharira1867 3 месяца назад

Well simplified. You're the best Tutor I have encountered.

@ImaobongUdoh-zb9cy 26 дней назад

great work

@vishwareddy6129 10 месяцев назад

Good Explanation bro....

@phonenow Год назад

Most helpful video

@ravikumar-vz5eh 23 дня назад

super sir .thankyou

@muhammedmuhajireen722 4 месяца назад

Simplified yet it was a very clear and meaningful explanation within a short time. Excellent brother. Thanks

@eunicebaidoo8851 4 месяца назад

It really helpful 😊😊🎉

@gradimukwasa1386 Год назад

Bravo!!!

@kamisoodaargekumsa314 2 месяца назад

interesting session

@PradeepKumar-hd1ty Год назад

Great video for me..

@dinahany233 4 дня назад

thanks..

@sakshi966 Год назад

Very informative thank you ✨👍

@abmty3734 10 месяцев назад

Great one

@ranjitha.p7599 9 месяцев назад

Thank you

@Interestingboy642 7 месяцев назад

I really love your video, where were you Sir, I subscribed liked loved it

@Karansamal11 10 дней назад

dataset for sale..wah nice

@rashmithakare7224 День назад

Can u please share any full project for data visualisation with excel , sql

@amanbhargava2702 Год назад

Thanks

@Data_Mom Год назад

Hi Ajay, Few suggestions: 1) it's helpful to include currency in sales amount, this example refers to Sales amount in Rupees, so helpful to have Rs symbol in Sales Amount 2) We can add Slicer's Reporting Connection to 'Sales by Months' pivot chart as well. Let me know your thoughts

@shaikhyaseen8322 4 месяца назад

Go to the number you will get option in last line of the series where you can turn currency in to Rupees

@hemasrisai4547 2 месяца назад

Nice thnx u

@syedghouri3441 21 день назад

awesome

@brettmeadway43 5 месяцев назад

thank you

@asadpasha5554 Месяц назад

Dear thanks for a such informative video ,I just want to learn that , after calculating business growth in pivot table in % ,how can we add it in dashboard in form of % in graph or column..

@anbhuvenkat 15 дней назад

super tutorials video

@phandongexcel 4 месяца назад

I like this video and comment ❤❤❤❤

@chandbashask8275 Год назад

Thanks for the video i would like to suggest you one thing is that slicer is not connected monthly sales pivot chart /pivot table. Bye the way i follow your channel for excel. your explained as a pro faculty.

@koshalneupane6150 Месяц назад

Supper 🎉❤

@SweetestGhada 6 месяцев назад

Thank you very much ajad ...but plz can you explain how i can daily add new data and update my dashboard data daily ?

@deshan4018 6 месяцев назад

Hi, can the charts in the dashboard be imported to powerpoint? This includes the Slicer.

@rangaranga5427 4 месяца назад

@ajay I have separate small table categories. I want main table pivot slicer list to have this independent data. This is static list or table . Any idea how to?

@user-sv8wn7uc9i 2 месяца назад

Can we create 3 district pivot table and then use slicer

@gadilingappasirigeri758 4 месяца назад

very nice awsome... you explained whole concept in simple way....🍉🍌

@navarajam4866 Год назад

Sir please present latest style Updated Dashboards

@Interestingboy642 7 месяцев назад

After failing in phone interview, bec I never worked on Dashboard before in excel, interviewer asked, do u know dashboard, I told I have worked on Charts and Graphs in but not on Dashboard, then I searched on RU-vid your video, it's really amazing, after watching this video should I add Dashboard in my CV or not or still a lot to learn about Dashboard please guide

@ujaan3335 11 дней назад

Wow

@abhishekbhushan1052 3 месяца назад

My financial year is April to March. Then how to arrange my data Qtr wise in dash board. Please guide me.

@user-hg9jh6bz3p 8 месяцев назад

why month wise sales no connected?

@menaka.r2294 2 месяца назад

Can you send the source data

@deepanshikatiyar3854 Год назад

Couldn't update anything in the sheet pls share a downloadable form

@megharajput430 18 дней назад

Thanku sir... it's very helpful for me...I created my first dashboard..☺️👍

@rinagandhi5609 3 месяца назад

It's good but I wanted the recruitment dashboard

@Maria-ju3kf Год назад

Good video. I’m a beginner, can someone tell me the function to insert a date in excel, for example, I want to put in 1-1-2018 to December 2018 Thank you

@AjayAnandXLnCAD Год назад

Custom Formatting in Excel can be used for this requirement. Type in 1-1-2018 into a cell > Right-click on the cell > Format Cells > Select Custom from the Categories > type in mmmm yyyy into the input box under the label Type and click OK. The cell will display January 2018