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
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.
Great video. I’ve been trying to keep my projects organized, and the Astirna New Tab extension has been a nice addition to my workflow. It helps with productivity while I work on dashboards like this.
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!
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. :)
When I try to make the slicer in minute 7:35 all I get in the box is (value)and(column1) how come? It didn’t show me the days or months and now it says there is no connection in the workbook
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. 💙
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
You are very welcome! Congratulations on creating your first dashboard! 🎉 Keep going and we can't wait to see what awesome projects you'll make next. Let us know if there's anything else you'd like to learn! 💙
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!!! ❤️
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
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.
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!
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.
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)
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. :)
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
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.
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!
@@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
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! :)
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!
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!
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
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!
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!
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.
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.
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!
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!
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?
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!
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!
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. ❤️
Hi! You may check out our latest video, we have charts to compare values this month vs last month vs last year: ruclips.net/video/-qt_nFudQkY/видео.htmlsi=NcjR0_uR5edaQw3c
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".
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.
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.
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??
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.
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
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: ruclips.net/video/qqZmwt9eSm8/видео.htmlsi=Ik1CoZINHB8BIMiLHope this helps.
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.
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
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!
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.
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!
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
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!
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?
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 :)
@@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 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
Hey everyone, we heard you! 💙💙 Here's a detailed, step-by-step guide on how to make the PivotTables used in this video: ruclips.net/video/JYfJwuVM7Kk/видео.htmlsi=ctSpwox-F505LPVu
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
Hi! You can download it here: docs.google.com/spreadsheets/d/1M9cfsruhA3gsK6nv2fn5FQuNrdorPI-m/edit?usp=sharing&ouid=117553288234376939891&rtpof=true&sd=true
@@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.
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: ruclips.net/video/qqZmwt9eSm8/видео.htmlsi=Ik1CoZINHB8BIMiL
@@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: ruclips.net/video/zk0_MUuCpYw/видео.htmlsi=XtgZxa_tVqtarHeg
@@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.
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!
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!
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
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
Thank you for this!
Too Fast
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.
Great video. I’ve been trying to keep my projects organized, and the Astirna New Tab extension has been a nice addition to my workflow. It helps with productivity while I work on dashboards like this.
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!
Thank you for sharing your tips to the community! We're glad you were able to create the dashboard. Congratulations!
This is the best dashboard tutorial I have ever seen. EVER. I was able to follow every step. Thank you!
We are glad to that the tutorial video is helpful for you. More tutorials in our channel :)
Loved the tutorial. Speed was normal and could be understood easily. I will surely try this. Thanks for sharing Ideas.
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. :)
When I try to make the slicer in minute 7:35 all I get in the box is (value)and(column1) how come? It didn’t show me the days or months and now it says there is no connection in the workbook
Simple, direct and rich in content as all tutorial should be. Thanks for sharing this great video!
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. 💙
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
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. ❤️
Thank you for this guided project. I made my first dashboard too.
You are very welcome! Congratulations on creating your first dashboard! 🎉 Keep going and we can't wait to see what awesome projects you'll make next. Let us know if there's anything else you'd like to learn! 💙
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!!
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!!! ❤️
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!
Congrats on making a dashboard! We're glad to be of help. :)
@@idata.analyticshub can I send you my dashboard? I want to know your comments about it.
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
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.
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!
It works. Thanks a lot, again.
You're welcome! ❤️
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.
Glad the video is helpful! Thank you for sharing the particular parts which were helpful. This guides us on creating more tutorials. ❤️
This tool is extremely useful for many people , thanks for sharing knowledge
You're welcome! Just let me know if you have questions
WOW! This is the best dashboard tutorial I have watched ❤
Comments like this really inspire us. Thank you! ❤️
Very easy to understand steps to create a basic dashboard. Thank you 🤗❤️
Thank you! We're so glad that you find the video easy to understand, just like how we wanted it ♡
Really like it bcs it is simple and on point. Compared to the latest kind of dahsboard which includes query, power pivot etc.
Gosh! Your video here is mind blowing...absolutely fantastic! 🎉👏👏👏👏👏
Thank you so much! I'm so glad you like the video 🥹❤️
Thanks!
Omg thank you so much for the Super Thanks sir!!! It really means a lot to us 🙏❤️❤️❤️
A very clear tutorial for me. Direct to the point. Thank you!
Glad the tutorial is clear. Thank you!
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)
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. :)
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?
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
Useful and fun to watch. The vid callouts and % done helped.
Glad the video is helpful and fun to watch. Thank you!
Thank you so much...I really Loved this video...to the point video thank you 🤗💕
Glad the video was helpful! This is really inspiring ❤️
Great presentation! Thank You😀👍
Glad the video is helpful! ❤️ if you have any question, just let us know and we'll be happy to assist 😀
hello sr, can u make a video to how to make povit table like u did for sales, customers, sales, competition, etc
Hi. Here's our tutorial video on how to make pivot table:
ruclips.net/video/qqZmwt9eSm8/видео.htmlsi=ii_nEdO1DX3dhxdM
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.
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!
@@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
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! :)
This is my favorite tutorial. Thank you!
Glad it is helpful! ❤️
I'm having problems with the doughnut chart to respond with the slicer
Hi. Make sure that the Slicer is connected to the source of doughnut chart. You can check this on Slicer Connections.
What is the meaning of sales completion and incompletion?
I had the same question at first. I think it's how close to the target sales
Next level ❤😊
Hope it helped! 💙
How to get this files, your website is not working
Hi. Upon checking, the link is still accessible. You may also send us an email to request for the file.
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!
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!
Thanks for sharing knowledge 🙏
Glad the video is helpful! 💙
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
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!
I learned and refer here alot! thanks!
That's so nice to hear. We're glad the video is helpful. Thank you! ❤️
This is really helpful. Thank you!
We are glad to know that. Thank you!
Or cut pasted the chart?
Hi. Yes, I cut pasted the chart on the video
@@idata.analyticshub so is it always that we need to cut paste or copy paste will also work
Copy paste also works :)
In Metrics couldn't add formula = its disabled by defaul, any solution?
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!
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.
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.
can you please explain the last step "Slicer"?
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!
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!
Hi. Hope this helps! ruclips.net/video/4EOYhvaa16o/видео.htmlsi=81gJepPYfe7zqy4U
❤absolutely brilliant video❤
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?
Please tell us how to make that original table with percentage of sales and profit
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!
Thanks for sharing this great video.
Glad the video helpful! 💙
Which version of excel are you using?
The latest one.
Great tutorial, Thank you 🤩
We're glad the tutorial is helpful! ❤️ If you have any questions, feel free to reach out. :)
so it is must to have pivot tables
Yes! The file already contains the needed pivot tables. :)
How to connect yearly and monthly slicer together???
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!
thanks for sample file
I can follow step by step your video
thank you very much
Glad the sample file and video are helpful! If you have any questions, we'll be glad to help 💙
Very useful, thanks a lot
Glad the video is useful! If you have any question, we'll be glad to help :)
Im working as a senior MIS Officer. In Sales Team it will Help me Lot ❤.
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. ❤️
@@idata.analyticshub hey hi.
My request is the same as how to make Last Month VS This Month comparing the report dashboard .
Hi! You may check out our latest video, we have charts to compare values this month vs last month vs last year: ruclips.net/video/-qt_nFudQkY/видео.htmlsi=NcjR0_uR5edaQw3c
@@idata.analyticshub thanks 🙏👍
how can I customize the structure ? if I want to use it for defect inventory as per week and month ?
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".
@idata.analyticshub and the sales with defects and customers with the products, correct?
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.
@@idata.analyticshub thank you so much
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.
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??
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.
I dint have the data thing tab, did y’all find it
Hi. What tabs do you see?
Why I can't put the matrix in text box
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.
WOW! This is amazing!
Thank you! Hope it helps!
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?.
Hi. Yes, when you change data in data sheet, the dashboard should automatically update. No need to build the dashboard every time. :)
Thank you ❤
Glad it helped! 💙
Great 👍😊
Glad it helped! 💙
What software did you use to edit this video please?
Hi. I mainly use canva.
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
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: ruclips.net/video/qqZmwt9eSm8/видео.htmlsi=Ik1CoZINHB8BIMiLHope this helps.
how can you put formula inside a text box?
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.
i'll try it!
THANK YOU!
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
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!
I think what happened is you put the formula "=A2", for example. It should be "=GETPIVOTDATA()"
wow i can download the full file?
Yes! You can download it in the description :)
You copy pasted the chart ?
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.
@@idata.analyticshub I tried but I was not able to put the slicers in that.
So was facing difficulty as not all the charts are getting filtered properly
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!
Will try this. Thanks!
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
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!
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
Excuse me, can you example (Overview, data, and Pivot Tables)? ( Details )
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?
@@idata.analyticshubplease share details on pivot analyze tab about how to do it and how to enable it.
where can i get the file?
Hi. You can get the file on the description box :)
Im your new subscriber ❤
Thank you! We really appreciate it ❤️ more videos like this coming soon
I need this with full disborad
Hello! Sharing our full dashboard course. Hope this helps: ruclips.net/video/zk0_MUuCpYw/видео.htmlsi=9jRLa92javuXfOzp
Nice one, but one thing all of you should consider is a proper naming of the pivot tables 😊
That's correct. Thank you!
I will give it a try.
Best of luck!
Wow! That was amazing!
Thank you for the kind words! Really appreciate it ❤️
I'm unable to use slicer 😢
Hello! I'd be happy to guide you. How did you try to use a slicer? :)
your data set is without Dashboard, Slicer and pivots.. kindly share the full dashboard as you explained in Video.. thanks in advance
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 :)
hello! i want to ask that how you added sales completion rate plzz reply
Hello! I added sales completion rate at 2:27.
Hope this helps!
How you add in data in percentage?
@@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.
Sharing our tutorial here as well on How to Create a PivotTable. I hope this helps :)
ruclips.net/video/qqZmwt9eSm8/видео.htmlsi=O_vM_IXT-zntoOr-
Thank you so much 😊😊
Which version is this excel?? Please reply
Hi! We're using the latest version
@@idata.analyticshub is this the paid one??
Hi. It's the free one
@@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
Hello how to make trading journal forex trading long short lot pair profit or loss and feedback 😢😢😢
Hi! Would you mind sharing what charts or visualizations are you looking for in this trading journal?
@@idata.analyticshub like tradezella
What is that?
Wonderful
Glad the video is helpful!
Wow super Love it 😻
Thank you! Glad the video helped 😊
Hey everyone, we heard you! 💙💙
Here's a detailed, step-by-step guide on how to make the PivotTables used in this video: ruclips.net/video/JYfJwuVM7Kk/видео.htmlsi=ctSpwox-F505LPVu
sin las opciones de "pivot" no funciona.
Hi. Kindly translate to english so we can assist you properly. :)
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
Great help.
We're glad you found the video helpful. Thank you for the kind words. We really appreciate it. 🖤
Thank you😮😮
You're welcome! 😊
How I can download?
Hi! You can download it here:
docs.google.com/spreadsheets/d/1M9cfsruhA3gsK6nv2fn5FQuNrdorPI-m/edit?usp=sharing&ouid=117553288234376939891&rtpof=true&sd=true
Select Download under File option :)
Really helpful
Thank you for the kind words! Really appreciate it 🫶
I love this asmr tutorial
Thank you so much! We're glad you love the video
What's with this background music¿
Hi! Thank you for your feedback. Would you mind sharing how the background music to you is? Do you have any other preference/recommendation?
@@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.
Appreciate your feedback. We'll definitely use this on improvements. Hope you still learned a thing or two from the video.
Vanity matrices
Why
A kind of Power BI solution but pls explain what you do, music will not teach
Thank you for sharing your suggestions. We appreciate all suggestions to help us create better and more helpful tutorials.
great
Glad it helped! 💙
Thnak You
You're welcome! Hope the video is helpful
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: ruclips.net/video/qqZmwt9eSm8/видео.htmlsi=Ik1CoZINHB8BIMiL
Too difficult to understand because u are too fast
@@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: ruclips.net/video/zk0_MUuCpYw/видео.htmlsi=XtgZxa_tVqtarHeg
I like this video and you? www.youtube.com/@phandongexcel❤❤❤❤❤
@@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.
Okay How to this Dashboard view move to email
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!
Okay, I only reached 02:23 of the vid. Can't stand the background music"togs taks" sorry
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!
Stop being annoying and turn off the music volume
Demo is very fast. Nothing can be understand
Thank you for sharing your insight. This is noted.
Play the video in slow motion bro. I think it will help you.😊
Thank you so much for sharing this amazing tip! 😊
thanks bro
Happy to help bro. Feel free to let us know if you have questions
@@idata.analyticshub thanks, i doesnt have any question