Mandragore Academy / Microsoft 365

Microsoft 365

Master the Microsoft tools that make the difference at work.

Mandragore Academy's Learning Workspaces bring a new generation of Microsoft 365 training: interactive learning paths designed to turn knowledge into real, job-ready skills.

Get ready for the data and productivity tools of tomorrow.

Choose your course and build skills you can apply to your work right away.

Independent training — not affiliated with or certified by Microsoft.
Discover Excel professional

Your personal Learning Workspace is created automatically upon your first purchase.

Choose your tool

Excel

Excel professional

15 courses available

Power BI

Power BI professionnel

15 courses available

Power Automate

Professional Power Automate

15 courses available

Aperçu — Excel

01 Foundations

Discover Excel and create your first workbook

Understand the Excel environment and build a first usable table.

What Excel is used for Discovering the ribbon and interface Understanding workbooks, sheets, cells and ranges Creating, opening, saving and closing a workbook +4
02 Foundations

Present a professional table

Produce a clear, readable and properly presented sheet.

Recognizing different data types Formatting numbers, dates and percentages Organizing rows, columns and cells Using fonts, alignment, borders and colors +4
03 Foundations

Perform your first calculations

Understand the logic behind Excel formulas.

Understanding the structure of a formula Using mathematical operators Using relative references Using absolute and mixed references +4
04 Operational

Use the essential functions

Automate the most common calculations in business.

Using the IF function Combining several conditions with AND and OR Counting with COUNT, COUNTA and COUNTIF Adding with SUMIF and SUMIFS +4
05 Operational

Organize and control your data

Turn a simple list into a real Excel working base.

Turning a range into an Excel table Understanding structured references Sorting data on one or more criteria Using simple and advanced filters +4
06 Operational

Work with text and dates

Clean and transform the information you receive.

Extracting text with LEFT, RIGHT and MID Combining text with CONCAT and TEXTJOIN Cleaning up spaces and unwanted characters Replacing and converting values +4
See all Excel courses

Aperçu — Power BI

01 Fondations Power BI

Découvrir Power BI et son environnement

Comprendre le rôle de Power BI et découvrir les principaux composants de la plateforme.

Comprendre la Business Intelligence Identifier les usages professionnels de Power BI Découvrir Power BI Desktop Découvrir le service Power BI +4
02 Fondations Power BI

Importer ses premières données

Connecter Power BI à des sources simples et comprendre le cycle de chargement.

Comprendre le parcours d'une donnée dans Power BI Importer un fichier Excel Importer un fichier CSV Sélectionner les feuilles, tables et plages utiles +4
03 Fondations Power BI

Créer son premier rapport interactif

Transformer les données importées en un premier rapport exploitable.

Découvrir les vues Rapport, Table et Modèle Ajouter un tableau de données Créer une carte d'indicateur Créer un graphique en colonnes +4
04 Préparation des données

Nettoyer les données avec Power Query

Préparer une source imparfaite avant son utilisation dans le rapport.

Découvrir l'éditeur Power Query Comprendre les étapes appliquées Renommer et sélectionner les colonnes Supprimer les lignes et colonnes inutiles +4
05 Préparation des données

Transformer les colonnes et les données

Réaliser des transformations plus avancées dans Power Query.

Fractionner une colonne Fusionner plusieurs colonnes Extraire des informations d'un texte Transformer les dates et les heures +4
06 Préparation des données

Consolider plusieurs sources

Réunir plusieurs fichiers et tables dans un même projet Power BI.

Comprendre la différence entre fusionner et ajouter Ajouter plusieurs tables de même structure Fusionner deux tables à partir d'une clé Comprendre les types de jointures +4
Voir tous les cours Power BI

Preview — Professional Power Automate

01 Niveau 1

Understand Power Automate and scope an automation

analyze a business process, decide whether it should be automated and choose the right type of automation

Understand Power Automate within the Power Platform ecosystem Map a business process before automating it Identify triggers, actions, data and actors Distinguish cloud flow, desktop flow and human intervention +4
02 Niveau 1

Build reliable cloud flows

create, test and diagnose automated, instant and scheduled flows in the Power Automate designer

Discover the modern designer and the structure of a cloud flow Create an automated flow triggered by an event Create an instant flow triggered by the user Create a scheduled flow and master recurrence +4
03 Niveau 1

Handle data, expressions and structures

transform a flow's data and write robust expressions on strings, dates, arrays, objects and JSON

Create and use variables and intermediate values Build conditions, Switch and loops Manipulate strings and type conversions Manipulate dates, times and time zones +4
04 Niveau 2

Automate Microsoft 365 and approval processes

build business workflows combining Outlook, Teams, SharePoint, Forms, OneDrive, Excel and approvals

Design a coherent Microsoft 365 workflow Collect a request with Forms or a business event Store and track information in SharePoint or Dataverse Automate emails and Teams notifications +4
05 Niveau 2

Automate business data with Dataverse

use Dataverse as a secure data foundation for structured business automations

Understand Dataverse and its role in Power Platform Design tables, columns, keys and relationships useful to the flow Trigger a flow on Dataverse events Create, read, update and delete rows +4
06 Niveau 2

Integrate APIs, HTTP and custom connectors

connect Power Automate to external services via HTTP, REST and custom connectors without recreating a full API course

Understand an HTTP call in Power Automate Build requests, headers and parameters Interpret JSON and HTTP statuses Manage authentication and access secrets +4
See all Power Automate courses