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

Become an Excel and reporting expert

The catalogue prepares you for the Excel and reporting expert role with a path of 8 courses (40 lessons, 123 exercises, about 12 hours), from “Excel Fundamentals” to “Power Automate: Automate Your Tasks”. 14 catalogue courses list this job among their outcomes.

  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
Build my pathSee the 8 courses in order

The steps of the path

  1. Excel

  2. Generative AI

  3. Excel

  4. Power Platform

Skills practised

Excel50

Number formatsFormulasAbsolute and mixed referencesSOMME, MOYENNE, MIN, MAX, NBThe SI functionSortingAutoFilterConditional formattingChartsRECHERCHEXINDEX and EQUIVSI.CONDITIONSET and OUSOMME.SI.ENS

36 more skills

NB.SI.ENSText functionsDate functionsSIERREUR and SI.NON.DISPStructured tablePivotTableDate groupingCalculated fieldSlicersTimelinePivotChartData validationDefined namesDynamic arrays and spillingFILTER, UNIQUE, SORT, SORTBYScenario Manager and data tableGoal SeekFormula auditingPower Query in ExcelData cleaningMerge queriesAppend queriesData modelPower PivotMeasuresCALCULATEData refreshMacro recorderExcel object modelVariables and typesFor, For Each, Do While loopsIf and Select CaseError handlingMacro securityOffice Scripts and the main functionOffice Scripts and Power Automate

Generative AI8

Language model (LLM)Model limitationsWriting promptsVerifying answersData confidentialityGDPR and AIAssisted writingDocument summarization

Power Platform9

Cloud flowsTriggersApprovalsConditions and switchApply to each loopsExpressionsExcel Online (Business) connectorSharePoint connectorError handling

Courses that mention this job

Frequently asked questions

How long does the Excel and reporting expert path take?

The base path is about 12 hours of lessons and exercises, across 8 courses and 40 lessons. You go at your own pace, lesson by lesson.

Do I need any prior knowledge to start?

No. The path starts with “Excel Fundamentals”, a course with no prerequisites.

Which domains does the path cover?

In order: Excel, Generative AI, Power Platform. The last course is “Power Automate: Automate Your Tasks”.

Does the path lead to a certification?

Not at this stage. The platform does not issue certifications yet, and claims no RNCP registration, no Qualiopi certification and no CPF eligibility.

Other careers

  • Become a 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

  • Become a 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

  • Become a Power BI analyst

    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

  • Become a 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

  • Become a 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

  • Become a 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

  • Become a 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

  • Become an 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

  • Become a 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

  • Become a 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

  • Become a cloud and DevOps engineer

    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

  • Become a 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

  • Become a 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.