Advanced Excel with AI

Unlock the power of AI and advanced Excel tools for data analysis

More info
Enable Notifications

This edition has ended. Would you like to join our waiting list?
Enable notifications to receive updates about future editions of this course and similar training programmes

In-company training available. Contact us!

The integration of AI into Excel and the use of advanced tools such as Power Query and Power Pivot are transforming the way we work with data, improving both efficiency and accuracy in data analysis.

In this hands-on course, you will learn to use Excel at an advanced and applied level, combining powerful data analysis tools with AI capabilities. You’ll learn how to use Power Query to import, clean and transform data from multiple sources, and how to build data models in Power Pivot by creating relationships between tables.

You’ll also explore how AI can enhance your work in Excel by automating processes, analysing and visualising data, and creating custom GPTs that act as assistants for advanced data extraction and analysis.

By the end of the course, you’ll know how to write effective prompts that get the best results from AI and how to build a modern, professional data workflow using Excel, Power Query, Power Pivot and AI.

What's Included

Access to the virtual campus
Certificate of attendance
  • Master advanced Excel techniques for processing, analysing and modelling data using Power Query and Power Pivot.
  • Import, clean, transform and structure data from multiple sources, including Excel files, databases and web data.
  • Use AI to automate Excel workflows, generate formulas more efficiently and streamline repetitive tasks with LLMs and APIs.
  • Apply AI to data analysis and visualisation, including data preparation, transformation and analysis.
  • Build and use custom GPTs to support data analysis and automation tasks.

  • Master advanced Excel techniques for processing, analysing and modelling data using Power Query and Power Pivot.
  • Import, clean, transform and structure data from multiple sources, including Excel files, databases and web data.
  • Use AI to automate Excel workflows, generate formulas more efficiently and streamline repetitive tasks with LLMs and APIs.
  • Apply AI to data analysis and visualisation, including data preparation, transformation and analysis.
  • Build and use custom GPTs to support data analysis and automation tasks.

Why choose our training?

+13.275
Professionals Trained
+8.600
Training Hours Delivered
9,2
Average Rating of Our Training Programmes