Excel — Mandragore Academy

Excel Power BI Power Automate — Design and industrialize business automations

Excel — Catalogue

Choose a course or a bundle to get started.

Each course brings together 8 interactive lessons inside a Learning Workspace designed to turn knowledge into real, job-ready skills. Guided lessons, hands-on scenarios, dynamic quizzes, conversational support and progress tracking help you learn efficiently, at your own pace. The 15 courses follow a level-based progression, from discovering Excel to professional expertise and Copilot.

🎓 15 courses • 📚 120 interactive lessons • ⏱️ from 45 to 75 hours of conversational training

5 levels: Foundations — 9,90 € excl. VAT Operational — 12,90 € excl. VAT Advanced Analysis — 15,90 € excl. VAT Reporting & Data — 18,90 € excl. VAT Expert — 21,90 € excl. VAT

Best offer

Professional Excel — Complete Pack

🎓 Certificate : "Excel Professional" 238,50 €

📚 15 courses 📖 120 lessons ⏱ 45 to 75 h ⚡ 1800 credits included

143,10 € excl. VAT

Savings : 95,40 €

Foundations Bundle 3 courses Fondations

🎓 Certificate : Excel Foundations

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 240 credits included

29,70 €

22,90 excl. VAT

Savings : 6,80 €

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 Moving around and selecting efficiently Entering and editing data Copying, moving and auto-filling Workshop: create a first tracking table

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 80 credits included

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 Applying consistent styles and themes Using conditional formatting Preparing a sheet for printing and PDF Workshop: present a professional budget

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 80 credits included

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 Copying a formula correctly Using SUM, AVERAGE, MIN and MAX Identifying and fixing common errors Workshop: build a calculated expense table

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 80 credits included

Operational Bundle 3 courses Opérationnel

🎓 Certificate : Operational Excel

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 300 credits included

38,70 €

28,90 excl. VAT

Savings : 9,80 €

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 Calculating with AVERAGEIF and AVERAGEIFS Rounding results Handling errors with IFERROR Workshop: create a goals and results tracker

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 100 credits included

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 Creating drop-down lists Controlling entry with data validation Finding and removing duplicates Workshop: build a reliable tracking file

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 100 credits included

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 Understanding how Excel dates work Calculating durations and deadlines Calculating working days Workshop: clean up an imported file

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 100 credits included

Advanced Analysis Bundle 3 courses Analyse avancée

🎓 Certificate : Advanced Excel Analysis

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 360 credits included

47,70 €

35,90 excl. VAT

Savings : 11,80 €

07 Advanced Analysis

Search for and match information

Automatically retrieve information from another table.

Understanding the principle of a lookup Using XLOOKUP for an exact match Handling values not found Performing an approximate match Performing a lookup on two criteria Using INDEX and MATCH Understanding VLOOKUP and its limits Workshop: match two professional files

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 120 credits included

08 Advanced Analysis

Master modern and advanced formulas

Build dynamic calculations that are easier to maintain.

Using dynamic arrays Filtering automatically with FILTER Sorting with SORT and SORTBY Extracting unique values with UNIQUE Generating series with SEQUENCE Simplifying a formula with LET Combining several functions without losing track Workshop: produce a dynamic analysis

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 120 credits included

09 Advanced Analysis

Create professional charts

Choose and build the right visualization.

Choosing a chart suited to your message Creating column and bar charts Representing change over time Using pie charts with discernment Creating a combo chart Using a secondary axis Adding dynamic charts and sparklines Workshop: present results to management

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 120 credits included

Reporting & Data Bundle 3 courses Reporting et Data

🎓 Certificate : Excel Reporting & Data

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 420 credits included

56,70 €

42,90 excl. VAT

Savings : 13,80 €

10 Reporting & Data

Analyze with PivotTables

Quickly summarize a large volume of data.

Preparing a correct data source Creating a PivotTable Organizing rows, columns, values and filters Changing calculation modes Grouping dates and values Using slicers and timelines Creating a PivotChart Workshop: analyze the results of an activity

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 140 credits included

11 Reporting & Data

Build a dashboard

Bring together indicators, charts and filters in an interactive report.

Defining the dashboard's objectives Choosing genuinely useful indicators Preparing the source data Designing the dashboard's architecture Linking PivotTables and charts Adding interactive filters and slicers Improving readability and ergonomics Workshop: create a complete dashboard

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 140 credits included

12 Reporting & Data

Import and transform with Power Query

Automate the cleaning and consolidation of files.

Understanding the role of Power Query Importing an Excel or CSV file Discovering the Power Query editor Cleaning and converting data Splitting, merging and transforming columns Adding and merging several queries Refreshing data automatically Workshop: consolidate several monthly files

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 140 credits included

Expert Bundle 3 courses Expert

🎓 Certificate : Excel Expert

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 480 credits included

65,70 €

48,90 excl. VAT

Savings : 16,80 €

13 Expert

Build a data model with Power Pivot

Analyze several tables without cramming everything into one sheet.

Understanding the Excel data model Distinguishing fact tables from dimension tables Creating relationships between tables Building a calendar table Discovering Power Pivot Differentiating calculated columns and measures Creating your first DAX measures Workshop: analyze several linked tables

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 160 credits included

14 Expert

Secure, protect and automate Excel

Build robust workbooks and reduce repetitive tasks.

Auditing formulas and their dependencies Detecting inconsistencies and errors Protecting cells, sheets and workbooks Sharing a file and managing versions Identifying tasks that can be automated Recording a first macro Reading and adapting simple VBA code Workshop: automate a recurring task

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 160 credits included

15 Expert

Work with Copilot and complete a full project

Bring together all the course's skills in a professional case.

Properly preparing data for Copilot Writing a clear request in Excel Asking for a formula to be created or explained Analyzing and summarizing data with AI Creating tables, charts and AI-assisted summaries Checking Copilot's suggestions and results Building a complete professional Excel project Presenting, documenting and handing over the workbook

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 160 credits included