AWESOME Excel Charts & Visuals | For Business & Finance Professionals
Вставка
- Опубліковано 27 чер 2024
- The best Excel Charts for data visualization, specifically for business & finance professionals.
Firstly, we go over a stacked area chart, then we format a table with sparklines and borders, thirdly we create a football field chart (common in corporarte finance / investment banking valuation), and lastly we an advanced excel chart -gauge charts (speedometers) often used for measuring things like customer satisfaction scores.
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/61fbb9...
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - / kenji_explains
🤳 TikTok - www.tiktok.com/@kenjiexplains...
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:17 - Area Chart
2:31 - Table format & Sparklines
5:04 - Football Field Valuation Chart
9:20 - Gauge Chart (Speedometer)
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
P.S. Sorry for the re-upload, just corrected a mistake!
How long does the excel course take for completion?
Kenji is the hero on concepts and all about ecommerce and excel!
This is the type of content that should have 500 M clicks!
Thanks so much for giving us this information basically for free!
Greetings from Austria
Thank you !! Glad it was helpful!
Oh man Kenji!!! May god bless you!! Please dont stop with those Excel tutorials 🙏🏻
Thank you for the support Anas, more to come!
Kenji, my man!! Your videos are awesome 👏 just finished the first year of my MBA and currently interning at VC firm and your videos have been a tremendous help, thank you!
We should be able to get some sort of University credits by watching your videos haha, really appreciate your commitment towards helping the public 🤝🏽😁
Haha that'd be a win-win lol
You have the most advanced and on-point excel tutorial. Learning heaps from you
Love the excel videos please make more!
Will do!
Your videos are really helpful! I’m currently at my third internship and seeking a full time offer as a financial analyst or any finance related full time position and your videos add great value to my professional day to day job. Greetings from El Salvador 🇸🇻!
thank you Oscar means a lot 🙌
*_Thanks Kenji. Your tutorials r super.. Very educative_*
Great work as always brother!
This channel is a goldmine
Thank you, outstanding! Best regard from Limón, Costa Rica!
Great to hear! Un saludo!
You making me love the blue and white color theme
Excellent. Informative. Thank you
I learned so much from this video. Thank you so much for sharing!
Glad it was helpful!
Brilliant, and very easy to follow, thank you :)
Dahell. You make it look soo easy. I never hsed charts in excel and I have been failry comfortable with excel and modelling too.
This is lovely content!
Thank you 😊
Kenji your videos are so good - love how they relate to your real life work.
Thank you man!
Fine Kenji, Excellent Explanation🤠
Wow! You will rock brother. Keep posting videos.
Thank you 🙌
This guy is the hotkey king
Amazing tutorial! One of the best articulated on youtube. Thanks!
Glad you think so!
Hi Kenji ! Great video keep going 💪🏽🙌🏼🇲🇦
Thank you!
That trend line column was really cool. I will use it a lot now for each row. Thanks a lot for such an informative lesson.
Thanks for the awesome comment 🙌
I love you dude! Greetings from Poland :)
Awesome Adrian thank you for supporting 🙌
Hvala!
Explain about front, back, and middle office roles in investment banking
Your color choice is different, it look so professional
Hey Kenji, thanks for the amazing content.
Quick question: when setting the print area (alt +prs)--how do you create a toggle with If() that would allow the colors of the print area to change to black/white?
great work sir please make video of macro
Awesome 👍
Great smooth explanations very satisfying to watch the tutorials.
I learned many useful things from your videos thanks for your great help 👍
I would like to know about the software you use to record and editing these amazing learning videos.
Thanks again 😊
Really helpful video!!
Thank you!
Thankyou Kenji
Thanks for watching!
Great skills of explanation. Good luck 👍
Glad you liked it!
Super awesome
Kenji can you make a video on how to do a LBO model
The best!
Thank you!
excellent
Hi kenji do more such videos about data visualization on excel.
hey there, it's noted!
Instead of putting a line shape to represent the price today, perhaps turn this into a combo chart and put an extra column for all categories named today's price. Then turn that column alone into a column chart and increase the gap width?
Hello Kenji I love all your content and have been following you since almost 1 year now. I was wondering if there’s a way for me to send you my CV and CL to get your opinion on them ?
Hi Paul thank you! Unfortunately that’s not something I have the time to do (a lot of people request it and I’ve been declining them as it’s just too much work and time for me). That’s why i made all the comprehensive videos on cv and cover letter and showed mine completely for free. Sorry about this!
Kenji... can we use a negative variable in a Gauge Graph?
I can't seem to do it.
Plz Suggest some FINANCIAL & Marketing Data Analysis Portfolio Projects for Absolute FRESHER on - Data Cleaning , EDA , DASHBOARD Visualisation
i used to think that excel built in graphs and charts are poor, now i realized how much you can actually do with them
Could you do one on how to make a nice visual power point for finance presentations?
Hey Carlos good idea I'll keep it noted thanks :)
Hi bro I'm from WEST BENGAL .How are you doing today..
How did you master shortcuts?
Hi Kenji, what is a business career you would suggest for an undergraduate as a stepping stone to management consulting post MBA?
Hi there, are you an undergraduate or an MBA (postgrad)? Either way it’s common to have internships and/or full time entry level jobs in management consulting so I wouldn’t say a stepping stone is necessary. If you don’t have the grades/experience I’d just aim for a lower tier management consultancy as opposed to the big 3
@@KenjiExplains I’m an undergrad and want to do consulting post MBA; meant to ask alternate business careers to pursue for few years prior to MBA if unable to land junior consulting roles at the moment
Can someone please help me - I dont get when he means Alt+W+VG do I press all of these at the same time? Also I have a mac
Is there a way to change the entire Sparkline color dynamically based on a value? For example, Is there a way to base the SPARKLINE COLOR based on a cell value. So if the value is POSITIVE change the Sparkline color to GREEN and if value is negative, change Sparkline color to RED?
i'm not sure about that colorful graph in the beginning...i've never seen a graph like that before...wouldn't the data be better in a line graph?
I may have some ideas for you in the future as far as if you want to start your own consulting business. Next year I will graduate with a BS in Financial Management, I would guarantee you would love my ideas or jobs. I also currently own my own insurance agency and a licensed realtor.
Hi Kenji, Seems I have a problem with getting the free excel template? perhaps you may have other ways for us to access the template? thanks a lot!!
Did you not receive it via email? (sometimes there's a short delay)
@@KenjiExplains got that now. Thanks for filming such as an amazing videos
If you want to say the shortcuts for things, that's fine. But if your goal is to teach, you should state where the menu option actually is instead of just saying AltWVHTKDH like we're already fluent.
Kenji likes doughnuts 😄
BS
I'm loving the excel video. Can I text you on Linkedin? I need to ask you something.
Great work as always brother!
Cheers mate!