How to use Copilot in Excel - The Complete Beginners Course @TeachersTech

Uploaded November 2025 | Updated September 2026, 2 weeks ago

Unlock the power of Microsoft Copilot in Excel in this beginner-friendly tutorial!

Whether you’re brand new to Copilot or looking to understand what it can really do, this video walks you through everything step-by-step — from simple prompts to full data cleaning, analysis, formulas, charts, and more.

Copilot is now available in all Microsoft 365 accounts, and in this video I’m using the premium version, which includes additional features you might not see in the basic tier.

If you want to save time, work smarter, and turn messy spreadsheets into clean insights, this lesson will help you get started fast.

Practice Files:
Link to Module 2 Practice Workbook: https://go.teachers.tech/CopilotModule2
Link to Module 3 Practice Workbook: https://go.teachers.tech/CopilotModule3
Prompts I used in the video: https://go.teachers.tech/CopilotPrompts

Chapters:

00:00 - Intro
01:11 -Chat vs. App Skills
03:20 - Save your Excel files to the cloud
03:30 - Supported file types
04:06 - Turn range to tables
05:47 - Intro to Module 2
06:17 - Quick insights with Copilot
09:38 - Visualizations with Copilot (Create charts and images)
13:41 - Instant formulas with Copilot in Excel
19:36 - Conditional formatting with Copilot
21:19 - Cleanup and creating categories
26:09 - PivotTables with Prompts
29:08 - Trend Spotting and What Ifs with Copilot
31:36 - Summarizing for presentations
33:27 - Intro to Module 3
33:58 - Importing and combining data with Copilot in Excel
40:49 - Text insights & Structuring Notes
42:36 - Iterative questioning for deeper insight
45:05 - Python in Excel with Copilot

How to use Copilot in Excel - The Complete Beginners Course

7 Essential Copilot AI Tips for Microsoft Outlook Users

$7 AI tools combined in 1 AI Tool | ChatLLM Review Try ChatLLM Teams Today! https://chatllm.abacus.ai/iej Are you tired of juggling multiple AI tools that complicate your team’s workflow and drain your budget? In this video, we dive deep into ChatLLM Teams by Abacus.AI and show you how it can transform your team’s collaboration from chaos to control using cutting-edge AI technology—all for only $10 per month! Check out AI Agents in ChatLLM Teams: https://youtu.be/eg11Vf-zt8Y What You’ll Learn: ✨ Versatile AI Capabilities Access multiple state-of-the-art language models like GPT-4, Llama 3, Sonnet-3.5, and Gemini 2.0. Generate images, execute code, and interact with PDFs seamlessly. Discover the power of CodeLLM: an AI-powered, Python-based environment that eliminates the need for separate IDEs, offering real-time code execution, debugging suggestions, and more. 🤝 Seamless Collaboration Invite team members to projects and collaborate in real-time. Share conversations and AI-generated results effortlessly within your team. 🔗 Integration with Workplace Tools Connect with your favorite apps like Slack, Microsoft Teams, Google Drive, and OneDrive. Streamline your workflow by integrating AI insights directly into the tools you already use. 🚀 Enhanced Productivity Quickly summarize and analyze large documents. Utilize real-time code execution to speed up development. Leverage image generation and analysis for your design and social media needs. 💰 Cost-Effective Solution Unlock all these powerful features for just $10 per month—a fraction of the cost compared to other AI platforms. 🔒 Security and Compliance Enjoy enterprise-grade security with SOC-2 Type-2 and HIPAA compliance. Keep your data safe and secure while leveraging advanced AI capabilities. Why ChatLLM Teams? ChatLLM Teams is your all-in-one AI collaboration tool that simplifies complex workflows, enhances productivity, and fosters seamless teamwork. Whether you’re a developer, designer, marketer, or part of any team, ChatLLM Teams empowers you to achieve more with less effort. 0:00 Introduction 0:24 Versatile AI Capabilities 1:51 Seamless Collaboration 2:28 Integration with Workplace Tools 3:03 Enhanced Productivity 3:59 AI Agents 4:47 Connecting GitHub with ChatLLM Teams$

The Complete Seedance 2.0 Tutorial for Beginners

Gemini 3: Upgraded Smarts and New Capabilities

Are Schools Ready for AI? Google’s VP of Education Weighs In - Google I/O

Gemini 2.0: The AI That Sees, Hears, and Understands (Use it for FREE)

Let AI Create Your Next Google Slides Presentation

Higgsfield Supercomputer: What This AI Agent Got Right And Where You Still Take Over

NotebookLM + Gemini = Website Builder (Free & No Code)

How to Use Google Gemini in Google Classroom - Free & Safe for Schools

How to Combine Multiple Excel Sheets or Workbooks Seamlessly