Build 5 ADVANCED Excel Charts from Scratch

Поділитися
Вставка
  • Опубліковано 8 лют 2025

КОМЕНТАРІ • 79

  • @KenjiExplains
    @KenjiExplains  2 роки тому +10

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

    • @rudiansyahsyah9738
      @rudiansyahsyah9738 2 роки тому +1

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

  • @christiancoronado
    @christiancoronado 2 роки тому +6

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

  • @alaminhossain9803
    @alaminhossain9803 2 роки тому +2

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

  • @sagato888
    @sagato888 2 роки тому +1

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

  • @Bojerthe
    @Bojerthe 8 місяців тому +2

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

  • @violetheise4717
    @violetheise4717 Рік тому +1

    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!

  • @sammevinod
    @sammevinod 9 днів тому

    Wow truly amazing, just knew 1 but the last one was outstanding need to practice more on it.. Excellent way of teaching skills

  • @michaelquach7046
    @michaelquach7046 2 роки тому +2

    The progress column chart is a new favorite!

  • @dojcinka448
    @dojcinka448 2 роки тому +4

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

  • @alexrosen8762
    @alexrosen8762 Рік тому

    Great tutorial

  • @mohsinbaig9326
    @mohsinbaig9326 11 місяців тому +1

    Fantabulous! Love this video💖

  • @1MichaelAngelo
    @1MichaelAngelo Рік тому +1

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

  • @makumetoti52
    @makumetoti52 2 роки тому +3

    Really great stuff! Thank you for sharing

  • @camlex6310
    @camlex6310 2 роки тому +2

    Really comprehensive guide!!! Thanks

  • @mjm4220
    @mjm4220 4 місяці тому

    Thats great! I specially liked the last one. Thanks 🤜🤛

  • @stevencampbell3203
    @stevencampbell3203 Рік тому

    Great video, right to the point!

  • @hunterburns
    @hunterburns 2 роки тому +1

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

  • @dylansinclair7751
    @dylansinclair7751 2 роки тому

    Awesome stuff Kenji!

  • @pietrofornari577
    @pietrofornari577 2 роки тому +1

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

    • @KenjiExplains
      @KenjiExplains  2 роки тому

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

  • @vikramadityarathore97
    @vikramadityarathore97 2 роки тому +4

    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.

  • @Chris-ch5ei
    @Chris-ch5ei Місяць тому

    Thanks!

  • @CapitalCSGO
    @CapitalCSGO 2 роки тому

    Thanks for another great video Kenji!

  • @danielmwabila8064
    @danielmwabila8064 2 роки тому +1

    Really, thank you very much for your work!

    • @KenjiExplains
      @KenjiExplains  2 роки тому

      Cheers Daniel thanks for always commenting 🙌

  • @XtremelyREVolting
    @XtremelyREVolting 2 роки тому

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

  • @andreugiro2807
    @andreugiro2807 2 роки тому +1

    Great content as always!

  • @lux-nocopyrightmusic
    @lux-nocopyrightmusic 2 роки тому

    Great vid!

  • @gentansrimuhammadismailjam9483
    @gentansrimuhammadismailjam9483 2 роки тому +1

    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.

  • @gospelmoto2833
    @gospelmoto2833 2 роки тому

    Excellent!

  • @finalel2959
    @finalel2959 2 роки тому

    Really helpful!!

  • @fortune7399
    @fortune7399 Рік тому

    Thank you

  • @aidanordin3345
    @aidanordin3345 2 роки тому

    thank you very much

  • @LouMarnell
    @LouMarnell 5 місяців тому

    Level 2 is awesome for one of my scenarios. Can you get the same effect in Power BI?

  • @Irene-sq9en
    @Irene-sq9en 6 місяців тому

    You should use difference instead of variance. Variance is used to obtain standard deviation which shows the variation interval of your data. Variance is a statistical parameter of dispersion of your population/data.

  • @s_elgebali9660
    @s_elgebali9660 5 місяців тому

    GREAT

  • @willzinner8813
    @willzinner8813 2 роки тому +5

    make more of this please sir

  • @salafghaniedsa669
    @salafghaniedsa669 Рік тому

    awesome!

  • @bretmorris1
    @bretmorris1 7 місяців тому

    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?

  • @fatimazaim503
    @fatimazaim503 Рік тому

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

  • @h.l6849
    @h.l6849 2 роки тому +5

    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

  • @diegocastanedafiestas1574
    @diegocastanedafiestas1574 2 роки тому +1

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

  • @lucidbeing618
    @lucidbeing618 2 місяці тому

    Hi all and everyone, just a real quick query, does anyone know if it is possible to make a chart transparent on iOS device? Thank you in advance👌

  • @salmanasadulla4400
    @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

  • @Tjartech
    @Tjartech 2 роки тому

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

  • @randomgray1
    @randomgray1 2 роки тому

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

  • @amielaganan2442
    @amielaganan2442 2 роки тому +1

    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
      @KenjiExplains  2 роки тому

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

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 2 роки тому

    Awesome

  • @quietside1380
    @quietside1380 2 роки тому

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

  • @nitalin1
    @nitalin1 2 роки тому

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

  • @dorianpiret
    @dorianpiret 2 роки тому

    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!

  • @ashishbhasin1926
    @ashishbhasin1926 2 роки тому

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

    • @KenjiExplains
      @KenjiExplains  2 роки тому

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

  • @marykiboi4269
    @marykiboi4269 Рік тому

    The doughnut and forecast chart

  • @wisdomokparaji6884
    @wisdomokparaji6884 5 днів тому

    I had problem with the forecast

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

  • @chinyerenwigwe5166
    @chinyerenwigwe5166 Рік тому

    Wow

  • @Bgdhrinath143
    @Bgdhrinath143 2 роки тому

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

  • @guillervillaflor7955
    @guillervillaflor7955 7 місяців тому

    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.

  • @arlenecalinao9209
    @arlenecalinao9209 2 роки тому

    Literally many people don't use gms

  • @gamahala252
    @gamahala252 Рік тому

    You're so handsome

  • @mohammedazeempathan2580
    @mohammedazeempathan2580 7 місяців тому

    0

  • @robmarth2226
    @robmarth2226 2 роки тому

    Your name sounds like Japanese, but why do you have Filipinos accent?