Python in Excel! MAJOR Upgrade for Data Analysis & Visualization

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024

Комментарии • 73

  • @KenjiExplains
    @KenjiExplains  Год назад +6

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

    • @vernienavarro4403
      @vernienavarro4403 11 месяцев назад

      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!

  • @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 11 месяцев назад

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

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

  • @aegialina
    @aegialina 11 месяцев назад

    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.

  • @camlex6310
    @camlex6310 Год назад

    Great video on the new Python feature!! Thankssss

  • @paulmartineau3850
    @paulmartineau3850 11 месяцев назад

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

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

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

  • @yohannaagbanaji8012
    @yohannaagbanaji8012 Год назад +1

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

  • @marzenababij5148
    @marzenababij5148 Год назад

    Thanks🦋💙🦋, greetings from 🇵🇱🇩🇪

  • @CaribouDataScience
    @CaribouDataScience Год назад +2

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

  • @vikramadityarathore97
    @vikramadityarathore97 Год назад

    Great one Kenji!

  • @paopaoastig
    @paopaoastig 11 месяцев назад

    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

  • @albertuslano1785
    @albertuslano1785 11 месяцев назад

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

  • @darren-silvertrade
    @darren-silvertrade 11 месяцев назад +1

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

  • @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 11 месяцев назад

      no wonder

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

  • @motopelamohapi4152
    @motopelamohapi4152 Год назад

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

    • @KenjiExplains
      @KenjiExplains  Год назад

      Thanks for watching man I appreciate you!

  • @willm7994
    @willm7994 Год назад

    Kenji you are a ⭐️ ❤

  • @pl4195
    @pl4195 11 месяцев назад

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

  • @ttech_official
    @ttech_official Год назад

    Thank you so much!!

  • @OldDogNewTricks_at_60
    @OldDogNewTricks_at_60 Год назад

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

  • @charlesjaphe
    @charlesjaphe 11 месяцев назад

    Super Do-per

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

  • @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 11 месяцев назад

      never mind figured it out!

  • @wooddog007
    @wooddog007 Год назад

    Thanks

    • @KenjiExplains
      @KenjiExplains  Год назад

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

  • @Viper4ever05
    @Viper4ever05 Год назад +1

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

  • @user-dg6zy3fs6c
    @user-dg6zy3fs6c 11 месяцев назад

    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  11 месяцев назад

      Hey yeah I have mulitple excel test videos! See here ruclips.net/video/HXJ34-iN5H4/видео.html
      Good luck with the interview!
      This other finance interview questions should also be useful: ruclips.net/video/hZALF58_qsY/видео.html

  • @Techie-in-Cloud
    @Techie-in-Cloud Год назад +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

  • @Dedicated2WendyWilliams
    @Dedicated2WendyWilliams Год назад +1

    is this availible for MAC ?

  • @gersonady2274
    @gersonady2274 11 месяцев назад

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

    • @mohsentarashi
      @mohsentarashi 11 месяцев назад

      Office 365, newest version!

  • @victorfritsch3530
    @victorfritsch3530 Год назад

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

  • @celestinballa6640
    @celestinballa6640 11 месяцев назад

    please help me to get office 365

  • @faizansayed9203
    @faizansayed9203 Год назад

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

  • @MegaTrickykid
    @MegaTrickykid Год назад

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

  • @MuhammadAffaf
    @MuhammadAffaf Год назад +1

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

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

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