Python integration with Excel has arrived! While I enjoy guiding newcomers, diving into the documentation can often provide the most comprehensive understanding. Below, I’ve compiled a list of key resources and links to help you get started with Python in Excel. These cover everything from the basics of how it works, to available packages, and using the environment effectively. If you have any additional resources or links that could be beneficial, please share them. Thank you!
- “Get started with Python in Excel,” Microsoft Support. Explains Python in Excel availability and how to get started.
- “Data security and Python in Excel,” Microsoft Support. Offers overview of how Python in Excel code is executed and kept secure.
- “Open source libraries and Python in Excel,” Microsoft Support. Provides overview of Python in Excel environment and available packages.
- “Copilot in Excel with Python,” Microsoft Support. Demonstrates how to generate Python code for advanced analysis with Copilot in Excel.
- “Using Power Query data with Python in Excel,” Microsoft Support. Provides overview of using Power Query data as a Python data source. Python in Excel is currently not able to fetch external data sources.
- “Python Editor from Excel Labs,” Microsoft Tech Community. Free add-in allowing users to write and edit Python code using a dedicated editor similar to those found in Python notebook environments.
- “Python in Excel Cheatsheet,” My Online Training Hub. One-page cheatsheet explaining Python in Excel and how to use it effectively.
- “Python in Excel,” Anaconda. Various resources about using Python in Excel from Anaconda, the provider of the popular Python distribution used for Python in Excel.
- “Anaconda Toolbox,” Anaconda. This is a tool made available by Anaconda for Python in Excel that will help users create visualizations, generate code, practice on sample datasets and more.
- “Python in Excel,” Stringfest Analytics. And as always, head to my blog for posts on a variety of Python in Excel topics.
Leave a Reply