Hi all
I've been exploring Python in Excel and publishing short videos to share with the community.
You can see the playlist here:
Python in Excel! - YouTube
Part 1 - Introduction
Part 2 - Organization
Part 3 - Power Query Data
Part 4 - Diagnostics, Error values
Part 5 - Create Python cells from a gist using VBA
Part 6 - Using Python to restructure data
I hope it's useful.
Many aren't happy that they can see but not use it. The feature is in a very early stage and will no doubt improve with time (though I think it's already showing lots of promise). For now my approach is to take it as being in a state of flux and the fact that it's available to anyone outside of Microsoft is only so that real-world feedback can be collected.