Start a conversation ↗

Description

Excel — AI Assistant in the Spreadsheet: Query Your Data, Generate and Verify

Obtain a formula, an analysis or a chart in plain language, then check what is returned

  • 0.43 days — 3 h
  • In-person or virtual
  • Foundation
  • Up to 6 participants

Writing a nested formula or building a summary table takes time when the spreadsheet is only used occasionally. A built-in assistant now makes it possible to request a calculation or an analysis in plain language. The data still has to be structured for it, and the user must be able to recognise an incorrect answer presented with confidence.

This three-hour virtual short format is strictly limited to the spreadsheet. Participants prepare a sheet the assistant can work with, request formulas, sorting, formatting and summaries, then systematically check the results obtained. The emphasis is on verification before any figure is reused in a document that will be circulated.

Learning objectives

  • Prepare a worksheet so that it can be used by a built-in assistant
  • Phrase a calculation or analysis request in plain language
  • Obtain an explained formula and adapt it to your own table
  • Have conditional formatting, a sort or a chart generated
  • Verify a returned result before reusing it in a document

What makes this programme different

Every answer from the assistant is checked against a verification calculation carried out during the session
The three-hour virtual format is strictly limited to spreadsheet use cases
Participants leave with a list of requests tested on their own files

Programme

1Setting the ground

A table the assistant can read

  • Conditions of access to the assistant within the spreadsheet
  • Expected table structure and formatting data as a table
  • Headers, data types and named ranges
  • Data that should not be submitted
  • First request and reading the response

2Requesting and obtaining

Formulas, analyses and formatting

  • Phrasing a calculation request
  • Suggested formula explained and then adapted
  • Sorting, filtering and conditional formatting requested in plain language
  • Summary by category and chart
  • Rephrasing a request that was misunderstood

3Checking before using

The figure commits whoever circulates it

  • Verification recalculation on a sample
  • Identifying scope and filter errors
  • Checking totals and excluded rows
  • Traceability of formulas inserted by the assistant
  • Situations where manual work remains preferable

Who is it for

Spreadsheet users with access to a built-in assistant who wish to speed up their everyday calculations and analyses.

Prerequisites

Ability to enter data and write simple formulas in a spreadsheet.

Dates & locations

12 scheduled dates between November 2026 and December 2027. Seats are confirmed in the order enquiries are received.

November 2026

December 2026

January 2027

February 2027

March 2027

April 2027

May 2027

June 2027

September 2027

October 2027

November 2027

December 2027

None of these dates suit you? We open additional sessions on request, and any programme can be run privately for your team.

Practical details

Before the programme
Online positioning questionnaire. Your development objectives are shared with the trainer, who tailors the practical case studies to your context.
Teaching methods
Theoretical input, workshops and practical case studies. Digital course materials and method sheets provided.
Assessment
Multiple-choice tests and role-play exercises. Assessment of learning at the start and end of the programme, with immediate and 60-day follow-up evaluations.
After the programme
One year of access to the e-learning platform. Self-assessment of the skills acquired and a 30-day follow-up session with your trainer.
How to register
Registration online or on the basis of a quotation.
Lead time
11 working days after confirmation of registration.
Accessibility
Accessible to people of determination. Contact our accessibility coordinator to design a suitable solution: contact@mpf-academy.ae
Start dates
Rolling intake: in addition to the scheduled sessions, this programme can start on request.