Build 5 ADVANCED Excel Charts from Scratch

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ก.ย. 2024

ความคิดเห็น • 74

  • @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 3 หลายเดือนก่อน +2

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

  • @christiancoronado
    @christiancoronado 2 ปีที่แล้ว +6

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

  • @sagato888
    @sagato888 2 ปีที่แล้ว +1

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

  • @alaminhossain9803
    @alaminhossain9803 ปีที่แล้ว +2

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

  • @camlex6310
    @camlex6310 2 ปีที่แล้ว +2

    Really comprehensive guide!!! Thanks

  • @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 10 หลายเดือนก่อน +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 6 หลายเดือนก่อน +1

    Fantabulous! Love this video💖

  • @1MichaelAngelo
    @1MichaelAngelo 10 หลายเดือนก่อน +1

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

  • @makumetoti52
    @makumetoti52 2 ปีที่แล้ว +3

    Really great stuff! Thank you for sharing

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

  • @hunterburns
    @hunterburns 2 ปีที่แล้ว +1

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

  • @LouMarnell
    @LouMarnell หลายเดือนก่อน

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

  • @danielmwabila8064
    @danielmwabila8064 2 ปีที่แล้ว +1

    Really, thank you very much for your work!

    • @KenjiExplains
      @KenjiExplains  2 ปีที่แล้ว

      Cheers Daniel thanks for always commenting 🙌

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

  • @stevencampbell3203
    @stevencampbell3203 9 หลายเดือนก่อน

    Great video, right to the point!

  • @CapitalCSGO
    @CapitalCSGO 2 ปีที่แล้ว

    Thanks for another great video Kenji!

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

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

  • @andreugiro2807
    @andreugiro2807 2 ปีที่แล้ว +1

    Great content as always!

  • @dylansinclair7751
    @dylansinclair7751 2 ปีที่แล้ว

    Awesome stuff Kenji!

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

    • @danjarupath
      @danjarupath 2 ปีที่แล้ว +1

      Good comment

    • @SuperElitelee
      @SuperElitelee 2 ปีที่แล้ว

      You can change play back speed to less than 1

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

  • @willzinner8813
    @willzinner8813 2 ปีที่แล้ว +5

    make more of this please sir

  • @odius3548
    @odius3548 ปีที่แล้ว

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

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

  • @finalel2959
    @finalel2959 2 ปีที่แล้ว

    Really helpful!!

  • @gospelmoto2833
    @gospelmoto2833 ปีที่แล้ว

    Excellent!

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

  • @lux-nocopyrightmusic
    @lux-nocopyrightmusic 2 ปีที่แล้ว

    Great vid!

  • @aidanordin3345
    @aidanordin3345 ปีที่แล้ว

    thank you very much

  • @fatimazaim503
    @fatimazaim503 11 หลายเดือนก่อน

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

  • @fortune7399
    @fortune7399 ปีที่แล้ว

    Thank you

  • @Tjartech
    @Tjartech ปีที่แล้ว

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

  • @quietside1380
    @quietside1380 2 ปีที่แล้ว

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

  • @nitalin1
    @nitalin1 ปีที่แล้ว

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

  • @s_elgebali9660
    @s_elgebali9660 15 วันที่ผ่านมา

    GREAT

  • @randomgray1
    @randomgray1 ปีที่แล้ว

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

  • @salafghaniedsa669
    @salafghaniedsa669 ปีที่แล้ว

    awesome!

  • @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 TH-cam videos but that's it!

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

  • @marykiboi4269
    @marykiboi4269 11 หลายเดือนก่อน

    The doughnut and forecast chart

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

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 2 ปีที่แล้ว

    Awesome

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

  • @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 11 หลายเดือนก่อน

    Wow

  • @arlenecalinao9209
    @arlenecalinao9209 2 ปีที่แล้ว

    Literally many people don't use gms

  • @mohammedazeempathan2580
    @mohammedazeempathan2580 3 หลายเดือนก่อน

    0

  • @gamahala252
    @gamahala252 ปีที่แล้ว

    You're so handsome

  • @alexrosen8762
    @alexrosen8762 ปีที่แล้ว

    Great tutorial

  • @robmarth2226
    @robmarth2226 2 ปีที่แล้ว

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