Copilot for Microsoft 365 : Excel

Training Theme

​Simplify the management of your data and reveal the true potential of your spreadsheets with this training focused on Copilot for Excel. Even without being an expert in complex mathematics, you will learn to query your figures in natural language. This video course explains in detail how AI can clean raw databases, apply conditional formatting, generate instant charts, or even leverage advanced predictive analyses (notably thanks to Python). The objective is to free you from manual and tedious manipulations so that you can focus on what matters most: analysis, decision-making, and showcasing your results. 

Training Objectives

By the end of this training, you will able to :

• ​Start and clean a table efficiently with Copilot.
• ​Format and analyze large volumes of data.
• ​Generate simple or complex formulas from concepts expressed in natural language.
• ​Create insight grids and charts instantly.
• ​Use advanced classification and projection functions (including Python in Excel). 

Prerequisite and Target Audience

​Target audience: Users wishing to discover Copilot and learn to use it effectively.
​Starting Level: Beginner
Prerequisites: Be familiar with the basic use of a computer and have a version of Copilot for M365 for later practical application.

Means and Methods

• E-learning modules: Selection of a series of videos that will allow you to achieve the defined learning objective.

Training Content

11 tutorial videos:

• ​Clean up a table with Copilot
• ​Format data with Copilot
• ​Generate formulas with Copilot
• ​Generate formulas from a concept
• ​Sort, filter, and analyze data with Copilot
• ​Generate a chart with Copilot
• ​Use Copilot with right-click
• ​Create an insight grid
• ​Process text
• ​Sort and project using in Excel with Python
• ​Visualize and group using Copilot in Excel with Python 

Learn more about Microsoft Copilot

Copilot in Excel radically simplifies a multitude of analytical tasks, from the organization of raw data to the advanced modeling of your spreadsheets. Thanks to artificial intelligence, benefit from personalized recommendations to extract value from your figures, without having to master all complex mathematical formulas or programming language. Discover an exceptional analytical collaborator that automates the repetitive tasks of your spreadsheets, identifies hidden trends, and helps you make informed decisions quickly. The integration of Python pushes your projection and visual analysis capabilities even further.