Build 5 ADVANCED Excel Charts from Scratch

Поділитися
Вставка
  • Опубліковано 27 вер 2024

КОМЕНТАРІ • 75

  • @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 🏛🌍🌎🌏

  • @alexcolombu1025
    @alexcolombu1025 4 місяці тому +2

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

  • @alaminhossain9803
    @alaminhossain9803 Рік тому +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 😊

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

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

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

    The progress column chart is a new favorite!

  • @violetheise4717
    @violetheise4717 11 місяців тому +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!

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

    Fantabulous! Love this video💖

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

    Really great stuff! Thank you for sharing

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

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

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

    Really, thank you very much for your work!

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

      Cheers Daniel thanks for always commenting 🙌

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

    Thanks for another great video Kenji!

  • @stevencampbell3203
    @stevencampbell3203 9 місяців тому

    Great video, right to the point!

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

    Awesome stuff Kenji!

  • @LouMarnell
    @LouMarnell Місяць тому

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

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

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

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

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

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

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

    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?

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

    Really helpful!!

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

  • @fatimazaim503
    @fatimazaim503 11 місяців тому

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

  • @s_elgebali9660
    @s_elgebali9660 22 дні тому

    GREAT

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

    thank you very much

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

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

  • @marykiboi4269
    @marykiboi4269 11 місяців тому

    The doughnut and forecast chart

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

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

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

    awesome!

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

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

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

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

    Great tutorial

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

    Awesome

  • @chinyerenwigwe5166
    @chinyerenwigwe5166 11 місяців тому

    Wow

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

    Literally many people don't use gms

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

    You're so handsome

  • @mohammedazeempathan2580
    @mohammedazeempathan2580 3 місяці тому

    0

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

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

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

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

    make more of this please sir

  • @mjm4220
    @mjm4220 2 дні тому

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

  • @1MichaelAngelo
    @1MichaelAngelo 10 місяців тому +1

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

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

    Really comprehensive guide!!! Thanks

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

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

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

    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.

  • @Irene-sq9en
    @Irene-sq9en Місяць тому

    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.

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

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

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

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

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

  • @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 :)

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

  • @dorianpiret
    @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!

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

    Great content as always!

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

    Great vid!

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

    Thank you

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

    Excellent!