Build 5 ADVANCED Excel Charts from Scratch

Рет қаралды 210,014

Күн бұрын

Create advanced excel charts (forecast chart, waterfall chart, column chart etc.)
👉 Sign up to Morning Brew: morningbrewdaily.com/kenjiexp...
🆓 DOWNLOAD Free Excel file for this video:
view.flodesk.com/pages/62daa6...
In this video you'll learn to create 5 dynamic advanced excel charts.
In level 1, we'll go over a dynamic doughnut chart, where the centre will include the customer satisfaction score out of 100% dynamically linked.
In level 2, we'll go over a budget vs actuals charts. This will start as a column chart and by changing the second axis and the column widths we'll active a progress bar chart.
In level 3, we'll go over a waterfall chart, which allows us to track progress over time.
In level 4, we'll go over a forecast chart, which allows you to forecast how a certain trend is going to evolve in the future. In our case, we use Netflix shares as an example.
Lastly, in level 5, we go over a complex column chart with a percentage change to showcase the revenue trend in more detail.
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
USEFUL SOURCES:
Excel Campus: www.excelcampus.com/charts/co...
Xelplus: www.xelplus.com/excel-progres...
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Level 1 Doughnut Chart with Textbox
2:57 - Level 2 Progress Column Chart
5:59 - Level 3 Waterfall Chart
7:42 - Level 4 Forecast Chart
9:20 - Level 5: Column Chart with % Change
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 71

@KenjiExplains 2 жыл бұрын

👉 Sign up to Morning Brew: morningbrewdaily.com/kenjiexplains

@rudiansyahsyah9738 Жыл бұрын

classroom speak basic symbol motivation presentasi room speak english year 2022 / 2023 sys data com master quality utility 2022 / 2023 the internet.com 🏛🌍🌎🌏

@alexcolombu1025 2 ай бұрын

Kenji is by far the best in regards to excel and overall ease of explanation

@christiancoronado 2 жыл бұрын

Your excel content is 5 stars every time, thank you for sharing your knowledge!!!

@alaminhossain9803 Жыл бұрын

Your channel appears to be blessing for us as the time goes. Thanks.

@sagato888 2 жыл бұрын

Your voice is calming for me. deep and comforting which make me follow your instructions more easily 😊

@makumetoti52 2 жыл бұрын

Really great stuff! Thank you for sharing

@1MichaelAngelo 8 ай бұрын

This was a great and very useful tutorial! Thank you.

@mohsinbaig9326 5 ай бұрын

Fantabulous! Love this video💖

@violetheise4717 9 ай бұрын

I'm making myself a 'cheat sheet' and decided to just link here for that last one because of how many steps it has lol. Thanks Kenji!

@stevencampbell3203 7 ай бұрын

Great video, right to the point!

@finalel2959 2 жыл бұрын

Really helpful!!

@dojcinka448 2 жыл бұрын

Thanks for that last one! It will be super useful for collage assignments

@KenjiExplains 2 жыл бұрын

Glad to hear that!

@lux-nocopyrightmusic 2 жыл бұрын

Great vid!

@michaelquach7046 2 жыл бұрын

The progress column chart is a new favorite!

@KenjiExplains 2 жыл бұрын

Awesome!

@hunterburns 2 жыл бұрын

Tremendous! Keep it up boss 👊🏻👊🏻👊🏻 We want more videos like this one

@KenjiExplains 2 жыл бұрын

Thanks! Will do!

@gospelmoto2833 Жыл бұрын

Excellent!

@camlex6310 2 жыл бұрын

Really comprehensive guide!!! Thanks

@KenjiExplains 2 жыл бұрын

Glad you enjoyed it!

@CapitalCSGO 2 жыл бұрын

Thanks for another great video Kenji!

@KenjiExplains 2 жыл бұрын

Thank you for watching! :)

@danielmwabila8064 2 жыл бұрын

Really, thank you very much for your work!

@KenjiExplains 2 жыл бұрын

Cheers Daniel thanks for always commenting 🙌

@aidanordin3345 Жыл бұрын

thank you very much

@h.l6849 2 жыл бұрын

Hi Kenji great stuff! I am already using a forecast chart for my assignment. I am thinking of ways to create a forecast vs actual dashboard (incorporating the forecast chat and elements from your video on budget vs actual video.) Any advice. Thanks

@salafghaniedsa669 Жыл бұрын

awesome!

@dylansinclair7751 2 жыл бұрын

Awesome stuff Kenji!

@KenjiExplains 2 жыл бұрын

Thank you!

@fortune7399 Жыл бұрын

Thank you

@pietrofornari577 2 жыл бұрын

Keep it up with the great job 💪 Here since day 1

@KenjiExplains 2 жыл бұрын

Pietro! Great to hear from you man hope all is well :)

@diegocastanedafiestas1574 2 жыл бұрын

another great video! have a question: for the doughnut graph how can i properly add to it the average satisfaction of the last 6 months for instance? thanks a lot!!

@andreugiro2807 2 жыл бұрын

Great content as always!

@KenjiExplains 2 жыл бұрын

Glad you think so!

@vikramadityarathore97 2 жыл бұрын

Hey Kenji saw your frequency asked questions video for finance , it was amazing. Could you make a separate video for questions asked for different profiles like financial analyst, investment banker, fp&a, credit analyst etc.

@KenjiExplains 2 жыл бұрын

Thanks for the idea!

@odius3548 Жыл бұрын

Yoooo! The most complex one in excel, I just did that today. :D

@dorianpiret Жыл бұрын

Hi Kenji, I trust that you are well. I had a small question regarding the Column chart with % change. If you don’t take a month-by-month flows (let’s, say 6 month every new data point) the graph will look very thin as if excel wants to add the missing months. This makes the graph look weird and not pleasing to the eye. Do you have a way around that? Thanks in advance!

@Tjartech Жыл бұрын

Nice tutorial. How did you clear those difficult borders that come with Excel?

@solomonbhandari-young4154 2 жыл бұрын

Awesome

@KenjiExplains 2 жыл бұрын

Thank you!

@randomgray1 Жыл бұрын

Is there a way to make the text box work to a formula to bring back the top result in the Pivot?

@quietside1380 2 жыл бұрын

Do one with a cashflow forecast for one year using different scenarios.

@gentansrimuhammadismailjam9483 Жыл бұрын

Hi Kenji, great contents as usual. Just a request if possible. Could you slow down the presentation. My mind is not as sharp as it was before.

@danjarupath Жыл бұрын

Good comment

@SuperElitelee Жыл бұрын

You can change play back speed to less than 1

@alexrosen8762 Жыл бұрын

Great tutorial

@willzinner8813 2 жыл бұрын

make more of this please sir

@KenjiExplains 2 жыл бұрын

Coming!

@bretmorris1 Ай бұрын

Hi Kenji, great video on how I can enhance my reports however when I tried the Progress Column Chart my secondary data was sometimes greater than my primary yet it should be a subset of it. So I went back to your video and your data does the same. If you look at Transport Budget is greater than Actual but when you combine Actual is greater than Budget. Is this a bug with Excel?

@chinyerenwigwe5166 9 ай бұрын

Wow

@nitalin1 Жыл бұрын

Hello there, kindly guide, "in Data Lables, Value from cells is missing in my Excel worksheet 2021" plz guide.

@amielaganan2442 2 жыл бұрын

Hey Kenji, I'm planning to take the course, but I'm a bit confused, are the contents with Financial Edge and from your website the same?

@KenjiExplains 2 жыл бұрын

Hey, no they're not the same. Financial edge just sometimes sponsors our KZfaq videos but that's it!

@fatimazaim503 9 ай бұрын

how did you bring the customer satisfaction as a single header ? thanks!

@salmanasadulla4400 Жыл бұрын

Perfect stuff. You did not show how the Y axis label which is not merged with 2 columns and is not under the data column. Please show it as it is visually bugging me. 13:32

@marykiboi4269 9 ай бұрын

The doughnut and forecast chart

@SuperPrem 2 жыл бұрын

I'm 13 why am I watching this :skull: But this is good general knowledge for not only professionals but students as well. Good video.

@KenjiExplains 2 жыл бұрын

Great to hear!

@ashishbhasin1926 2 жыл бұрын

Hi kenji, How can we buy financial modelling and valuation cource from you

@KenjiExplains 2 жыл бұрын

Hey! You can get it here: www.careerprinciples.com/courses/finance-valuation-course

@Bgdhrinath143 Жыл бұрын

hi.....explain is good....but subtitles pls move on below

@guillervillaflor7955 Ай бұрын

regarding the waterfall chart, it seems to be inaccurate, don't you think? When you promote and demote people, they are, technically, already within the organization; therefore changes in the positions of existing employees shouldn't influence the total number of employees.