Make an Interactive Excel Dashboard in Just 12 Minutes

[@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!

[@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 :)

[@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. :)

[@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!!! ❤️

[@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]

[@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. ❤️

[@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

[@datablitz125]

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

[@idata.analyticshub]

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

[@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. ❤️

[@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 ♡

[@shakrikle]

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

[@mayaalw]

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

[@idata.analyticshub]

Glad the tutorial is clear. Thank you!

[@smn2197]

This is my favorite tutorial. Thank you!

[@idata.analyticshub]

Glad it is helpful! ❤️

[@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!

[@talknow2859]

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

[@idata.analyticshub]

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

[@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 ❤️

[@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! ❤️

[@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 😀

[@smn2197]

This is really helpful. Thank you!

[@idata.analyticshub]

We are glad to know that. 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! ❤️

[@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. :)

[@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! 💙

[@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 💙

[@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 🙏👍

[@pillauoc]

I can't add any formula in the text area, I write and it's working and formula symbol is not working. if I do tha't down in a cell it works but not in a text box :( I really. needed that. Thanks in advance!

[@idata.analyticshub]

Hi! Here’s how you can do it: 1. Click the Text Box 2. Go to the Formula Bar (while the text box is still selected) 3. Type the Formula "=" 4. Select the Metric (Cell) You Want to Show (Example: ='Pivot Tables'!E3) 5. Press Enter The value from the referenced cell will now appear inside the text box. Hope this helps!

[@mianuuraini]

i'll try it! THANK YOU!

[@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!

[@mohamedlebbai]

Very useful, thanks a lot

[@idata.analyticshub]

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

[@bounyoothammavong5712]

Great tutorial, Thank you 🤩

[@idata.analyticshub]

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

[@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

[@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! :)

[@darickgetachew8568]

Interesting and great presentation, can you please tell me how you calculate the ** average of sales completion ** Average of profit completion rate ** sales completion ** profit completion Please?

[@mayaalw]

WOW! This is amazing!

[@idata.analyticshub]

Thank you! Hope it helps!

[@TrusteestDesiChhora]

Next level ❤😊

[@idata.analyticshub]

Hope it helped! 💙

[@CMusica]

I will give it a try.

[@idata.analyticshub]

Best of luck!

[@aalapvora6853]

❤absolutely brilliant video❤

[@poethonn5999]

Thank you ❤

[@idata.analyticshub]

Glad it helped! 💙

[@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.

[@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!

[@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

[@Quijanos1]

Wow! That was amazing!

[@idata.analyticshub]

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

[@nimminarratives26]

Or cut pasted the chart?

[@idata.analyticshub]

Hi. Yes, I cut pasted the chart on the video

[@nimminarratives26]

@@idata.analyticshub so is it always that we need to cut paste or copy paste will also work

[@idata.analyticshub]

Copy paste also works :)

[@Natasha-je4be]

Which version of excel are you using?

[@idata.analyticshub]

The latest one.

[@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

[@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()"

[@arifbornal17]

Great 👍😊

[@idata.analyticshub]

Glad it helped! 💙

[@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.

[@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. :)

[@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.

[@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!

[@hamypham2490]

I really want that you can tell me the way about how metrics change following to the slicer. Please instruct me the way to do this because my number cannot change if I use the slicer. Please answer me this question.

[@idata.analyticshub]

Hi! Yes, I'd love to guide you through this. First, have you checked the Connections of your slicer? Make sure the the slicer is connected to all necessary PivotTables so that when you click the slicer, the metrics would also update.

[@DtlaDaisy]

I love this asmr tutorial

[@idata.analyticshub]

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

[@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!

[@jayjoe5160]

so it is must to have pivot tables

[@idata.analyticshub]

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

[@Ahmad-yh7od]

Wonderful

[@idata.analyticshub]

Glad the video is helpful!

[@johnsudhakarrandy7372]

Im your new subscriber ❤

[@idata.analyticshub]

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

[@nimminarratives26]

You copy pasted the chart ?

[@idata.analyticshub]

Hi. I cut pasted the charts on the video. If you prefer, you can also copy paste them. Although you won't be needing duplicate charts on the dashboard and data sheets.

[@nimminarratives26]

@@idata.analyticshub I tried but I was not able to put the slicers in that.

[@nimminarratives26]

So was facing difficulty as not all the charts are getting filtered properly

[@idata.analyticshub]

I understand. The missing step is connecting the slicer to ALL the charts, instead of on only 1. Here's how: 1. Click on the slicer to activate it. 2. On the Slicer tab, click Report Connections (or PivotTable Connections in older Excel versions). A window will appear showing all the pivot tables in the workbook. 3. Check the boxes for all pivot tables and pivot charts you want to connect to the slicer. 4. Click OK. Hope this helps!

[@nimminarratives26]

Will try this. Thanks!

[@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!

[@redquartz2229]

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

[@idata.analyticshub]

Hi. What tabs do you see?

[@coldsnow9284]

Great help.

[@idata.analyticshub]

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

[@analyticshub9615]

What software did you use to edit this video please?

[@idata.analyticshub]

Hi. I mainly use canva.

[@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.

[@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.

[@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 :)

[@hazaraonlineeducation7517]

Really helpful

[@idata.analyticshub]

Thank you for the kind words! Really appreciate it 🫶

[@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

[@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!

[@johnsudhakarrandy7372]

Wow super Love it 😻

[@idata.analyticshub]

Thank you! Glad the video helped 😊

[@AbdulbastHawar]

where can i get the file?

[@idata.analyticshub]

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

[@ahmedzain2783]

I need this with full disborad

[@idata.analyticshub]

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

[@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.

[@myfuture1164]

"Supper se Upper"

[@idata.analyticshub]

Thank you!

[@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

[@JayandKeval]

hello! i want to ask that how you added sales completion rate plzz reply

[@idata.analyticshub]

Hello! I added sales completion rate at 2:27. Hope this helps!

[@JayandKeval]

How you add in data in percentage?

[@idata.analyticshub]

@@JayandKeval For data in percentage of sales, I created a PivotTable and used the value Sales Completion Rate. The default calculation of values is SUM. So I just changed it to AVERAGE. You should be able to get 86% for sales completion rate.

[@idata.analyticshub]

Sharing our tutorial here as well on How to Create a PivotTable. I hope this helps :) kzbin.info/www/bejne/p6K9nqqqbsqGo5osi=O_vM_IXT-zntoOr-

[@JayandKeval]

Thank you so much 😊😊

[@ahmedzain2783]

Thanks!

[@idata.analyticshub]

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

[@AdnanLocationlab]

great

[@idata.analyticshub]

Glad it helped! 💙

[@tpkchannel4001]

Thank you😮😮

[@idata.analyticshub]

You're welcome! 😊

[@kgomotsodiale7355]

Thnak You

[@idata.analyticshub]

You're welcome! Hope the video is helpful

[@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? :)

[@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 :)

[@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?

[@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

[@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

[@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.

[@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!

[@TheDrSimus]

nice!

[@idata.analyticshub]

Thanks dude!

[@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! 😊

[@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

[@DerevalareAlakiassetDereval]

Dereval are a laki asset Dereval bawer full

[@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.

[@KO-nn1vm]

Too much music no good

[@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.

[@arifibrahim9815]

Vanity matrices

[@idata.analyticshub]

Why

[@junaldcayetano2473]

Togs taks hahaha

[@idata.analyticshub]

I know. The original audio hit a potential copyright. That's why we replaced it with an audio that's available on youtube. Hence the togs taks :(

[@sleep.study.relaxwithnatur1996]

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