Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Just Got Smarter - Meet the NEW COPILOT Function

Kevin Stratvert via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn how to leverage Excel's revolutionary new =COPILOT() function in this comprehensive 15-minute tutorial that demonstrates how to integrate AI directly into your spreadsheet cells for instant data analysis and content generation. Discover how to use prompts and cell references to generate cookie types and descriptions, analyze customer feedback with automatic sentiment analysis and categorization, and summarize results using Group By functionality. Master advanced techniques like extracting names and phone numbers by combining Copilot with regex patterns, and create dynamic content such as student visit itineraries complete with emojis. Explore practical applications including organizing feedback data, summarizing large datasets, and creating engaging, dynamic spreadsheet content that can save hours of manual work. Understand the key limitations and requirements of this new AI-powered function while gaining hands-on experience with real-world examples that showcase how artificial intelligence is transforming Excel's capabilities for data analysis and content creation.

Syllabus

00:00 - Intro to Excel’s New Copilot Function
00:26 - First Example: Generate cookie types & descriptions
02:26 - Analyze customer feedback with sentiment & categories
05:13 - Summarize results with Group By
07:30 - Extract names & phone numbers Copilot + regex
11:31 - Build a dynamic student visit itinerary
14:17 - Key limitations & requirements

Taught by

Kevin Stratvert

Reviews

Start your review of Excel Just Got Smarter - Meet the NEW COPILOT Function

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.