Build Awesome Excel Visuals to Grab Anyone's Attention

[@KenjiExplains]

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

[@solomonbhandari-young4154]

Amazing

[@bolumekenejoan6360]

How much is the current cost of the Excel file

[@crickcence_14]

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

[@solomonnkwagu1271]

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

[@ProfessorRocky]

I love the quality of information you present. Thank you for sharing !

[@henryvelasco9860]

Your language is perfect particularly your enunciation

[@Farmermoses86]

Awesome tutorial. Your way of teaching is very simple and easy to follow

[@CristinaFernandez-d5t]

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!

[@cajinguy218]

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

[@mahnoorasif819]

Same

[@newday8074]

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

[@andreugiro2807]

Thanks Kenji! I liked a lot Gauge Charts part!

[@syahrulkhannn]

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

[@nmp369]

Very helpfull - thank 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!

[@김혁-i9s]

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?

[@kozukikarin2644]

That’s true

[@KenjiExplains]

Just fixed it my apologies!

[@LosAngeles-le2bf]

They look great!! I use Power Bi but sometimes need to use excel for those who don’t have a PBI license.

[@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!

[@austinoma7903]

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

[@INAdnyana]

great job Kenji..

[@muddasar3060]

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

[@gayaa6490]

Thanks, Kenji! :)

[@MgGlobal]

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

[@Moglikaur]

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

[@KenjiExplains]

You are most welcome!

[@jeaavery2273]

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

[@KenjiExplains]

Noted! coming in 2023!

[@andrewt207]

@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.

[@simonoganga9535]

Marvelous job Kenji. I like your thoroughly done charts.

[@KenjiExplains]

Thank you Simon!

[@hisokaamorou4211]

Awesome Kenji! great video!

[@KenjiExplains]

Glad you enjoyed it!

[@Sarah-db3lz]

YOURE AMAZING

[@jim5400]

I think I love you 😂. Great tutorial!

[@mjestvofficial7792]

Thank you Sir Kenji. Amazing tutorial

[@rasikahewage-e7h]

Thank you very much!

[@rotethongvanit]

Well done!

[@samarahmad4784]

Marvelous job Boss

[@LearnCapita]

Splendid Splendid

[@reginaldsaunders7117]

Very nicely done!!

[@ayomide6257]

Thank you Kenji

[@kirandeepkaur7470]

you are an amazing tutor

[@ظافرعبدالله-د6د]

Very nice explanation 🎉

[@m.ssharma535]

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

[@fireman194]

This was great.

[@enriquesuch4917]

This is a very good video

[@tun-tunninc.6492]

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

[@Storygospel533]

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 KZbin.

[@FaheemaHaneef]

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

[@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

[@gurharkrishanbureau187]

Wonderfully explained. Pls share tutorial for power bi

[@KenjiExplains]

Will upload soon!

[@fbi1980m]

Nice job. Thank you

[@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 🎁🎁

[@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. 😅

[@mackyty-v5182]

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

[@hnquran1002]

Thank you bro😊

[@danielenotomalta9705]

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

[@vikasmishra134]

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

[@sukiwong1219]

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

[@theanxiousinvestor4508]

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.

[@camlex6310]

Really cool!! And Merry Christmas :))

[@KenjiExplains]

Happy holidays!

[@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!

[@Heartsinmelody]

Very very good.

[@alessandrovinci4725]

Yes, PowerBI videos please

[@kameshsubramanian2553]

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 ?

[@zabitaguliyeva9992]

Hello, Firstly thank you for such a informational tutorial, I wanted to practice with you but I couldn't find file I tried to download from link it was different file not related to this video

[@zabitaguliyeva9992]

PS it fixed when I try to download from mail thank u

[@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.

[@MommyNel_Levi]

i did it, thanks🥰

[@hassanelfakey4708]

You're amazing

[@MarcinKozowski-bd6kv]

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

[@jalalsafadi2621]

Thanks

[@prateekvarshney4826]

Thank you, for the video Kenji, however, I believe the sheet attached in the caption is incorrect.

[@KenjiExplains]

Just fixed it my apologies!!

[@peterolawoye5715]

Thanks alot

[@Surachetphunsawat]

Amazing

[@sunnindawg]

Good vid.

[@zabashhd459]

Perfect

[@mohamadfaisalgunawan5934]

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

[@kozukikarin2644]

The exercise file is wrong, i would be grateful if he had put the right one. Anyway thanks for the effort

[@POLKING-TV]

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

[@vincentayugi5690]

More power bi videos please 😊

[@jewelqueen5949]

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.

[@Trucpq]

So useful !!!

[@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

[@DươngNguyễnThanhThùy]

I can not see the raw file, the link at the description gave me a different file :

[@harish0811240]

Great

[@iriswil]

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

[@dwighty825]

Has anyone found the link to the proper excel file in order to better follow along and practice?

[@KenjiExplains]

Just fixed it my apologies!!

[@Joeyleander27]

Merry Christmas Kenji

[@KenjiExplains]

Thank you Joey you too!

[@labelleaffairs]

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

[@solomonbhandari-young4154]

you always grab my attention

[@liketwogrand]

Is the excel template available for download?

[@KenjiExplains]

yes in the description!

[@arthuroludotun4055]

Great video. Please do a Power BI tutorial

[@KenjiExplains]

Noted! thanks for your comment :)

[@shimaamohamed6658]

can you get me the right link to download the right data you use in the video plz ?

[@KenjiExplains]

Just fixed it my apologies!

[@shimaamohamed6658]

@@KenjiExplains thank u so much

[@kunalsinha1119]

Interested for powerbi

[@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.

[@KSMVideos]

Good video but that donut chart was quite complicated.

[@sagar9060]

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

[@siddharthmhaskar4420]

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

[@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.

[@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: kzbin.info/www/bejne/nYupl6KfjtB_Y7c

[@MoneyBread22]

@@KenjiExplains thanks Kenji 🙌

[@michaelquach7046]

Gant chart all the way!

[@KenjiExplains]

Yes!

[@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

[@simon-e7t]

what is the 138% ? Gauge chart?

[@ferhatborj5551]

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

[@iulianabarnes6001]

For me the excel file is not downloading for free. It's downloading as a file visual, asking me to pay $30-40

[@KenjiExplains]

Not sure what file you have but it's not mine as I don't charge money for file downloads. The start file I provide is free and you can find it here: view.flodesk.com/pages/639c825e49ad46f529603a71 Additionally, can you please share the link to the file you mention is asking you to pay?

[@madhurimadas8845]

kindly provide the complete raw file

[@KenjiExplains]

its in the description as i mention in the video