From the course: Advanced Analysis Using Python in Excel Copilot
Join today to access over 25,500 courses taught by industry experts.
Using advanced analysis
From the course: Advanced Analysis Using Python in Excel Copilot
Using advanced analysis
- [Instructor] Copilot is Microsoft's generative AI assistant. And as a Copilot Pro subscriber, we can use it inside of Excel to provide tips and insights and to analyze our data. Today, I'm happy to be able to show you a forthcoming feature of Excel Copilot called "Advanced analysis," which allows Copilot to generate Python code to help us analyze our data. Using Advanced analysis, Excel Copilot will be able to recognize data in tables in my workbook. So it starts out with that useful context, and we can ask natural language questions about that range of data. Advanced analysis will use our data and prompts that we provide to generate Python code that responds to our requests. I have a workbook here with some sushi dishes and their prices and ratings. Let's use this data to explore how Advanced analysis works. Here's my data, and we can see a few different columns of information here. To find the Advanced analysis feature, I'll open my Home ribbon, and find the Copilot button, and…
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.