This course runs for a duration of 1 Day.
The class will run daily from 8 AM CT to 4 PM CT.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
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.
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.
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.
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
Before taking this course, it is highly recommended that students complete MS-4005 Craft effective prompts for Microsoft Copilot for Microsoft 365
