From the course: Advanced Analysis Using Python in Excel Copilot
Join today to access over 24,900 courses taught by industry experts.
Using Python in Excel
From the course: Advanced Analysis Using Python in Excel Copilot
Using Python in Excel
- [Instructor] Before we move on to using advanced analysis to generate Python code for us, let's take a few minutes exploring how Python in Excel works just to get started. Python in Excel is a feature that's available to Microsoft 365 subscribers, and it allows us to use Python inside of Excel. This feature is made possible by an Anaconda Python environment running in the cloud, and that environment has many popular data science and machine learning libraries already installed. That's things like Matplotlib, Scikit-learn, NumPy, SciPy, Pandas, Seaborn and more. We'll access these libraries, and write our Python code in a Python cell, which we can create anywhere on the Excel grid by typing =py(). We can edit our Python code right in that cell using the editor bar, or we can find formulas in the ribbon, and find the Python section, and open up a Python editor on the side of our window to see more code. at once. Python in Excel can reference values in the Excel workbook using the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.