Mastering Microsoft Copilot for Microsoft Excel

Skip to Scheduled Dates

Course Overview

Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft Excel. Participants will delve into the advanced features of Microsoft Copilot, learning how to streamline their workflow and optimize their use of Microsoft Excel. Through hands-on exercises and expert-led instruction, attendees will gain practical experience and confidence in leveraging Microsoft Copilot to its fullest potential.

Who Should Attend

Intermediate to advanced Excel users aiming to drastically improve their data management, analysis, and visualization skills through the advanced features of Microsoft Copilot.

Course Objectives

    Provide participants with an in-depth understanding of Microsoft Copilot in Excel, enabling them to leverage AI for advanced data analysis, automation of tasks, and creation of dynamic reports and visualizations.

Course Outline

1 - Comprehensive Introduction to Copilot in Excel

  • Overview and set up of Copilot.
  • Writing effective prompts.

2 - Advanced Data Analysis Techniques with Copilot

  • Natural language queries for data analysis
  • Highlight, sort, and filter data.
  • Identify insights with Copilot in Microsoft Excel.
  • Prediction and Trend Identification.

3 - Automation, Data Cleaning, and Formula Creation

  • Automate Repetitive Tasks such as data entry, pivot tables, and more
  • Data Cleaning
  • Formula Creation

4 - Creating Dynamic Reports and Visualizations

  • Create compelling data visualizations
  • Create dashboards to analyze and interpret Excel data

5 - Collaboration, Sharing, and Security

  • Using Copilot for collaboration in Excel
  • Course Wrap-Up and Q&A

< Back to Course Search

Class Dates & Times

Class times are listed Eastern time

This is a 1-day class

Register for Class

Register When Time Where How
Register 06/05/2025 9:00AM - 5:00PM Online VILT
Register 07/08/2025 9:00AM - 5:00PM Online VILT
Register 08/13/2025 9:00AM - 5:00PM Online VILT
Register 09/09/2025 9:00AM - 5:00PM Online VILT
Register 10/13/2025 9:00AM - 5:00PM Online VILT
Register 11/17/2025 9:00AM - 5:00PM Online VILT
Register 12/17/2025 9:00AM - 5:00PM Online VILT

The classes listed are available to all United Training customers and does not reflect, in any way,
the availability or support of technology within the University of Maine System.