From the course: Python-Powered Excel: Boost Your Excel Productivity with the Power of Python by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Set up custom functions

Set up custom functions

From the course: Python-Powered Excel: Boost Your Excel Productivity with the Power of Python by Microsoft Press

Start my 1-month free trial Buy for my team

Set up custom functions

“

All right. So the first thing that we're going to talk about here is how to get started with custom functions. Now, first of all, what you'll notice here, you may notice that the operating system I'm showing you is different. The previous one that I was recording with was a Mac. The thing about using custom functions in Excel is that currently, this feature is only available for the Windows desktop app, right? So the locally run version of Excel, it's currently not available on Excel for web, Excel for Mac, or anything like that. Although from the sound of it, there are plans to add it for those other operating systems. So I wanted to have this in here just so that you see how this can work. There are other tools that will allow you to do this as well, like xlwings, if you look that up. But, well, I just wanted to show you this to give you an idea of how Python can be integrated into Excel on at least Windows. All right. So what you're going to see here, first of all, I have the…

Contents