Great Canadian Training Company color logo

Microsoft Copilot for Excel

What You'll Learn in Microsoft Copilot for Excel

Course Length

3 hours (1/2 day)

Learning Objectives

  • Understand how Microsoft 365 Copilot Chat and Copilot in Excel work
  • Create clear, structured prompts and effective follow-up questions
  • Analyze, clean, and organize data using Copilot
  • Generate, understand, and troubleshoot formulas
  • Create charts, summaries, and reports from structured data
  • Use Copilot responsibly and confidently

Target Student

This course is designed for professionals who are new to Microsoft 365 Copilot or want to build confidence using Copilot Chat and Excel. Participants will learn practical ways to analyze information, work with formulas, prepare data, and communicate insights. 

Prerequisite

Participants require the paid Copilot Pro license for this course.

Course Outline

This course introduces participants to Microsoft 365 Copilot Chat and Copilot in Excel. It focuses on using clear prompts, referencing work content appropriately, analyzing and preparing data, generating and explaining formulas, and producing charts, summaries, and reports. Participants will also explore privacy, security, and responsible use.


Section 1: Introduction to Microsoft 365 Copilot Chat

What Microsoft 365 Copilot Chat Is

Using Copilot Chat for Everyday Work

Web-Grounded vs. Work-Grounded Responses

Referencing Files, Emails, Meetings, and Chats

Copilot Settings and Access Considerations


Section 2: Foundations of Effective Copilot Prompting

Components of an Effective Prompt

Defining the Task, Context, Source, and Output Format

Using Specificity, Constraints, and Examples

Refining Responses Through Conversation and Follow-Up

Common Prompting Mistakes and How to Avoid Them


Section 3: Introduction to Copilot in Excel

How Copilot Supports Excel Workflows

Preparing Data for Effective Copilot Use

Working with Tables and Structured Data

Asking Questions About Spreadsheet Data

Understanding Capabilities and Limitations


Section 4: Data Analysis, Formulas, and Reporting

Identifying Trends, Patterns, and Insights

Generating and Explaining Formulas

Cleaning and Preparing Data

Creating Charts, summaries, and Reports

Exploring Advanced Analysis Scenarios

Reviewing Outputs for Accuracy


Section 5: Responsible Use and Practical Application

Privacy, Security, and Data Protection

Verifying Copilot-Generated Analysis and Formulas

Recognizing Bias, Errors, and Incomplete Results

Applying Copilot to Realistic Excel Tasks

Excel Prompting Techniques and Best Practices

Sample Prompts

Microsoft Copilot for Excel

Book Private Training

DatesPriceQty
March 9, 2027
1:00 PM to 4:00 PM ET
$475.00
Online
October 22, 2027
9:00 AM to 12:00 PM ET
$475.00
Online
January 10, 2028
1:00 PM to 4:00 PM ET
$475.00
Online
* Applicable taxes will be applied on checkout

Have a Group?

Complete the form to receive a quote for private or customized training.

More people = GREATER savings

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Learn or Come Back Free Policy on Public Classes
  • Email After-Training Support

All of our courses include

PDF Reference Guide

Take your learning further with a digital Reference Guide you can access anytime. It’s practical, paper-free, and accessible on any device.

After-Training Support

Get 30 days of after-training support via email to apply what you've learned

Certificate of Completion

Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.


Want even more?
Check out our add-ons

Extended After-Training Support

Extend your support beyond the standard 30 days for ongoing assistance.


Can I customize my course?
OF COURSE!

Customized to meet your unique needs

We can customize your training to fit your exact needs, whether it's making small adjustments or creating entirely new courses. From setting specific objectives and including your own files to addressing unique challenges, we're here to help. We can even tailor the training to align more closely with how you work and to fit perfectly into your schedule. Our goal is to provide training that's as unique as your goals.


Use your own files instead of our exercise files

You can opt to use your working files in your private training sessions (instead of our standard exercise files). This allows you to see how the lessons apply directly to your day-to-day role and get work done while you train—a true win-win!


Access to your recorded session for 60 days

You can request your private session be recorded. You can have access for 60 days to revisit what you’ve learned.