Microsoft Excel Tutorial: Microsoft Labs in Cambridge releases a great Python editor for Excel.
Just 27 days after Python preview appears in Excel, Microsoft has added a dramatically better Python editor.
To download the workbook from today: www.mrexcel.com/youtube/UKpmN...
Welcome to episode 2625 of the MrExcel netcast, where we explore all things Excel. In today's episode, we're diving into the exciting news that Excel has added a Python editor just 27 days after Python's debut in the program. This is a game-changing addition for all Excel users, and we can't wait to show you all the amazing features it has to offer.
But before we get into the details, I want to give a shout out to Waldemar on Unsplash.com. If you're ever in need of silo photos as a metaphor for corporate environments, this guy has some truly beautiful shots. Now, let's get back to the main event - the Python editor in Excel.
There are a few theories as to why the editor was added just 27 days after Python's debut. One possibility is that the editor simply took longer to develop. But another theory is that the team at Excel Labs in Cambridge saw the debut of Python and thought, "We can make this even better." If that's the case, then kudos to them for developing and testing the editor in just 27 days.
To access the Python editor, simply go to the Get Add-Ins option, which can be found on either the Insert or Home tab, depending on your version of Excel. From there, search for Excel Labs and click on the Advanced Formula Environment. If you already have this add-in, you may need to update it to access the Python editor.
Once you have the editor open, you'll notice that it has a similar layout to the formula bar, but with some major improvements. For starters, you can choose to work in either one specific cell or all Python cells in your workbook. The code is also color-coded, making it much easier to read and navigate. And perhaps the most exciting feature - auto-complete is now available when writing Python code in Excel.
But that's not all - the Python editor also has a scratch pad feature, allowing you to save your code in the task pane and come back to it later. You can even switch to manual calculation mode to only run specific Python cells, saving you time and effort. Overall, this is a huge improvement from the Excel Labs team and we can't believe we've been writing Python without it.
Thank you for tuning in to today's episode of the MrExcel netcast. If you enjoyed this video, please don't forget to like, subscribe, and ring the bell for notifications on future episodes. And as always, feel free to leave any questions or comments down below. See you next time!
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
This new editor in the task pane offers AutoComplete, Intellisense, and automatic code coloring. Take a walkthrough the editor in today's video.
#excel
#microsoft
#microsoftlabs
#microsoftexcel
#exceltricks
#excelpython
#microsoft365
#walkthrough
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
Table of Contents
(0:00) Python Editor Added to Excel
(0:10) Free Silo Photos
(0:20) Theories on backstory
(0:59) Get Add-Ins moving from Insert to Home tab
(1:22) Update Excel Labs add-in twice
(1:49) Open Excel Labs & Python Editor
(2:00) Contrast Formula Bar editor to Python Editor
(2:17) Expand Editor
(2:33) Pane shows preview of data frame
(2:45) Color coded
(3:00) Images won't render in editor
(3:10) Adding a new Python cell
(3:24) AutoComplete
(3:45) Choose Python object or Excel values
(3:56) Easier to use XL function in formula bar than python editor
(4:50) Sorting in Python
(5:40) Scratchpad without committing the code
(6:03) In Manual Calculation mode, only one cell calculates when committing code
(6:34) Wrap-up
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...
14 июл 2024
