The Adam Shilton Podcast cover image

The Adam Shilton Podcast

Unlocking Python: From Misconceptions to Mastery with Tony Roberts

Jul 16, 2024
01:18:05

For more visit adamshilton.com | Join me as we learn from Tony Roberts, founder of PyXLL, for an in-depth discussion on Python's role in Excel and beyond. We address misconceptions about Python, explore its versatility from beginner to advanced use cases, and examine the pros and cons of AI-assisted coding. Tony shares his journey creating PyXLL and explains how it empowers Excel users with Python's capabilities. The episode also covers cloud deployment considerations and the future of Python in corporate environments. Don't miss this opportunity to stay ahead of the curve with Python.

------SHOW NOTES------

- Check out PyXLL - https://www.pyxll.com/
- Watch PyXLL on YouTube - https://www.youtube.com/@python-excel 
- Connect with Tony - https://www.linkedin.com/in/troberts79/

------CHAPTERS------

- (00:00:00) - Introduction of Tony Roberts and podcast overview
- (00:01:18) - Misconceptions about Python's difficulty and capabilities
- (00:24:46) - Time-saving benefits of AI in coding
- (00:27:57) - Challenges with OpenAI Whisper API and debugging
- (00:29:25) - Pragmatism in using AI for coding
- (00:32:01) - Experimenting with AI tools for coding
- (00:33:41) - Use of bots and AI in customer support
- (00:39:02) - Coding mode differences in Microsoft Copilot
- (00:45:39) - Ethical AI-generated communication in business
- (00:48:49) - Importance of genuine interest in marketing
- (00:52:56) - Transitioning from VBA to Python in corporate settings
- (01:04:50) - Considerations for coding platform choices
- (01:06:24) - Digital course plans and Python accessibility
- (01:14:58) - Using Excel as a front end for Python functions
- (01:17:21) - Conclusion and contact information

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode