Make an Interactive Excel Dashboard in Just 12 Minutes

Get the dataset here for free:
docs.google.co...
Build an Interactive Excel Dashboard in just 12 minutes. In this video, we will build an automated excel dashboard from scratch using the sample data provided below. First, we prepare the base of our dashboard by removing the gridlines and adding color on the entire sheet. Then we will outline the overall structure of the dashboard using shapes. Next, we will connect our metrics using text box, the formula bar, and the metric value on our pivot tables. After that, we will create charts as our visualizations - stacked column chart for Sales vs Target per month, smooth line chart for total customers per month, and bar chart for profit per region. Since our charts is based on Pivot Tables, by default, messy Field Buttons appear on our charts. We will also show how to remove these buttons. Then we will customize our dashboard and finally add slicers. The slicers make our dashboard automated by providing buttons that we can click to filter data at once.
📂 Online store (complete dashboard and templates files - edit and customize as you like!): idata-analytic...
iDATA Analytics Hub provides free tutorial videos for Data Visualization, Data Storytelling and Data Analytics.
EXCEL BEGINNERS LEVEL 1: • EXCEL TUTORIAL FOR BEG...
EXCEL BEGINNERS LEVEL 2: • EXCEL TUTORIAL FOR BEG...
EXCEL INTERMEDIATE LEVEL: • EXCEL FOR INTERMEDIATE...
EXCEL ADVANCED LEVEL: • EXCEL FOR ADVANCED USERS
TABLEAU BEGINNERS LEVEL: • Tableau

[@idata.analyticshub]

Hi everyone! This is for those who want the Pivot Tables. Since google drive turned the Pivot Tables into normal tables, we uploaded another copy of the Excel file here for only $1 (minimum price allowed). Free refund if Pivot Tables not available. Hope this helps! idata-analytics-hub-shop.fourthwall.com/products/excel-file-with-pivot-tables

[@carlocaranguian3761]

Thank you for this!

[@jayashankarhr]

Too Fast

[@idata.analyticshub]

Hi. Thank you for your feedback. If it helps, viewers find it helpful to slow down the video by using the gear button on the bottom right of the screen.

[@bkindtoall]

For those who are finding a few places hard to see exactly what's being clicked on or done, (as I did, lol) you can slow the vid down using the gear button on the bottom right of the screen. Click on Playback Speed and you'll have choices to slow it down at the hard-to-catch spots. That aside, first time watching a video on your channel. Super helpful, will be back. Cheers!

[@idata.analyticshub]

Thank you for sharing your tips to the community! We're glad you were able to create the dashboard. Congratulations!

[@jesusbvasquezq6597]

Simple, direct and rich in content as all tutorial should be. Thanks for sharing this great video!

[@idata.analyticshub]

Glad the video is helpful! Thank you also for taking the time to indicate what you particularly like about the tutorial. This helps us create more helpful tutorials. 💙

[@apoorvagala]

Loved the tutorial. Speed was normal and could be understood easily. I will surely try this. Thanks for sharing Ideas.

[@idata.analyticshub]

Thank you and we are so happy to hear that you like this tutorial. If you have any questions while trying this, feel free to let us know. We'll be glad to be of guide. :)

[@sranalyst26]

WOW! I've been looking for a tutorial and this is the BEST ONE out there. I finally able to create my own dashboard. Thank you!

[@idata.analyticshub]

Congrats on making a dashboard! We're glad to be of help. :)

[@sranalyst26]

@@idata.analyticshub can I send you my dashboard? I want to know your comments about it.

[@idata.analyticshub]

Sure! We'd love to see your dashboard and give our comments and recommendations. You can send over a screenshot to our email [e-mail]

[@datablitz125]

WOW! This is the best dashboard tutorial I have watched ❤

[@idata.analyticshub]

Comments like this really inspire us. Thank you! ❤️

[@smn2197]

This is the best dashboard tutorial I have ever seen. EVER. I was able to follow every step. Thank you!

[@idata.analyticshub]

We are glad to that the tutorial video is helpful for you. More tutorials in our channel :)

[@fianski]

A very clear guide for me. This is what i have been looking for -connecting several charts to the slicers date. Thank you so much!!

[@idata.analyticshub]

Hi! First, congratulations on successfully connecting several charts to a single slicer! 💯 reading comments like this really inspire us to create more tutorial videos. Thank you!!! ❤️

[@Norahvr]

This tool is extremely useful for many people , thanks for sharing knowledge

[@idata.analyticshub]

You're welcome! Just let me know if you have questions

[@shakrikle]

Really like it bcs it is simple and on point. Compared to the latest kind of dahsboard which includes query, power pivot etc.

[@zeeshanareef6904]

Very easy to understand steps to create a basic dashboard. Thank you 🤗❤️

[@idata.analyticshub]

Thank you! We're so glad that you find the video easy to understand, just like how we wanted it ♡

[@murulaelia2270]

Hi, very nice Excel tutorial, i was looking for a video that explain nicely how to pivot table and create dashboard, finally after watching this i managed to create my own excel dashboard

[@idata.analyticshub]

Hi! Thank you so much for sharing this. We are so happy to know that you have created your own excel dashboard and that our video is helpful. ❤️

[@mayaalw]

A very clear tutorial for me. Direct to the point. Thank you!

[@idata.analyticshub]

Glad the tutorial is clear. Thank you!

[@ayzellbala5308]

I learned and refer here alot! thanks!

[@idata.analyticshub]

That's so nice to hear. We're glad the video is helpful. Thank you! ❤️

[@4423PrachiIthape]

Thank you so much...I really Loved this video...to the point video thank you 🤗💕

[@idata.analyticshub]

Glad the video was helpful! This is really inspiring ❤️

[@sunnindawg]

Useful and fun to watch. The vid callouts and % done helped.

[@idata.analyticshub]

Glad the video is helpful and fun to watch. Thank you!

[@sumardjo]

thanks for sample file I can follow step by step your video thank you very much

[@idata.analyticshub]

Glad the sample file and video are helpful! If you have any questions, we'll be glad to help 💙

[@dirkstaszak4838]

Nice one, but one thing all of you should consider is a proper naming of the pivot tables 😊

[@idata.analyticshub]

That's correct. Thank you!

[@smn2197]

This is my favorite tutorial. Thank you!

[@idata.analyticshub]

Glad it is helpful! ❤️

[@almi3910]

Great presentation! Thank You😀👍

[@idata.analyticshub]

Glad the video is helpful! ❤️ if you have any question, just let us know and we'll be happy to assist 😀

[@amalmostafa724]

Thanks for sharing knowledge 🙏

[@idata.analyticshub]

Glad the video is helpful! 💙

[@katherinek9561]

Thanks for sharing this great video.

[@idata.analyticshub]

Glad the video helpful! 💙

[@MGA19a]

Nice one - small remark - for example slicer box was formatted from Jan - Sep - think of future use too - if this is going to be used for data of one year then format this immediately for Jan - Dec buttons and so on ;-) nothing is then more annoying when a new month is added and your dashboard formatting falls apart because of this (or you need to scroll around)

[@idata.analyticshub]

Thank you for sharing your insights to the community! It's definitely helpful to format the month slicer for one year. But if your data only contains a few months, you can still use a slicer. Then when you add more months to your data, the slicer would automatically update when you refresh. :)

[@talknow2859]

Gosh! Your video here is mind blowing...absolutely fantastic! 🎉👏👏👏👏👏

[@idata.analyticshub]

Thank you so much! I'm so glad you like the video 🥹❤️

[@johnsudhakarrandy7372]

Im working as a senior MIS Officer. In Sales Team it will Help me Lot ❤.

[@idata.analyticshub]

That's so great! Congratulations on your job as a Senior MIS Officer! Being a senior officer says a lot about your dedication and passion. We're glad to help and please feel free to let us know if you have any request and suggestions. ❤️

[@johnsudhakarrandy7372]

@@idata.analyticshub hey hi. My request is the same as how to make Last Month VS This Month comparing the report dashboard .

[@idata.analyticshub]

Hi! You may check out our latest video, we have charts to compare values this month vs last month vs last year: kzbin.info/www/bejne/Y6LXkKF8qsmEobssi=NcjR0_uR5edaQw3c

[@johnsudhakarrandy7372]

@@idata.analyticshub thanks 🙏👍

[@mianuuraini]

i'll try it! THANK YOU!

[@mohamedlebbai]

Very useful, thanks a lot

[@idata.analyticshub]

Glad the video is useful! If you have any question, we'll be glad to help :)

[@CMusica]

I will give it a try.

[@idata.analyticshub]

Best of luck!

[@arifbornal17]

Great 👍😊

[@idata.analyticshub]

Glad it helped! 💙

[@bounyoothammavong5712]

Great tutorial, Thank you 🤩

[@idata.analyticshub]

We're glad the tutorial is helpful! ❤️ If you have any questions, feel free to reach out. :)

[@smn2197]

This is really helpful. Thank you!

[@idata.analyticshub]

We are glad to know that. Thank you!

[@aalapvora6853]

❤absolutely brilliant video❤

[@mayaalw]

WOW! This is amazing!

[@idata.analyticshub]

Thank you! Hope it helps!

[@Vogelfrei-jb6hu]

Great content. Thanks a lot. But can you tell me how to avoid moving percentage labeling within the progress chart bar? Once I refresh the data the percentage is wanderung around.

[@idata.analyticshub]

Thank you! Glad you found our content great. To avoid moving the percentage labeling within the progress chart bar, you can change its properties. Below is a step by step guide on how to do this: 1. Right-click on the percentage label. 2. Select “Size and Properties”. 3. In the “Format Shape” dialog box, navigate to the “Properties” section. 4. Choose the option “Don’t move or size with cells”. 5. Click “Close” to apply the changes. By selecting this option, your percentage label will remain fixed in its position regardless of cell movement, resizing, or refreshing of data. Hope this helps!

[@Vogelfrei-jb6hu]

It works. Thanks a lot, again.

[@idata.analyticshub]

You're welcome! ❤️

[@Ahmad-yh7od]

Wonderful

[@idata.analyticshub]

Glad the video is helpful!

[@Quijanos1]

Wow! That was amazing!

[@idata.analyticshub]

Thank you for the kind words! Really appreciate it ❤️

[@xrfXRF]

The data you copy into your metrics, comming from columns D and E (headers profit, sales, customers), Is that a dynamic copy of your pivot tables in columns A and B? In other words.. do these values change along when you apply filters? And how did you manage to get those dynamically? My challenge is to keep data dynamically when chaning the pivot tables. Thanks in advance, hope my questions are clear.

[@idata.analyticshub]

Hi. Yes, your questions are clear. And yes, the metrics used in the video updates when you apply filters. The important step here is to use your pivot tables as a reference to make your metrics dynamic. Tip: Consider using the GETPIVOTDATA formula to reference specific cells within the pivot table. Hope this clears things up!

[@xrfXRF]

@@idata.analyticshub Thanks! I will look this up. If you refer to a cell in the pivot table, does this automatically refresh when you apply other things too in the pivot table (choosing from the list on the right)? (in other words, when the set-up of the pivot table changes due to adding more parameters for example). Anyway, thanks a lot for your response, this really helped to get further :D

[@idata.analyticshub]

Yes. When the pivot table changes (like adding parameters or applying filters), the metric also updates. You may also watch on the metrics part of the video how to properly connect it to pivot table. Hope this helps! :)

[@austinmarvellous2127]

I'm having problems with the doughnut chart to respond with the slicer

[@idata.analyticshub]

Hi. Make sure that the Slicer is connected to the source of doughnut chart. You can check this on Slicer Connections.

[@Raz-h4l]

Hi I was wondering if you can help me design a dashboard on monthly basis for a business presentation? Thanks

[@idata.analyticshub]

Hi. Yes, we accept dashboard projects. You can email your request at [e-mail]. :)

[@DecadentBehaviour]

I need Operational Efficiency KPIs ad 3 additional KPIs dashboard. Can you point out which one in your store ca be adapted to suit my needs?

[@idata.analyticshub]

Hi. The 'Dashboard FULL COPY' suits your needs. It has Sales, Profit, and & Number of Customers KPI. Additionally, it has Monthly Customers, Actual vs Target Sales, and Profit by Country. It already has Slicers or Filters as well. This is an adaptable file since it contains all the needed tabs: Dashboard Data Pivot Tables Contact Us

[@DtlaDaisy]

I love this asmr tutorial

[@idata.analyticshub]

Thank you so much! We're glad you love the video

[@coldsnow9284]

Great help.

[@idata.analyticshub]

We're glad you found the video helpful. Thank you for the kind words. We really appreciate it. 🖤

[@hazaraonlineeducation7517]

Really helpful

[@idata.analyticshub]

Thank you for the kind words! Really appreciate it 🫶

[@faulkma]

This is super, thank you. I have some newbie questions. How do you append the data table to see the changes when new data comes in? I’m assuming that you keep the pivot table the same for the dashboard? In other words, don’t change it or manipulate it

[@idata.analyticshub]

Hello! Nice to have you here. That's right, I keep the pivot table the same for the dashboard. I created pivot tables so that when new data is added, the dashboard automatically updates. Sharing a tutorial on Pivot Tables below. Hope this helps Pivot Tables in 2023: kzbin.info/www/bejne/p6K9nqqqbsqGo5osi=Ik1CoZINHB8BIMiLHope this helps.

[@RKsanskrit007]

hello sr, can u make a video to how to make povit table like u did for sales, customers, sales, competition, etc

[@idata.analyticshub]

Hi. Here's our tutorial video on how to make pivot table: kzbin.info/www/bejne/p6K9nqqqbsqGo5osi=ii_nEdO1DX3dhxdM

[@Natasha-je4be]

Which version of excel are you using?

[@idata.analyticshub]

The latest one.

[@hudamuhammed8552]

In Metrics couldn't add formula = its disabled by defaul, any solution?

[@idata.analyticshub]

Hi. To fix the problem, you can try the following steps: 1. Select the text box where you want to put the metric. 2. In the formula bar, type the formula =. 3. Press Enter on your keyboard to apply the formula. This should resolve the issue. Hope this helps!

[@AdnanLocationlab]

great

[@ahmedzain2783]

Thanks!

[@idata.analyticshub]

Omg thank you so much for the Super Thanks sir!!! It really means a lot to us 🙏❤️❤️❤️

[@DerevalareAlakiassetDereval]

Dereval are a laki asset Dereval bawer full

[@johnsudhakarrandy7372]

Im your new subscriber ❤

[@idata.analyticshub]

Thank you! We really appreciate it ❤️ more videos like this coming soon

[@tpkchannel4001]

Thank you😮😮

[@idata.analyticshub]

You're welcome! 😊

[@stefanstroie]

The percentage numbers from sales profit and number of customers keep changing position whenever I use the slicers. Can someone explain to me how can i prevent that. And how can i return to the overall view after using the slicers? Thank you!

[@idata.analyticshub]

Hi. Hope this helps! kzbin.info/www/bejne/anayipuslsZkbNEsi=81gJepPYfe7zqy4U

[@goutamnayak5011]

Sir please clear my doubt Copilot 365 soon available in Excel & other ai tools are there So is it still important to learn ms Excel deeply all functions and advance formulas??

[@idata.analyticshub]

Hello! This is a very excellent question. We are now approaching the era of AI and while most of us are thrilled with the advancements that come with AI, some people have a valid concern of getting replaced by AI. AI tools are based and trained on data that was originally created by humans. So while AI can automate certain tasks, it cannot replace humans. It simply does not have the human intelligence, creativity, and social understanding. So to answer your question directly, yes it is still relevant to learn Excel. Even more important now more than ever to learn Excel deeply, to be be able to control, maintain, and update AI tools.

[@kwab6689]

Hi! Awesome vid. When you're adding your metrics, how did you create the table that referenced your grand total of sales? I'm having problems trying to formulate it without getting incorrect info when I try to filter and the pivot shrinks. Thanks

[@idata.analyticshub]

Hi! I created a normal table (not pivot or anything). Then on one cell on the table, I put "=" then selected the total sales (pivot table). Hope this helps!

[@idata.analyticshub]

I think what happened is you put the formula "=A2", for example. It should be "=GETPIVOTDATA()"

[@kgomotsodiale7355]

Thnak You

[@idata.analyticshub]

You're welcome! Hope the video is helpful

[@jayjoe5160]

so it is must to have pivot tables

[@idata.analyticshub]

Yes! The file already contains the needed pivot tables. :)

[@abdulrahmanoubari765]

What is the meaning of sales completion and incompletion?

[@mayaalw]

I had the same question at first. I think it's how close to the target sales

[@4423PrachiIthape]

Please tell us how to make that original table with percentage of sales and profit

[@idata.analyticshub]

Hi. It's a pivot table using the Sales and Profit field. When you use Sales in the pivot table, the default function is SUM of Sales. Just changed it to AVERAGE of Sales. Same thing with Profit. Hope this helps!

[@360Degrees]

can you please explain the last step "Slicer"?

[@idata.analyticshub]

Certainly! In the last step, I created Slicers that would interactively filter data in my dashboard. First, I clicked anywhere in the PivotTable where I want to create a slicer. Then, I went to "PivotTable Analyze" tab. Then I clicked "Insert Slicer". A dialog box appeared and I just selected the checkbox for the fields that I want to create slicers for. Then I clicked "OK" and the slicers for each selected field appeared. Hope this helps!

[@BharathK-um4sl]

Hi i have one concern, this dashboard have to build every time? Like when we change some data in data sheet. It has to change right?.

[@idata.analyticshub]

Hi. Yes, when you change data in data sheet, the dashboard should automatically update. No need to build the dashboard every time. :)

[@KoinPeraks]

thanks bro

[@idata.analyticshub]

Happy to help bro. Feel free to let us know if you have questions

[@KoinPeraks]

@@idata.analyticshub thanks, i doesnt have any question

[@trading_addiction]

How to connect yearly and monthly slicer together???

[@idata.analyticshub]

To connect slicers together, you can use the “Report Connections” feature. First, select the slicer you want to connect to multiple pivot tables. Then, activate the “Slicer” tab and click on the “Report Connections” icon in the Slicer group. In the “Report Connections” dialog box, select all the pivot tables that you want to connect with the selected slicer. Finally, press OK to complete the connection. Do these steps to both Yearly and Monthly slicers. I hope this helps!

[@jadad1010]

How can I make the bar graph into a stacked bar of two countries sales totals. For example, if I sorted to Peru & columbia... and wanted to show each part of the bar as Peru + Columbia sales

[@idata.analyticshub]

Hi! To make the bar graph to a stacked bar, you can follow these steps: 1. Select the data range that you want to use for your chart. 2. Go to the Insert tab in the Excel ribbon. 3. Click on the Bar Chart button in the Charts group. 4. Choose the Stacked Bar option. Hope this helps!

[@ahmedzain2783]

I need this with full disborad

[@idata.analyticshub]

Hello! Sharing our full dashboard course. Hope this helps: kzbin.info/www/bejne/sJyTkICLqqijj9ksi=9jRLa92javuXfOzp

[@redquartz2229]

I dint have the data thing tab, did y’all find it

[@idata.analyticshub]

Hi. What tabs do you see?

[@MrJethivikas]

your data set is without Dashboard, Slicer and pivots.. kindly share the full dashboard as you explained in Video.. thanks in advance

[@idata.analyticshub]

Hi. The dataset was shared to help you practice creating your dashboard through the guidance of the video. Hence, there's no readily made dashboard. You may use the dataset and follow the steps as explained in the video. Please let us know if we can help you with anything more :)

[@myfuture1164]

"Supper se Upper"

[@idata.analyticshub]

Thank you!

[@TheDrSimus]

nice!

[@idata.analyticshub]

Thanks dude!

[@365dFACTS]

Why I can't put the matrix in text box

[@idata.analyticshub]

Hi. Have you tried using the formula bar? You can click the text box first, then place the formula for matrix inside the formula bar.

[@kitjipong5081]

how can you put formula inside a text box?

[@idata.analyticshub]

To put a formula inside a text box, you can follow these steps: 1. Create a text box. 2. Click inside the text box and then click inside the formula bar. 3. Type ‘=’ and click on the cell which contains the value that you want to show. In this video, we clicked on the cell on the pivot table. 4. Press ENTER button. I hope this helps! Let me know if you have any other questions.

[@analyticshub9615]

What software did you use to edit this video please?

[@idata.analyticshub]

Hi. I mainly use canva.

[@fengy23]

How do you get the Sales Figures into the text box? I can't seem to put them in there due to it being a shape / text box gives me this formula is missing a range or a defined name error

[@idata.analyticshub]

Hi! The error "this formula is missing a range or a defined name error" means that the text box can't read the number inside a pivot table. To fix this, what I did is that I put the number in a normal cell. Then I pointed my text box to that cell. Hope it helps!

[@olypower1337]

But if you do it that way you have to manually change that position for every month and the slicer loses its point ?@@idata.analyticshub

[@anjanbin-bb3ud]

Excuse me, can you example (Overview, data, and Pivot Tables)? ( Details )

[@idata.analyticshub]

Hi! Sure, we would love to create a detailed tutorial on overview, data, and Pivot Tables on our next video. While waiting, do you have any specific parts that you'd like to see on our tutorial? Perhaps how to clean data?

[@shrikanthpc2719]

​@@idata.analyticshubplease share details on pivot analyze tab about how to do it and how to enable it.

[@deedeeakk2050]

how can I customize the structure ? if I want to use it for defect inventory as per week and month ?

[@idata.analyticshub]

Hi. You can add a weekly and monthly inventory chart. The video shows how to create a monthly chart. For the weekly chart, you can follow the same steps but use the "Week" field instead of "Month".

[@deedeeakk2050]

@idata.analyticshub and the sales with defects and customers with the products, correct?

[@idata.analyticshub]

Yes that's correct. It would also be helpful if you have the specific type of defect on your data. And you can show it in the dashboard as well to highlight what is the most common defect.

[@deedeeakk2050]

@@idata.analyticshub thank you so much

[@idata.analyticshub]

You're welcome! You're dashboard seems to be very interesting. If you have data for the location/source of the defects, that would also be very helpful to show in the dashboard. That way your superiors would be able to be informed which location/source needed help.

[@mohanraj-qg7nr]

Demo is very fast. Nothing can be understand

[@idata.analyticshub]

Thank you for sharing your insight. This is noted.

[@coldsnow9284]

Play the video in slow motion bro. I think it will help you.😊

[@idata.analyticshub]

Thank you so much for sharing this amazing tip! 😊

[@nmcflims7421]

Hello how to make trading journal forex trading long short lot pair profit or loss and feedback 😢😢😢

[@idata.analyticshub]

Hi! Would you mind sharing what charts or visualizations are you looking for in this trading journal?

[@nmcflims7421]

@@idata.analyticshub like tradezella

[@idata.analyticshub]

What is that?

[@sleep.study.relaxwithnatur1996]

got it right , but in the end you left out a lot so I struggled , felt like i waisted my time

[@Exam_Solution_07]

I'm unable to use slicer 😢

[@idata.analyticshub]

Hello! I'd be happy to guide you. How did you try to use a slicer? :)

[@jadenhaan]

Hey you, mr. Hurricane, 12 minutes is the duration of your hi-speed video. But, i'm trying. Thanks

[@idata.analyticshub]

Hi. Apologies for the inconvenience. Here are some best practices from people who watch this video: 1. Try turning down the Playback Speed in the settings 2. Pause or go back to parts that are not clear We hope you'd be able to succeed on creating the dashboard!

[@shrikanthpc2719]

Which version is this excel?? Please reply

[@idata.analyticshub]

Hi! We're using the latest version

[@shrikanthpc2719]

@@idata.analyticshub is this the paid one??

[@idata.analyticshub]

Hi. It's the free one

[@shrikanthpc2719]

@@idata.analyticshub actually I have 2010 ,, I am not finding some of the vlookup featured so asking ,, not finding combined option in in it ,, please show us

[@krishnachand255]

A kind of Power BI solution but pls explain what you do, music will not teach

[@idata.analyticshub]

Thank you for sharing your suggestions. We appreciate all suggestions to help us create better and more helpful tutorials.

[@AbdulbastHawar]

where can i get the file?

[@idata.analyticshub]

Hi. You can get the file on the description box :)

[@KO-nn1vm]

Too much music no good

[@miguel.arancibia.h]

sin las opciones de "pivot" no funciona.

[@idata.analyticshub]

Hi. Kindly translate to english so we can assist you properly. :)

[@idata.analyticshub]

Hi everyone! This is for those who want the Pivot Tables. Since google drive turned the Pivot Tables into normal tables, we uploaded another copy of the Excel file here for only $1 (minimum price allowed). Free refund if Pivot Tables not available. Hope this helps! idata-analytics-hub-shop.fourthwall.com/products/excel-file-with-pivot-tables

[@thefinaldestination-japan]

You tube par jyda beginners hi video dekhte hai agar unko hi na samjh aaye to fayda kya banake video

[@idata.analyticshub]

In english please

[@TeshomeTamiru-zw1qe]

How I can download?

[@idata.analyticshub]

Hi! You can download it here: docs.google.com/spreadsheets/d/1M9cfsruhA3gsK6nv2fn5FQuNrdorPI-m/edit?usp=sharing&ouid=117553288234376939891&rtpof=true&sd=true

[@idata.analyticshub]

Select Download under File option :)

[@crazyfirefly5735]

What's with this background music¿

[@idata.analyticshub]

Hi! Thank you for your feedback. Would you mind sharing how the background music to you is? Do you have any other preference/recommendation?

[@crazyfirefly5735]

@@idata.analyticshub Use kind of music that goes with your video content, sorry to say this music is annoying and a hindrance to the subject of the video content.

[@idata.analyticshub]

Appreciate your feedback. We'll definitely use this on improvements. Hope you still learned a thing or two from the video.

[@yoganandk9360]

I think one mistake is there. How is profit higher than sales?? It should be less than sales

[@idata.analyticshub]

Hi. Did you follow the steps in the video?

[@yoganandk9360]

@@idata.analyticshub Yes I am following but some mistakes are there in the data set profit always should be less than sales.

[@idata.analyticshub]

Yes profit should be less than sales in real life. Please note that the data used for this tutorial is purely sample data only, not from any company data.

[@yoganandk9360]

Ok thank you for your reply and I have doubt about the pivot chart analyze tab. If I click this tab fields button is not enabled can you please tell me how to enable it. I checked in KZbin also I didn't get any idea

[@idata.analyticshub]

Hi! You can try the following steps to resolve the issue: Go to the File tab. Click on Options. Navigate to the Add-Ins category. Click on Manage Excel Add-ins. Check the box next to Analysis ToolPak. Click OK. Then Restart ExClose and reopen Excel to ensure the changes take effect.

[@Mrholo999]

👍👍👍

[@idata.analyticshub]

❤️❤️❤️

[@PritamPaul717]

❤️❤️❤️❤️❤️👌👌👌👍👍👍

[@idata.analyticshub]

Thank you! 🫶🫶🫶🫶🫶

[@junaldcayetano2473]

Okay, I only reached 02:23 of the vid. Can't stand the background music"togs taks" sorry

[@idata.analyticshub]

Hello! Thank you so much for your feedback. We'll take this into consideration on our next tutorials to ensure a smooth learning experience. Thank you again!

[@novocanal7153]

Stop being annoying and turn off the music volume

[@Jr-bi4tc]

Bad sound.

[@trevorsmith3475]

Too complicated

[@preciouskadiri9506]

Was too fast

[@idata.analyticshub]

Hi. We understand your concern. We have available videos in the channel in slower pace. For this video, you may also toggle with the speed settings to adjust the speed to your desired pace. :)

[@teachme1988]

Have not learned anything from this video.

[@martyns1722]

Actually i did and to be frank I’m amazed.

[@idata.analyticshub]

We're so glad that to know that you have learned something from this video. Thank you!

[@fianski]

I think you need to try to ceeate a dashboard from other tutorial which have slower guidance and come back to learn more. As for me, this video is very helpful and exactly what im looking for. Straight to the point and create a mind map from the beginning to understand the step to create Dashboard. If you were looking for detailed info even how to prepare the data then i think u need to learn more first about excel before you want to create an interactive Dashboard

[@eduleira8516]

Hahahaha

[@goldridder]

Judging by your username you’re probably another online school? You’re also an idiot.

[@ericssontest2332]

Q

[@idata.analyticshub]

Hello

[@sportsofficial6374]

Please try to speak

[@idata.analyticshub]

Soon we will

[@idata.analyticshub]

Hi! The data used for this tutorial is available on the attached file with readily structured Pivot Tables. Sharing a tutorial on Pivot Tables below: Pivot Tables in 2023: kzbin.info/www/bejne/p6K9nqqqbsqGo5osi=Ik1CoZINHB8BIMiL

[@ezegloria8196]

Too difficult to understand because u are too fast

[@idata.analyticshub]

@@ezegloria8196 hi! Thank you for providing your feedback and we're sorry to hear that this video is too fast. Perhaps our FULL EXCEL DASHBOARD COURSE is a better fit for you. Link: kzbin.info/www/bejne/sJyTkICLqqijj9ksi=XtgZxa_tVqtarHeg

[@phandongexcel]

I like this video and you? www.youtube.com/@phandongexcel❤❤❤❤❤

[@wegotthis247]

@@ezegloria8196I suggest going into settings and changing the playback speed to .75 - I find that useful when I’m following tutorials. That, along with the ability to stop and replay, is quite useful.

[@rdatta]

Really outstanding work and design. Well done. Particularly to lay out the data and metrics first. Lots of people tey to do this as they go and it can rwally slow one down.

[@idata.analyticshub]

Glad the video is helpful! Thank you for sharing the particular parts which were helpful. This guides us on creating more tutorials. ❤️