Make an Interactive Excel Dashboard in 4 Simple Steps!

  Рет қаралды 168,396

Kenji Explains

Kenji Explains

Күн бұрын

Make a Dynamic Excel Dashboard in 4 simple steps.
👉 Take our Excel for Business & Finance Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this tutorial, we'll make this beautiful, interactive Excel dashboard in four simple steps in just 20 minutes. First, we'll set up the dashboard structure using Excel shapes and images. Then, we'll look at the dataset and analyze it with pivot tables to get the relevant numbers. Third, we'll build the right charts and visuals. These include some KPIs (key performance indicators), tables, and charts such as a combo chart. Finally, we'll create pivot table slicers to make the whole dashboard dynamic.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​​ - Step 1: Dashboard Structure
4:17​ - Step 2: Data Analysis
9:08​ - Step 3: Visuals (Charts, KPIs and Tables)
16:14​ - Step 4: Make the Dashboard Dynamic with Slicers
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 106
@KenjiExplains
@KenjiExplains 5 ай бұрын
👉 Take our Excel for Business & Finance Course here: www.careerprinciples.com/courses/excel-for-business-finance
@fatokiadeola8338
@fatokiadeola8338 4 ай бұрын
Can i have discount code please
@EmranAfghan-le8vb
@EmranAfghan-le8vb 18 күн бұрын
how I can download the link?
@KenjiExplains
@KenjiExplains 5 ай бұрын
happy new year everyone! Thanks for watching these videos :)
@naquibataee8235
@naquibataee8235 5 ай бұрын
Thank you Kenji. Love to you from Afghanistan ❤️
@camlex6310
@camlex6310 5 ай бұрын
Thank you for all the great videos the past year!!
@Cheeseandchili
@Cheeseandchili 3 ай бұрын
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 3 ай бұрын
That’s amazing congratulations!! Thank you for your lovely comment 👍
@diemtrangpham674
@diemtrangpham674 4 күн бұрын
I am from VietNam, thank you for your vidieos, you look very handsome between Europe and Asia😄
@tugcev.8992
@tugcev.8992 26 күн бұрын
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!!
@user-oi2rf2dj3z
@user-oi2rf2dj3z 4 ай бұрын
Excellent Kenji. Thanks for teaching
@shreyatiwari4985
@shreyatiwari4985 14 сағат бұрын
Very very nice, thank you so much :)
@GoodThrilling
@GoodThrilling 2 ай бұрын
Thanks, Kenji for your explanations
@LordBransty
@LordBransty 3 ай бұрын
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!
@bounyoothammavong5712
@bounyoothammavong5712 2 ай бұрын
Great tutorial and helpful for me. Thanks so much Kenji!
@user-ix4wg7if7w
@user-ix4wg7if7w 4 ай бұрын
Nice. thanks for sharing your knowledge. God bless you Kenji...
@tejasd1980
@tejasd1980 2 ай бұрын
Thank you Kenji, excellent dashboard
@n101fm
@n101fm 4 ай бұрын
Super and easy explained! Thanks a lot
@digvijayreviewsystem
@digvijayreviewsystem 5 ай бұрын
Thanks for such amazing dashboard with detailed .
@magdahassib694
@magdahassib694 5 ай бұрын
Thanks 👍 you always present new and wonderful information
@alexrosen8762
@alexrosen8762 5 ай бұрын
Great tutorial in every sense 👌
@cooperranu3606
@cooperranu3606 4 ай бұрын
Excellent. Thank you.
@TheKotsola
@TheKotsola 26 күн бұрын
Great stuff! Simplified.
@tuzaguilar4201
@tuzaguilar4201 Ай бұрын
Wow. That was pretty good. Thank you!
@Mark-gz9si
@Mark-gz9si 5 ай бұрын
Just what I needed, Kenji! Thanks!
@KenjiExplains
@KenjiExplains 5 ай бұрын
lets go!
@alecseidman5601
@alecseidman5601 5 ай бұрын
Your videos have been very helpful for me while starting in analytics, thanks Kenji!
@sheethalg
@sheethalg 5 ай бұрын
This was a great dashboard tutorial and just what I needed. Thanks
@KenjiExplains
@KenjiExplains 5 ай бұрын
Glad it helped!
@ivystutorial
@ivystutorial 2 ай бұрын
You make the most beautiful Excel dashboards 😫❤
@adilfarhan6704
@adilfarhan6704 Ай бұрын
THANK YOU KENJI LOTS OF RESPECT FROM KERALA INDIA
@camlex6310
@camlex6310 5 ай бұрын
Very cool dashboard!!
@antoniop.3586
@antoniop.3586 5 ай бұрын
Awesome video, as usual. Thank you very much and congratulations!
@KenjiExplains
@KenjiExplains 5 ай бұрын
Thank you!
@Godsown_vessel
@Godsown_vessel 5 ай бұрын
Thank you Kenji.... You have made my journey in the world of analytics very interesting. 😊😊
@KenjiExplains
@KenjiExplains 5 ай бұрын
Happy to hear that!
@patriciapetri4792
@patriciapetri4792 5 ай бұрын
Awesome work. Thank you!
@KenjiExplains
@KenjiExplains 5 ай бұрын
Glad you liked it!
@TengsWorldOfficial
@TengsWorldOfficial Ай бұрын
Thank you so much this is so helpful.
@souviksengupta2873
@souviksengupta2873 4 ай бұрын
Excellent presentation 👌👌👌
@user-gs5wr3wn5f
@user-gs5wr3wn5f 4 ай бұрын
excellent tutorial
@bchizzle8094
@bchizzle8094 5 ай бұрын
Love how clearly you make and present your videos - super informative and useful
@user-sf2dd8kn3i
@user-sf2dd8kn3i 3 ай бұрын
really helpful thank youu
@rafayhussain4171
@rafayhussain4171 5 ай бұрын
This Is valuable for Professional bodies like ACCA , CA
@therainsoundmix101
@therainsoundmix101 Ай бұрын
Execellent surely i want to learn more great video
@blessedowo1958
@blessedowo1958 5 ай бұрын
Thank you. Happy new year :3
@KenjiExplains
@KenjiExplains 5 ай бұрын
Happy new year!
@xllearner
@xllearner 5 ай бұрын
Would you please make a video on combining three workbooks with some additional columns in or two of the files? Thank Kenji.
@tsogtooezs
@tsogtooezs Ай бұрын
Thank you guy
@usmnichols8636
@usmnichols8636 5 ай бұрын
Kenji Is an Excel *GOD*
@contactayyub
@contactayyub 5 ай бұрын
Great dashboard, may I use the dataset for my portfolio project?
@user-ym3gc7bs4c
@user-ym3gc7bs4c 4 ай бұрын
nice and thanks
@kramer20032
@kramer20032 2 ай бұрын
that was great!!!! but how do you put that last formula (last updated)?
@gebreeyesusaregawi
@gebreeyesusaregawi 25 күн бұрын
it is very nice and very impressive
@mohamedtalaat5836
@mohamedtalaat5836 5 ай бұрын
As usual, awesome content regarding copilot I have office 365 still now didn't appear in the the ribbon
@shirlyliu8334
@shirlyliu8334 4 ай бұрын
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!
@mohamedtalaat5836
@mohamedtalaat5836 5 ай бұрын
Perfect
@kimwullems
@kimwullems 5 ай бұрын
Thanks!!! How can i keep updating my dashboard with new data?
@user-ix4wg7if7w
@user-ix4wg7if7w 4 ай бұрын
Thanks.
@mjmousavin6865
@mjmousavin6865 21 күн бұрын
سلام کنجی عزیز ممنون که فایل اکسل رو برای ویدیوتون گذاشتین.
@ragulmarley4900
@ragulmarley4900 5 ай бұрын
U did video 20 mins i try this more than one hour to do this dashboard really helpful one
@manuelvega-arango599
@manuelvega-arango599 5 ай бұрын
Great as always ! Thanks
@williampowell3378
@williampowell3378 5 ай бұрын
AWESOME
@KenjiExplains
@KenjiExplains 5 ай бұрын
Thanks 🤗
@user-qu4hm5qx6s
@user-qu4hm5qx6s 5 ай бұрын
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
@kevindebeer4773
@kevindebeer4773 5 ай бұрын
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 5 күн бұрын
No
@Joyokhomina55
@Joyokhomina55 4 ай бұрын
Nice ❤
@kausarsayyed7552
@kausarsayyed7552 15 күн бұрын
nice video
@syedarifzaidy
@syedarifzaidy 4 ай бұрын
Bravo
@BNLien
@BNLien 5 ай бұрын
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 5 ай бұрын
hey, thanks for your interest. If you don't mind, please ask any questions to info@careerprinciples.com
@Sushiswap956
@Sushiswap956 3 ай бұрын
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 😎
@user-nj1fy1ow7y
@user-nj1fy1ow7y 2 ай бұрын
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.
@afterieffectsi8652
@afterieffectsi8652 Ай бұрын
can i add this in my resume ?
@gebreeyesusaregawi
@gebreeyesusaregawi 25 күн бұрын
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?
@2dope4kidzclothing10
@2dope4kidzclothing10 3 ай бұрын
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 3 ай бұрын
Copy the table but change the field BRAND to RETAILER for the rows
@lateefameza3958
@lateefameza3958 Ай бұрын
@@GhostGuitars thank you that helped me so much!
@janalgos
@janalgos 5 ай бұрын
How to deal with allowing the user to refresh pivot table data if the dataset is updated?
@Drizzle430
@Drizzle430 4 ай бұрын
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
@eddieclarke-edwards9939
@eddieclarke-edwards9939 2 ай бұрын
Great dashboard Kenji, but how do I update it every time I receive new data?
@dishant_7
@dishant_7 Ай бұрын
You need to make the pivot table dynamic to change in data by using the offset formula .
@ahmatmarsaleh783
@ahmatmarsaleh783 5 күн бұрын
Need your support who to filter a pivot table on online excel sheet :)
@Beatrice_129
@Beatrice_129 14 күн бұрын
is the "last update Jan 2024 date" dynamic ? and how did you add it please?
@satyajeet7633
@satyajeet7633 Ай бұрын
How u get the last updated month of text box
@ephraimekong6697
@ephraimekong6697 3 ай бұрын
I can't download the data used for this video. Help me out,please.
@jboag4631
@jboag4631 2 ай бұрын
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
@princeheusen3723
@princeheusen3723 Ай бұрын
How to put checkbox under insert tab -> cell controls? Mine is not visible in the ribbon?
@Rex-Solis
@Rex-Solis 5 күн бұрын
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
@ithinkthereforeiam2592
@ithinkthereforeiam2592 Ай бұрын
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??
@amalmuhamm8477
@amalmuhamm8477 4 күн бұрын
i tried to do it but the chart did not have the dynamic affect , why?
@elanebabemanganaan1215
@elanebabemanganaan1215 Ай бұрын
I cannot proceed to the next step you didn't show us how to add another table
@melatemusic2581
@melatemusic2581 4 ай бұрын
You did not explain how to add that last update field. You advanced it too fast 😂
@elanebabemanganaan1215
@elanebabemanganaan1215 Ай бұрын
how
@shukuramartin5495
@shukuramartin5495 3 ай бұрын
I got stuck on the hot keys because they don’t work on my computer
@muhammadzulqarnain7717
@muhammadzulqarnain7717 5 ай бұрын
waiting for get hired for Accounts or Data Analyst work 😢
@willzinner8813
@willzinner8813 5 ай бұрын
HNY!
@naquibataee8235
@naquibataee8235 5 ай бұрын
If you see this comment you are not first
@KenjiExplains
@KenjiExplains 5 ай бұрын
Lol
@siimkask14
@siimkask14 4 ай бұрын
I never am
@altair769
@altair769 19 күн бұрын
Hahaha!
@aliyuyahya4352
@aliyuyahya4352 5 ай бұрын
Job well done sir! Thank you so much for all these videos, you always makes us proud... Please sir can you help me with either your WhatsApp number or e-mail address for additional details. Once again thank you
@lloydmafela8478
@lloydmafela8478 3 ай бұрын
Hmmmm
@TikTok-vk5zm
@TikTok-vk5zm 4 ай бұрын
i will try to make a dashboard tomorrow in my workplace
Data Analysis Project in Excel (3-Step Framework)
13:53
Kenji Explains
Рет қаралды 70 М.
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 176 М.
UFC Vegas 93 : Алмабаев VS Джонсон
02:01
Setanta Sports UFC
Рет қаралды 219 М.
Smart Sigma Kid #funny #sigma #comedy
00:19
CRAZY GREAPA
Рет қаралды 20 МЛН
Tom & Jerry !! 😂😂
00:59
Tibo InShape
Рет қаралды 47 МЛН
Can teeth really be exchanged for gifts#joker #shorts
00:45
Untitled Joker
Рет қаралды 15 МЛН
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,3 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 304 М.
Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)
18:57
MyOnlineTrainingHub
Рет қаралды 98 М.
Try This New Formula Instead of Pivot Tables
12:08
Kenji Explains
Рет қаралды 219 М.
Build the ULTIMATE Excel Dashboard from Scratch
20:42
Kenji Explains
Рет қаралды 413 М.
How to create Power BI Dashboard (Report) in 7 Minutes | @PavanLalwani
12:55
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 194 М.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Рет қаралды 769 М.
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
Kenji Explains
Рет қаралды 400 М.
UFC Vegas 93 : Алмабаев VS Джонсон
02:01
Setanta Sports UFC
Рет қаралды 219 М.