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 View courses

Power BI

Power BI professionnel

15 courses available View courses

Power Automate

Professional Power Automate

15 courses available View courses

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

Discover Power BI and its environment

Understand the role of Power BI and the platform's main components.

Understand Business Intelligence Identify professional uses of Power BI Discover Power BI Desktop Discover the Power BI service +4

02 Fondations Power BI

Import your first data

Connect Power BI to simple sources and understand the loading cycle.

Understand the data journey in Power BI Import an Excel file Import a CSV file Select the useful sheets, tables and ranges +4

03 Fondations Power BI

Create your first interactive report

Turn imported data into a first usable report.

Discover Report, Table and Model views Add a data table Create a KPI card Create a column chart +4

04 Préparation des données

Clean data with Power Query

Prepare an imperfect source before using it in a report.

Discover the Power Query Editor Understand applied steps Rename and select columns Remove unnecessary rows and columns +4

05 Préparation des données

Transform columns and data

Perform more advanced transformations in Power Query.

Split a column Merge several columns Extract information from text Transform dates and times +4

06 Préparation des données

Consolidate multiple sources

Bring several files and tables together in one Power BI project.

Understand the difference between Merge and Append Append several tables with the same structure Merge two tables using a key Understand join types +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