Your tutorials are awesome. I've watched three so far, worked through the exercise files with the explanation videos and learned so much. And - to top it off - what I learned in those videos got me a job as a data analyst! While being experienced in building fancy Salesforce dashboards, I've never needed to do so in Excel, and only used some dropdown menus and simple formulas and pivot tables in Excel. Then an amazing job opportunity popped up and they said - Excel Dashboards are one of their most important tools - so I had to skill up. It worked. It impressed. And now I'm hooked, eager to learn a lot more through your videos. Thank you for making such great and well explained content!
I just made my first interactive dashboard, thanks to you! Your videos are edited beautifully, your style of teaching is best. Thank you so much. I have learned a lot.I would love to learn pivot tables on qualitative data.
the formula for the totals on the right side/Sale by Retalier are wrong; they're still referencing the Sales by Beverage Brand...guessing I'm not the first person to point this out. You're videos are excellent and get right to the point. thank you!!! I can see the issue if fixed later when you connect or link the tables to slicers.
YO!.... AMAZING..... I simulated everything in the tutorial and it was amazing. you also open my mind to some things in pivot that i have been stuggling with. to be sure i got it right, i followed your format and use create an interractive map.... Awesome. i just wish i can share it with you.... i will be interested to watch more of your videos... keep the good work
What a great pace video. My mind wanders when waiting for someone who's fannying about. This was "accelerator down" all the way, and I watched from start to end without fidgeting. Perfect!
Thank you for another great video. I just finished watching another of your videos on how to create forms in excel. QQ: Is it possible to have a form for data entry in this file so that I don’t have to copy data from one excel sheet to this sheet? The data would go into the data tab when someone completes the form and then the dashboard would automatically update for use?
Hi there. I have an job interview test that I will be given various data to make a data power point report. I am wondering if that includes in your Powerpoint course and there is enough exercise to practise? Thank youuuu
Hi Kenji, Thanks you for this very interesting video. However, I have a question. At 17.44 when you select region "Midwest", I see in the chart below datas, column and the legend of the graph with "0". How to fix that ? Thank you for the answer 😎
Hey.. I had the exact same question and as a solution I believe this can be fixed by creating charts using the PivotChart Option under the "PivotTable Analyze" tab, rather than referencing data on adjacent cells and then creating a chart using it. The PivotChart will dynamically adjust to the changing pivot table according to the slicer actions. Not sure if this is still relevant to you, but hope it helps you :) Cheers.
Thanks, very useful! Is it also possible to have a Slicer set up with a range of 2 dates? If I want to filter all the data between for example 1 jan and 8 jan?
Thank you so much Kenji for this beautiful dynamic dashboard and I would to like make it perfectly useful for my project analysis. After the dashboard was created, I found that the bottom chart is Quarter's sequence was misarranged and placing 0 for the quarter's name but contains values on the bar chart showing more than 0 in the "Sales and Operating Profit Margin by Quarter". For example, if you filter the rregion to be Northeast, the quarters for the 2022 is listed as Qtr1, Qtr2, Qtr3, Qtr1 again.... It is also labeling the last Qtr4 as "0". I assume it is because there is no Qtr4 2022 data in the chart which confirmed by filtering the original data. How can we make the data look for clean on the dashboard when there is no data? I would be happy to email you a screenshot of what I meant. :) Thank you again!
can you make a video on how to print dashboard with multiple set of data in one go. . just like what we do into ms word in mail merge. . . data in sheet 1 but printing of dashboard
Not tried it yet but when you create the graph you use data linked to the pivot table. When you “=“ to a pivot it returns “Getpivotdata….” Then your video changes to “=xx”. I presume you turned off the getpivotdata option (generally not advised - better to link the formula to the cells by replacing the link in quotation marks) Can you confirm that this was done by a bit of editing that we didn’t see how that switched please? If you pause the video you can see it returns the pivot table string for a second before changing TIA
I can't get a formula to come up in a text box like you did. It just shows the text of " =Data!E104 " that I typed into the text box. How do you get a formula in a text box??
I'm wondering the same, cause he didn't show how to connect it to the data he use to made the chart, cause it didn't do it from the table, it came from the data he copy from the table 4
I think his calculation for average price per unit at 05:25 is incorrect. He took the average of all the prices, instead of a weighted average price per unit which should take the sum of all sales divided by the sum of all units. This would give you a value of $0.48 rather than $0.45. Otherwise, an excellent explanation.
👉 Take our Excel for Business & Finance Course here: www.careerprinciples.com/courses/excel-for-business-finance
Can i have discount code please
how I can download the link?
yes
Your tutorials are awesome. I've watched three so far, worked through the exercise files with the explanation videos and learned so much. And - to top it off - what I learned in those videos got me a job as a data analyst! While being experienced in building fancy Salesforce dashboards, I've never needed to do so in Excel, and only used some dropdown menus and simple formulas and pivot tables in Excel. Then an amazing job opportunity popped up and they said - Excel Dashboards are one of their most important tools - so I had to skill up. It worked. It impressed. And now I'm hooked, eager to learn a lot more through your videos. Thank you for making such great and well explained content!
That’s amazing congratulations!! Thank you for your lovely comment 👍
I just made my first interactive dashboard, thanks to you! Your videos are edited beautifully, your style of teaching is best. Thank you so much. I have learned a lot.I would love to learn pivot tables on qualitative data.
Thank you Kenji! I dont know if your Bachelor is engineering but I love how you are structured the flow in tutorials with such clear steps.. Perfect!!
the formula for the totals on the right side/Sale by Retalier are wrong; they're still referencing the Sales by Beverage Brand...guessing I'm not the first person to point this out. You're videos are excellent and get right to the point. thank you!!! I can see the issue if fixed later when you connect or link the tables to slicers.
You make the most beautiful Excel dashboards 😫❤
your teaching style is awesome brother keep shine
YO!.... AMAZING.....
I simulated everything in the tutorial and it was amazing. you also open my mind to some things in pivot that i have been stuggling with. to be sure i got it right, i followed your format and use create an interractive map.... Awesome. i just wish i can share it with you....
i will be interested to watch more of your videos... keep the good work
THANK YOU KENJI LOTS OF RESPECT FROM KERALA INDIA
You are actually life saving
Love how clearly you make and present your videos - super informative and useful
2:36 Wow! This is my first time knowing this. I usually merge and center, but this is extra step but nice X-D
Thank you!
AMAZING. Nice video. Thank you
Crystal clear.. thanks!!
What a great pace video. My mind wanders when waiting for someone who's fannying about. This was "accelerator down" all the way, and I watched from start to end without fidgeting. Perfect!
This Is valuable for Professional bodies like ACCA , CA
Wow. That was pretty good. Thank you!
Thank you Kenji.... You have made my journey in the world of analytics very interesting. 😊😊
Happy to hear that!
So nice and fit for students
Hi Kenjii you are the best.
Great tutorial and helpful for me. Thanks so much Kenji!
Great stuff! Simplified.
Thanks, Kenji for your explanations
Awesome video, as usual. Thank you very much and congratulations!
Thank you!
Would you please make a video on combining three workbooks with some additional columns in or two of the files? Thank Kenji.
Thank you Kenji, excellent dashboard
Just what I needed, Kenji! Thanks!
lets go!
Kenji Is an Excel *GOD*
Your videos have been very helpful for me while starting in analytics, thanks Kenji!
Very very nice, thank you so much :)
Excellent presentation 👌👌👌
Thank you so much this is so helpful.
I am from VietNam, thank you for your vidieos, you look very handsome between Europe and Asia😄
Execellent surely i want to learn more great video
Great tutorial in every sense 👌
U did video 20 mins i try this more than one hour to do this dashboard really helpful one
Thank you. Happy new year :3
Happy new year!
Thank you for another great video. I just finished watching another of your videos on how to create forms in excel. QQ: Is it possible to have a form for data entry in this file so that I don’t have to copy data from one excel sheet to this sheet? The data would go into the data tab when someone completes the form and then the dashboard would automatically update for use?
Thanks 👍 you always present new and wonderful information
Nice. thanks for sharing your knowledge. God bless you Kenji...
Excellent Kenji. Thanks for teaching
Hi Kenjie, can you please provide dashboard for training completion, most of the dashboards in UA-cam are about sales.
Super and easy explained! Thanks a lot
Awesome work. Thank you!
Glad you liked it!
Thanks for such amazing dashboard with detailed .
This was a great dashboard tutorial and just what I needed. Thanks
Glad it helped!
Excellent. Thank you.
excellent tutorial
the best explain
Very cool dashboard!!
Great staff
Hi there. I have an job interview test that I will be given various data to make a data power point report. I am wondering if that includes in your Powerpoint course and there is enough exercise to practise? Thank youuuu
hey, thanks for your interest. If you don't mind, please ask any questions to info@careerprinciples.com
Thank you guy
really helpful thank youu
Super report creation
it is very nice and very impressive
Hi Kenji,
Thanks you for this very interesting video.
However, I have a question. At 17.44 when you select region "Midwest", I see in the chart below datas, column and the legend of the graph with "0". How to fix that ?
Thank you for the answer 😎
Hey.. I had the exact same question and as a solution I believe this can be fixed by creating charts using the PivotChart Option under the "PivotTable Analyze" tab, rather than referencing data on adjacent cells and then creating a chart using it. The PivotChart will dynamically adjust to the changing pivot table according to the slicer actions.
Not sure if this is still relevant to you, but hope it helps you :)
Cheers.
Thanks, very useful! Is it also possible to have a Slicer set up with a range of 2 dates? If I want to filter all the data between for example 1 jan and 8 jan?
No
As usual, awesome content regarding copilot I have office 365 still now didn't appear in the the ribbon
Thank you so much Kenji for this beautiful dynamic dashboard and I would to like make it perfectly useful for my project analysis. After the dashboard was created, I found that the bottom chart is Quarter's sequence was misarranged and placing 0 for the quarter's name but contains values on the bar chart showing more than 0 in the "Sales and Operating Profit Margin by Quarter". For example, if you filter the rregion to be Northeast, the quarters for the 2022 is listed as Qtr1, Qtr2, Qtr3, Qtr1 again.... It is also labeling the last Qtr4 as "0". I assume it is because there is no Qtr4 2022 data in the chart which confirmed by filtering the original data. How can we make the data look for clean on the dashboard when there is no data? I would be happy to email you a screenshot of what I meant. :) Thank you again!
that was great!!!! but how do you put that last formula (last updated)?
Thanks.
Hi
I need help ☺️
I have a question
I don't see all the sheets in report connection
My one of the sheet is not linked to dashboard slicer
can you make a video on how to print dashboard with multiple set of data in one go. . just like what we do into ms word in mail merge. . . data in sheet 1 but printing of dashboard
nice and thanks
If you see this comment you are not first
Lol
I never am
Hahaha!
AWESOME
Thanks 🤗
What formula should we use. If we want to repeat the same word but vertically
i have one question , when i analyzing the data , on pivot analysis on the data invoice how the date and month i remove from the column selected?
Thanks!!! How can i keep updating my dashboard with new data?
Great dashboard Kenji, but how do I update it every time I receive new data?
You need to make the pivot table dynamic to change in data by using the offset formula .
I can't download the data used for this video. Help me out,please.
Not tried it yet but when you create the graph you use data linked to the pivot table. When you “=“ to a pivot it returns “Getpivotdata….” Then your video changes to “=xx”.
I presume you turned off the getpivotdata option (generally not advised - better to link the formula to the cells by replacing the link in quotation marks)
Can you confirm that this was done by a bit of editing that we didn’t see how that switched please?
If you pause the video you can see it returns the pivot table string for a second before changing
TIA
nice video
Great dashboard, may I use the dataset for my portfolio project?
is the "last update Jan 2024 date" dynamic ? and how did you add it please?
Perfect
can i add this in my resume ?
What course included creating dashboard
How to put checkbox under insert tab -> cell
controls? Mine is not visible in the ribbon?
Nice ❤
How u get the last updated month of text box
I am not able to perform Ctrl R and Ctrl D when u present that data by beverage brand and retailers in dashboard !!
Any Help please
Great as always ! Thanks
Need your support who to filter a pivot table on online excel sheet :)
I can't get a formula to come up in a text box like you did. It just shows the text of " =Data!E104 " that I typed into the text box. How do you get a formula in a text box??
How to deal with allowing the user to refresh pivot table data if the dataset is updated?
Bravo
You did not explain how to add that last update field. You advanced it too fast 😂
how
how can we publish this dashboard on our website?
I cannot proceed to the next step you didn't show us how to add another table
on 11:58, why it says reference isn't valid. i have tried many times btw
Pls i need dataset for this please
I got stuck on the hot keys because they don’t work on my computer
waiting for get hired for Accounts or Data Analyst work 😢
i tried to do it but the chart did not have the dynamic affect , why?
I'm wondering the same, cause he didn't show how to connect it to the data he use to made the chart, cause it didn't do it from the table, it came from the data he copy from the table 4
I think his calculation for average price per unit at 05:25 is incorrect. He took the average of all the prices, instead of a weighted average price per unit which should take the sum of all sales divided by the sum of all units. This would give you a value of $0.48 rather than $0.45. Otherwise, an excellent explanation.
HNY!
سلام کنجی عزیز
ممنون که فایل اکسل رو برای ویدیوتون گذاشتین.
Miller Jose Thomas Richard Garcia Michael