Excel with Copilot: AI-Driven Data Analysis
This course explains how Excel Copilot uses AI to automate tasks like preparing data, creating formulas, profiling datasets, and sorting and filtering information. It also introduces the COPILOT function, showing how to use AI directly in cell formulas for tasks such as summarizing text, classifying content, and generating sample data with natural language prompts.
Instructor: George Mount
Released: 11/18/2025
Length: ~1 hour, 38 minutes
Platform: LinkedIn Learning
Skill Level: Intermediate
Purpose: To teach Excel users how to leverage Copilot and AI-powered features to automate tasks, build formulas, analyze and transform data, and apply the new COPILOT function for intelligent, semantic data work in Excel.
Excel with Copilot: AI-Driven Data Analysis
This course explains how Excel Copilot uses AI to automate tasks like preparing data, creating formulas, profiling datasets, and sorting and filtering information. It also introduces the COPILOT function, showing how to use AI directly in cell formulas for tasks such as summarizing text, classifying content, and generating sample data with natural language prompts.
Start Your Training Here!* Please sign in at the top of the LinkedIn Learning Website with your TAMU email address.
This course will provide the following:
- Getting your data into Copilot
- A tour of the Copilot editor
- Basic table reformatting with Copilot
- Using Copilot Chat in Excel for non-Excel tasks
- Challenge: Table setup in Copilot
- Solution: Table setup in Copilot
- Creating formulas and functions faster with Copilot
- Debugging Excel formulas with Excel Copilot
- Using Microsoft Copilot as an Excel formula tutor
- Using the COPILOT() function
- Data profiling
- Sorting and filtering data
- Working with multiple tables in Copilot
- Challenge: Enhancing a table with Copilot
- Solution: Enhancing a table with Copilot
- Conditional formatting
- Advanced data analysis and insights
- AI-powered data visualization with Copilot
- Introducing advanced analysis with Python for Copilot
- Time series analysis with advanced analysis in Copilot
- Text analysis with advanced analysis in Copilot
- Researcher and analyst agents in Copilot
- Challenge: Copilot for data analysis
- Solution: Copilot for data analysis
