Make an Interactive Excel Dashboard in 4 Simple Steps!

  Рет қаралды 342,681

Kenji Explains

Kenji Explains

Күн бұрын

Пікірлер
@KenjiExplains
@KenjiExplains 11 ай бұрын
👉 Take our Excel for Business & Finance Course here: www.careerprinciples.com/courses/excel-for-business-finance
@fatokiadeola8338
@fatokiadeola8338 10 ай бұрын
Can i have discount code please
@EmranAfghan-le8vb
@EmranAfghan-le8vb 6 ай бұрын
how I can download the link?
@DoeBlapoh-gh1mk
@DoeBlapoh-gh1mk 3 ай бұрын
yes
@wepnjegerald7554
@wepnjegerald7554 2 ай бұрын
how do I download the sample data sir?
@Cheeseandchili
@Cheeseandchili 10 ай бұрын
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!
@KenjiExplains
@KenjiExplains 10 ай бұрын
That’s amazing congratulations!! Thank you for your lovely comment 👍
@JanetOluwadiya-gk6su
@JanetOluwadiya-gk6su 6 күн бұрын
How can I get the exercise file?
@LeanneCHE
@LeanneCHE 2 ай бұрын
This was honestly one of the most useful tutorials I've ever used. Thank you!
@xllearner
@xllearner 11 ай бұрын
Would you please make a video on combining three workbooks with some additional columns in or two of the files? Thank Kenji.
@LordBransty
@LordBransty 9 ай бұрын
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!
@dianalionel9662
@dianalionel9662 3 ай бұрын
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.
@tugcev.8992
@tugcev.8992 6 ай бұрын
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!!
@calvenyankee2078
@calvenyankee2078 2 ай бұрын
Thanks!
@KenjiExplains
@KenjiExplains 2 ай бұрын
Thank you for supporting the channel! Hopefully I can make more useful videos for you :)
@usmnichols8636
@usmnichols8636 11 ай бұрын
Kenji Is an Excel *GOD*
@BNLien
@BNLien 11 ай бұрын
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
@KenjiExplains
@KenjiExplains 11 ай бұрын
hey, thanks for your interest. If you don't mind, please ask any questions to info@careerprinciples.com
@GoodThrilling
@GoodThrilling 8 ай бұрын
Thanks, Kenji for your explanations
@bchizzle8094
@bchizzle8094 11 ай бұрын
Love how clearly you make and present your videos - super informative and useful
@2dope4kidzclothing10
@2dope4kidzclothing10 10 ай бұрын
Your video is quite thorough, and I grasp the content well. However, I'm seeking clarification on the section concerning Amazon data transfer, specifically at the 6:25 mark. I'm uncertain about the process involved in that part. Could you provide guidance on how to achieve that step? Your assistance in understanding this aspect would be greatly appreciated.
@GhostGuitars
@GhostGuitars 9 ай бұрын
Copy the table but change the field BRAND to RETAILER for the rows
@lateefameza3958
@lateefameza3958 7 ай бұрын
@@GhostGuitars thank you that helped me so much!
@tejasd1980
@tejasd1980 8 ай бұрын
Thank you Kenji, excellent dashboard
@ivystutorial
@ivystutorial 8 ай бұрын
You make the most beautiful Excel dashboards 😫❤
@Sushiswap956
@Sushiswap956 9 ай бұрын
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 😎
@PrateekTripathi-k5p
@PrateekTripathi-k5p 8 ай бұрын
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.
@ramasme2960
@ramasme2960 16 күн бұрын
Thank you, great tutorial 👍 👌
@kevindebeer4773
@kevindebeer4773 11 ай бұрын
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?
@gregharrison7654
@gregharrison7654 6 ай бұрын
No
@kramer20032
@kramer20032 8 ай бұрын
that was great!!!! but how do you put that last formula (last updated)?
@1979rehan
@1979rehan 2 ай бұрын
You are super, thanks for sharing one of the best content over the web !
@alecseidman5601
@alecseidman5601 11 ай бұрын
Your videos have been very helpful for me while starting in analytics, thanks Kenji!
@McPixelWizard
@McPixelWizard 3 ай бұрын
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.
@souviksengupta2873
@souviksengupta2873 10 ай бұрын
Excellent presentation 👌👌👌
@waleadeniji6959
@waleadeniji6959 5 ай бұрын
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
@Godsown_vessel
@Godsown_vessel 11 ай бұрын
Thank you Kenji.... You have made my journey in the world of analytics very interesting. 😊😊
@KenjiExplains
@KenjiExplains 11 ай бұрын
Happy to hear that!
@CristinaManongsong
@CristinaManongsong Ай бұрын
Hi, may I ask why the analyze not working in text box?
@Mark-gz9si
@Mark-gz9si 11 ай бұрын
Just what I needed, Kenji! Thanks!
@KenjiExplains
@KenjiExplains 11 ай бұрын
lets go!
@alexrosen8762
@alexrosen8762 11 ай бұрын
Great tutorial in every sense 👌
@blessedowo1958
@blessedowo1958 11 ай бұрын
Thank you. Happy new year :3
@KenjiExplains
@KenjiExplains 11 ай бұрын
Happy new year!
@lucaslegz
@lucaslegz 4 ай бұрын
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?
@RanuSrivastava-b1u
@RanuSrivastava-b1u 2 ай бұрын
Thank you very much. Such a wonderful and insightful video yet very simple to understand
@antoniop.3586
@antoniop.3586 11 ай бұрын
Awesome video, as usual. Thank you very much and congratulations!
@KenjiExplains
@KenjiExplains 11 ай бұрын
Thank you!
@shirlyliu8334
@shirlyliu8334 10 ай бұрын
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!
@KRISHIKACHANDWANI-w5u
@KRISHIKACHANDWANI-w5u Ай бұрын
Thank you very much.. The explanation was very useful..
@rafayhussain4171
@rafayhussain4171 11 ай бұрын
This Is valuable for Professional bodies like ACCA , CA
@anwerbagdadi8500
@anwerbagdadi8500 29 күн бұрын
Excellent work
@Fthydsdhuu
@Fthydsdhuu 4 ай бұрын
What formula should we use. If we want to repeat the same word but vertically
@Drizzle430
@Drizzle430 10 ай бұрын
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
@ironman25087
@ironman25087 2 ай бұрын
love you bro!
@kimwullems
@kimwullems 11 ай бұрын
Thanks!!! How can i keep updating my dashboard with new data?
@magdahassib694
@magdahassib694 11 ай бұрын
Thanks 👍 you always present new and wonderful information
@gebreeyesusaregawi
@gebreeyesusaregawi 6 ай бұрын
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?
@uptowndesmond6708
@uptowndesmond6708 2 ай бұрын
Amazing work.
@Atifilyas-y9e
@Atifilyas-y9e 5 ай бұрын
your teaching style is awesome brother keep shine
@PreethyKarthik
@PreethyKarthik 10 ай бұрын
Excellent Kenji. Thanks for teaching
@mohamedtalaat5836
@mohamedtalaat5836 11 ай бұрын
As usual, awesome content regarding copilot I have office 365 still now didn't appear in the the ribbon
@n101fm
@n101fm 10 ай бұрын
Super and easy explained! Thanks a lot
@m2mdohkun
@m2mdohkun 3 ай бұрын
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!
@tijaniismaila8707
@tijaniismaila8707 27 күн бұрын
Thanks for the video. how can i download the data set used
@peterzhu8123
@peterzhu8123 5 ай бұрын
You are actually life saving
@camlex6310
@camlex6310 11 ай бұрын
Very cool dashboard!!
@adilfarhan6704
@adilfarhan6704 7 ай бұрын
THANK YOU KENJI LOTS OF RESPECT FROM KERALA INDIA
@sheethalg
@sheethalg 11 ай бұрын
This was a great dashboard tutorial and just what I needed. Thanks
@KenjiExplains
@KenjiExplains 11 ай бұрын
Glad it helped!
@HanifRiansyah
@HanifRiansyah 9 ай бұрын
really helpful thank youu
@patriciapetri4792
@patriciapetri4792 11 ай бұрын
Awesome work. Thank you!
@KenjiExplains
@KenjiExplains 11 ай бұрын
Glad you liked it!
@mbalimthethwa6054
@mbalimthethwa6054 5 ай бұрын
Hi Kenjii you are the best.
@ragulmarley4900
@ragulmarley4900 11 ай бұрын
U did video 20 mins i try this more than one hour to do this dashboard really helpful one
@cooperranu3606
@cooperranu3606 10 ай бұрын
Excellent. Thank you.
@FaisalHussain-i6i
@FaisalHussain-i6i 10 ай бұрын
excellent tutorial
@osuhonrebecca8446
@osuhonrebecca8446 Ай бұрын
Please,I have a question those shapes are they called summary cards or score card
@DeepakSejwal-n8s
@DeepakSejwal-n8s Күн бұрын
Icannot see the data tab on the downloaded file used in this vedio...? Kenji can you please help provide the data.
@eddieclarke-edwards9939
@eddieclarke-edwards9939 8 ай бұрын
Great dashboard Kenji, but how do I update it every time I receive new data?
@dishant_7
@dishant_7 8 ай бұрын
You need to make the pivot table dynamic to change in data by using the offset formula .
@AlisaRay-j2r
@AlisaRay-j2r 11 ай бұрын
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
@gemestrada9666
@gemestrada9666 3 ай бұрын
Hi Kenjie, can you please provide dashboard for training completion, most of the dashboards in KZbin are about sales.
@digvijayreviewsystem
@digvijayreviewsystem 11 ай бұрын
Thanks for such amazing dashboard with detailed .
@Slaayb1055
@Slaayb1055 6 ай бұрын
is the "last update Jan 2024 date" dynamic ? and how did you add it please?
@teopistohallazgo
@teopistohallazgo 10 ай бұрын
Nice. thanks for sharing your knowledge. God bless you Kenji...
@contactayyub
@contactayyub 11 ай бұрын
Great dashboard, may I use the dataset for my portfolio project?
@imranamir3852
@imranamir3852 6 ай бұрын
on 11:58, why it says reference isn't valid. i have tried many times btw
@bounyoothammavong5712
@bounyoothammavong5712 8 ай бұрын
Great tutorial and helpful for me. Thanks so much Kenji!
@fakhrulnawawi9681
@fakhrulnawawi9681 4 ай бұрын
Crystal clear.. thanks!!
@ITGate24h
@ITGate24h 4 ай бұрын
AMAZING. Nice video. Thank you
@JafarAman-u3r
@JafarAman-u3r 5 күн бұрын
did you get this data from keggle?
@ephraimekong6697
@ephraimekong6697 9 ай бұрын
I can't download the data used for this video. Help me out,please.
@infamousprince88
@infamousprince88 Ай бұрын
Is this an example of a business scorecard? Trying to find an example to mimick for a business use case in a similar industry.
@tonyjacobs465
@tonyjacobs465 28 күн бұрын
I need to sort data from an input form to a data sheet and then, with the results, split the data into another worksheet sorted by building, but I want to export the entire line, not just one word... I have tried everything but can sort the entire line .. any help or tips please.. thanks
@sammywondu5486
@sammywondu5486 4 ай бұрын
So nice and fit for students
@TheKotsola
@TheKotsola 6 ай бұрын
Great stuff! Simplified.
@williampowell3378
@williampowell3378 11 ай бұрын
AWESOME
@KenjiExplains
@KenjiExplains 11 ай бұрын
Thanks 🤗
@tuzaguilar4201
@tuzaguilar4201 7 ай бұрын
Wow. That was pretty good. Thank you!
@shreyatiwari4985
@shreyatiwari4985 6 ай бұрын
Very very nice, thank you so much :)
@avikmondal7440
@avikmondal7440 2 ай бұрын
There are some problems in the invoice date I am using Excel 2010 and there is no month wise or quarter wise or year wise in the column label
@princeheusen3723
@princeheusen3723 7 ай бұрын
How to put checkbox under insert tab -> cell controls? Mine is not visible in the ribbon?
@jariraziz2493
@jariraziz2493 3 ай бұрын
the best explain
@satyajeet7633
@satyajeet7633 7 ай бұрын
How u get the last updated month of text box
@Rex-Solis
@Rex-Solis 6 ай бұрын
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
@jboag4631
@jboag4631 8 ай бұрын
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
@chirumeadmiretarisirayi6196
@chirumeadmiretarisirayi6196 4 ай бұрын
Great staff
@rosacenteno3194
@rosacenteno3194 3 ай бұрын
What course included creating dashboard
@diemtrangpham674
@diemtrangpham674 6 ай бұрын
I am from VietNam, thank you for your vidieos, you look very handsome between Europe and Asia😄
@afterieffectsi8652
@afterieffectsi8652 7 ай бұрын
can i add this in my resume ?
@TengsWorldOfficial
@TengsWorldOfficial 7 ай бұрын
Thank you so much this is so helpful.
@Joyokhomina55
@Joyokhomina55 10 ай бұрын
Nice ❤
@therainsoundmix101
@therainsoundmix101 7 ай бұрын
Execellent surely i want to learn more great video
@ziarehman288
@ziarehman288 5 ай бұрын
Super report creation
@teopistohallazgo
@teopistohallazgo 10 ай бұрын
Thanks.
@tameratabate-k7t
@tameratabate-k7t 10 ай бұрын
nice and thanks
@mahdihabibi8959
@mahdihabibi8959 9 күн бұрын
I can not find the option quarter (invoice date )in the list
@lucidbeing618
@lucidbeing618 Ай бұрын
Hi all and everyone, just a real quick query, does anyone know if it is possible to make a chart transparent on iOS device? Thank you in advance👌
@ithinkthereforeiam2592
@ithinkthereforeiam2592 7 ай бұрын
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??
Make a Professional Excel Dashboard From Scratch Using Real-World Data
21:28
Build the ULTIMATE Excel Dashboard from Scratch
20:42
Kenji Explains
Рет қаралды 435 М.
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 54 МЛН
Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)
18:57
MyOnlineTrainingHub
Рет қаралды 152 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 385 М.
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 491 М.
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 463 М.
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 430 М.
Telling a Story with Data | Dashboard Build Demo
13:41
Maven Analytics
Рет қаралды 158 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 347 М.
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,6 МЛН