AI-Powered Excel: Mastering Built-In Automation Features
1h 2mIntermediate2024-03-29
Authors
George Mount
Course details
Learn to harness the power of the built-in AI features of Excel with the help of Microsoft MVP George Mount. George begins by covering Excel’s powerful data manipulation features, including Flash Fill and Formula by Example. Next, he takes you through advanced data entry and forecasting features, such as predictive analytics and linked data types. Learn how to master Excel’s AI-powered data visualization tools as well as data summaries with Recommended PivotTable. Lastly, George introduces the new Analyze Data function and shows numerous examples of how to put it to work.
Skills covered
Microsoft CopilotSpreadsheetsMicrosoft ExcelArtificial Intelligence for BusinessBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
Introduction
- Welcome to AI-powered Excel
- What to know before starting this course
AI-Driven Data Manipulation
- Automating data entry with Flash Fill
- Creating a Column by Example
- Creating a Formula by Example
- Joining tables with fuzzy matching
- Challenge - Flash Fill vs. Column by Example
- Solution - Flash Fill vs. Column by Example
Advanced Data Entry and Forecasting
- Importing data from a picture
- Introducing predictive analytics with Forecast Sheet
- Enhancing data insights with linked data types
- Challenge - Predicting the population of Europe
- Solution - Predicting the population of Europe
AI-Powered Charts and PivotTables
- AI-powered data visualization with Recommended Charts
- AI-powered data summaries with Recommended PivotTable
- Challenge - Exploring NYC population trends
- Solution - Exploring NYC population trends
Analyze Data - Deep Dive
- Introducing Analyze Data for AI-powered insights
- Preparing data properly for Analyze Data
- Challenge - Explore census trends with Analyze Data
- Solution - Explore census trends with Analyze Data
Conclusion
- Where to learn more about AI for Excel