Copilot in Microsoft Excel

Learn to use Copilot, an AI-powered assistant integrated into Excel, to enhance productivity and efficiency. Discover how Copilot can help with data analysis, formula creation, and chart generation.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Learn to use Copilot, an AI-powered assistant integrated into Excel, to enhance productivity and efficiency. Discover how Copilot can help with data analysis, formula creation, and chart generation.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

This course will introduce you to the powerful capabilities of Copilot, an AI-powered digital assistant that is integrated into Microsoft Excel. Copilot is designed to help users with their tasks by providing suggestions and automating processes. It combines the power of large language models with your data in the Microsoft Graph and the Microsoft 365 apps to turn your words into the most powerful productivity tool on the planet. Throughout this course, you will learn how to use Copilot to unleash your creativity, unlock productivity, and uplevel your skills in Excel. You will discover how Copilot can help you with tasks such as data analysis, formula creation, and chart generation. By the end of this course, you will have a solid understanding of how to use Copilot to enhance your productivity and efficiency in Excel.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

What you need to get started - Copilot in Microsoft Excel

Module 00 - Getting Started 3 min.

Module 01A - Class Introduction (What is Copilot and How Does it Work) 8 min.

Module 01B - Class Introduction (How to Enable Copilot in Excel) 7 min.

Module 02A - AI Driven Analytics with Copilot (Using Prompt Guide or View Prompts) 9 min.

Module 02B - AI Driven Analytics with Copilot (Understanding Copilot Labs) 2 min.

Module 02C - AI Driven Analytics with Copilot (Prompts for Extracting Insights) 10 min.

Module 02D - AI Driven Analytics with Copilot (Prompts for Formatting) 7 min.

Module 02E - AI Driven Analytics with Copilot (Prompts for Creating New Visuals) 8 min.

Module 02F - AI Driven Analytics with Copilot (Prompts for Writing Formulas and Calculations) 9 min.

Module 03 - Tips and Tricks (Do's and Don'ts of Prompt Writing) 6 min.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Devin Knight

President

Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, FL Devin is a contributing member to several local user groups.

Learn More

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion