From the course: Python in Excel
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Using Python in Excel
- [Instructor] Once the Python in Excel feature is available for your account, you can insert a Python cell using the button in the Python section of the formula's ribbon, or by going to a cell and typing =py, opening parenthesis and the cell will switch to a Python cell. We could also use the keyboard shortcut, Control + Alt + Shift + P to create a Python cell. Notice that the interface changes a little bit. We see a PY indicator here on the left of the cell. This indicates that this is a Python cell. Within the cell is a multi-line editor where we can write our Python code. I can work inside here, or I can click up in the formula bar to use that editor. I can switch back and forth between the cell and the formula bar with Control + F2. We can enlarge this bar by clicking on the downward facing arrow on the right side or we can toggle this larger view with Control + Shift + U. I'll write a very basic program…
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.