Python in Excel! MAJOR Upgrade for Data Analysis & Visualization

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

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

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

    ✅Learn more Excel with my course here: www.careerprinciples.com/courses/excel-for-business-finance

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

      Hi Kenjie, I would really like to enroll on the Excel and Power BI bundle course, do you till provide discount?

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

    I'm not that excited about this per se - but I am excited about what more talented people can do with it that I can copy!

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

      have the same thought

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

    I thought it may be great at first BUT from what I've read python code is at Microsoft's end of the server (not your local machine). Apparently anywhere python is inserted it acts like a volatile function; seriously affecting performance, so you can't have much python in your spreadsheet, refreshing each time you click inside a dataframe I'd imagine. i have not been lucky enough to receive the python in excel despite updating to the latest build in the Insider 365 beta channel.

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

    Thanks!! Could you do a tutorial on the S&P Capital IQ plug in

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

      Not sure but will keep it noted! Thanks for the suggestion

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

    Python is the excellently language and one of more used languages ​​in Microsoft projects. I wanted an Excel that was secure and easy to use ironPython in it. The current version is very similar to most of my expectations and is revolutionary. I want this powerful language to be used by more people.

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

    But both Python and R are available in Power BI.....

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

    New subscriber here. Anyone!. I'm not knowledgeable to excel. Even a simple basic. Any recommendations of how to learn excel from basic to advanced. A simplified teaching will be much appreciated. Thank you

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

    Thanks for this great video. That is excellent! Could you please upload your Excel workbook for this tutorial? Then I can follow step by step for practice.

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

    Thanks for your video. I just found out about this and want to use it as soon as it available.

  • @m-e-Lee-o
    @m-e-Lee-o ปีที่แล้ว

    Extraordinary way to summarize this update for Excel. Thanks for sharing!

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

      Thanks for the nice comment :) Glad it was helpful!

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

    Your Excel knowledge was really helpful for me on today's exam ❤

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

    Great video on the new Python feature!! Thankssss

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

    Thanks🦋💙🦋, greetings from 🇵🇱🇩🇪

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

    please explain, vba versus phyton....what same the fiture or phyton more full and more good vba

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

    Nice job as usual Kenji. I am following closely. Keep it up.

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

    Great one Kenji!

  • @darren-silvertrade
    @darren-silvertrade ปีที่แล้ว +1

    i have a new install of office 365 with excel... but do not see python in the formula bar. How to get this ?

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

    Great video, thanks Kenji!

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

    Is there a quick reference of the python codes that you’ve used in this? Can we see anywhere in the excel sheet or we need to just Google it up?

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

    Super Do-per

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

    doesn't look like its on the Mac version :(

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

    Great video! When is this going to be available for the public to use?

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

      It's already available for some people so should be rolled out more generally soon :)

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

    Hi Kenji, I cannot find python in my insert tab. Any way that I could activate it? thank you!

  • @lazyswimmer7
    @lazyswimmer7 ปีที่แล้ว +16

    To clarify, this is only available to a few for marketing purposes, this is not available to the public.

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

      Not true

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

      It is in the beta channel of excel releases (which anyone with a subscription can get. Ltsc licenses do not get updates)

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

      @@redeux Of course you can sign up for it, but that still doesn’t mean you can use it.

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

      no wonder

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

    Thank you so much!!

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

    Kenji you are a ⭐️ ❤

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

    hello - what version of Excel is this possible - I still have 2010 excel in my PC

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

    Hey Kenji, great video. I've gone through all of the steps and have added the Python add-in but only get the "preview" option. I've tried to troubleshoot but no luck. Is there something else I need to do? Many thanks!

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

      never mind figured it out!

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

    Thanks

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

      Thank you for supporting the channel! Hopefully more good videos coming :)

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

    is this availible for MAC ?

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

    please help me to get office 365

  • @Techie-time
    @Techie-time ปีที่แล้ว +1

    For me Insert Python itself is not enabled. Can you help enabling it.? I have already joined the insider program but it is of no help.

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

      Hey, I explain more about the rollout process in the video

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

      see towards the end for the details of the rollout process

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

    correct if i wrong but excel dont install python in your machine only use python which is hosted in a server.

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

    Does it autoupdate or we need to buy a premium version for it? Which version has this feature

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

      Autoupdates with microsoft 365

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

    What excel year from? 2013 or after? And how to install it?

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

      Office 365, newest version!

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

    Kenji, You are the Man. Thank you a million.

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

      Thanks for watching man I appreciate you!

  • @user-dg6zy3fs6c
    @user-dg6zy3fs6c ปีที่แล้ว

    Hi Kenji, I am a huge fan of your videos and all your advice. I have an interview excel test coming up and I was wondering if you have any videos on that? Like what sort of questions to look for? I was told it would be basic cash flow definitions, WACC calculations, and fundamental financial statement questions
    Thank you

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

      Hey yeah I have mulitple excel test videos! See here th-cam.com/video/HXJ34-iN5H4/w-d-xo.html
      Good luck with the interview!
      This other finance interview questions should also be useful: th-cam.com/video/hZALF58_qsY/w-d-xo.html

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

    Awesome - thank you very much indeed for this very useful tutorial!

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

    At this point why even use excel? If you want to create good visuals with python you need many more lines of code. Easier to just put the data in a csv, import and manipulate with pandas. Then matplotlib however much you want to tweak to perfection.

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

    Python is best
    If you know python
    Upwork give you 1st job

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

    Notification gang

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

    If you have a team you do something if you are alone you dont do any think

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

    nice intro lol

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

    Every video i have seen so far doesn't tell you how to enable python inside excel, they only tell you how to use it, for god sake!!!

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

    This is not Python...