Excel with Copilot: AI-Driven Data Analysis
44mIntermediate2024-03-07
Authors
George Mount
Course details
In this course, analytics author, trainer, and Excel MVP George Mount highlights the role of Copilot in automating Excel tasks and the potential of AI-driven data manipulation and analysis. Learn how to prepare your data to be compatible with Copilot and how to set up and reformat tables using Copilot. Find out how to use Copilot to speed up creating formulas and functions, conduct basic data profiling and exploration, and sort and filter data. Go over conditional formatting, advanced data analysis and insights, and AI-powered data visualization. Build your understanding of the evolving AI landscape in Excel and learn to embrace continuous learning for AI technologies!
Skills covered
Microsoft CopilotAI Productivity ToolsSpreadsheetsMicrosoft ExcelArtificial Intelligence for BusinessData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
Introduction
- Welcome to Copilot and AI-Powered Excel
- What to know before starting this course
First Steps with Copilot
- Getting your data into Copilot
- A tour of the Copilot editor
- Basic table reformatting with Copilot
- Challenge - Table setup in Copilot
- Solution - Table setup in Copilot
Data Management with Copilot
- Creating formulas and functions faster with Copilot
- Data profiling
- Sorting and filtering data
- Challenge - Enhancing a table with Copilot
- Solution - Enhancing a table with Copilot
Analyzing and Visualizing Data with Copilot
- Conditional formatting
- Advanced data analysis and insights
- AI-powered data visualization with Copilot
- Challenge - Copilot for data analysis
- Solution - Copilot for data analysis
Conclusion
- The future of AI in Excel