From the course: Python in Excel: Getting Started with Data Analysis
Join today to access over 24,600 courses taught by industry experts.
A simple example
From the course: Python in Excel: Getting Started with Data Analysis
A simple example
- [Instructor] Let's begin with some simple examples to see how we can use Python within our Excel worksheet. And before we do that, let's get familiar with the Python tools that are in Excel. So here in Excel, I have my workbook opened, named basics_start, and that's in chapter 1 of the exercise files. So first I'm going to select the formulas section here in the Excel ribbon, and you can see that I have an area labeled Python. So there's a button that allows me to insert Python code into a cell or to try out one of the prebuilt samples. And we'll get back to that a little bit later. There's also a button labeled diagnostics, and if I click on it, you can see that a side panel opens and this is where you can debug and track down errors in your Python code, right? Let's go ahead and close that. We'll learn about that a little bit later in the course as well. This button is labeled initialization, and if I click on this, you can see I get another side panel. And this shows me the…
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.