How to Create an Interactive Excel Dashboard in Just 12 Minutes

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

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

50% 1

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

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

21 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@idata.analyticshub 3 месяца назад

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 3 месяца назад

Thank you for this!

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

Too Fast

@idata.analyticshub 3 месяца назад

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 11 месяцев назад

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 11 месяцев назад

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

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

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

@idata.analyticshub 4 месяца назад

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. 💙

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

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 5 месяцев назад

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

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

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

@idata.analyticshub 5 месяцев назад

Sure! We'd love to see your dashboard and give our comments and recommendations. You can send over a screenshot to our email idataanalyticshub@gmail.com

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

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

@idata.analyticshub 6 месяцев назад

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

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

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

@idata.analyticshub 5 месяцев назад

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

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

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

@idata.analyticshub 5 месяцев назад

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

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

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 4 месяца назад

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

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

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

@idata.analyticshub 10 месяцев назад

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.

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

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 7 месяцев назад

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

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

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 6 месяцев назад

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 5 месяцев назад

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

@idata.analyticshub 5 месяцев назад

Glad the tutorial is clear. Thank you!

@4423PrachiIthape 4 месяца назад

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

@idata.analyticshub 4 месяца назад

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

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

This is my favorite tutorial. Thank you!

@idata.analyticshub 4 месяца назад

Glad it is helpful! ❤️

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

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

@idata.analyticshub 4 месяца назад

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

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

I learned and refer here alot! thanks!

@idata.analyticshub 4 месяца назад

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

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

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

@idata.analyticshub 6 месяцев назад

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

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

Great presentation! Thank You😀👍

@idata.analyticshub 4 месяца назад

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

@MGA19a 11 месяцев назад

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 11 месяцев назад

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 6 месяцев назад

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

@idata.analyticshub 6 месяцев назад

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

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

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

@idata.analyticshub 3 месяца назад

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

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

Thanks for sharing knowledge 🙏

@idata.analyticshub 4 месяца назад

Glad the video is helpful! 💙

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

Thanks for sharing this great video.

@idata.analyticshub 3 месяца назад

Glad the video helpful! 💙

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

Great 👍😊

@idata.analyticshub 10 дней назад

Glad it helped! 💙

@dirkstaszak4838 11 месяцев назад

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

@idata.analyticshub 11 месяцев назад

That's correct. Thank you!

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

Very useful, thanks a lot

@idata.analyticshub 4 месяца назад

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

@johnsudhakarrandy7372 11 месяцев назад

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

@idata.analyticshub 11 месяцев назад

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 11 месяцев назад

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

@idata.analyticshub 11 месяцев назад

Hi! You may check out our latest video, we have charts to compare values this month vs last month vs last year: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--qt_nFudQkY.htmlsi=NcjR0_uR5edaQw3c

@johnsudhakarrandy7372 11 месяцев назад

@@idata.analyticshub thanks 🙏👍

@Vogelfrei-jb6hu 7 месяцев назад

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 7 месяцев назад

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 7 месяцев назад

It works. Thanks a lot, again.

@idata.analyticshub 7 месяцев назад

You're welcome! ❤️

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

i'll try it! THANK YOU!

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

Great tutorial, Thank you 🤩

@idata.analyticshub 5 месяцев назад

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

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

I will give it a try.

@idata.analyticshub 2 месяца назад

Best of luck!

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

This is really helpful. Thank you!

@idata.analyticshub 6 месяцев назад

We are glad to know that. Thank you!

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

WOW! This is amazing!

@idata.analyticshub 5 месяцев назад

Thank you! Hope it helps!

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

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 2 месяца назад

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 2 месяца назад

@@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 2 месяца назад

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

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

❤absolutely brilliant video❤

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

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

@idata.analyticshub 18 дней назад

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

@Quijanos1 9 месяцев назад

Wow! That was amazing!

@idata.analyticshub 9 месяцев назад

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

@faulkma 11 месяцев назад

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 11 месяцев назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qqZmwt9eSm8.htmlsi=Ik1CoZINHB8BIMiLHope this helps.

@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 idataanalyticshub@gmail.com. :)

@Ahmad-yh7od 4 месяца назад

Wonderful

@idata.analyticshub 4 месяца назад

Glad the video is helpful!

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

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 3 месяца назад

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

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

@DtlaDaisy 11 месяцев назад

I love this asmr tutorial

@idata.analyticshub 11 месяцев назад

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

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

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 10 месяцев назад

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 10 месяцев назад

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

@goutamnayak5011 11 месяцев назад

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 11 месяцев назад

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.

@coldsnow9284 9 месяцев назад

Great help.

@idata.analyticshub 9 месяцев назад

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

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

Really helpful

@idata.analyticshub 10 месяцев назад

Thank you for the kind words! Really appreciate it 🫶

@johnsudhakarrandy7372 11 месяцев назад

Wow super Love it 😻

@idata.analyticshub 11 месяцев назад

Thank you! Glad the video helped 😊

@hamypham2490 9 месяцев назад

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 9 месяцев назад

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.

@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 26 дней назад

Hi. Hope this helps! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4EOYhvaa16o.htmlsi=81gJepPYfe7zqy4U

@johnsudhakarrandy7372 11 месяцев назад

Im your new subscriber ❤

@idata.analyticshub 11 месяцев назад

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

@BharathK-um4sl 5 месяцев назад

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 5 месяцев назад

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

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

Thanks!

@idata.analyticshub 10 месяцев назад

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

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

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

@idata.analyticshub 6 месяцев назад

Hi. Here's our tutorial video on how to make pivot table: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qqZmwt9eSm8.htmlsi=ii_nEdO1DX3dhxdM

@Natasha-je4be 16 дней назад

Which version of excel are you using?

@idata.analyticshub 16 дней назад

The latest one.

@jadad1010 8 месяцев назад

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 8 месяцев назад

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!

@tpkchannel4001 11 месяцев назад

Thank you😮😮

@idata.analyticshub 11 месяцев назад

You're welcome! 😊

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

Thnak You

@idata.analyticshub 10 месяцев назад

You're welcome! Hope the video is helpful

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

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

@idata.analyticshub 6 месяцев назад

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

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

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 10 месяцев назад

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 7 месяцев назад

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

@4423PrachiIthape 4 месяца назад

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

@idata.analyticshub 4 месяца назад

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!

@AdnanLocationlab 4 дня назад

great

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

so it is must to have pivot tables

@idata.analyticshub Месяц назад

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

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

Dereval are a laki asset Dereval bawer full

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

What software did you use to edit this video please?

@idata.analyticshub 6 месяцев назад

Hi. I mainly use canva.

@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

@abdulrahmanoubari765 26 дней назад

What is the meaning of sales completion and incompletion?

@mayaalw 26 дней назад

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

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

can you please explain the last step "Slicer"?

@idata.analyticshub 7 месяцев назад

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!

@anjanbin-bb3ud 10 месяцев назад

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

@idata.analyticshub 10 месяцев назад

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 9 месяцев назад

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

@trading_addiction 8 месяцев назад

How to connect yearly and monthly slicer together???

@idata.analyticshub 8 месяцев назад

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!

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

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

@idata.analyticshub 7 месяцев назад

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 7 месяцев назад

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

@idata.analyticshub 7 месяцев назад

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 7 месяцев назад

@@idata.analyticshub thank you so much

@idata.analyticshub 7 месяцев назад

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.

@myfuture1164 9 месяцев назад

"Supper se Upper"

@idata.analyticshub 9 месяцев назад

Thank you!

@TheDrSimus Год назад

nice!

@idata.analyticshub Год назад

Thanks dude!

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

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

@idata.analyticshub 3 месяца назад

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

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

@@idata.analyticshub like tradezella

@idata.analyticshub 3 месяца назад

What is that?

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

I need this with full disborad

@idata.analyticshub 10 месяцев назад

Hello! Sharing our full dashboard course. Hope this helps: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zk0_MUuCpYw.htmlsi=9jRLa92javuXfOzp

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qqZmwt9eSm8.htmlsi=Ik1CoZINHB8BIMiL

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

Too difficult to understand because u are too fast

@idata.analyticshub 7 месяцев назад

@@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zk0_MUuCpYw.htmlsi=XtgZxa_tVqtarHeg

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

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

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

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

@jadenhaan 9 месяцев назад

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

@idata.analyticshub 9 месяцев назад

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!

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

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

@idata.analyticshub 5 месяцев назад

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

@kitjipong5081 8 месяцев назад

how can you put formula inside a text box?

@idata.analyticshub 8 месяцев назад

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.

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

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

@idata.analyticshub 2 месяца назад

Hi. What tabs do you see?

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

Why I can't put the matrix in text box

@idata.analyticshub 7 месяцев назад

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.

@mohanraj-qg7nr 9 месяцев назад

Demo is very fast. Nothing can be understand

@idata.analyticshub 9 месяцев назад

Thank you for sharing your insight. This is noted.

@coldsnow9284 9 месяцев назад

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

@idata.analyticshub 9 месяцев назад

Thank you so much for sharing this amazing tip! 😊

@shrikanthpc2719 9 месяцев назад

Which version is this excel?? Please reply

@idata.analyticshub 9 месяцев назад

Hi! We're using the latest version

@shrikanthpc2719 9 месяцев назад

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

@idata.analyticshub 9 месяцев назад

Hi. It's the free one

@shrikanthpc2719 9 месяцев назад

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

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

I'm unable to use slicer 😢

@idata.analyticshub 10 месяцев назад

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

@junaldcayetano2473 8 месяцев назад

Togs taks hahaha

@idata.analyticshub 8 месяцев назад

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

@thefinaldestination-japan 9 месяцев назад

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

@idata.analyticshub 9 месяцев назад

In english please

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

👍👍👍

@idata.analyticshub 10 месяцев назад

❤️❤️❤️

@miguel.arancibia.h 3 месяца назад

sin las opciones de "pivot" no funciona.

@idata.analyticshub 3 месяца назад

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

@idata.analyticshub 3 месяца назад

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

Vanity matrices

@idata.analyticshub 6 месяцев назад

Why

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

where can i get the file?

@idata.analyticshub 5 месяцев назад

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

@yoganandk9360 9 месяцев назад

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

@idata.analyticshub 9 месяцев назад

Hi. Did you follow the steps in the video?

@yoganandk9360 9 месяцев назад

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

@idata.analyticshub 9 месяцев назад

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 9 месяцев назад

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 RU-vid also I didn't get any idea

@idata.analyticshub 9 месяцев назад

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.

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

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

@idata.analyticshub 10 месяцев назад

Thank you! 🫶🫶🫶🫶🫶

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

@KO-nn1vm Месяц назад

Too much music no good

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

What's with this background music¿

@idata.analyticshub 3 месяца назад

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 3 месяца назад

@@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 3 месяца назад

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

@junaldcayetano2473 8 месяцев назад

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

@idata.analyticshub 8 месяцев назад

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 4 дня назад

Stop being annoying and turn off the music volume

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

Okay How to this Dashboard view move to email

@idata.analyticshub 7 месяцев назад

Hi. You can put this dashboard view to email by pasting it as picture. Here is a step by step guide on how to do that: 1. Select all the cells where the entire dashboard are on 2. CTRL + C to copy the cells 3. Go to the email and right click on the part of the email where you want to place the dashboard view 4. Select Paste as Picture Hope this helps!