Applied AI at work / Module 9
Module 9. Excel and data with AI
Time: 3 h (lesson 45 min, exercise 1 h 55 min, quiz 20 min) For: everyone who lives in spreadsheets: month-end close, expense and cost analysis, headcount and pipeline reports, stock files, weekly reporting, reconciliations and variance commentary.
The rule of this module fits in one line: the AI writes the method, your spreadsheet computes the number. A chat tool that reads a pasted table and "adds it up" will sometimes read only part of it, round silently or invent a row. A formula you can see, run and re-run does not. By the end you will have cleaned a 5,000-row expense file, answered five questions with exact figures, and written a variance paragraph where every number comes from your workbook.
What you will be able to do
- Get formulas, Power Query steps or code from an AI tool using headers and dummy rows only, without entering personal or confidential data.
- Profile a data file (rows, distinct IDs, blanks, label variants, date range) before analysing it.
- Clean data on a copy with a written log: exact duplicates, label harmonisation, recomputed blanks.
- Answer finance questions with SUMIFS, COUNTIFS and pivots, checking bounds, operators and cleaned columns, and confirm with a second method.
- Write a variance paragraph with AI in which every figure traces to the workbook and no cause is invented.
- Adapt formulas to French and German Excel (function names and separators).
3 video lessons, 10 minutes
- 9.1 What is in a spreadsheet, and profiling the data first 3:16
- 9.2 Clean with a log, then answer with formulas and a pivot 3:20
- 9.3 The weekly report, the variance paragraph, and the exercise 3:35
Exercise: Module 9 exercise: clean an expense file and answer five questions
Fictional data, scored automatically against the answer key, with the model answer after you submit.
Module quiz
8 questions, pass mark 6. Passing it counts towards your course certificate.
Sources
- Regulation (EU) 2016/679 (GDPR), Article 4(1) (personal data) and Article 5(1)(c) (data minimisation): https://eur-lex.europa.eu/eli/reg/2016/679/oj
- Regulation (EU) 2024/1689 (AI Act), Article 4, AI literacy, as amended, AI Act Service Desk: https://ai-act-service-desk.ec.europa.eu/en/ai-act/article-4
- CSSF, Thematic review on the use of artificial intelligence in the Luxembourg financial sector, May 2025, p. 5 ("Data quality" is the top AI challenge reported, followed by "Data protection" and "Data governance"): https://www.cssf.lu/wp-content/uploads/Thematic_report_AI_2024.pdf