See how live online training works in this brief video.
All Excel classes include
Free retake
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Small class sizes
Course recording
Excel AI Copilot Course Online December 17, 2026
Excel Copilot AI course
$295.00
Improve your productivity and decision-making with this hands-on AI course for Excel. This Excel Copilot training teaches you how to use Microsoft Copilot and other artificial intelligence tools to analyze data, generate insights, automate tasks, and create visualizations within Excel. Whether you're working with spreadsheets, formulas, or reports, this artificial intelligence course shows you how to work more effectively.
Introduction to AI in Excel
- Understanding AI and its role in modern data workflows
- Overview of AI tools integrated with Excel
- Microsoft 365 Copilot
- Python in Excel (via Copilot)
- OpenAI tools (e.g., ChatGPT with Excel)
- Power Platform AI features (Power Automate, Power BI AI visuals)
Getting started with Copilot in Excel
- Enabling and accessing Copilot in Excel
- Microsoft 365 licensing requirements
- Supported platforms and versions
- Interface overview
- Navigating the Copilot Pane
- Chat interface
- Prompt templates
- Context-aware assistance
- Collaborating with Copilot
- Dedicated Copilot-generated analysis sheets
- Preserving original data while working with AI
AI-Powered data interaction
- Asking natural language questions about data
- Text insights and summarization
- Copilot-generated visualizations
- Charts
- PivotTables
Using Copilot in Excel for data analysis
- Identifying patterns, trends, and anomalies
- Scenario analysis and forecasting
- Generating automated insights
- Dashboard and summary sheet generation
Copilot and data manipulation in Excel
- Natural language for highlighting, sorting, and filtering
- Cleaning and formatting data
- Removing extra spaces
- Merging columns
- Deleting duplicates
- Automating repetitive data tasks
Excel formula assistance with Copilot
- Generating formulas with natural language
- Understanding and explaining existing formulas
- Suggesting new formulas for calculated columns
- Debugging and optimizing formulas
AI-Powered external data integration
- Retrieving external data with Copilot
- Web-based content
- Accessing your data sources
- Verifying accuracy and attribution of sources
Advanced data analysis with Copilot in Excel
- Introduction to how Copilot helps you use Python for data analysis in Excel
- Writing and running Python code with Copilot's help
- Statistical analysis
- Data transformation
- Create data visualizations
- AI-assisted advanced modeling in Excel
Enhancing Excel with Copilot
- Using Copilot for formula generation and logic support
- Introduction to Power Automate
- Developing a GPT-powered Excel assistant
- Advanced prompt engineering for Excel contexts
Other AI tools for Excel and business intelligence
- Power BI AI features and visualizations
- Smart narratives
- Key influencers
- Overview of additional tools for analysis
- Sentiment analysis
- Document processing
- Image-to-table AI
Best practices and considerations when using Copilot AI with Excel
- Writing effective AI prompts
- Ensuring privacy, accuracy, and responsible use
- Recognizing the limitations of AI tools
Copilot Excel AI project
- Creating Excel business reporting with AI
- Dashboards
- Forecasts
- Insights
Why Excel classes at AGI are the best option for you
- Hands-on learning: Learn Excel quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
- Expert instructors: Our instructors are Excel experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.