Skip to content
Banner for the course Excel in the AI era

Excel in the AI era · Level 1 — Fundamentals

Excel in the AI era — Level 1: Analysis & business data

Analysis & business data

5 intensive daysOnline or in-house

Programme content

  • Collect, clean, combine and automate data (Excel, CSV, API) with Power Query — with AI speeding up every step
  • Model your data and build advanced measures with Power Pivot & DAX, with formulas generated and corrected by AI
  • Consolidate multiple files and data sources, using AI to make consolidation faster and more reliable
  • Spot trends, anomalies and variances with AI as your exploration assistant
  • Build professional dashboards, generated and enriched with the help of AI

Expected outcomes

  • Build a complete AI-augmented Excel analysis chain on your own, from raw data to dashboard

Hands-on case studies

File consolidationCleaning customer databasesSales analysisBudget monitoringFinancial reportingHR analyticsProject trackingAnomaly detection

Who it is for

Professionals who use Excel regularly: finance, accounting, HR, administration, monitoring and evaluation, sales, project management, logistics, NGOs, public sector, SMEs.