Build Awesome Excel Visuals to Grab Anyone's Attention

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

Күн бұрын

Create awesome excel excel charts and visuals to impress anyone!
👉 Get 20% OFF our Excel Course with code XMAS20 at checkout: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/639c82...
Learn to make advanced excel hearts and turn int into a nn awesome dashboard to impress anyone. First, we'll make a Gantt chart, which will act as the project roadmap. Then, we'll make a table, where we can see the trendiness (sparklines) and conditional formatting (for the growth rates). In step 3, we'll make gauge charts, which tell su the satisfaction scores for employees and customers. In step 4, we'll make a budget vs actuals chart where we assess our expenses. Lastly, we'll make a waterfall charts to visualise our employee headcount change in the past year.
LEARN:
📈 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 - Intro
0:50 - Gantt chart (Project Roadmap)
4:41 - Table format & Sparklines
7:54 - Gauge Chart
13:10 - Budget vs. Actuals Chart
15:38 - Waterfall Chart
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 138

@KenjiExplains Жыл бұрын

👉 Get 20% OFF our Excel Course with code XMAS20 at checkout: www.careerprinciples.com/courses/excel-for-business-finance

@solomonbhandari-young4154 Жыл бұрын

Amazing

@bolumekenejoan6360 5 ай бұрын

How much is the current cost of the Excel file

@solomonnkwagu1271 Жыл бұрын

This guy can teach... He makes it look very understandable, practical and easy to follow.

@crickcence_14 9 ай бұрын

One of the best Excel expert I have seen . Thankyou for making everyone as you😊

@vijayarjunwadkar Жыл бұрын

Awesome tutorial Kenji! Learnt so much about charting in this one video itself! Thank you! I am definitely interested in Power BI videos too!

@syahrulkhannn Жыл бұрын

Thanks Kenji, i learn a lot from your videos for 3 months, can't wait to see another excel videos tips & tricks.

@FaheemaHaneef Жыл бұрын

You are doing an excellent job. Learned a lot from your videos. your explanation method is very clear and easy. Thanks

@user-fr6lj8lp9i Жыл бұрын

Great tutorial video Kenji! I wish I had ran into your channel last year. We are currently transitioning all reporting from Excel to PowerBI & I am definitely interested in learning how to replicate this same dashboard - especially the gauges in PowerBI. Looking forward to watching your other videos!

@dantherman4202 Жыл бұрын

That's interesting, are you going to be doing all data cleaning and transforming in PowerBI/power query now, or will you just be using PowerBI for visualization? I wonder if a lot of companies are making this switch. I'm interested to hear your companies reasoning!

@mackyty-v5182 Жыл бұрын

This is amazing!!!! Going to be a big help on my current role! Thank you!

@newday8074 Жыл бұрын

The best on youtube, effective and straight to the point with awsome tips

@andreugiro2807 Жыл бұрын

Thanks Kenji! I liked a lot Gauge Charts part!

@Cireroca Жыл бұрын

Muchas gracias ken. ive learned a lot from you. Im considered mysel a rokie to amateur 😅😅 btw, Im an accountant but i used to work with advanced accounting templates so no need to learn about formating. Just copy paste the data. But when i transfer to new company, i was shocked theyre using very rokie template. Wish you next video is accounting excel from bookkeep to FS. 😅

@danielenotomalta9705 Жыл бұрын

Thanks Kenji, wonderful video as usual! Please consider making some content with Power BI. Cheers!

@andrewt207 10 ай бұрын

@kenjiexplains I like the Gauge chart. Is there a way to change the gauge arrow so that the center of it points to the value rather than the trailing edge? It's a small thing but at the 0, 50% and 100% points it just looks a little 'off'. As the width is 2, logically deducting 0.01 from the 'point' value would give the arrows midpoint but, for a zero value (this works for every value except 0), Excel seems to add the 0.01 rather than deleting it.

@sarahyambao6454 Жыл бұрын

One day when I have the money, I'm sure taking the class would be worth it! :) In the mean time, thank you so much!

@gogigogi8835 Жыл бұрын

Thanks @Kenji Explains for great video! I would like to query 10:48 of your video and ask if there is any option to change chart type on Macbook excel (without installing windows on Mac). Thanks!

@MgGlobal Жыл бұрын

Thank you for Sharing Kenji you are very smart I love it

@austinoma7903 9 ай бұрын

Thank you so much ,I learnt so much in few minutes

@tauraizambezi Жыл бұрын

Hi Kenji, Thank you for the video and the education. Muach appreciated! However, I could not download the excel document for further practice. Could you help.

@ojeladeadewale7331 2 ай бұрын

Thanks so much for the lecture

@MarcinKozowski-bd6kv Жыл бұрын

Great video!!!Many thanks. Which Excel are you using? Mac or Windows?

@muddasar3060 2 ай бұрын

Great tips for short span of time.... and great learning experince thank you kenjji

@reginaldsaunders7117 11 ай бұрын

Very nicely done!!

@mjestvofficial7792 9 ай бұрын

Thank you Sir Kenji. Amazing tutorial

@Hello-bn2yc 9 ай бұрын

Great Video Kenji ... Loved it

@m.ssharma535 11 ай бұрын

Waterfall chart is excellent and useful for stock intrinsic value and sources of it. I am trying to automate it.

@fbi1980m Жыл бұрын

Nice job. Thank you

@samarahmad4784 Жыл бұрын

Marvelous job Boss

@henryvelasco9860 Жыл бұрын

Your language is perfect particularly your enunciation

@user-st7jl9ht5o 4 ай бұрын

Thank you very much!

@ChasingMyLiberty Жыл бұрын

could you possibly make a video over pitchbooks? I would really like more information on them. Would it matter if I made one for an interview? Thank you for everything. May the Force be with you.

@kameshsubramanian2553 8 ай бұрын

Great video Kenji. Regarding the 2nd part (Sales by Country ($ thousands)), conditional formatting doesn't work when percentage instead of number is selected. Can this be made to work with percentage ?

@ayomide6257 2 ай бұрын

Thank you Kenji

@INAdnyana Жыл бұрын

great job Kenji..

@fireman194 Жыл бұрын

This was great.

@gayaa6490 11 ай бұрын

Thanks, Kenji! :)

@mohamadfaisalgunawan5934 Жыл бұрын

your video is so excellent, and I would like to see the power BI tutorial as well

@Sarah-db3lz Күн бұрын

YOURE AMAZING

@hnquran1002 9 ай бұрын

Thank you bro😊

@user-qu2xy8uw8c Жыл бұрын

Very nice explanation 🎉

@kirandeepkaur7470 9 ай бұрын

you are an amazing tutor

@sukiwong1219 Жыл бұрын

I would like to see the Tableau video too.Thank you so much!

@rotethongvanit 7 ай бұрын

Well done!

@jim5400 Жыл бұрын

I think I love you 😂. Great tutorial!

@hisokaamorou4211 Жыл бұрын

Awesome Kenji! great video!

@KenjiExplains Жыл бұрын

Glad you enjoyed it!

@Moglikaur Жыл бұрын

what a great job .. very big thank you from India

@KenjiExplains Жыл бұрын

You are most welcome!

@cajinguy218 Жыл бұрын

Your video randomly showed in my feed… +1 subscriber. EXCELLENT video!

@mahnoorasif819 Жыл бұрын

Same

@MommyNel_Levi 2 ай бұрын

i did it, thanks🥰

@peterolawoye5715 Жыл бұрын

Thanks alot

@Heartsinmelody Жыл бұрын

Very very good.

@RadcliffeBromfield Жыл бұрын

Great job, but I recommend instead of the raw templates you can maybe add a sheet with the finished product so we can practice even with text instructions as some persons might not have that internet connectivity to watch all the duration of the videos but can follow offline. Respect and thanks

@LearnCapita Жыл бұрын

Splendid Splendid

@sagar9060 Жыл бұрын

Bro, very insightful videos especially your graphics. Please you tell me what softwares and apps you use to edit your videos?

@sunnindawg 2 ай бұрын

Good vid.

@jewelqueen5949 9 ай бұрын

Is there anyway to add the months, as well as the dates & be able to expand/collapse the months like in a pivot table? I don't believe so because it's a graph, but just asking. Thanks.

@theanxiousinvestor4508 5 ай бұрын

Great stuff but how do I create a gauge chart that occasionally has negative values? For example, the percentage change for a stock price for the day. Sometimes this will be positive and sometimes, if the stock is down on the day, this value will be negative. I'd like unchanged to be straight up with higher on the day to the right and lower on the day (and a negative value) to the left. Not sure if it's possible to make a slice of a pie chart with a negative value. Thanks.

@enriquesuch4917 Жыл бұрын

This is a very good video

@POLKING-TV Жыл бұрын

Hi, may I suggest do have a version of this tutorial on Google excelsheets

@vikasmishra134 Жыл бұрын

Thank You soo much for creating such a free learning video. Kenji

@jeaavery2273 Жыл бұрын

Yes I would like to see Power bi videos. I liked this one as well; really helpful.

@KenjiExplains Жыл бұрын

Noted! coming in 2023!

@jalalsafadi2621 Жыл бұрын

Thanks

@alessandrovinci4725 Жыл бұрын

Yes, PowerBI videos please

@hassanelfakey4708 Жыл бұрын

You're amazing

@zabashhd459 6 ай бұрын

Perfect

@user-jk5gg8mv6n 10 ай бұрын

Amazing

@iriswil Жыл бұрын

I need help creating a chart with some data that includes branches, accounts observed, errors, no errors, total accts. opened. Please!

@simonoganga9535 Жыл бұрын

Marvelous job Kenji. I like your thoroughly done charts.

@KenjiExplains Жыл бұрын

Thank you Simon!

@user-ic9ov5ss4v 10 күн бұрын

Thank U Kenji. I think this attached excel file is not correct one(start file visual.xlsx is an another video lecture). Would you please upload a correct file to your website?

@gurharkrishanbureau187 Жыл бұрын

Wonderfully explained. Pls share tutorial for power bi

@KenjiExplains Жыл бұрын

Will upload soon!

@krishnatripathi5461 Жыл бұрын

Awesome visuals man... Really good Do one with PowerBI if you can

@KenjiExplains Жыл бұрын

Thank you Krishna, it's on the way for the new year!

@krishnatripathi5461 Жыл бұрын

@@KenjiExplains Awesome... New Year Gift 🎁🎁

@solomonbhandari-young4154 Жыл бұрын

you always grab my attention

@vincentayugi5690 Жыл бұрын

More power bi videos please 😊

@liketwogrand 6 күн бұрын

Is the excel template available for download?

@harish0811240 Жыл бұрын

Great

@labelleaffairs 7 ай бұрын

Can we get the raw dataset for thid exercise? i mean the raw excel file complete dataset?

@coolasiandud3 Жыл бұрын

Hi, im trying to figure out how to make a column of data. say, I have a cell that changes in amount daily and I want to make a column and take the value of the original cell every month. ie, Jan 1st the first cell, then Feb 2nd the cell below, etc. thanks, can somebody help me.

@kunalsinha1119 Жыл бұрын

Interested for powerbi

@camlex6310 Жыл бұрын

Really cool!! And Merry Christmas :))

@KenjiExplains Жыл бұрын

Happy holidays!

@pkprasads Жыл бұрын

Cool

@MoneyBread22 Жыл бұрын

Great video, can you make a video on how to make a business model and plan in excel, Like Revenue plans, Cost, Budget, Marketing customer segments, etc. :D Also waiting for Power BI 😊

@KenjiExplains Жыл бұрын

I think this video I made is kind of what you're looking for: kzfaq.info/get/bejne/ncB2mdKavtGwXYk.html

@MoneyBread22 Жыл бұрын

@@KenjiExplains thanks Kenji 🙌

@tun-tunninc.6492 Жыл бұрын

Question. As a Jr. Analyst...what's the importance of a dashboard and how do u maintain it??

@chrysanth267 Жыл бұрын

Your manager's job is to run your department, and they typically can't sit there and get intimate with the data like you can. A dashboard is an often automated tool that easily communicates your granular understanding of a topic to your manager, so they can make impactful decisions. No more running to you at at all hours with random questions about the numbers, now they can find the answer themselves in the dashboard you maintain. Try searching "dashboard maintenance", or something like that into KZfaq.

@arthuroludotun4055 Жыл бұрын

Great video. Please do a Power BI tutorial

@KenjiExplains Жыл бұрын

Noted! thanks for your comment :)

@simonabikzer1439 Жыл бұрын

what is the 138% ? Gauge chart?

@siddharthmhaskar4420 2 ай бұрын

Can anyone please explain why the pie chart points all equal to 200 like if for 20% the gauge was 2 then rest was 178

@jeanpavan6816 Жыл бұрын

Super good as always but you do not explain where the 138 is coming from in the gauge presentation

@KenjiExplains Жыл бұрын

My bad! Basically the sum of all the ranges is 200%. So the 138% is 200%-2%-60%, where the 2% is the thickness of the line, and the 60% is the satisfaction score. Hope that makes sense.

@jeanpavan6816 Жыл бұрын

Perfect thanks

@Joeyleander27 Жыл бұрын

Merry Christmas Kenji

@KenjiExplains Жыл бұрын

Thank you Joey you too!

@KSMVideos Жыл бұрын

Good video but that donut chart was quite complicated.

@Trucpq 2 ай бұрын

So useful !!!

@jarodzillinger4731 Жыл бұрын

I could never get the colors to change in the waterfall chart, the fill color would only change the actual legend itself

@CookieMonstro21 3 ай бұрын

🤯🤯🤯🤯

@ferhatborj5551 Жыл бұрын

Crtl page down +ctrl page up do not work in excel + ^ and ' When cleared back

@A.Nahedd Жыл бұрын

Hi Kenji, the downloaded file is empty of charts.

@KenjiExplains Жыл бұрын

It’s a start file so you’re supposed to follow along and learn how to make the charts…

@michaelquach7046 Жыл бұрын

Gant chart all the way!

@KenjiExplains Жыл бұрын

Yes!

@maxmorris4562 Жыл бұрын

1:32

@hassan06ny Жыл бұрын

Power bi

@AllyAaaY 8 ай бұрын

My gauge does not move

@sebawagosh2356 Жыл бұрын

NONE of your FREE offering urls are working today?

@KenjiExplains Жыл бұрын

check your browser / desktop downloads they should all be there. No technical issues found on my side sorry

@azplamkata Жыл бұрын

@KenjiExplains Жыл бұрын

vamos!

@syaz_9763 Жыл бұрын

then i realize that put intermediate in Microsoft excel was a good decision since i know that i don't know about this hahahha

@victor_wang_1 Жыл бұрын

Don't put raw data on the same sheet as the visuals...

@SeVeN-os3jl 3 ай бұрын

Yeah it's weird

@faithukpeh8200 2 ай бұрын

Why?

@sudarshankukian1617 Жыл бұрын

Good range should be 75%, isn't it? Instead it says 25%.