PathTailor
FRSign inBuild my path
PathTailor
Build my pathSign inLire en français

Excel and data for the office path

The Excel and data for the office learning path chains 8 courses: 40 lessons, 123 exercises and about 12 hours of content. It starts with “Excel Fundamentals” and ends with “Power Automate: Automate Your Tasks”. This is the base order: your personal path is built from it and from your goal.

  • 8 courses
  • 40 lessons
  • 123 exercises
  • about 12 h
  • Runs in: windows vm, browser
  1. Excel Fundamentals
  2. Excel: Lookup and Logical Functions
  3. Excel: PivotTables
  4. Build and Safeguard a Reliable Excel Workbook
  5. Using Generative AI at Work
  6. Power Query and Power Pivot in Excel
  7. Automating Excel (VBA and Office Scripts)
  8. Power Automate: Automate Your Tasks
  • Excel
  • Generative AI
  • Power Platform
Build my pathBecome an Excel and reporting expert

The 8 courses, in order

  1. Excel4 courses
    1. 01Excel FundamentalsSolid Excel basics: data entry and formats, formulas and references, SOMME (SUM) and SI (IF), sorting, filtering, conditional formatting and charts.Beginner5 lessons1 h 30 minWindows VM
    2. 02Excel: Lookup and Logical FunctionsRECHERCHEX (XLOOKUP), INDEX/EQUIV (INDEX/MATCH), SI.CONDITIONS (IFS), SOMME.SI.ENS (SUMIFS), text and date functions, error handling: the key Excel functions for the office.Intermediate5 lessons1 h 35 minWindows VM
    3. 03Excel: PivotTablesSummarize your data in a few clicks: structured tables, PivotTables (TCD), grouping, calculated fields, slicers and PivotCharts.Intermediate5 lessons1 h 25 minWindows VM
    4. 04Build and Safeguard a Reliable Excel WorkbookBuild reliable Excel workbooks: data validation, tables and names, FILTER and UNIQUE, scenarios, Goal Seek and formula auditing.Intermediate5 lessons1 h 30 minWindows VM
  2. Generative AI1 course
    1. 05Using Generative AI at WorkUse generative AI day to day with a clear method: effective prompts, checking answers, protecting data, and real workplace use cases.Beginner5 lessons1 h 25 minBrowser
  3. Excel2 courses
    1. 06Power Query and Power Pivot in ExcelImport and clean data with Power Query, link your tables in the data model, write your first DAX measures and refresh with one click.Advanced5 lessons1 h 35 minWindows VM
    2. 07Automating Excel (VBA and Office Scripts)Automate Excel: macro recorder, VBA basics, loops and conditions, Office Scripts for Excel on the web and macro security.Advanced5 lessons1 h 30 minWindows VM
  4. Power Platform1 course
    1. 08Power Automate: Automate Your TasksAutomate your repetitive tasks with Power Automate: triggers, emails, approvals, Excel, SharePoint and error handling.Beginner5 lessons1 h 35 minWindows VM

Optional courses

Suggested depending on your goal, on top of the base path.

Other paths

  • Data analyst

    17 courses · 87 lessons · about 47 h
    1. Programming Basics and Algorithms
    2. Coding with an AI Assistant (Prompts, Code Review)
    3. SQL Fundamentals (SELECT, Filters, Aggregates)
    4. Intermediate SQL (joins, subqueries)
    5. Descriptive Statistics
    6. Python Fundamentals
    7. Data Analysis with pandas and NumPy
    8. Data Cleaning and Preparation
    9. Visualization (Matplotlib, Seaborn, Plotly)
    10. Probability and Inferential Statistics
    11. Exploratory Data Analysis
    12. Business Metrics and KPIs
    13. Advanced SQL (CTEs, window functions)
    14. Data Storytelling and Presenting Results
    15. Automate with Python (Files, Excel, APIs)
    16. A/B Testing and Experimentation
    17. Simple ETL Pipelines
    • Foundations
    • SQL
    • Statistics
    • Python
    • Data analysis

  • Data scientist

    27 courses · 139 lessons · about 83 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. SQL Fundamentals (SELECT, Filters, Aggregates)
    6. Intermediate SQL (joins, subqueries)
    7. Advanced SQL (CTEs, window functions)
    8. Descriptive Statistics
    9. Probability and Inferential Statistics
    10. Python Fundamentals
    11. Intermediate Python (Functions, Modules, OOP)
    12. Data Analysis with pandas and NumPy
    13. Data Cleaning and Preparation
    14. Visualization (Matplotlib, Seaborn, Plotly)
    15. Exploratory Data Analysis
    16. Introduction to Machine Learning (scikit-learn)
    17. Supervised Learning: Regression and Classification
    18. Unsupervised Learning: Clustering and Dimensionality Reduction
    19. Model Evaluation and Validation
    20. Feature Engineering
    21. Time Series and Forecasting
    22. HTTP and REST APIs
    23. APIs with FastAPI
    24. Deep Learning with PyTorch
    25. Natural Language Processing (NLP) and LLMs
    26. Deploying a Model (API, MLOps Basics)
    27. Docker and Deployment
    • Foundations
    • SQL
    • Statistics
    • Python
    • Data analysis
    • Data science
    • Back-end
    • Python for the web

  • Power BI

    13 courses · 65 lessons · about 26 h
    1. SQL Fundamentals (SELECT, Filters, Aggregates)
    2. Intermediate SQL (joins, subqueries)
    3. Database Modeling
    4. Descriptive Statistics
    5. Business Metrics and KPIs
    6. Getting Started with Power BI Desktop
    7. Power Query: Import and Transform
    8. Star Schema Modeling
    9. DAX Fundamentals
    10. Advanced DAX (Context, Time Intelligence)
    11. Data Storytelling and Presenting Results
    12. Designing Reports and Dashboards
    13. Power BI Service: Publishing, Sharing and RLS Security
    • SQL
    • Statistics
    • Data analysis
    • Power BI

  • JavaScript web developer

    24 courses · 127 lessons · about 75 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. HTML Fundamentals
    6. CSS Fundamentals
    7. Responsive Layout (Flexbox, Grid)
    8. JavaScript Fundamentals
    9. DOM and Events
    10. Asynchronous JavaScript (Promises, fetch, APIs)
    11. Accessibility and SEO
    12. Data Structures and Complexity
    13. TypeScript
    14. React
    15. SQL Fundamentals (SELECT, Filters, Aggregates)
    16. Intermediate SQL (joins, subqueries)
    17. Database Modeling
    18. HTTP and REST APIs
    19. Node.js Fundamentals
    20. API with Express
    21. Automated Testing
    22. Authentication and Web Security (OWASP)
    23. Full-Stack React + Node Application
    24. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • Back-end
    • Server-side JavaScript

  • Python web developer

    22 courses · 115 lessons · about 70 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. Python Fundamentals
    6. Intermediate Python (Functions, Modules, OOP)
    7. HTML Fundamentals
    8. CSS Fundamentals
    9. Responsive Layout (Flexbox, Grid)
    10. JavaScript Fundamentals
    11. DOM and Events
    12. Asynchronous JavaScript (Promises, fetch, APIs)
    13. SQL Fundamentals (SELECT, Filters, Aggregates)
    14. Intermediate SQL (joins, subqueries)
    15. Database Modeling
    16. HTTP and REST APIs
    17. APIs with FastAPI
    18. Django Fundamentals
    19. Automated Testing
    20. Authentication and Web Security (OWASP)
    21. Complete Application with Django
    22. Docker and Deployment
    • Foundations
    • Python
    • Front-end
    • SQL
    • Back-end
    • Python for the web

  • PHP web developer

    22 courses · 116 lessons · about 68 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. HTML Fundamentals
    6. CSS Fundamentals
    7. Responsive Layout (Flexbox, Grid)
    8. JavaScript Fundamentals
    9. DOM and Events
    10. Asynchronous JavaScript (Promises, fetch, APIs)
    11. SQL Fundamentals (SELECT, Filters, Aggregates)
    12. Intermediate SQL (joins, subqueries)
    13. Database Modeling
    14. PHP Fundamentals
    15. Object-Oriented PHP and Composer
    16. PHP and Databases (PDO)
    17. HTTP and REST APIs
    18. Laravel Fundamentals
    19. Automated Testing
    20. Authentication and Web Security (OWASP)
    21. Advanced Laravel (API, Queues, Tests)
    22. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • PHP
    • Back-end

  • Java web developer

    23 courses · 121 lessons · about 70 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. Data Structures and Complexity
    6. HTML Fundamentals
    7. CSS Fundamentals
    8. Responsive Layout (Flexbox, Grid)
    9. JavaScript Fundamentals
    10. DOM and Events
    11. Asynchronous JavaScript (Promises, fetch, APIs)
    12. SQL Fundamentals (SELECT, Filters, Aggregates)
    13. Intermediate SQL (joins, subqueries)
    14. Database Modeling
    15. Java Fundamentals
    16. Object-Oriented Java
    17. Collections, Streams, and Exceptions
    18. Testing with JUnit
    19. HTTP and REST APIs
    20. Spring Boot: REST API
    21. Persistence with JPA and Hibernate
    22. Authentication and Web Security (OWASP)
    23. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • Java
    • Back-end

  • AI at work

    5 courses · 25 lessons · about 8 h
    1. Using Generative AI at Work
    2. Cybersecurity: The Basics for Everyone
    3. GDPR for Data and Product Teams
    4. AI Governance and the AI Act
    5. Power Automate: Automate Your Tasks
    • Generative AI
    • Cross-functional skills
    • Power Platform

  • AI developer

    12 courses · 61 lessons · about 28 h
    1. Programming Basics and Algorithms
    2. Python Fundamentals
    3. Intermediate Python (Functions, Modules, OOP)
    4. Git and GitHub
    5. Using Generative AI at Work
    6. HTTP and REST APIs
    7. Integrating an LLM into an Application
    8. RAG in Production
    9. AI Agents and Automation
    10. Evaluating and Monitoring an AI System
    11. Docker and Deployment
    12. Self-Hosting AI Models Locally
    • Foundations
    • Python
    • Generative AI
    • Back-end

  • Data engineer

    18 courses · 91 lessons · about 43 h
    1. Terminal and Command Line
    2. Git and GitHub
    3. SQL Fundamentals (SELECT, Filters, Aggregates)
    4. Intermediate SQL (joins, subqueries)
    5. Advanced SQL (CTEs, window functions)
    6. Database Modeling
    7. Python Fundamentals
    8. Intermediate Python (Functions, Modules, OOP)
    9. Data Analysis with pandas and NumPy
    10. Data Warehouses and Analytical Modeling
    11. Data Quality and Governance
    12. Transforming Data with dbt
    13. Orchestrating Pipelines with Airflow
    14. Distributed Processing with Spark
    15. PostgreSQL in Practice (indexes, performance)
    16. Docker and Deployment
    17. Cloud Fundamentals
    18. Deploying an Application to the Cloud
    • Foundations
    • SQL
    • Python
    • Data engineering
    • Back-end
    • Cloud and DevOps

  • A website for my business

    4 courses · 21 lessons · about 7 h
    1. Build Your Website with WordPress
    2. Online Store with WooCommerce or Shopify
    3. Local SEO and Online Presence
    4. HTML Fundamentals
    • Websites and CMS
    • Front-end

  • Marketing analyst

    9 courses · 45 lessons · about 19 h
    1. SQL Fundamentals (SELECT, Filters, Aggregates)
    2. Intermediate SQL (joins, subqueries)
    3. Descriptive Statistics
    4. Business Metrics and KPIs
    5. Marketing Analytics
    6. E-commerce Analytics
    7. Data Storytelling and Presenting Results
    8. A/B Testing and Experimentation
    9. Local SEO and Online Presence
    • SQL
    • Statistics
    • Data analysis
    • Business analytics
    • Websites and CMS

  • Cloud and DevOps

    10 courses · 50 lessons · about 20 h
    1. Terminal and Command Line
    2. Git and GitHub
    3. Linux for Developers
    4. Docker and Deployment
    5. Continuous Integration and Deployment
    6. Cloud Fundamentals
    7. Deploying an Application to the Cloud
    8. Kubernetes
    9. Infrastructure as Code with Terraform
    10. Cybersecurity: The Basics for Everyone
    • Foundations
    • Cloud and DevOps
    • Back-end
    • Cross-functional skills

  • Mobile developer

    10 courses · 53 lessons · about 28 h
    1. Programming Basics and Algorithms
    2. Git and GitHub
    3. JavaScript Fundamentals
    4. DOM and Events
    5. Asynchronous JavaScript (Promises, fetch, APIs)
    6. TypeScript
    7. React
    8. HTTP and REST APIs
    9. Mobile Apps with React Native
    10. Mobile Apps with Flutter
    • Foundations
    • Front-end
    • Back-end
    • Mobile

  • Digital project manager

    7 courses · 35 lessons · about 12 h
    1. Using Generative AI at Work
    2. Agile Project Management
    3. Business Analysis: From Needs to Specifications
    4. UX Design and Mockups
    5. GDPR for Data and Product Teams
    6. SQL Fundamentals (SELECT, Filters, Aggregates)
    7. Business Metrics and KPIs
    • Generative AI
    • Cross-functional skills
    • SQL
    • Data analysis

Say what you want to be able to do, we build your path

Your path is assembled from the catalogue courses. With the Pro plan, every lesson is told with examples from your job.

The preview is free, and you can take the courses one at a time without paying. The path only contains lessons from the catalogue.